SUMMARY

• 12+ years of IT experience with planning and execution, design and build, deployment and managing the implementation of full cycle projects for Banking, Healthcare, CRM, and Retail industries.
• Seasoned Consulting in Business Intelligence area by working with Wipro, Confidential, Confidential and clients such as Confidential, Confidential, Gilead Science, City of New York and Bank of India.
• Experience working in 5 full life - cycle implementation which covers all phases of SDLC.
• Innovative and creative problem solver, who is result oriented, has an aptitude for learning new solutions and technology’s.
• Dedicated to translating changing business objectives into cutting edge technical solutions.
• Strong business & technical vision, recognized as an energetic team leader, strong communicator, and motivational team member with focus on a solutions based approach in solving IT problems while exceeding customer expectations.
• Proficient in leading on-site/offshore/3rd party project teams & ensuring IT design/delivery governance.
• Strong experience working in the area of Enterprise Data Management which includes Architecture Design, Data Governance, Data Analytics and Metadata management.
• 8+ years of strong experience working in Informatica Power Center - ETL.
• 6+ years of strong experience working in OBIEE.
• Expertise in designing and developing Informatica MDM and Data Quality products.
• Expertise in designing and developing logical and physical database applications, Dimensional Schema Models (Star, Snow-Flake), OLAP Cubes and Decision Support System (DSS). Hands on experience in ER and Dimensional Data Modeling using ERWIN.
• Expertise in Dimensional Data Model Design, Data Mart/Data Warehouse Project design, ETL process design using Informatica Power Center 9.1/8.6x/ 8.2/7.2.4/7.1.1/6.2.
• Lead and managed Installation, Configuration, Administration & Development of Informatica Power Center ETL, OBIEE with Informatica & Linux, OWB with OFSA & Oracle suite.
• Designed and developed complex mappings using various transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Actively involved in Performance Tuning and Error handling on Informatica projects.
• Designed and developed metrics in metadata (rpd) using all 3 layers and Reports & Dashboards using OBIA.
• Expertise in development of SQL, PL/SQL programs for data loading into Data Warehouse.
• Hands on experience in Oracle Warehouse Builder that includes Installation, Configuration, Administration and development. Reporting tools experience include Business Objects and Cognos.
• Knowledgeable in Apache Hadoop YARN and MapReduce for Big Data Analytics. Self-learning for a certification.

TECHNICAL SKILLS:

ETL Tools: Informatica PC, Oracle ODI, Microsoft SSIS

Business Intelligence Tools: OBIEE, MS Analysis Service

OBIEE Apps: Financial, Procurement & Spend, Supply Chain & Order

Management: MS Project Management and Office suite.

RDBMS: Oracle 11g/10g/9x/8i, SS 2008/2005/2000.

Programming Languages: PL/SQL, UNIX Shell Scripts, Visual Basic, C++, and Core Java.

Operating System: Windows Family, HP UNIX, Red Hat Linux 4/5.

Hands on: Oracle DRM; Business Objects, Cognos, Crystal Reports.

Knowledgeable: Hadoop, IBM DataStage

Data Modeling Tool: ERWIN 4.5.

PROFESSIONAL EXPERIENCE:

Confidential, Bolingbrook, IL,

Senior Consultant

Sr. Informatica developer/ Team Lead

Responsibilities:

• Lead and coordinated with Functional team for requirement gathering. Reviewed Technical documents for sign-off deliverables.
• Lead the Design and Development phase for data store. Was the point of contact for any technical Informatica issues
• Was liaison between various departments for heterogeneous sources from Oracle, SQL Server, and Flat Files.
• Designed and Developed ETL, metadata and reports using Informatica and BO.
• Lead Informatica installation and configuration of Production, UAT and Testing environments.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Managed Production Support team of 3 resources and also a single point of contact for any Issue Resolutions.
• Lead the agile process for bi weekly update to the base code which included issue handling, remedy and new requirement deployment.
• Coordinated with Test team to ensure quality deliverables and was reviewer for all Technical documents. Assisted testing team in migration and testing process for go-live in all environment.

Confidential, NJ

Data Analyst, Senior Developer

Responsibilities:

• Worked with project shareholders and was a Technical Advisory in creating a Global data group and its functions within Confidential .
• Implemented Master Data Management using Informatica MDM with custom dashboards in java code and reports in BO.
• Provide guidance and training for setting up, configuring and implementation of data quality projects using the Confidential internal Data Quality Platform.
• Managed metadata portal as a part of analysis of the data elements applicable for the Product Processors.
• Implemented DQ application Guide cross-team efforts in requirements, quality assurance, and operational stability for the Data Quality Platform.
• Designed Data Privacy, Implementation and Operations processes used across the program. Data Quality Platform (Nov 2011 to Jan 2014)
• Implemented DQ custom built data mart; went live initially for Anti-Money Laundering transaction data to verify and monitor quality. Currently DQP is live with AML, Risk, Finance and Genesis data. Single point owner of all applications track for the Customers.
• Lead and coordinated with Functional team for requirement gathering. Reviewed Technical documents for sign-off deliverables. Assisted Technical Architecture and Testing team in migration and testing process.
• Lead Informatica software upgrade 8.6.1 & 9.2. Co-ordinated with multiple business, technical and testing teams for successful implementation in all environments.
• Designed, Developed and Supported custom built Informatica ETL objects, BO reports and Java based dashboards.
• Successfully done Informatica ETL deployments in all testing and implementation phase across 3 regions.

Confidential, CA

Analytics Project Lead

Responsibilities:

• Coordinated with management team to create OBIEE Road map for Phase 1 & Phase 2 implementation. Coordinated with the Functional team for requirement gathering.
• Served as a liaison between various groups specialized in defining technology strategy for integrating OBIEE with DRM and Hyperion.
• Lead a team of 10 resources, managed two off-shore resources which includes assignment, monitoring and review of tasks.
• Lead Installation and configuration of Production, UAT and Testing environments. This includes OBIEE 10g, OBIA 7.9.6, Informatica 8.6.1 & 9.1, DAC 10g with Clustering on Red Hat Linux 5
• Configuration done based on Gilead’s requirements for Financial, Procurement & Spend and Supply Chain & Order Management modules.
• Reviewed Technical documents for sign-off deliverables. Assisted Technical Architecture and Testing team in migration and testing process.
• Developed ETL and OBIEE development standards which tailor industry and client requirements for the implementation. Designed and developed Customized reusable OOTB ETL objects and made reusable for requirements.
• Successfully done OBIEE/ETL deployments in all implementation phase.

Confidential, Florham Park, NJ

Solution Architect, Design & Development Lead

Responsibilities:

• Lead the Design and Development phase for both OLTP and OLAP systems. Managed 10 resources and was the point of contact for any project issues.
• Designed and Developed ETL, metadata and reports using Informatica and OBIEE.
• Coordinated with Test team to ensure quality deliverables and was reviewer for all Technical documents.
• Successfully deployed major and support releases. Raised Risks and Issues to the Program and Project Manager as necessary. Resolved issues and risks as needed.

Confidential, City of New York, NY

Production Support Manager

Responsibilities:

• Managed and Lead Production Support Phase with 6 resource team members.
• Developed, Communicated and Enforced 311 Analytics Production Support standards.
• Coordinated with Technical Architecture, Design, Build and Test team to ensure quality deliverables.
• Created / Updated / Reviewed support documents for quality assurance purposes.
• Successfully deployed 3 major releases and 28 support releases.
• Raised Risks and Issues to the Solution Architect's and Project Manager's, as necessary. Resolved issues and risks as needed.
• Held full time point of contact for any production issues.