PROFESSIONAL SUMMARY:

• An experienced Technical Architect with the ability to initiate/manage cross - functional teams and multi-disciplinary projects.
• Provides technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Implemented several Data warehouse /BI Reporting projects and participated in requirement gathering, source system analysis, data modeling, architecture, detailed design, development, system integration testing, user acceptance testing, production implementation phases of project.
• Sound experience in enabling high level ETL architecture for building data integration solutions using Informatica Power center 9.x, 8.x, 7.x and other ETL tools with over 12 years of experience in Informatica ETL
• Extensive Experience in data warehousing applications using Informatica Power Center 10.X/9.X/8.X/7.X, Informatica MDM, Datastage, OBIEE, Tableau, Oracle 10g/9i/8i, UNIX.
• Experience in Data profiling and working on Master Data Management and data governance project implementations.
• Experience working with various customers onshore across the globe with diverse projects and domains
• Worked with Pharmaceutical, Insurance, Securities and Manufacturing clients like Confidential USA, Vertex Pharmaceuticals USA, Prudential Insurance UK, Union Bank of Switzerland USA and GE Aircraft Engines.
• Strong analytical, communication and interpersonal skills

TECHINICAL ATTRIBUTES:

ETL: Informatica Power Center/7X/8X/9X

IBM Data Stage 7/8.5: Alteryx

Database: Oracle 9i/10g/11g

Data quality: Informatica Data Quality 9.1

Reporting: OBIEE, Tableau, Informatica MDM 9.5.1 (Trained)

Languages: Oracle PL/SQL Unix Shell scripting

Scheduling tool: Autosys

KEY COMPETENCIES:

• Led and developed full scale project plans and executions.
• Estimation and project planning for multiple modules for a release with in the project.
• Tracked project deliveries using project management tools.
• Reported on project progress and communicated relevant information for Management reporting.
• Tracked and resolved critical issues to minimize project risk factors.
• Communicated extensively with clients, sub-contractors and vendors to establish cordial/effective working relationship.
• Worked closely with business to understand business requirements to capture the data warehouse and reporting requirements
• Managed the business users and delivering technical specifications.
• Architecture and Design of Data warehouse and the BI Platform and participated in design review workshops to enable high end architecture.
• Enable the data warehouse with strong audit logging framework and robust ETL architecture
• Discover and analyze the data anomalies across the key data elements and found hidden data problems
• Created scalable Datamodel based on the business requirements catering the end user requirements
• Design of Master data management Framework to have single version of truth across the customer domain
• Design of staging tables and target tables to enable data cleansing, Parsing and standardization
• ETL Development with low priority defects and component testing
• Focused on high quality ETL Code with zero high priority defects in production
• Participated in Code reviews and provide suggestions for normalizing the solutions for better performance.
• Created and executed System integration test cases and ensured proper defect analysis, defect fix and defect closure is done before the UAT.
• Ensured proper configuration management practices are followed in the project
• Conducted Business user training to enable UAT.
• Provided the required support to Business users during the UAT and analyze, debug the issue from both ETL and reporting perspective and ensure the UAT signoff on schedule and on time.
• Impact analysis of change requests and ensure the design and development of change requests has no impact on other components.
• Prepared Production implementation plan with Historical data movement and incremental data movement and ensure smoother Production move and successful completion of project
• Preparing and publishing release notes and production support manuals
• Provide demos to customer on Product framework.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect

Tools: Informatica v9.5.1, Informatica MDM v9.5.1 and Data quality, OBIEE, Oracle database, Oracle SOA, Oracle IDM

Responsibilities:

• Participate in architecture and design workshops for creating a robust product environment on an Amazon/Oracle cloud environment in a standard manner to enable plug in at multiple clients for the purpose of generating reports, and various analytical reports
• Proving flexibility in exchanging data through standardized Schema and built a SOA (SOA) and transforming into relational database form before moving it to Dimensional modeling
• Implemented user management through SSO -IDM suite of applications (OAM, OIM)
• Mastering Person Information pertaining to Site Investigators
• Enabling Business users to create OBIEE reporting and Tableau based on the current data model
• Planning for the infrastructure requirements of the Project discussing with oracle and Amazon cloud team
• Participated in Planning and execution of the complete platform

Technical Architect/ Onshore Coordinator

Confidential

Tools: ETL: Informatica 9.5.1, Informatica MDM 9.5.1 Database: Oracle 11G, Reporting tool: OBIEE 11G SSO: Oracle Access Manager and Identity Manager

Responsibilities:

• Experience summary played key role in Planning and Estimation for the complete Project
• Conduct requirement workshops with business users and capture the requirements
• Convert the Requirements into technical specification documents
• Created scalable Data model to capture the business requirements
• Architecture, Design and develop data platform from 3 different sources data into facts and dimensions
• Enabled Data exchange platform through Oracle SOA and Business Access Manager(BAM) for exchanging data through standardized XSD
• Enabled VPN connection between Client network and Oracle cloud to Enable data exchange of XML files with operational and Master data for Studies, Site, Subjects and POA
• Design the Single sign on platform for user interface to facilitate reporting and analyzing capabilities
• Handle the ETL design and development for Historical data load and incremental data loading
• Design, develop and test robust audit logging mechanism
• Ensure to capture all KPI Requirements in the data warehouse and showcase the KPI'S in the reports
• Enable the OBIEE platform for canned and adhoc reporting needs.
• Engage business users during the system integration testing of the project in agile fashion to capture the changing requirements of the user
• Create robust documentation as deliverable during Requirements gathering, Data modeling, design, production support activities
• Prepared Production implementation plan and ensured production release in time

Confidential

Project manager / Technical Architect

Tools: ETL: Informatica 9.5.1, Informatica MDM 9.5.1 Database: Oracle 11G, Reporting tool: OBIEE 11G

Responsibilities:

• Lead Operational Datawarehouse (ODW) module in the program which will allow Confidential to perform horizontal and vertical metric reporting across a wide slice of operational data. This facility will include ETL and visualization tools and methods. The ODW reporting leverages the Oracle Clinical Development Analytics (CDA) tool.
• Lead the Planning and Estimation for the ODW Module and as well as played key role in complete Project planning
• Convert the Requirements into technical specification documents
• Created scalable Data model to capture the business requirements
• Architecture, Design and develop data platform from 3 different sources data into facts and dimensions
• Handle the ETL design and development for Historical data load and incremental data loading
• Design, develop and test robust audit logging mechanism
• Ensure to capture all KPI Requirements in the data warehouse
• Enable OBIEE Platform for canned and adhoc reporting needs.
• Create robust documentation as deliverable during Requirements gathering, Data modeling, design, production support activities
• Prepared Production implementation plan and ensured production release in time

Confidential

Business Intelligence Stream Lead

Tools: ETL: Informatica 9.5.1, Database: Oracle 11G, Reporting tool: Business Objects

Responsibilities:

• Lead end to end Integration projects that involved BI tools and applications
• Managed the Planning and Estimation for the multiple Integration projects
• Managed and Interacted with multiple Business stakeholders including contractors from other companies enabling smooth Data migration and Integration of data into Confidential Applications.
• Convert the Requirements into technical specification documents
• Created and executed data migration plan and executed the data migration steps.
• Involved in Report migrations as well as new report development in Business Objects on new environment.
• Handle the ETL design and development for Historical data load and incremental data loading
• Create robust documentation as deliverable during Requirements gathering, Data modeling, design, production support activities
• Prepared Production implementation plan and ensured production release in time

Confidential

ETL Lead

Tools: ETL: Informatica 7i./8i, Oracle 9i, And Data Cleansing tool - Trillium, scheduling tool: Autosys.

Responsibilities:

• Involved in analysis of requirements
• Preparation of High level and Low level design documents.
• Involved in Integration of data from 3 new sources into the platform while enabling single customer view
• Involved in ETL development activities for Party, prospect and policies subdomains.
• Component test cases, system test case preparation and Execution.
• Performance test case preparation and execution.
• Performance tuning activities to reduce the batch timings to meet the SLA.
• Performance testing defect analysis and fixes. Interacting with customers during the User Acceptance Testing and Regression Testing Phases.
• UAT defect analysis and fixing the defects. Support and Regression testing activities. Regression testing defect analysis, Fixing of Regression testing defects.
• Involved in Implementation Phases. Support activities for the Implementation both Initial and Incremental Implementation. Post Implementation issue resolution. Identifying the data fixes and code fix. batch tuning process during the warranty phase to Improve the performance