SUMMARY:

• Senior information technology professional with over 15+ years of experienced in Management, Development and Implementation of large scale Data Warehousing and BI projects focused on Strategy, Technical Program Management and Solution Architecture
• Provide technical leadership and guidance for end to end implementation of data warehouse and BI projects
• Expertise in Technical and Functional Program/Project Delivery, Solution Architecture, ETL Strategy, Client Relationship, Presales, Resource Management
• PMP Certified in Project Management and Togaf9 certified in enterprise architecture
• More than 10 years of experience in managing and delivering large and medium scale Data Warehouse Programs/Projects in onsite/offshore model
• 10+ years of experience in End to End implementation of Data integration projects including Data analysis, Data quality, ETL architecture, design, development, testing and implementation
• Experienced in Solution Architecture, Data Integration, ETL Strategy
• Experienced in Source System Analysis, Data Analysis and Data Mining.
• Experienced in preparing Test Strategy, Test Planning and Text Execution for DWBI application
• Good Understanding of Data Governance, Data Quality and Metadata Management
• Good Understanding of Bigdata Ecosystem (HDFS, MAP Reduce, Hive, HBASE)
• Extensive programing experience ETL and Business intelligence using Informatica, Oracle PLSQL and Base SAS, Tableau
• Strong domain knowledge of Mortgage Banking Originations and Default
• Strong domain knowledge of Healthcare Payer Business (All Payer Database, Hedis reporting)
• Experienced and well versed with all phases of SDLC using Waterfall and Agile methodology
• Experienced in executing and delivering projects in both Fixed Price and Time and Material engagement model in Onsite/Offshore environment.
• Experienced in creating Implementation Roadmap, Effort Estimation, Project Planning, Project Status Reporting, Risk identification, Risk Mitigation, Issue Resolution.
• Experienced in working with cross functional team on requirement analysis, deliverables, and issue resolution.
• Exceptional ability to maintain and build relationships with top decision makers at client location, frequent meeting one on one with clients, able to comfortably converse with all facets including CXO level in client organization.
• Organize and lead response for RFP,RFI and RFQ, Participate and lead proposal development, Pricing strategies for new business
• Experienced in showcasing innovative ideas and value add solution to clients which helps in resolving critical business problems and pain area
• Experienced in Account Planning, Revenue forecasting, Resource Planning/Forecasting and Budgeting.
• Possesses Excellent Skills & Capability in Handling / Managing Teams, some of the core skills include
• Building High Performance Teams
• Enhance Competitiveness
• Mentoring and guiding Individuals on Career Path

TECHNICAL SKILLS:

Languages: SQL, Oracle PL/SQL, Unix shell scripting

Database: Oracle 10, SQL Server, Teradata

Tools: and Utilities: Informatica 9.x/8.x, Base SAS, TOAD, Cognos, MS - Office, Tableau

Project Management /Process Management utilities: MS Project, MS-Excel, MS-PowerPoint, Quality Center, MS Visio, Jira

Bigdata: HDFS, MAP Reduce, Hive, HBASE,PIG

REPRESENTATIVE EXPERIENCE:

Confidential

Responsibilities:

• Solution Architecture for Enterprise Data Lake on Big Data Platform
• Delivered project on Confidential APD submission and Hedis reporting.
• Integrate Facet application with data warehouse
• Set up principal and Guideline for build and use of Data warehouse
• Establish the end to end data governance, data quality, program governance based on people, process and technology

Technology: Big Data (HDFS, Hive, Spark), Data Stage 9, Oracle 11g, Cognos 10

Confidential

Technology: Hadoop (HDFS, Map Reduce, Hive, HBASE), Informatica BDE, Jira.

Responsibilities:

• Responsible for end to end implementation of Data warehousing projects
• Managed and lead multiple teams involved in Data Analysis, Design, Development and Testing (QA) and Post Production Support Team on several data warehouse technologies including Big data, Informatica, Oracle Sql/ PLSQL, and Base SAS in onsite / offshore environment.
• Responsible for effort estimation, Planning, Implementation Roadmap, Project Status reporting, Risk identification and Execution of project to meet the deadlines
• Solution Architecture for Enterprise Data Lake on Big Data Platform
• Propose architecture roadmap, technical approaches and solution based on business requirements
• Architecture review, approvals and signoffs on architecture/design docs from core enterprise architecture and design team
• Interaction with Business users to understand new functional and reporting requirements.
• Interact and coordinate with cross functional team to capture and fulfill business requirement., requirement analysis, deliverables, and issue resolution
• Create test strategy, test plan and test cases document and performed the testing during SIT for various project.
• Facilitate and participate in Integration testing and User Acceptance testing.
• Daily, Weekly and Monthly status reporting for key stake holder,
• Participate and Run the account reviews, project reviews and weekly meetings with project steering committee
• Provide timely and detailed analysis to internal clients on various ad-hoc requests regarding the status of workout programs, product performance etc.
• Team Management, Performance appraisal and Mentoring.

Confidential

Technology: Oracle 9.1.2, Informatica Power Center 7.1.2, UNIX.

Responsibilities:

• Worked as a Project Lead (Senior Consultant).
• Interacted with client for knowledge transfer of application
• Setup of offshore team and development environment.
• Effort estimation and Planning of projects
• Interaction with Business users to understand new functional and reporting requirements
• Responsible for Analysis and Design phase of the project.
• Prepared High and Low Level Design of various feeds.
• Coding & Unit testing the Informatica workflows and Oracle PLSQL Stored Procedures.
• Active participation Involved in Integration and UAT testing and implementation of the project
• Production support for the project.
• Configuration Management and coordination between the onsite and offshore team so that there was a seamless integration between the two teams.
• Status reporting with stake holders

Confidential

Technology: Developer 2000(Forms 5.0/Reports 3.5), oracle 8.1.7, Designer 2000, UNIX

Oracle Programmer

Responsibilities:

• Performed the Analysis, Design Coding and Testing for Cold rolling mill application in Developer 2000 and oracle PLSQL
• Developed PLSQL script for data integration from multiple external source system like, DB2 and SAP to Cold rolling mill data warehouse and reporting.
• Actively supported SIT and UAT.
• Actively involved in project implementation by performing code migration.
• Responsible for Post production support

Confidential

Technology: Developer 2000(Forms 5.0/Reports 3.5), oracle 8.1.7

Oracle Programmer

Responsibilities:

• Performed the Analysis, Design Coding and Testing for Coil Tracking and Transportation System in Developer 2000 and oracle PLSQL
• Actively supported SIT and UAT.
• Actively involved in project implementation by performing code migration.
• Responsible for Post production support.