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.
