V Chinmai Email & Phone Number

Austin, Tx, Us

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.• Developed .NET console applications to automate ETL processes, including data extraction, transformation, and loading into SQL databases.• Designed and implemented error logging and debugging mechanisms in .NET console applications for monitoring database workflows.• Integrated REST APIs with SQL databases to fetch and process real-time data for business intelligence applications.• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables. Involved in the continuous enhancements and fixing of production problems.• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances. • Developed and maintained complex SQL queries, stored procedures, and triggers to support ERP data operations.

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. • Generated server side PL/SQLscripts for data manipulation and validation and materialized views forremote instances.• Created management analysis reporting using ParallelQueries, Javastoredprocedure, HTPPackage and• 'WEB.SHOW_DOCUMENT. • Integrated .NET console applications with REST APIs to fetch and process data into database systems• Participated in change and code reviews to understand the testing needs of the changecomponents. Worked on troubleshooting defects in timely manner.• Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. • Designed and tested REST APIs to enable data sharing between SQL databases and external systems.• Created Design Fact and Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin Tool.• Spearheaded the design and implementation of database structures, ensuring scalability and efficiency for handling increasing data volumes.• Collaborated with the data architecture team to create normalized database schemas, optimizing data storage and retrieval.• Collaborated with cross-functional teams to troubleshoot and resolve database-related issues, ensuring minimal downtime and optimal application performance.• Implemented database security measures in Azure SQL, including role-based access control and encryption, aligning with industry best practices and compliance standards.

• Developed the User Interactive web pages in a professional manner by using web technologies like HTML/ HTML5, XHTML, CSS3, JavaScript as per company standards.• Extensively used CSS LESS/SASS as pre-processors which extend the properties of CSS.• Worked throughout the full stack (Node JS, Angular JS) to see software extensions through to completion.• Used Angular.JS, MVC Framework in the development of the web application to bind the data/model that was retrieved from a database through services provided in a controller to the view using scope.• Automated database maintenance tasks, such as backups and index rebuilding, using .NET console applications• Used AngularJS as framework to create a Single Page Application (SPA) which can bind data to specific views and synchronize data with server using SASS, LESS, Bootstrap, JavaScript AngularJS.• Used REST APIs to validate and enrich SQL database records with data from third-party services.• Used built in directives for the two-way data bindings and used $scope, $resource extensively in AngularJS.• Involved in setting up of the Azure Blob Storage account for the finance and operations teams and creating blobs for sources.• Worked on data migration from various flat files in Azure Blobs by developing SQL Server Integration Services (SSIS) packages for migration using Stored procedures and CTE’s .• Managed ERP database instances across development, testing, and production environments.• Designed and enforced indexing strategies to optimize ERP transaction processing and reporting performance.• Conducted data integrity checks and validation to ensure accuracy and reliability of ERP data.• Developed and executed data migration plans for ERP system upgrades, minimizing impact on business operations.• Collaborated with ERP vendors and consultants to address performance and functionality issues.• Implemented disaster recovery plans and performed regular backups to safeguard ERP data.

• As a Data Analyst I was responsible for gathering data migration requirements. • Identified problematic areas and conduct research to determine the best course of action to correct the data. • Analyzed problem and solved issues with current and planned systems as they relate to the integration and management of order data. • Experienced in working with Report Builder 3.0 and also worked in Linked reports, sub reports and dynamic Report delivery by using Visual Studio Shell 2013 – SQL server Data Tool(SSDT BI).• Involved in Data Mapping activities for the data warehouse. • Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports. • Implemented Azure Data Factory operations and deployment into Azure for moving data from on-premise into cloud.• Created azure data factory (ADF pipelines) using Azure polybase and Azure blob.• Built a common sftp download or upload framework using Azure data Factory and databricks.• Monitor for timely and accurate completion of select data elements. • Collected, analyze and interpret complex data for reporting and/or performance trend analysis. • Monitor data dictionary statistics. • Involved in analyzing and adding new features of Oracle 10g like DBMS_SHEDULER, Create Directory, Data pump, CONNECT_BY_ROOT in existing Oracle 10g application. • Archived the old data by converting them into SAS data sets and flat files. • Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible• Enhance smooth transition from legacy to newer system, through change management process. • Planned project activities for the team based on project timelines using Work Breakdown Structure. • Compare data with original source documents and validate Data accuracy.