SUMMARY

• Has more than 14+ years of experience in the information technology industry, coupled with extensive experience in multiple domains banking, insurance and financials.
• Has experience in managing all aspects of the SDLC, from initial capture of requirements through development, testing, and implementation stages, and detail project execution plan including dependencies, risks and assumption.
• Has experience in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and Supporting for Enterprise Data warehousing, Data marts, Data Conversion, Data Integration, Data management projects.
• Hand - on experience in data model & architect design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Expertise in driving the modernization of the architecture and design of the data & analytics technical track, including traditional and modern data stores and data engines, BDM, and analytical/BI reporting capabilities including multiple database technology, Query performance optimization, writing complex join queries. Troubleshooting technical issue at grass root level
• Strong ETL experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architecting, Informatica BDM, Development & Testing.
• Has hands-on experience in multiple software technologies (SQL, PL/SQL, Informatica BDM, Informatica Powercenter, Hadoop, Hive, Oracle, SQL Server, MYSQL, DB2, Sybase, Pega DB tools, Shell Script, and more).
• Skilled in building, training, and mentoring high-performing teams to consistently delivering strategic projects.
• Experience in designing enterprise data architect, data modeling of (OLTP applications), dimension modeling, ETL tools (Informatica BDM, Informatica PowerCenter), database programming, query tuning.
• Very good in building strong relationships between teams within IT Solutions and between IT Solutions and related business teams and maintains professional relationships with peers in other corporations and outside organizations.
• Has strong communication and influence skills when interacting with all levels of the organization starting with senior leadership on down to the team members.
• Dedicated, self-motivated achiever who is committed to success and adept at handling multiple tasks in a high-pressured environment and Experience with working on a Scrum Agile team

TECHNICAL SKILLS

• Enterprise Application Integration Architecture, ETL (Informatica BDM, Informatica PowerCenter etc.) OBI reports
• RDBMS platforms (Hive, Impala, SQL, PL/SQL, Oracle, MYSQL, SQL Server, DB2, PostgreSQL, Sybase etc.,)
• Hive, Impala, Hadoop
• Enterprise Data Warehouse with Data Warehouse Technologies
• BI Tools Tableau and SSRS
• HDFS File Management
• ETL, Informatica BDM, Informatica PowerCenter, IBM Data Stage
• Sql Server Tool SSIS, SSMS, SSRS, SSAS
• MS Excel as many project related matrix analysis, monitoring tracking
• Hadoop, Hive, Impala
• DevOps GitHub & Jenkins Repository Management
• BI Tools Tableau
• ALM Quality control
• Erwin, SQL Server DB Modeler
• Data migrations, homogenous and heterogeneous
• SQL/PLSQL, Oracle, DB2, SQL Server, Sybase, Teradata, MySQL, PostGreSQL, Data Warehouse, etc.,

PROFESSIONAL EXPERIENCE

Confidential

MS Project Manager

Responsibilities:

• Participate in Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Involved in the complete life cycle of ETL implementations which include Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.
• Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments
• Experience in Informatica BDM Mappings, Dynamic Mappings, BDM Parameter Files, Source Analyzer, Applications, Workflows, Mapping Designer, Mapplet, Transformations, PL/SQL procedures, Fact & dimension tables, data extraction for various sources, ETL mappings, data loads, tuning the repository, and reports for different regions.
• Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database
• Perform requirements analysis; Interact with business analysts to get functional requirements, interact with end users to determine reporting needs, and conduct discussions with the project team to identify additional requirements, and implement the same into a functional database design.
• Provides technical expertise in diagnosis and resolution of complex technical, architectural issues by working closely with IT teams, business, and development team
• Responsible for managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Verify decision support program specifications with users for reliability, accuracy and functionality. Ensure users’ effective, accurate and easy access to data; translate user information requirements into data structures.
• Prepared deployment plan and go-live check list for streamlined code promotions and avoided any issues which might arise during go-live activities.
• Optimizing Query Performance, Session Performance and Reliability workflow manager, workflow monitor.
• Has strong communication and influence skills when interacting with all levels of the organization starting with senior leadership on down to the team members

Confidential

ETL Migration Tech lead

Responsibilities:

• Analyzed solution architecture and design documents including Source to Target & detail design documents needed for each tracks and plan test design activities
• Involved in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and Supporting for Enterprise Data warehousing, Data marts, Data Conversion, Data Integration, Data management projects.
• Managed end-to-end complex data migration, conversion and data modeling
• Participate in Design / Approach review sessions to migrate the data between structured/unstructured and legacy system
• Participate in requirement gathering, issue clarifications, review documentations and ensure traceability.
• Extensively used ALM to track post migration defects and worked with team to address
• Involved in business functionality checks such as data flow and control flow transformations are executed as per design document.
• Involved setting up Hadoop configuration (Hadoop cluster, Hive connection) using Informatica BDM.
• Creation of deployment, implementation documents.
• Expertise in ETL best practices/methodologies (transformation usage, naming conversions, mapping standards, slowly changing dimensions, deployment groups, versioning, etc).

Confidential

Senior ETL Migration Technical Lead & Data Analyst

Responsibilities:

• Participate in Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Responsible for managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Involved in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Involved in end-to-end complex data migration, conversion by creating extensive SQL Scripts & written PL/SQL.
• Thorough understanding of Data Model, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Involved in business functionality checks such as data flow and control flow transformations are executed as per design document.
• Involved in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Responsible for documenting the process, issues and lessons learned for future references.
• Written several complex SQL queries for data verification and data quality checks.
• Participate in requirement gathering, issue clarifications, review documentations, ensure traceability and own change management scoping
• Liaise with other teams for project status, quality checks, and closure of all defects.