Shivam Rastogi

APAX : Worked as individual contributor

Tools Used: SQL Server 2012, SSIS, visual studio, SSMS

• Evaluated diverse organizational systems to identify workflow, communication and resource utilization issues.
• Proficiency in writing complex stored procedures, Joins, Function, Triggers and designing ETL mappings to support data integration, analysis, and various business processes.
• Strong understanding of Database concepts, Designing database from scratch, SQL Server Data Sync, Replication, Distributed transaction management
• Verified performance and reliability of development database transformation solutions.
• Wrote complex and optimized in-application SQL statements including views, stored Proc,functions, CTEs, table variables.
• Performance Tuning, Query Optimization and ETL package optimization, logging.
• Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
• Experience in implementing Data flow/Control flow Tasks, Containers and Transformations task like Lookup, Merge, union, conditional split and Data Conversion etc.
• Experience in building SSIS package Configuration and Package deployment using file system and ispac.
• Experience in Migration of SSIS packages from older to newer version.
• Planned and installed upgrades of database management system software to enhance database performance.
• Analyzed complex SQL to help plan data extraction and processing tasks, aiding in eventual deployments.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Writing Python query for extraction through API and files and populating into SQL DB tables.
• Designed & Developed ETL SSIS package as per the business requirement to load the data on Data marts, hitting API to collect data from different sources (similarWeb, SemRush, sistrix, GoogleAnalytics, other 18 sources) and then transforming it as per business logics for monthly and weekly and daily execution.
• Prepare and review requirements, functional specifications, technical designs and implementation documentation

WBA Project :

Tools Used: Talend, Java script basic, Power BI, WinScp, Putty, Azure Cosmos DB, Git, DB Visualizer, JIRA

• Orchestrated optimized transformation processes for moving data sets between sources and target tables.
• Experience on writing java code and script to take care of talend jobs while development.
• Experience of store migration using talend ETL Jobs and cosmos db, Azure data factory, azure service bus.
• Complex Orchestrator design with Performance improvement.
• Maintain code standards,business documents and practices on confluence and code version using Git.
• Writing Cosmos SQL query to retrieve the data through panda explorer and azure cloud.

BCD Travel

Tools Used : SQL Server 2016, SSIS , Redshift , POWER BI

• Requirement Gathering and Analysis Sessions with Client.
• Creating the Project Plan and follow up with client on daily basis.
• Design & Develop ETL SSIS package as per the business requirement to load the data on Data marts to develop reports etc.
• Apply transformation as per business rules to load data on pre-trip and post trip.
• Created, implemented and maintained ETL packages and business process
• Writing Dynamic, complex and optimized SQL queries.

Syneos Health

Tools Used : SQL Server 2008 R2,2012,T-SQL,Informatica

• Designing and creating mapping, workflow, session using SSIS to migrate and load data in data Warehouse.
• Creating and implementing SCD 1, SCD 2, SCD 3 type mapping using SSIS.
• Monitoring and testing Informatica mapping and workflow.
• Developing T/SQL stored procedures, functions, triggers, views.
• Monitoring and testing Informatica mapping and workflow.
• Move files from FTP/SFTP protocol using Batch script to load data and load files on Salesforce for report generation.
• Maintain processes to execute batch script for loading data and archiving the files after execution.
• Data from IQVIA/IMS and process it to analyze the sales and payer information, concur expenses and built chart over it on Salesforce for more than 30 clients of pharma industry like Novartis, Amgen, Shire, Westward etc

BCD Travel

Tools Used : SQL Server 2014, SSIS

• Interpreted data models for conversion into ETL diagrams and code.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Migration from 2014 to sql server 2016.