SUMMARY:

• Confidential is a Principal Consultant in the Business Intelligence practice at NTT Data with more than 12 years of experience assisting clients on Data Warehousing and Data Integration Projects.
• Confidential is an Informatica Architect with good client facing skills and strong written / oral communication skills. He has proven experience as Data Warehouse Architect in Designing Business/ETL process flows, Documenting Data Dictionaries, Defining Data Management tasks, Deliverables, Strategies, Standards, and Best Practices.
• Confidential has experience in Star / Snowflake Schema, Fact / Dimension Tables, Business Process Analysis, Production support, Data cleansing, Data analysis and Performance tuning of sources, targets, mappings sessions and SQL’s.
• He primarily worked in Business Intelligence/Data warehousing projects focusing on Informatica (Administration, Upgrade, Admin Console, Development, Power Center Web Service Hub, Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), DB2, Sybase IQ, SQL, Unix, Autosys, IDQ, Power Exchange, SAS, Oracle, MQ - Series and Performance tuning.
• Confidential has experience in working on Agile Methodology. He conducts "Scrum" meetings, daily stand-ups, reviews and retrospectives. He is also responsible for keeping "Sprints" on track. Confidential has been involved in different phases of Data Warehouse life cycle ranging from project planning, requirements gathering and analysis, offshore coordination, ETL design
• ETL development and testing, Reporting, integration, regression and user acceptance testing, implementation, system documentation and support. He has experience in executing complete SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) projects. He has strong troubleshooting, effective-QA and debugging skills.
• Confidential has maintained accurate data in project governance tools (HP Quality Center, JIRA, SVN, Clear Case & Clear Quest) including project plan estimates, Business Requirements, Design document, Unit/Integration/System Test Plan & Results, Deployment Plan & Schedule, User Response, Affirmation from User to close the Project & Lessons Learned. He also ensures that Project deliverable meets the Project Scope & Requirements.

TECHNICAL SKILLS:

ETL: Informatica Power Center 8.x and 9.x, Informatica Data Quality 9.xAdmin Console, Power Exchange 8.x, DMExpress (Syncsort), Informatica Analyst

Reporting: SAS 9.x, Business Object XI R4, Tableau 9.x

Databases: Oracle, Sybase IQ, SQL Server, DB2, DB2/400

Database Tools: Aqua Data Studio, Oracle SQL Developer

Middleware: Power Center Web Service Hub, IBM Web sphere MQ-Series

Operating Systems: Unix, Red Hat Linux, AS/400 (OS/400), Windows

Job Scheduler: Autosys, CTRL-M, Cron tab, Robot

Languages: SQL, PL/SQL, Unix Shell Scripting, Perl Scripting, Base SAS, SAS MACROS, SAS/GRAPH, SAS/SQL, RPG, RPGLE

Technologies: Strong knowledge of data warehousing concepts

Tools: HP Quality Center, JIRA, WinScP, File Zilla, Putty, Tortoise SVNRemedy, Rational Clear Case, Clear Quest

Microsoft Tools: MS Project, MS Visio, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City NJ

Senior Informatica Administrator & Developer

Responsibilities:

• Co-ordination with Data Modeler, Business & Systems (ETL & Reporting) team for Business requirements.
• Translate Functional Requirements Document into Technical Requirements.
• Create Unix shell scripts and configure parameter files.
• Create ETL mappings, sessions & workflows using Informatica Power Center Designer and Workflow Manager.
• Configure Concurrent Workflows and use SOAP UI to test workflows triggered through Power Center Web Service.
• Use Informatica Analyst to specify, validate, configure, test data quality rules and collaborate efficiently with Users to share profiles and implement data quality rules.
• Identify anomalies, manage data quality exception records and track data quality targets on an ongoing basis using Informatica Analyst.
• Use Informatica Developer to reuse all profiling and rule specifications from business analysts and data stewards across all applications and projects.
• Prepare test cases & perform Unit / Integration / System / Regression Testing. Assist Business during UAT.
• Create and configure Autosys JIL.
• Work with Test Leads & approve / reject defects in HP Quality Center 11.0
• Facilitate communication and collaboration within and around the team (release & sprint planning, user stories, etc.). Work with Agile Scrum teams to help resolve issues and conflicts.
• Provide technical guidance and mentor junior resource & offshore (Bangalore) team members.
• Performance Tuning of ETL and share ETL best practices with the developers.
• Work with Business Users & resolve issues logged / assigned in JIRA within the SLA.
• Use Tortoise SVN for version control of source codes (Shell Scripts, DDL and DML Scripts, Parameter Files, XML version of Informatica Workflows, etc.)
• Perform Informatica deployment using XML from Repository Manager.
• Manage Production & Non-Production Informatica Domains, Grids, Nodes and Repositories.
• Maintenance of ETL Repositories & Integration Services using Admin Console.
• Create the users and user groups in Admin Console.
• Create folders in Repository Manager and provide appropriate privileges to users.
• Create Connection Strings in Workflow Manager and grant appropriate access to developers.
• Perform BO Migration using SAP Business Objects Central Management Console.
• Perform Application Deployment / Migration weekly. This includes Informatica deployment, Database Changes, Unix and setting up Autosys JIL.
• Participate in Disaster Recovery Testing and Support with Infrastructure teams (Unix Admin and Database Admin)

Confidential

Senior ETL Administrator & Developer (Informatica)

Responsibilities:

• Involved in Business and Data Requirements. Analyze multiple data sources and document data mapping to meet the requirements.
• Extensively used Transformations like Source Qualifier, Expression, Look Up (Un-connected and Connected), Sequence Generator, Router, Joiner and Update Strategy.
• Use Designer to create Mappings and Workflow Manager to create sessions and workflows.
• Create Unix Scripts. Performance tuning of ETL mappings. Perform Peer Code Review.
• Promote ETL Best practices and educate ETL developers on those practices.
• Provide technical guidance and mentor junior resource & offshore team members.
• Prepare test cases & perform Unit / Integration / System / Regression Testing. Assist Business during UAT.
• Extensive experience in the Workflow Manager tool including creation of parameter files, setting session properties, workflow variables, etc.
• Provide 24X7 On-call support for Sev1/2 issue. Provide Root Cause Analysis for Sev1/2 issue.
• Monitor Informatica ETL jobs in Workflow Monitor.
• Participate in Weekly Change Management Review Process.
• Perform ETL Migration using Static Deployment Group
• Manage Production & Non-Production Informatica Domains, Grids, Nodes and Repositories.
• Maintenance of ETL Repositories & Integration Services using Admin Console.
• Created Data Maps using Power Exchange Navigator as per request from the Developers.
• Upgrade to Informatica 8.6 from 8.1. Installed Informatica 8.6 in Linux server, configured the domain, added nodes to the existing domain and configured the Repositories.
• Created the users and user groups. Created folders and provide appropriate privileges to users.
• Performed the builds. Configured the integration servers with different code pages
• The technologies in use included Informatica 8.1 / 8.6 / 9.1, Admin Console, IDQ, Power Exchange, Sybase IQ, Oracle10g, SQL, DB2, Perl, Business Objects, Unix & Shell Scripting. Control-M is used as a job scheduler Tool.
• Worked on PoC (Proof of Concepts) to replace SAS Dataflux with IDQ.
• Provide Weekly & Monthly reports to D&B ETL CoE Manager.

Confidential, Torrance CA

Senior BI (Business Intelligence) Tech Lead

Responsibilities:

• Work as Senior Business Intelligence resource for BICC (Business Intelligence Competency Center) Team. Solution environment was Informatica 8.1, SAS 9.2, SAS 9.1, Unix, Oracle 10g, PL/SQL, DB2, SQL, iSeries & MQ-Series.
• He was involved in requirement analysis of all minor / major enhancements.
• His job description involves following list of activities:
• Design / Develop / Change applications for Toyota Logistics & Data warehousing Application.
• Create mappings, Configure sessions, Set up parameter files and Develop workflows.
• Develop Unix Scripts. Maintain ETL Repositories & Integration Services using Admin Console.
• Create the users and user groups in Admin Console.
• Create folders in Repository Manager and provide appropriate privileges to users.
• Create Connection Strings in Workflow Manager and grant appropriate access to developers.
• Perform ETL Migration.
• Assist in User Acceptance Testing.
• Create SAS Users using SAS Management Console. Generate SAS Reports.
• Suggest Continuous improvements to Subject Matter Experts (SME).
• Provide Weekly & Monthly reports to Toyota Management.
• Confidential played an active role in Production support; coordinating bug fixes & analyzing root causes.

Confidential, McKinney TX

Technical Project lead

Responsibilities:

• Analysis of Requirements, Implementation of Change Requests, Preparation of Unit test cases / results, Plan & Monitor Test Execution, Analyze Test Results, User and Documentation.
• Provide Application Maintenance & Support on Viaware (WMS), JD Edwards (World soft) & EDI application.
• EDI coordinator for Confidential Inc. Worked on PO (850), Invoices (810), Remittance Advice (820).
• The technologies in use included Provia Viaware (WMS), EDI (Trusted Link), JD Edwards, iSQL, Oracle, SQL, Unix, Cron (Job Scheduler) & Shell Scripting.
• Incident Management and co-ordination between GMs/Accounting Director/Warehouse Managers, Users, IBM, Infor & other Support Groups in case of Warehouse & JD Edwards issues/problems.
• Assist Confidential accounting in closing their Trailer Close, Invoicing & Month end process (JD Edwards).
• Services include investigate, determine the cause of and repair all production problems during and outside of normal working hours (24 x 7), including support of the scheduled and on-request batch processing.

Confidential, Irving TX

Data Warehouse Developer(Informatica and SAS)

Responsibilities:

• ETL Developer in Data warehouse CoE team at Confidential .
• The technologies in use included Informatica 7.x, SAS 8.x, Teradata, Showcase, SQL, Oracle, Unix & Shell Scripting.
• He was involved in gathering Requirements from Client, Analysis of Requirements, Design, Preparation of Program Specification, Implementation of Change Requests, User, Documentation, Unit Test Plans & Results.
• Develop new & modify existing ETL mappings / sessions / workflows.
• Transfer Knowledge to Citi RtB Team after each enhancement for 24 X 7 application maintenance & support.
• Monitor Informatica ETL jobs in Workflow Monitor.
• Generate Dealer Activity Reports (SAS) & execute ADHOC requests from Business Users.
• Perform proof of concepts.

Confidential, Houston TX

ETL Developer(Informatica)

Responsibilities:

• Design and Create data cleansing, validation and loading scripts for Oracle data warehouse using Informatica ETL tool
• Involved in design of ETL mappings
• Created and Monitored Batches and Sessions using Informatica Power Mart
• Created data mappings to extract data from different source files, transform the data using filters, expressions, xml parser and lookup Transformations then load to Oracle data mart.
• Prepared Low Level Design for ETL mappings. Prepared Unit test cases for ETL mappings