SUMMARY

• Over 12 years of professional IT experience in Data Warehousing, ETL (Extract, Transform and Load) and exposure to Data Analytics.
• Played roles like Delivery Lead, Lead Data Engineer and Technical Manager.
• Handled responsible and accountable positions for supporting enterprise level ETL architecture and BI.
• Ability to handle multiple projects in parallel wif utmost precision.
• Experienced in delivering complex solutions by mentoring, guiding and leading large teams to work in harmony.
• Strong in Requirements Gathering, Designing, Consulting, Implementation and Production support.
• Strong understanding of Software Development Life Cycle (SDLC) and ability to work as the primary liaison between Business Users and Developers. Excellent Analytical and Problem - Solving skills, Leadership and management abilities and team spirit.
• Strong in Requirements Gathering, Designing, Consulting, Implementation and Production support.
• Trained and Mentored people on technical and functional of different team sizes.
• Excellent in oral & written communication, negotiation and leadership skills
• Experience in onsite-offshore model in managing large projects involving multiple teams across globe.
• Experienced in building robust ETL standards and best practices for DW/BI solutions.
• Extensive experience on ETL tools like Alteryx, SSIS, IBM DataStage, Informatica PC & Informatica Cloud (IICS), Pentaho-PDI and BODS.
• Experienced in reporting tools like IBM Cognos, Tableau and BOBJ.
• Profound knowledge on relational database management systems (RDBMS) including Oracle, MS SQL Server, Teradata and DB2.
• Proficient in SQL, T SQL and PL/SQL (Stored Procedures, Functions, Triggers, Cursors, and Packages).
• Proficient in scripting languages like, UNIX Shell Scripting, Perl, Windows Batch Script and PowerShell.
• Experienced in JavaScript, Python languages for data scraping and pipeline building activities.

TECHNICAL SKILLS

Languages: UNIX Shell Scripting, Perl, Windows Batch Script, Java Script, PowerShell, Python.

RDBMS: Oracle, Teradata, DB2, SQL Server 2012/2008

ETL Tools: SSIS, Informatica PC, Informatica Cloud (IICS), IBM DataStage, Pentaho-PDI, Alteryx, BODS

SQL: SOAP UI, XSLT, XSD, XPATH, XQuery, JQuery

IDE: SQL*Plus, SQL Developer, SQL Server Management Studio

Analytics/BI: IBM Cognos, Tableau and BOBJ

Misc Tools: GIT, Azure DevOps, JIRA, Autosys and Control M

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Responsibilities:

• Lead a team of 13 members to perform ETL and BI upgrade/migrate activities.
• To migrate the legacy data into EDW and integrate new ERP.
• To migrate the IBM Cognos reports to Tableau.
• Worked on various POCs including Alteryx and Hyper API solutions to create hyper extracts in Tableau.
• Created SSIS solutions for seamless integration of legacy and new ERP systems.
• Designed Batch Audit Process to monitor each ETL job along wif reporting status which includes table name, start and finish time, number of rows loaded, status, etc.
• Analyzed Stored Procedures to convert business logic into SSIS jobs
• Built Tableau workbooks for demoing the new data insights to the business users.
• Built Python scripts to scrape data from competitors’ websites

Confidential, New Britain, CT

Technical Architect

Responsibilities:

• Led enterprise level ETL architecture design initiatives.
• Developed Informatica Data synchronization tasks, Mappings, and workflows to load transformed data into CRM from various source systems such as SAP R2, and Flat Files.
• Extracted data from heterogeneous sources and performed complex business logic on data using Informatica Intelligent Cloud Services (IICS).
• Developed a reusable Change Data Capture (CDC) process for a standard incremental ETL process.
• Supported production jobs and developed several automated processes to handle errors and notifications. Also, tuned performance of slow jobs by improving design and configuration changes of code.

Confidential

ETL Architect

Responsibilities:

• Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including ERP system and external files, cleanse and tan load the data into the target data warehouse.
• Extracted data from ERP and created a landing zone.
• Built a stable ETL platform to address their enterprise DW needs.
• Responsible for ETL best practices and standardizations.
• Created Pentaho Data Integration Transformations & Jobs (aka Kettlewif UI as Spoon) to extract data from OLTP systems and load into staging databases
• Used different types of input and output steps for various data sources including Tables, Text files, Excel and CSV files
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Used several transformations in Kettle to cleanse, validate and improve quality of data before loading it into target schemas.

Confidential, New Britain, CT

BI Architect

Responsibilities:

• Led enterprise level ETL architecture design initiatives.
• Extracted data from heterogeneous sources and performed complex business logic on data using best practices.
• Integration of the various systems and arriving at the consensus of picking the right carrier based on cost needed a summarized view and special ETL complex logics were built in to cater the need.
• Supported production jobs and developed processes to handle audit, errors and notifications.
• Built parallel jobs to process the data in the given timeframe and enabled the transport team to pick the right choice for the delivery.
• Performance tuning of the ETL jobs and SQL server components was needed to fit the ETL process in the given window.

Confidential, New Britain, CT

ETL Architect

Responsibilities:

• Designed the complex solution in IBM Datastage to integrate various ERPs in a planned and phased manner.
• dis also involved migration of complex ETL logics in BODS to IBM Datastage as part of making the global ETL COE.
• Developed audit process using IBM Datastage Basic code by creating parallel routines and subroutines.
• Built heavy lifting jobs to handle huge volume.
• Developed a dynamic schema solution for addressing the integration of various systems dat would reduce the work for future integration of any new systems.
• Supported production jobs and developed processes to handle audit, Errors and notifications.
• Handled various projects along wif dis massive project in parallel.
• Developed BO universe & worked on creating crystal reports and Webi reports.

Confidential, New Britain, CT

ETL Developer

Responsibilities:

• Designed the complex solution in IBM Datastage to integrate various ERPs.
• Challenge was to understand the source system’s invoice statuses and do conditional updates in the ETL process. dis required a perfect ETL solution wif highest quality standards. Played the crucial role in getting dis delivered.
• The benchmarking for KPIs was a complex solution itself and dis was delivered wif highest precision and quality standards.
• Developed audit process using Datastage Basic code by creating parallel routines.
• Extracted data from heterogeneous sources and performed complex business logic on data using best practices.
• Developed a reusable parallel jobs template for a standard incremental ETL process.
• Supported production jobs and developed processes to handle audit, Errors and notifications.

Confidential, New Britain, CT

ETL Developer

Responsibilities:

• Designed the complex solution in IBM Datastage to integrate various ERPs.
• Challenge was to understand the various source systems data and to integrate them and do conditional updates in the ETL process. dis required a perfect ETL solution wif highest quality standards. Played the crucial role in getting dis delivered.
• Extracted data from heterogeneous sources and performed complex business logic on data using best practices.
• Developed a reusable parallel jobs template for a standard incremental ETL process.
• Supported production jobs and developed processes to handle audit, Errors and notifications.