SUMMARY:

• Possess more than 20 years of experience in IT industry, out of which, more than 12 years in Data Warehousing projects.
• Worked as Tech Lead, BI Lead, Informatica Architect, Lead Data Architect, Technical Lead, PMO Content, Project Leader, Informatica ETL Lead, Oracle DBA.
• Knowledge in Big Data, Hadoop, Cassandra, Couchbase, Python, Tableau etc.
• Certified Informatica 8 Designer and 6.x Consultant (Certificate#: Consultant: 194690, Administrator: 65119 and Designer: 131082). Worked in Informatica 8.x products.
• Responsible for data modeling (Star schemas), design and development of ETL architecture and mappings for a Data Warehousing project, data modeling for data warehouse, data validation with Cognos cubes, capacity planning of database.
• Other job descriptions like Oracle DBA (Oracle Installation, Back - up, Recovery, Grants, Privileges, Database and Application Optimization etc.), Exposure to Oracle9i. Following organizations' and client's quality processes, Project management, scheduling and assigning tasks. Domain knowledge of Sales and Distribution, Payroll and Personal Information System, Marketing.

TECHNICAL SKILLS:

ETL: ETL Informatica 9.5.1/8.6 /7. x/6.x/5.x, Certified Informatica 8 Designer, Certified Informatica 6.x Consultant. Pentaho, Oracle Data Integrator (ODI) v10.1.3.5

Data Science: Python

Visualization: Tableau

BI: BI Concepts, Reasonable knowhow of Cognos and OBIEE (Oracle Business Intelligence Enterprise Edition) tools.

Data Integration: Informatica XE (B2B), Complex Data Exchange (CDE/DT)

Tools: ERWin, Designer 6i, Informatica PowerPlug, TOAD, SQL Station, Advanced Query Tool, Quest Central for DB2, Rational Rose, VSS, PVCS, MS-Office, MS-Project etc., Alliance Remedy 4.05.02, $Universe, Autosys scheduler, Informatica Proactive Monitoring tool

Databases: Oracle 11g/10g,/9i/8i/7.x, Oracle 8i (DBA), Integrated DBMS of AS/400, DB2 v7, MySQL, SQL Server

Languages: Python, C, C++, Pascal, RPG/400, CL/400, SQL, Oracle PL/SQL, Java2, Confidential -SQL

GUI: Developer/2000 Rel 1.3 (Forms 4.5, Reports 2.5), Developer 6i

Application Server: Powertier 6.0, Exposure to Oracle9i Application Server

Internet Technology: Basic knowledge of Java, Servlet, JSP, XML/XSL

Hardware: HP servers Infinity, AS/400

O S: Windows NT, Unix(Sun Solaris 5.8), Windows, MS-DOS, OS/400, AIX Unix Server, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

• Analysis and design of OMX new brands - refactoring issues, Orders, Order Status, Shipments and Continuity memberships, Contra Revenues
• Physical and Logical Data Modeling
• End to End ETL Data Integration solution for all the business requirements in Fulfillment business area.
• Complex SQLs to retrieve data for various business needs such as Pattern search, %age trend, attrition etc
• Support for Integration testing, UAT and deployment
• Post deployment production bug fixes
• Development of refactoring shipments and accounting related reports
• Oracle SQLs and ETL Performance tuning
• ETL development using Informatica Powercenter
• Oracle SQLs scripting

Technical Environment: Oracle 11g, Informatica 9.5.1, TOAD, Cognos 8.3, MySQL, SQL Server

Confidential

Tech/BI Lead

• Designing ETL solutions using Informatica and Oracle platform.
• Creating critical - path, high-risk, advanced and/or cross-functional technical designs.
• Collaborating with other teams on integration needs/design.
• Participating and contributing to Nike's overall architectural footprint, direction, and standards.
• Performing application support, problem solving, and issue resolution with internal and external resources.
• Contributing to technical solutions by performing technical analysis and identifying options and solutions, internal and external resources.
• Contributing to technical solutions by performing technical analysis and identifying options and solutions.
• Identifying technical issues and determining options for issue resolution and risk mitigation.
• Defining and communicating requirements for technical environments and determining the technical scope for projects.
• Creating and appling architecture, governance, security, and global process standards to system changes and deployments.
• Establishing, maintaining, and appling coding/configuration standards and best practices.
• Reviewing and approving test plan, test execution, and validation
• Conducting performance monitoring and analyzing performance against benchmarks.
• Analyzing business requirements and creating performance testing scenarios that ensure application performance meets customer needs.
• Reviewing and approving performance test results, recommendations, and tuning results.
• Mentoring the team for any technical issues.
• Point of Contact for GCD360 track for technical discussions
• Provide weekly status to the reporting manager

Technical Environment: Oracle 11g, Informatica 9.1, TOAD, Tableau, Informatica Proactive Monitoring Tool, Autosys scheduler.

Confidential

Data Integration Lead

• Managing EDW environment and multiple sub - projects
• Involved in many other data acquisition projects and analysis
• Pentaho to Informatica ETL conversion
• Involved in BI migration to Cloud (Savvis)
• Daily, weekly and monthly data load monitoring (Informatica ETL) and monitoring. Resolve issues if any during the data load. Enhancement/changes to the system.
• Mentoring the team for any technical issues.
• Point of contact for EDW data issues, International projects and other Data Acquisition projects.
• Regular discussion with respective offshore coordinators for critical decisions and/or planning.
• Prepare weekly status report and discuss with client Managers for any queries/decisions

Technical Environment: Oracle 11g/10g, Informatica 9.5.1/8.1, TOAD, Cognos 8.3, MySQL, Pentaho

Confidential

Data Integration Lead

• Managing multiple projects and pool of resources to meet the need of offshore support/development
• Daily, weekly and monthly data load execution (Informatica ETL) and monitoring. Resolve issues if any during the data load.
• Follow - up with users and team to resolve the issues.
• Enhancement of SSIS ETL packages. Support to SSIS and Cognos administrative queries.
• Mentoring the team for any technical issues.
• Managing a team of 4 technical persons and tracking their tasks
• Single point of contact for offshore development and support.
• Regular discussion with respective onsite coordinators for critical decisions and/or planning.
• Prepare weekly status report and discuss with client Managers for any queries/decisions
• Technical Environment: Oracle 10g, SQL Server 2005, Informatica 8.1, SSIS 2005, TOAD, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle 10gSQL Developer.

Confidential

Technical Architect

• Resolving Sales related issues.
• Communicating with business users to resolve their issues and other groups such as Marketing and Finance sustainment.
• Follow - up with users and team to resolve the issues.
• Mentoring the team for any technical issues.
• Managing a team of 4 technical persons.

Technical Environment: Informatica 8.5, Oracle 10g, Teradata, PL/SQL, Teradata SQL Assistant 7.1, Unix.

Confidential

Informatica Architect

• Study existing EAI system and come up with the architecture to implement using Informatica B2B tool.
• Set the standards and methodologies for developers providing sample use cases.
• PoC of new features/technologies and guide the developers to use the same.
• Design ETL architecture for the project

Technical Environment: Informatica 8.5.1/8.6, Informatica B2B (XE), Complex Data Exchange (Data Transformations), Oracle 10g, PL/SQL, Unix.

Confidential

Lead Data Architect, ETL Designer, ETL Developer

• Study AS - IS SCM Process Map from already existing ETL mappings.
• Determine effort estimates for each module for ETL part.
• Design and implement necessary changes in the mappings as per Abbott s standards including data error handling, purging strategy and incremental data load strategy.
• Develop transformation specs for each mapping.
• Technical Environment: Informatica 6.2, Oracle 8.1.7, PL/SQL, Cognos 7, Coldfusion, Unix.

Confidential

PMO Content, Support to CRPII

• Provide support to CRP (Conference Room Pilot) phase II to business users.
• Understand and execute functional test scripts.
• Do Technical Review of ETL scripts and Oracle Workflow.
• Provide substance to the Model Office Testing Project Management.
• Interact with all Business Groups (Canada, US and Corporate) and around 34 Business Units.
• Create standards documentations and governance model.
• Create Model Office Test Plan document.
• Study the Defect Management and create accordingly for Model Office.
• Tracking of Action Items and Issue Logs.
• Track all phases of the project by generating consolidated status reports of all Business Groups and Business Units.
• Follow - up for Model Office sign-off.

Technical Environment: Oracle Confidential, Unix, Mainframe, OWB, Oracle Workflow, OFA, Oracle Discoverer, Oracle 9iR2 database, Lotus Notes, Test Director.

Confidential

Informatica Tech Lead, Analyst, Project Lead

• Providing maintenance and support to the Customer Insight module, part of Marketing IT and G2C Managed Services.
• Monitoring data load batch jobs on daily basis.
• Implementing Enhancement or Change Requests.
• ETL load tuning.
• Onsite coordinator for the onsite - offshore module.
• Hardware and enhancement estimation and impact analysis. Supporting application engine and supporting tools.

Technical Environment: Informatica 5.2, Oracle 8.1.7, Toad, Livelink, Visio, ERWin 5.x, Remedy (Alliance Software), $Universe, Unix.

Confidential

Project Leader-Offshore

• Providing support to the Siebel CRM application.
• Monitoring data loads on weekly basis.
• Collecting statistics and analyzing the same.
• Implementing Problem Reports or Change Requests. ETL load tuning.

Technical Environment: Informatica 5.2, DB2 v7, Quest Central for DB2, Advanced Query Tool, Unix.