SUMMARY:

• More than 17+ years of IT experience including 10+ years in ETL Development, Data warehouse, system analysis, gathering requirements, supporting project management and Legacy Application Development and Support.
• Specialized in Informatica PowerCenter, Data Quality, Oracle database, IBM Mainframes, DB2, Unix, Cobol, Requirement Analysis, System Design, Process flow, Workflow, Use and Test Case Development, Software Development Life Cycle (SDLC), System Testing, SCRUM/Agile development, Bug fixing, Documentation, Implementation, Production Support and Maintenance of systems.
• Extensive experience in Informatica Power Center client tools like Designer, Workflow Manager, Workflow Monitor, PWX and admin console. Certified PowerCenter developer and SCRUM methodology implementation certified.
• Implemented complex business rules using Informatica PC transformations, Workflows/Worklets, Mappings/Mapplets, and parameterized the environment for better handling of data control for users as well as production support team. Documented Test Plans, Test Strategies and Test Cases for various Data Warehousing projects implementation.
• Experience in performing Data Profiling on source data using Informatica Data Quality (IDQ) using Informatica Developer. Specialist in using transformations like Expressions, Lookups, Normalizer, XML, Stored Proc etc and Informatica S3/Redshift connector/integration experience.
• Very strong data base experience in Oracle 11g/10g/9i, MS Sql server 2008, Teradata and DB2.
• Expertise in Data modeling techniques like star and snowflake schemas using ERWin and SQL Developer Modeler tools. Resolved many to many cardinalities into one - to-many using bridge tables.
• Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture. Designed data marts for presentation layer to work with reporting tools like IBM Cognos.
• Utilized data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse. Designed and Developed process documentation to standardize ETL development activities for various data sources like Oracle, MS SQL Server, XML, JSON,COBOL, Flat files and Teradata
• Experienced in job scheduling using BMC Control-M, Autosys JIL files and IBM Tivoli Maestro.
• Strong performance tuning skills in tuning SQL Queries and stored procedures.
• Expertise in writing Stored Procedures in PL/SQL, DB2, SQL Server and queries.
• Proficient in Cobol, PL/1 programming and JCL job creation. Analyzed and changed CobolDB2 and IMSDB Cobol programs in mainframe environment. Experience in debugging COBOL, Cobol DB2 programs using Xpediter tool.
• Wrote numerous documents for Data Dictionary, Mapping Specifications, STM, Unit test cases.
• Experience in working on Health Care, Telecom, Automobile, Insurance, Banking and Retail domains.
• Team player, Self-motivated and dynamic with excellent oral and written communication skills. Quick learner and adaptive to new and challenging technological environments.
• Excellent Analytical and problem solving skills, systematic approach to programming tasks and good interpersonal skills.

TECHNICAL SKILLS:

Languages: COBOL, PL/1, JCL, SQL, PL/SQL, C, VB/VB.NET

Scripting: Unix shell scripting, VB Script and Java Script

Databases: Oracle, SQL Server, DB2, Teradata.

ETL Tools: Informatica PowerCenter v 9.x/8.x, Informatica Developer 9.x, Informatica IDQ, Talend data Profiler

Data Modeling Tools: Erwin Data Modeler, MS Visio, SQL Developer data modeler. Data Vault 2.0,Star Schema, Snow Flake Schema, Fact and Slowly Changing Dimension Tables, Physical and Logical

Other Tools: SQL developer, IBM Data Studio, IBM Cognos 10,Teradata SQL Assistant, PL/SQL developer, Toad, SVN, Visual Studio, Autosys, Tivoli Maestro.

Operating Systems: UNIX-AIX, Solaris, Windows, MS DOS, MVS

Methodologies: Waterfall, Agile, SCRUM

Schedulers: AutoSys, Control-M, IBM Tivoli Maestro and CA-7

PROFESSIONAL EXPERIENCE:

Confidential, The Woodlands, TX

Informatica Solution Designer

Responsibilities:

• Negotiated with Stakeholders regarding business requirements, functional specifications and facilitated enhancements, based on the business needs created technical design and modified functional specification documents with phased approach in development of the project.
• Secured all the requirements for ETL work estimations and Unified process of cost estimation for all development work, Implemented and standardized process for ETL team.
• Coordinated with various teams and facilitated for smooth migration of Informatica version upgrade to 10.2 from 9.5.
• Coordinate with application team and develop all ETL processes. Assist development teams to maintain all data sources. Proactively identifying, tracking, managing, and resolving software and technical issues
• Evaluate all functional requirements and map documents and perform troubleshoot on all development processes
• Collaborate with application groups to prepare effective solutions for all programs. Documents all technical specifications and associate project deliverables.
• Design all test cases to provide support to all systems and perform unit tests.
• Maintain knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to the BI department.
• Lead the production release process including planning, development, testing and communication/ coordination with other teams.
• Develop automated file retrieval from shared folders, FTP and others data sources into the warehouse. Ensuring application systems are operating within service levels
• Provides in-depth analysis of operational data to perform root cause analysis and improve efficiency, productivity and customer satisfaction. Surfaces recurring problems with work processes, policies or procedures.
• Evaluates new projects and opportunities. Identifies and implements new reporting solutions to provide accurate and detailed project analyses.
• Troubleshoot problem areas (in person, by telephone, or via e-mail) within service levels on a level I and/or II basis. Rotational overnight support on a weekly basis is required
• Co-ordination with Change Management team to facilitate implementation through ticketing process and KT sessions.
• Work with DBAs, Architects and other teams as necessary to facilitate quality and timely project completion.

Environment: Informatica PowerCenter 10.2/9.5, Oracle 12c / 11gR2, SQL Server 2008, Flat Files, Toad 12.5, Erwin, SQL, PL/SQL, Shell Scripting, Control-M, Jira, Confluence, SVN. Tableau

Confidential

Informatica Solution Designer/Architect

Responsibilities:

• Negotiated with Stakeholders regarding business requirements, functional specifications and facilitated enhancements, based on the business needs created technical design and modified functional specification documents with phased approach in development of the project.
• Handled triage meetings within JAD (Joint Application Development) sessions for various CR’s, development changes and within project delivery time line changes to expedite.
• Secured all the requirements for ETL work estimations and Unified process of cost estimation for all development work, Implemented and standardized process for ETL team.
• Coordinate with application team and develop all ETL processes. Assist development teams to maintain all data sources. Proactively identifying, tracking, managing, and resolving software and technical issues
• Provide an efficient interface with brand for all processes across various platforms. Administer all requests and analyze issues and provide efficient resolution for the same. Design all programs and systems and associate documentation for same
• Evaluate all functional requirements and map documents and perform troubleshoot on all development processes
• Collaborate with application groups to prepare effective solutions for all programs. Documents all technical specifications and associate project deliverables.
• Design all test cases to provide support to all systems and perform unit tests.
• Responsible for ensuring ongoing compliance with development practices in the business intelligence program.
• Maintain knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to the BI department.
• Lead the production release process including planning, development, testing and communication/ coordination with other teams.
• Develop automated file retrieval from shared folders, FTP and others data sources into the warehouse. Ensuring application systems are operating within service levels
• Provides in-depth analysis of operational data to perform root cause analysis and improve efficiency, productivity and customer satisfaction. Surfaces recurring problems with work processes, policies or procedures.
• Evaluates new projects and opportunities. Identifies and implements new reporting solutions to provide accurate and detailed project analyses.
• Troubleshoot problem areas (in person, by telephone, or via e-mail) within service levels on a level I and/or II basis. Rotational overnight support on a weekly basis is required
• Co-ordination with Change Management team to facilitate implementation through ticketing process and KT sessions.
• Work with DBAs, Architects and other teams as necessary to facilitate quality and timely project completion.

Environment: Informatica PowerCenter 9.6/9.5, PWX for RedShift, Oracle 12c / 11gR2, SQL Server 2008, Flat Files, XML, Mainframe - Cobol, Erwin, SQL, PL/SQL, Shell Scripting, Control-M, Oracle EDQ, Data Vault 2.0,Informatica IDQ, JSON Sources, Teradata, MicroStrategy

Confidential

IT Consultant - ETL

Responsibilities:

• Negotiated with Stakeholders regarding business requirements, functional specifications and facilitated enhancements, based on the business needs created technical design and modified functional specification documents with phased approach in development of the project.
• Handled triage meetings with in JAD (Joint Application Development) sessions for various CR’s, development changes and within project delivery time line changes to expedite.
• Secured all the requirements for ETL work estimations and Unified process of cost estimation for all development work, Suggested and standardized process for ETL team.
• Identifying root cause for failures and segregated to reproduce the failure for better solution of the problem and this approach improved testing team capacity as well.
• Utilized varied sources, applying business rules and loading them to target Data Marts using Informatica Power Center tool in batch mode solution environment.
• Designed and Developed convoluted Mappings flows of data in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML, Normalizer, Update strategy and Sequence generator transformations etc.), Mapping Parameters/Variables, Parameter files, SQL overrides, Transformation Language.
• Simplified business rules and created data cleansing logics from data profiling the source data /files. It helped in design of developing data model, mappings, workflows and environment.
• Implemented SCD Type2, SCD Type1 dimension tables, incremental load, Snapshot and transactional fact tables, headers and footers to Flat File, dynamic input/output Files process.
• Scheduled the Workflows to run on a daily and weekly basis using Autosys Scheduling tool.
• Provided support to the QA team for various testing phases. Achieved project excellence for having minimal bugs in ETL code. Supported business for internal audit by using metadata manager with the help of lineage and business glossary.
• Documented mapping specifications, STM, Unit Test cases, procedure and results and other artifacts. Resolved issues during QA and tuned ETL for better performance at Source, Target, Mapping and Session levels.

Environment: Informatica PowerCenter 9.5, Oracle 11gR2, SQL Server 2008, Flat Files, XML, Mainframe - Cobol, Erwin, SQL, PL/SQL, Shell Scripting, IBM Cognos 10, Autosys.

Confidential

Sr DWH Consultant

Environment: Informatica PowerCenter 9.6, Oracle 11,DB2, Flat Files, SQL, Shell Scripting, TWS Maestro, WinSCP, Universal SQL Developer

Roles & Responsible for:

• Provide architectural oversight and monitoring of the technical implementation offshore team’s work to ensure adherence to enterprise architectural standards, as well as compliance with business requirements, IT policies and procedures, and regulatory requirements
• Identify areas of architectural risks and provide recommendations to mitigate risks
• Identify areas of potential improvement and provide solutions for the Enterprise Data Management process
• Synthesizes, aggregates, and validates data from disparate sources to create reporting key metrics
• Troubleshooting and identifying data discrepancies between data sources, including interpretation and validation of specialized campaign data
• Review and agree on requirements and designs with relevant business owners
• Assist and coordinate user testing, ensuring issues are resolved in a pragmatic and appropriate manner
• Provide technical support for projects and existing systems in cooperation with other team members including issue identification, log review, job flow dependencies and resolution. Client support for on call, after hours, weekends, and public holidays when required
• Consult with various solution architects across multiple technology groups in order to design and implement a robust end to end solution. Execute the bank-wide data governance framework. Implement proof-of-concept prototypes
• Develop and unit tested mappings, Sessions and Workflows with sources like relational tables and Flat files. Developed Relational table definitions, views and write complex override SQL’s. Implemented CDC, SCD1, SCD2, incremental load, Snapshot and transactional fact tables, headers and footers to Flat File, File list.
• Promote Code to SIT and Production using ICEM code management tool.
• Subject Matter Expert (SME) in the team for Informatica Power Center and Exchange 9.1 for reading VSAM/COBOL sources.
• Work in Agile methodology Environment for projects with multiple sprints.
• Developed Maestro Schedules and Jobs for running Unix, Informatica and Db2 load jobs. Debug Informatica jobs for complex mappings and data flows.
• Conduct and proactively participate in Defect/Change request triage meetings on daily and weekly basis.
• Resolve Priority tickets as P1/P2/P3. Use HP ALM to update the status of ongoing defects
• Responsible for project deliverables to be documented thoroughly like Recovery specifications, Project Change

Confidential

IT Consultant -ETL

Responsibilities:

• As a Sr. Developer involved in coding and unit testing accounting module integration.
• Involved in enhancing the current Quarterly NBR reports. Involved in production support and automation of monthly Valuation process. Facilitated the QA team with System Testing.
• Walk through of Business requirements with offshore teams and managed query resolution.
• Mentored new team members (onshore and offshore) and provided business knowledge to reduce the learning curve. Preparation and review of HLD & LLD. Migrated data from legacy to Oracle systems.

Environment: Informatica PowerCenter 9.1, Flat files, Oracle 11g(OLAP), Erwin, Toad, AIX-Unix, SQL*Loader, CSV files, Autosys, DB2(OLTP).

Confidential - Connecticut

ETL Solution Lead

Responsibilities:

• Transition from mainframe development to Informatica PowerCenter ETL development.
• Metadata Management, data lineage, business glossary using Informatica.
• Successfully managed cross-functional teams from 7 to 24 people (on-site and remote management)
• Monitor project milestones, technical status, and critical dates to identify potential jeopardy of project schedule; and identify ways to resolve schedule issues; and keeping management aware of the situation.
• Mentored the team and provided technical assistance whenever required to the team.
• Ensured delivery excellence; by taking up ownership of complete end to end project delivery and ensure customer satisfaction; through total control on the projects across multiple technologies.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Act as a one point contact during project implementation with a hands-on approach to testing, QA, training, user documentation, user support, and follow-ups.
• Creation and maintenance of clear, consistent and complete knowledge capsules in Knowledge Management System for the project.
• Manage all reporting needs for the project; standardize daily reports, create presentations and executive reports for senior management.
• As a Tech lead provided technical leadership through expert understanding of the project life cycle and business requirements, review of System Requirement and Analysis.
• Determined nature and scope of enhancements and problems and made recommendations for design solutions.
• Work with designers/developers and determine how we could enhance our testing by creating automation tools, writing queries, etc.
• Act as a liaison between the QA Automation team and development team and provide technical recommendations as and when required.
• Walk through of Business requirements with offshore teams and managed query resolution.

Environment: Informatica PowerCenter 8.5, Flat files, Oracle 10g, Erwin, Toad, AIX-Unix, SQL*Loader, CSV files, Autosys, DB2, IBM Mainframe COBOL, JCL, Teradata, Cognos 8, SQL Server), DB2,Endevor,CA/7,BMC

Confidential

Project Lead

Responsibilities:

• Interpreted the requirements of business into design solutions.
• Accountable for designing, coding, development, testing, documentation and debugging to fulfill the requirements of one or more user areas.
• Make recommendations, researches and find out alternative solutions.
• Provided technical assistance to the team members as and when needed.
• Created and updated system's functional and reference documentation.

Confidential, NH

Tech Lead

Responsibilities:

• Involved in requirements gathering, analysis and coding.
• Prepared analysis document and program specification documents.
• Responsibilities included an extensive analysis of the given problem, fixing the problem followed by coding, testing and reviewing the changed components.
• Responsible for coding COBOL, DB2 modules, writing JCL for batch programs.
• Prepared Unit Test cases. Responsible to perform unit testing and supported System testing.
• Responsible to perform peer code reviews and test case review.

Confidential, NJ

Sr. Developer

Responsibilities:

• Involved in requirements gathering, analysis and coding.
• Prepared analysis document and program specification documents.
• Responsibilities included an extensive analysis of the given problem, fixing the problem followed by coding, testing and reviewing the changed components.
• Responsible to perform unit testing/
• Responsible to perform peer code reviews.

Confidential, PA

Developer

Responsibilities:

• Development and Maintenance of various components which includes Tele Marketing, Mail and Customer Support, Order Processing, Ware House Management (WMS) system and Inventory Management System.
• Prepared analysis document and program specification documents.
• Coded Interfaces for getting data into and out of MACS system
• Responsible to perform unit testing.