SUMMARY

• Having 13+ years of strong experience as Technical Architect/Technical Lead especially with Data Warehousing - Informatica, Oracle BI Apps, Informatica Data Quality (IDQ), Master data management (MDM), OBIEE, Tableau, Power BI, Oracle Enterprise Data Quality, Talend, Denodo, Appworx, AWS, Snowflake.
• Studying FSD and Understanding the Business requirements, Conversion of functional requirements to technical design.
• Prepared the ETL High Level Design Document (HLDD) for ETL requirements.
• Involved and coordinates in preparing Low Level Design document (LLD).
• Involved in identifying the Granularity and prepared Data Model in MS Visio.
• Estimated the number of Personal Days (PD’s) for coding, Unit testing, and Integration testing.
• Responsible for overseeing the Quality procedures and Coding Standards related to the project.
• Responsible for all deliverables from onshore.
• Provided leadership & guidance on solving highly complex problems in Data Integration, data architecture, design and build of complex applications and perform design reviews.
• Performed requirement gathering, analysis, design, development, and testing, implementation, support and maintenance phases of Data Integration Projects.
• Engaging in performance tuning, load testing. Experience in develop performance test plans and automation test cases.
• Good Experience in understanding business application, business dataflow and data relation.
• Knowledge of Dimensional Modeling, Star and Snowflake Schemas.
• Expertise in Data Profiling and providing Data Analysis Document.
• Good Experience in providing generic solutions, which can be used as a global template for the other teams.
• Good Experience in Prioritize tasks, delegate work/tasks to team effectively, manage risks, and escalate communications when required.
• Good Experience in Performance Tuning of database and Informatica levels.
• Good communication, inter-personnel and analytical skills.
• Good problem solving, self-learning ability and can adapt to new environments.
• Proactive, Dedicated, and zeal to learn New Technologies and Tools.

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect

Responsibilities:

• Studying FSD and Understanding the Business requirements.
• Conversion of functional requirements to technical design
• Prepared the ETL High Level Design Document (HLDD) for ETL requirements.
• Involved and coordinates in preparing Low Level Design document (LLD).
• Involved in identifying the Granularity and prepared Data Model in MS Visio.
• Estimated the number of Personal Days (PD’s) for coding, Unit testing, and Integration testing.
• Responsible for overseeing the Quality procedures and Coding Standards related to the project.
• Developed Complex mappings for populating target table in efficient manner
• Responsible for all deliverables from onshore.

Confidential

Team Lead

Responsibilities:

• Studying FSD and Understanding the Business requirements.
• Conversion of functional requirements to technical design
• Interacting with the onsite team on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Prepared the ETL High Level Design Document (HLDD) for ETL requirements.
• Involved and coordinates in preparing Low Level Design document (LLD).
• Involved in identifying the Granularity and prepared Data Model in MS Visio.
• Estimated the number of Personal Days (PD’s) for coding, Unit testing, and Integration testing.
• Responsible for overseeing the Quality procedures and Coding Standards related to the project.
• Developed Complex mappings for populating target table in efficient manner
• Involved in requirement analysis, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence platform.
• Performed the detailed design of Reports/Dashboards and Analytical Data Model (Metadata/.rpd).
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Involved in Unit testing of custom-built reports and dashboards.
• Responsible for all deliverables from offshore

Confidential

Team Lead

Responsibilities:

• Prepared the ETL High Level Design Document (HLDD) for ETL requirements.
• Involved and coordinates in preparing Low Level Design document (LLD).
• Involved in identifying the Granularity and prepared Data Model in MS Visio.
• Developed Complex mappings for populating target table in efficient manner
• Involved in requirement analysis, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence platform.
• Performed the detailed design of Reports/Dashboards and Analytical Data Model (Metadata/.rpd).
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Involved in Unit testing of custom-built reports and dashboards.

Confidential

Team Lead

Responsibilities:

• Prepared the ETL High Level Design Document (HLDD) for ETL requirements.
• Involved and coordinates in preparing Low Level Design document (LLD).
• Involved in identifying the Granularity and helped Data Modeler in preparing Data Model in ERWIN.
• Estimated the number of Personal Days (PD’s) for coding, Unit testing, and Integration testing.
• Responsible for overseeing the Quality procedures and Coding Standards related to the project.
• Developed Complex mappings for populating target table in efficient manner
• Involved in end to end Testing, pre-production and CR’s.
• Handling Support Issues and providing solutions.
• Providing fixes for the issues raised in Request Management Tool.
• Converting the issues to a CR if the functionality doesn’t exist.
• Repository development in OBIEE to meet the quarterly enhancement release.