We provide IT Staff Augmentation Services!

Technical Architect Resume

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.

Hire Now