Animesh Shukla

Bangalore, India

Email: acvx9f@r.postjobfree.com

Phone: +91-974*-***-***

PROFESSIONAL SUMMARY

5+ years of professional experience in Information Technology with experience in the field of Enterprise Data Warehousing (EDW) using ETL.

Working on UBS AG Client, CCIT from July 2015 till present.

Proficient in ETL (Extract – Transform – Load) using Informatica Power Center 9.1.0, SQL Server Integration Services 2008 (SSIS) and Open Text Integration Center 8.0 tool.

Extensive experience in working with SQL/T-SQL (DDL/DML) queries.

Experience with business Reports requirements gathering, business analysis and documentation via ETL and SAP BO Crystal Report.

Extensive testing ETL experience using & Informatica (Power Center) (Designer, Workflow Manager, Workflow Monitor)

Executed Software projects for Banking, Pharma and Life Science, Manufacturing and Financial Market Industry domain.

Self-motivated and able to work highly independently as well as in a group environment with an active team player attitude.

Excellent communication, interpersonal and analytical skills.

Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

Strong analytical skills with a knack for problem solving. TECHNICAL SKILLS

Programming Languages: TSQL 2005, PL- SQL, UNIX Shell Scripting

Databases: MS Access, SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, Oracle 10g/9i/8i, Oracle 11.2

Database Warehouse: SILO2, PMX Warehouse, GMARS 4.0, CCIT DW.

ETL Tools: Hummingbird Genio v7.1 /Open Text Integration (Genio) Center v8.0. SQL Server Integration Service 10.0 on MSSQL2008R2, Informatica Power Center 9.1.0

Other Tools: Quest Software TOAD, SAP BO Crystal Report, HP Quality Center ALM 11.0, EMBARCA, TOAD, Putty, Team Foundation Server

Operating Systems: Windows 95/98/NT/2000/2008/XP/Redhat Linux Rel-5.9 WORK EXPERIENCE

IBM India Pvt. Ltd., Bangalore Associate System Engineer Jul 2010 – Present Animesh Shukla

ETL Consultant

PROFESSIONAL EXPERIENCE

Project: UBS AG - Dragon Jul 2015 – Till Date

Brief Description:

UBS AG is the biggest bank in Switzerland and is considered the world's largest manager of private wealth assets offers a combination of wealth management, asset management and investment banking services in more than 50 countries with about 63,500 employees globally as of 2012. The Clients applications are further categorized in two category CCIT and WMRC applications. Under CTB Change the Bank program, we part of Dragon CCIT Team at L3 level(Team Size 4) were responsible for new development and providing minor enhancement to existing CCIT applications.

Role: Data Specialist ETL Informatica, Package Deployment. Jul 2015 – Nov 2015

● Analyzed the business requirement and designed the ETL process to integrate the processed Chain IQ Transition Program Cost Center data requirements.

● Extensively used Transformations like Source Qualifier, Joiner, Aggregator, Expression etc.

● Modified mappings as per the changed business requirements.

● Developed mapplets and worklets. Designed reusable transformations and shortcuts to share different mappings.

● Worked with mapping parameters, variables and parameter files and designed the ETL to create parameter files.

● A total of 12 mappings in total created for a single source file from UBS SAP System to Chain IQ system. Source file Tab CSV delimiter is sent 365 days a year via sftp to Informatica server on fixed path.

● Informatica acts as middle-ware between source and target 12 different target Chain IQ CSV files in a designated folder. The file type is determined by various business provided filters.

● Duplicate records are filtered to daily error file with different error messages based on duplicate columns and conditions.

● Used provided shell scripts for scheduling jobs daily and archiving monthly. Shell scripts are provided and dependent on Target Chain IQ systems third party tool. E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Animesh Shukla

ETL Consultant

Project: ELI LILLY Jul 2013 – Jun 2015

Brief Description:

The purpose of the implementation of Eli Lilly, PMX and GMARs Application warehouse is to understand the trends, performance and customer analysis of Lilly services. Subject areas covered in the GMARs warehouse are data associated with work order, asset, location maintenance inventory, vendors and manufacturing financial, purchase orders. And Subject areas covered in PMX Warehouse are PMX is the implementation of the Manufacturing Execution system and Warehouse execution system functionalities for manufacturing sites. PMX Provides limited reporting and charting capabilities.

Role: ETL Informatica Testing Team Lead Oct 2014 – Jun 2015

● Responsible for testing and reviewing of ETL Workflows using Informatica Power Center 9.1.0 for all Data Integration and Analytic s (20+)applications for Service Now Project.

● Responsible for testing successful migration of all application from legacy REMEDY to new SERVICE NOW system.

● Created Test Plan document, Test strategy document, Effort Estimations documents before starting project. Provided Onshore offshore coordination plan and work distribution.

● Assigning weekly task to team members and confirming closure to management. Defect Creation and management in HP Quality Center.

● Providing daily status report in Informal/Dry Run phase and Formal Testing phase.

● Created 15 formalized test scripts for various applications in HP Quality Center and did End to End management in QC. All test scripts were heavily based on testing Unix Shell scripts and testing Informartica Workflow execution, their timely execution through Crontab, correct shell scripts block execution, correct Ticket generation. 2 test scripts for Ticket generation using Informatica Mapplet. One test script for testing existing MCM ticket generation setup which checks more than 100 interfaces and generate tickets and send emails based on Lower and Upper Cut-off levels predefined in configuration tables.

● Extensively used Putty and Toad in entire cycle of project.

● All test scripts and defects were tracked, reviewed, analyzed using Quality Center in Formal Testing phase of the project. Extensively helped team member and Client Tester on using HP QC for uploading, executing, defect cycle etc.

● Executed 12 formalized test scripts in Quality Center capturing evidence etc. in two weeks Formal run duration.

● Provided Test Summary Report detailing test runs and their execution on conclusion of Formal Testing.

E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Animesh Shukla

ETL Consultant

Role: Enhancement- ETL Informatica Tester March 2014 to October 2014

● Responsible for testing and reviewing of ETL Workflows using Informatica Power Center 9.1.0 for GMARS DW migration project.

● Testing of ETL jobs that are scheduled for file transfers and daily data load using Unix Confab.

● Tested the performance bottle-necks at sources, targets, mappings, and sessions and employed required measures.

● Used Toad extensively for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.

● Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.

● Test Data creation for approx. 110 tables Type1 (Incremental load using Audit table) Type2

(auto-incrementing change identifier) and Type3 (Daily Re-load) and created Insert/Update and Delete for each table.

● Executed and managed Test Cases and reported bugs using HP ALM Quality Center.

● Test Scripts included main ETL test script, ETL Data Migration, ETL multiple source to single Target, ETL Failure Notification using Unix shell, Performance Testing, ETL Initial Load, Generic Database test script.

● Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center. Using PL/SQL procedure which supported RowVsRow and ColumnVsColumn verification did source vs target data comparison using DB Linked Views for 200+ tables.

● Involved heavily in parameter configuration for different Source/Target schemas in DEV/TEST/QAR for testing daily and initial load.

● Involved in performing various levels of testing like Unit Testing, Informal Testing with Test Data, System testing and Regression testing.

● Assisted Business team with planning, co-ordinate and execution of User Acceptance Testing before Production Deployment.

● Defects were tracked, reviewed, analyzed compared using Quality Center.

● Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.

● Involved in Test Reporting on daily/ weekly basis through prescribed format.

● Involved heavily in Data Simulation tasks with 200+ GB of data before Production deployment. Helped simulation team with data validation, table types in GMARS, configuration in main tables, provided feedback on using existing package for RowVsRow and ColumnVsColumn verification post simulation.

E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Animesh Shukla

ETL Consultant

Role: Enhancement- ETL SSIS Developer July 2013 to February 2014

● Involved in design/ build/ unit test/ deployment of Management Framework package for PMX project. Benefits includes decrease development/deployment time, single development/deployment strategy, easily configurable/reusable.

● Involved in adding Configuration Management Scheme (XML, SQL Server configuration)/ Logging (SQL server logging) and Auditing management scheme to Management Framework.

● Experience in creating configuration files to deploy the SSIS packages across all environments.

● Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)

● Involved in creating SSIS base Template package using above features and distributing it to PMX developers so that they can be dynamically deployed in development, test and production environments.

● Experienced in using Business Intelligence Development Studio (BIDS), Graphical User Interface (GUI) to design SSIS (SQL Server Integration Services) packages for Data Management applications.

● Excellent experience in migration of data from Excel source, Flat file source, Oracle to Microsoft SQL Server, OLE DB Source using File Transfer, file co- ordination and file achieving.

● Experience in Creating, Configuring and Fine-tuning ETL packages designed in MS SQL Server Integration Services (SSIS).

● Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

● Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

● Familiar with Incremental Extraction using- modified date or created date column from a database source, using an auto-incrementing change identifier column, using an audit table using DB trigger. Delete row logic in source DB translation to Target DW using Flag, using audit table.

Project: Jones Lang LaSalle Jul 2010 – Jul 2013

Role: Associate System Engineer (ETL Support)

● Involved in DB mapping for new report requirement and setup.

● Participated in the development and maintenance of a Date Warehouse Loading/Maintenance/Scheduling.

E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Animesh Shukla

ETL Consultant

● Supported Business critical report delivery/ support/ maintenance using Integration Center Designer.

● Worked on Integration Center Scheduler for running/monitoring & scheduling jobs & Integration Center Administration Console for Repository Database Set Up

(metadata)/Import/ Export/Activation.

● Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.

● Ownership and tracking of all data warehouse related issues.

● Performed entire disaster recovery for (DB warehouse).

● Performed analysis/design/metadata migration/unit testing for Genio upgrade from version 7.1 to 8.0.

● Performed entire (SILO2 DB Warehouse) migration from platform (Win2000/MS SQL server 2005(32bit) to platform (Windows2008/MS SQL server 2005(64bit))

● Worked on various reports/deliverables creation/setup via ETL or MS Excel reports for business.

● Migrated various critical existing long running MS Access applications to SQL Server 2005 Data Warehouse.

● Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverables.

● Involved in business requirements gathering to enable Data Integration across all business groups.

● Implemented many ETL Enhancement -job development through Integration Center Designer and their planning using Integration Center Scheduler for various reporting requirement.

● Involved in optimization of Linked Server SQL queries using OpenQuery in order to reduce job execution duration runtime.

● Developed ETL projects for Ireland DB Warehouse for Ireland for initial full loading and incremental loading based on Date Identifier.

● Extensively used Staging DB Design included Staging Database Area which included daily full refresh/ incremental load tables.

● The Project processes include, a Master Process which executes a number of Child Process based on Events. The processes created include a variety of transformations like Execute SQL Module, Script Module, Execute Package Task, File Connection, Derived Column, For Each Loop etc.

● Created ETL processes using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using Open Text Integration Center.

● Team ticket monitoring.

E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Animesh Shukla

ETL Consultant

● Supported Business critical application Yardi and its related 20+ associated Vendor based interfaces including (Ticket resolution, Change Management, Disaster recovery testing).

● Supported Imaging software (Optical Disk Storage) and further involved in migration from Optical Disc Storage to File System storage.

● Daily Checks for tier1 application.

EDUCATION QUALIFICATION

Bachelor of Engineering, Electronics & Communication, Bangalore Institute of Technology, Visvesvaraya Technological University, India, (Batch 2010). References Available on Request

E-Mail - acvx9f@r.postjobfree.com

Phone - +91-974*-***-***

Contact this candidate