SWATI GUPTA
Team Lead
Delhi
Summary
10 years of extensive experience in Software Development, Team Handling and Project Management in the field of ETL and Data warehouse design and testing, Data Analytics tools,Requirement Gathering and providing end to end Solution to client Expertise in creating a data warehouse solution consisting of migrating and integrating data from various SOR using MSBI technologies (SSIS). Strong experience in data analytics and insight generation, data manipulation using python Experience in Natural Language Processing (NLP) techniques including regular expressions, data cleansing and insight generation of text data. Proficient in RDBMS knowledge and concept of Schema, Objects, relations and constraints Customization the ETL SSIS framework using Scripting language like C# Requirement Gathering and providing end to end Solution to client Creating and executing test plans, cases and scripts to support ETL Informatica/SSIS Techno-Functional Knowledge in Oil & Gas Investment Banking HR & Recruitment
Overview
10
10
years of professional experience
4
4
years of post-secondary education
Work History
Project Manager
Accenture Technologies
Mumbai, MH
03.2020 - 08.2022
- Development of various modules in SSIS
- Team Handling and Project Management Experience
- Job Scheduling using ControlM and SQL server Agent Jobs
- Enhancements and maintenance of existing functionality
- As the project is completely Client driven, business requirements are one to one gathered directly from client
- Team Size 15, ,ControlM
- Tools
- ControlM, SSIS,SQL
Technical Lead
Accenture
Mumbai
07.2017 - Current
- The project provides various services to DU and DG Leads, HR Leads who work with Accenture Business
- Data warehousing solution has been created to deliver the required information to the Leads to measure KPI and parameters
- Client
- Accenture Business
- Domain
- HR and Recruiting
- Role & Contribution
Software Consultant
Genpact Headstrong
07.2015 - 01.2017
- Genpact Headstrong Capital Markets is a global consulting and IT services company with a specialized focus in capital markets and is present across North America, Europe and Asia-Pacific
- The BMD project provides various services to financial and sales advisors who work with Morgan Stanley Investment Bank
- Multiple utilities have been developed to accomplish the same., Development of various modules in SSIS, Informatica
- Job Scheduling using TWS and SQL Server Agent Jobs
- Enhancements and maintenance of existing functionality
- As the project is completely Client driven, business requirements are one to one gathered directly from client
- Customization of SSIS Framework using C# Scripts
- Technologies, SQL, Informatica, C#, WebAPI
- Team Size 5
Developer
12.2013 - 06.2015
- UWT DF project provides common solution to different Chevron BU’s
- The objective of this solution is to meet data requirements for quicker, more efficient deployment of UWT common solutions and proliferation based on UWT DF Target Architecture
- The architecture includes Data migration, cleaning, Merging and aggregation in various layers
- This will improve ability to actively monitor data quality and make available high quality data to support growth rates in Functions and Bus
- Role & Contribution Role:, Creating and maintaining SSIS packages for data transformation and loading
- Developing ETL solution to merge SOR data into different layers of architecture databases
- Creating UI Reporting in SSRS, cube for analytics in SSAS, TIBCO Spotfire
- Implemented CDC /Incremental load to improve performance of packages
- Developing Technical Specifications
- Creating Test Plan for ETL packages
- Scheduling and monitoring ETL package execution
- Technologies
- Oracle ,SQL SERVER ,SSIS,SSRS,MS EXCEL,MS ACCESS, TIBCO Spotfire, SSAS
- Tools
- TOAD,SQL SERVER 2008 R2
- Project 2:
- Project Name
- RBI Reporting Support
- Team Size
Bid Manager
BIDMAN
04.2012 - 04.2013
- Is a product developed by Client (Eaton Electricals) to configure its products for the end users
- It consists of various applications following business rules to generate pricing for its various products.
Developer
Shri Krishan (Dev Bhoomi) Institute of Engineering & Technology
01.2007 - 01.2011
- Designing of the application, developing applications or modifying existing applications according to project requirement
- Designed a windows application in Dotnet 3.5 to generate pricing details using an excel as source and communicating through XML to apply appropriate business rules
- Providing Maintenance as well as providing code fixes for various other asp.net and VB applications
- Technologies
- Dotnet 2.0,3.5,4.0 ,VB ,SQL SERVER 2008 R2,Silverlight,MVVM Pattern,WCF,XML,XSLT
- Tools
- E-timecard, RepriceRenewals, Document Release Service
- Education Qualifications
- Qualification
- Year
- Institute (Board, Marks/CGPA
- Recognition
- B.Tech, Kurukshetra 72.60%
- Honours
- Class
Class
Convent Of Jesus And Mary, Ambala Cantt
01.2006 - 01.2007
Convent Of Jesus And Mary, Ambala Cantt
01.2004 - 01.2005
Education
Bachelor of Technology - Computer Science
Shri Krishna Dev Bhoomi Institute of Eng. & Applied Research
Kurukshetra 05.2007 - 05.2011
Skills
Technical Expertiseundefined
Timeline
Project Manager
Accenture Technologies
03.2020 - 08.2022
Technical Lead
Accenture
07.2017 - Current
Software Consultant
Genpact Headstrong
07.2015 - 01.2017
Developer
12.2013 - 06.2015
Bid Manager
BIDMAN
04.2012 - 04.2013
Bachelor of Technology - Computer Science
Shri Krishna Dev Bhoomi Institute of Eng. & Applied Research
05.2007 - 05.2011
Developer
Shri Krishan (Dev Bhoomi) Institute of Engineering & Technology
01.2007 - 01.2011
Class
Convent Of Jesus And Mary, Ambala Cantt
01.2006 - 01.2007
Convent Of Jesus And Mary, Ambala Cantt
01.2004 - 01.2005
Similar Profiles
Shyam Shankar SShyam Shankar S
Packaged App Development Senior Analyst at Accenture TechnologiesPackaged App Development Senior Analyst at Accenture Technologies
Abinaya MudliarAbinaya Mudliar
Senior Data Analyst at Accenture TechnologiesSenior Data Analyst at Accenture Technologies
Bharat PeralaBharat Perala
Data Science Senior Analyst at Accenture TechnologiesData Science Senior Analyst at Accenture Technologies