Raviteja K

• Having a good Experience in Designing and Developing the SQL Server Integration Services (SSIS) Packages with different Control Flow Tasks and Data Flow Transformations, Containers, Securing Packages and Deploying the Packages.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Knowledge on SQL Server Profiler, Database Tuning Advisor
• Expertise in Data Migration from sources like SQL Server, Text Files, and Excel to SQL server 2016 using SQL Server Integration Services (SSIS).
• Extensive Experience in RDBMS concepts such as Tables, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures
• Supported development effort by providing T-SQL statement tuning and optimize data loading processes.
• Prepared Weekly Status Reports and shared with the On-site Managers.
• Extracting the data from excel file and load data into SQL tables.
• Using SQL profiler and run traces.
• Gathering requirements from day to day.
• Creating Stored Procedures with business logic.
• Creating Views as per Power BI reports requirements.
• Creating SSIS packages as per client requirement and deploy to production.
• Monitoring SQL Agent jobs.

Primus Pharmaceuticals

Client: Primus

Description:

Primus is built on a clinical approach to medical nutrition based on science each of our product formulations is proven effective by clinical studies. Primus is committed to the highest-purity standards and manufacturing practices to ensure consistent quality, Primus products are designed to meet the needs of specific chronic diseases and are used under physician supervision

• Migrated data from ORACLE Database to MS SQL Database.
• Designed and developed various SSIS packages to Extract and Transform and Load (ETL) data into the data warehouse database from heterogeneous database / data sources (MS Excel, SQL Server and Flat Files).
• Created ADF pipelines for getting the data from Sales force and syncing the data from Sales force to DB and DB to CRM.
• Monitoring ADF pipelines.
• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
• Updated old code bases to modern development standards, improving functionality.
• Integrated third-party tools and components into applications.
• Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.