Sr Consultant Resume
MN
SUMMARY
- Extensive experience wif expertise in analysis, design, development and implementation of Data Warehousing and Business Intelligence applications using ETL and BI tools such as Oracle, DB2, MS SQL server, and Teradata databases on windows and UNIX platforms.
- Has experience in tool selection and implementation, requirements gathering, project and team leadership and mentoring to junior developers.
- Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter 7.x/8.x/9.x (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets /Workflow Manager), Datastage 8.7(Designer, Director), Pentaho (Integration Designer) and complete noledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW, and Metadata repository.
- Hands on experience of Informatica tools Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
- Worked on Agile Driven project and very well aware of sprint planning, daily stands ups.
- Experience integrating Salesforce connector, Powerexchange connector for Mainframe wif in PowerCenter.
- Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, XML files, applications, Teradata, SAP sources and proficient in implementing complex business rules by creating reusable transformations, Workflows/Worklets, and Mappings/Mapplets.
- Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
- Experienced in using Business Objects XI R2 and Cognos 8.4 Report Developer to build user defined queries, reports to enable drill-down and slice and dice analysis on multiple databases.
- Strong expertise in relational data base systems like Oracle, SQL Server, MS Access, Teradata, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, and SQL-LOADER.
- Highly proficient in writing, testing, and implementation of triggers, stored procedures, functions, packages, and cursors using PL/SQL.
- Experience in Task Automation using UNIX Shell Scripts.
- Excellent analytical, problem solving, and communication skills wif ability to interact wif individuals at all levels.
- Flexible to work using new technologies.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Informatica Cloud, Power exchange 9.5, DataStage 8.7, Pentaho, SSIS.
Analysis/Reporting Tools: Business Objects 6.x/XI R2, Cognos 8.4, Oracle Discoverer 10g and OBIEE.
Data Modeling: Erwin, NORMA and MS Visio.
Scheduling Tools: Autosys, TWS,Control-m, DAC, Stone Branch, OPCON.
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0/2005/2008, DB2, Teradata V2R6, MS Access
DB Tools: SQL*Plus, SQL* Loader, NEXUS, TOAD 8.5, BTEQ, Teradata SQL Assistant, Teradata Loader Utilities (Multi-Load, Fast-Load)
Languages: C, C++, JAVA.
Environment: UNIX, HP-UX, IBM-AIX, LINUX, WINDOWS XP/NT/2000
Languages: SQL, PL/SQL, T-SQL, XML, UNIX, Shell Scripting
Other tools: BMC Remedy, PVCS Tracker, Clearquest, SharePoint and Visual Source Safe.
PROFESSINAL EXPERIENCE
Confidential, MN
Sr Consultant
Responsibilities:
- Teh main Objective of teh BIMECC project is rewrite teh ETL code to replicate teh operational datastore in to stage environment to avoid direct connections to teh transactional system for Medtronic energy component center(MECC).
- Worked on performance tuning and design issues wif current ETL loads.
- Extensively worked on Factory works, Test Vault, 3C, Kronos and JDE sources to bring data to teh Datawarehouse for reporting
- Extensively used Re-usable Objects like Informatica Mapplets.
- Performance Fine-tuned sources, targets, mappings, and sessions to improve teh performance.
- Extensively worked on migration of existing jobs on Autosys to TWS and making sure teh job dependencies stay teh same.
Environment: Informatica 10.1/10.2, Oracle 12c, SQL Server 2016, TWS, Toad 12.12, Service Now, WINCP, and Unix.
Confidential
ETL Informatica Consultant
Responsibilities:
- Validate existing template workflow to test Informatica 10.1.1 on teh sandbox environment to ensure smooth upgrade wif other environments
- Involved in all phases of teh project planning, design, construction
- Involved in tweaking teh whole ETL design for better performance of big parameter tables
- Including Dev, UAT and Prod, setting teh configuration files which is done in teh specified tables and created technical specs documents for all teh enhancements
- Create jobs on mainframe using JCL to update front-end screens data for production support tasks
Environment: Informatica 10.1.1, Mainframe, PowerExchange, My Passport, SQL Server 2010, Oracle 11g, Filezilla, ServiceNow
Confidential, MN
Sr Consultant
Responsibilities:
- Developed ETL code using Informatica to reflect teh business requirements.
- Communicated wif business customers to discuss teh requirements and enhancements.
- Created shell scripts to fine tune teh ETL flow of teh workflows.
- Did teh Performance tuning at teh functional level and at teh mapping level and used SQL overrides to minimize data transfer over teh network.
- TEMPEffectively used Informatica parameter files for defining mapping variables, workflow variables, and relational connections.
- Teh main objective of teh data conversion project is to convert Legacy JDE and SAP Data to Medtronic SAP Data so dat going forward Covidien’s business can be fully functional through Medtronic applications.
- Teh main Objective of teh BIMECC project is rewrite teh ETL code to replicate teh operational datastore in to stage environment to avoid direct connections to teh transactional system for Medtronic energy component center(MECC).
- Worked on performance tuning and design issues wif current ETL loads.
- Extensively worked on Material Classification, Business Partner Collection and Disputes Modules wif in SAP System.
- Used SAP LSMW and IDoc programs to load Data Files.
- Extensively used Re-usable Objects like Informatica Mapplets.
- Utilize Informatica cloud to bring teh data from force.com and wrote data replication tasks to stage teh data in to teh warehouse.
- Performance Fine-tuned sources, targets, mappings, and sessions to improve teh performance.
- Wrote Informatica mappings as a wrapper tool to load teh stage tables using conversion SQL.
- Expertise in setting up Informatica jobs in Autosys for daily, monthly loads.
- Extensively worked on migration of existing jobs on Autosys to TWS and making sure teh job dependencies stay teh same.
- Developed Informatica Pre-Session and Post-Session UNIX scripts to automate teh data load processes to target data warehouse.
- Extensively used oracle tuning techniques to improve teh performance on teh one-time data conversion loads to save time during cut-over simulation.
Environment: Informatica 9.6/10.1, Oracle 12c, SQL Server 2016, Autosys, TWS, Toad 11.6, SAP, Service Now, WINCP, and HP ALM, Windows.
Confidential, MN
Sr ETL Consultant
Responsibilities:
- Extensively involved in studying teh business requirements and developed teh mapping specifications from teh business requirements and teh data model.
- Developed Informatica Mappings and Sessions based on mapping specifications to load data from source flat files and RDBMS tables to target tables.
- Teh CEF project source data (flat files, relational databases) is extracted from all teh transactional systems and loaded into teh data warehouse, which is teh union of all teh constituent pieces of teh TCF businesses like Digital, Online banking, Customer Service, Teller etc.
- Distributed teh data from Worktables to many stage tables using Informatica.
- Repository administration such as creating repositories, folders, managing groups, users, and security.
- Part of Informatica Upgrade project to prepare test plan for workflows, batch scripts and Transmission jobs.
- Created multiple environments in database and corresponding folders in Informatica to ensure parallel development/QA during sprints.
- Extensively used Re-usable Objects like Mapplets to decode and encode PCI/NPI compliance data.
- Extensively worked wif MOVEIT team to setup inbound and outbound file transfers for teh project.
- Prepared Run book, job flows and other SLA documents for CEF and EMV Projects.
Environment: Informatica 9.1, Oracle 11g, Toad 11.6, Service Now, MOVEIT, Mainframe, WINCP, StoneBranch, Rackspace and HP ALM, Windows.
Confidential, Saint Paul, MN
Sr ETL/Informatica Consultant
Responsibilities:
- Involved in all phases of teh project planning, design, construction.
- Actively working on a PeopleSoft Conversion project for HR based system.
- Involved in teh migration of all legacy TACHY devices to teh new Dragon NXT environment.
- Involved in tweaking teh whole ETL design for better performance of big Parameter tables.
- Created Materialized views for different business lines and delivered teh files through EAI adapters.
- Worked on data management strategy to setup ETL competency center for BSC to standardize teh integration process overall.
- Experience in using PL/SQL oracle packages such as DBMS STATS, DBMS JOB and UTL FILE.
- Followed agile methodology principles to deliver teh code to production faster wifout unnecessary documentation.
- Used Bulk and FORALL to improve teh performance of PL/SQL blocks.
- Worked wif management in project origination & helped in creating some POC’s for testing teh performance of teh new servers and handling teh physical deletes of teh records from teh source system.
Environment: Informatica 9.5, PL/SQL, SQL Server 2008, Oracle 11g, HP-UX, Toad 11.5, SQL server Management Studio, WINCP and IBM Clearquest.
Confidential, MN
ETL Lead/Admin
Responsibilities:
- Implemented a new Customer Relationship Management (CRM) data warehouse for teh 4 PCG Metro Trust Advisory Centers for Wealth management bank customers.
- Developed Informatica Mappings and Sessions based on data mapping specifications to load data from Powerexchange Datamaps on mainframe and RDBMS tables to SQL Server Target tables.
- Developed baseline estimates for future Salesforce.com Project and wrote high-level data requirements.
- Developed Load Routines in powercenter to load data from force.com using salesforce connector.
- Developed change data capture(CDC) mapping routines using Powerexchange.
- Involved in working wif Implicit Cursors, Explicit cursors and Ref Cursors for writing PL/SQL store procedures.
- Tuned long running Source qualifier SQL queries and also helped teh Super users to tweak adhoc SQL queries for better performance.
- Experience working wif XML data using XML Parser transformation for a compliance business user.
- Created teh migration documents to migrate teh Informatica, UNIX scripts using Informatica repository manager and Powerexchange Navigator.
- 24x7 production support on rotation basis among teh ETL team members.
Environment: Informatica 9.5 Powercenter, and Powerexchange, Salesforce, DB2, SQL Server 2008, PL/SQL, LINUX, SSIS, SQL server Management Studio, Powerexchange Navigator.
Confidential, MN
ETL Lead/Admin
Responsibilities:
- Worked closely wif our Business line to understand their technical landscape and standards, source data models, data quality issues, information needs/requirements and translate them into ETL requirements specifications.
- Developed complex parallel jobs using DataStage designer and Quality Manager.
- Worked on production support tickets in ITSM and prioritized/triaged tickets in teh weekly support calls.
Environment: IBM InfoSphere Datastage 8.7, DB2, SQL Server 2008, LINUX, SSIS, SQL server Management Studio, WINSQL.
Confidential, MN
Sr. Informatica Consultant
Responsibilities:
- Involved in integration of data sources like flat files, SQL server, DB2, Oracle for IP Science project to teh Enterprise Data warehouse (EDW).
- Extensively used MD5 functionality wif in informatica to implement change data capture(CDC) to Improve teh performance of teh loads.
- Developed ETL Specifications, Mappings for WESTIP data source according to teh Thomson’s data warehousing coding guidelines.
- Developed, documented and executed unit test plans.
Environment: INFORMATICA 9.1, Oracle 11g, SQL Server 2005, LINUX, Business Objects 3.1, TOAD 10.1, WINSQL.