Siva Kumar

Experience

• 

  Symphony Services

  Jul 2006 - May 2010

  Software Engineer

  ETL Developer,DB Developer and DBA• Worked in end to end Architecture, Design, and Development using Metadata Driven Architecture for Data Access Layer for the Order Process Management System to make generic and reusable.• Developed core Framework for the CRM Application Development User.Created logical data model & physical data model based on the application’s object model & functional analysis document under the guidance of database architect.• Created low level design documents for the database.• Modifying database design to accommodate the new business logic that evolves over time using Change management• Analysed existing database & data for the purpose of data migration.• Prepared necessary documents such as Segmentation of database into smaller pieces as per the new database & application design modules.• Prepare documents for mapping between the old & new database at table level, column level.• Develop SQL Sever SSIS scripts to migarte the data from the existing database to the new database.• Develop PL/SQL procedures by which all ICDR application modules can access ICDR metadata and or data including generic Oracle exceptions and ICDR application exceptions.• Create VB scripts for input files quality check.• Apply Database server Tuning, TSQL Tuning, Index Tuning and analyze the execution plans and optimize. Show less

• 

  Aditi Technologies

  May 2010 - Mar 2012

  Senior developer

  Microsoft Buiness Intelligence Solutions - Senior Developer• Create low level design documents for the database.• Modifying database design to accommodate the new business logic that evolves over time using Change management• Prepare necessary documents such as Database standards ,Design Documents and For Schema set up and Data Transfer and Load modules.• Handle schema deployment and automate database deployment.• Automate database deployment.• Understand the BRD and Design documents for BI requirements and worked on the project estimation and implementation.• Modifying BI Logic to accommodate the new business logic that evolves over time using Change management.• Created automated SSIS packages and its execution by adding these into SQL jobs.• Performance tuning of ETL packages.• Implemented partitioning for bigger tables and introduced indexes to improve the ETL pull. Show less

• 

  QuintilesIMS

  Apr 2012 - Mar 2017

  Senior Software Engineer

  Areas of expertise include developing stored procedures, triggers, SSIS (SQL Server Integration Services) scripts, SSRS (SQL Server Reporting Services), ETL tools SSIS, Informatica, relational database architecture, database, SSIS , SSRS performance tuning ,data migration and database design and hands on experience on Netezza data ware house appliance. • Create Project Work Requests for Product enhancements and implementation using Scrum.• Understand the BRD and Design documents for BI requirements and worked on the project estimation and implementation.• Modifying BI Logic to accommodate the new business logic that evolves over time using Change management.• Reports Development and migration- Understanding the reports in Sagent and tableau and Migrating into SSRS. Involved in Tableau reports CRM.• ETL Support - supporting overall 25 clients, 32 Applications, over 150 ETL process, monitoring nearly 1 Billion records getting processed every day and night. Show less

• 

  Convergytics Solutions Pvt. Ltd.

  Apr 2017 - Sept 2017

  Senior Tech Lead

  • Create work breakdown structure(WBS) and delegate detailed tasks with estimates.• Strongly knowledge in implementing Agile, SDLC life cycle.• Make technical decisions to meet the design goals laid out in product road map and by management.• Collaborate with business and vendor teams to gather requirements and business needs.• Test, maintain and monitor computer programs and systems including the coordinating the installation of computer programs and systems.• Development of application architecture framework. Show less

• 

  Harman Connected Services Corp India Private Ltd

  Sept 2017 - Jun 2022

  • Data Modeling, Data Mapping, and Database Normalization using RDBMS Concepts and Constructs.• Scrum master for BI team following SAFe Scalable Agile Framework and involved in PI -Program Increment planning and implementing.• Keep abreast of technology trends and how they apply to our area. Put forward suggestions for improvement to development processes or tools where applicable. • Build DataMart structure and table attributes as per the requirements.• Development of a range of BI solutions in support of the Product Portfolio. Show less

  • Principal Engineer

    Jan 2021 - Jun 2022

  • Technical Lead

    Sept 2017 - Dec 2020
• 

  IQVIA India

  Jun 2022 - now

  Technical Manager

  • Drive high quality technical solutions, and provide inputs regarding architecture, design, and priorities for healthcare analytical products on AWS/Snowflake.• Articulate and Communicate Vision, Plans, Status, Anticipate Risks, and mitigation plans for the Project management.