PROFESSIONAL SUMMARY:

• Confidential has around 13 years of experience in Architecture, Analysis, Design, and Development, Data modeling and Implementation of Data warehouse systems
• Experience in Data Warehouse Architect and working with Data conversion, Data migration and (ETL) Extraction/Transformation/Loading using Informatica Power Center/Talend with Oracle, Greenplum, JD Edwards, SAP, AS400 etc.,
• Have played key roles as Sr architect in right from tool evaluation, architecturial discussions as well as solution design
• Strong skills in the areas of Relationship management, Customer management, Business Transformation, Value Creation, eco system partnership development, leading/integrating global teams
• Extensive experience with Data Warehouse and BI methodologies (Kimball - Star, Inmon-Snowflake Schemas), and strong understanding of Relational, Multi-Dimensional Database concepts and OLAP Cubes.
• Worked as BICOE Portfolio Manager and contributed to its business growth significantly.
• Extensively worked on integrating as well as migrating dashboards/reports into Tableau Reports Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling
• Experience in Informatica Power Center Client (including Designer, Workflow Manager, Workflow Monitor, Repository Manager)
• Good Knowledge on Finance, Manfacturing, Commercial, HR and Sourcing Functions and acted as Business analyst
• Experience in Architecting and integrating discrete source systems like Oracle ERP, SAP, JDE, Salesforce, AS400, Syteline into single datawarehouse
• Flexible and versatile to adapt to new environment and working on new projects.
• Experience in working on Greenplum Projects
• Extensive knowledge in executing projects in Agile, Fastwork and Waterfall models.
• Committed to continuous improvement, excellent communications, and project management skills. Self-disciplined, focused, solid teamwork and a team player.
• Good experience in technical documentation.

SKILL:

ERP-technical: Oracle ERP, Syteline, JDE, AS400, SAP BW

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Talend, HVR

Reporting: Tableau 10.X, Cognos 10, Cognos Power Play Transformer, Business Objects

Databases: Oracle 11g, SQL Server 2005, 2000/7.0/6.5 , Greenplum 3.3.4/4.2, PostgreSQL 9.0/9.1, Access

OS: UNIX (Sun), Windows NT/2000/XP

Scheduling Tools: Appworx

Other: Microsoft Office (word, excel, power point, outlook), MS Visio, Visual Studio 2005, 2003.

Data Quality Tools: Data Quality Inspector

Secondary Skills 3: Software testing

Primary Domain: Commercial, Manufacturing, Finance, Engineering

Trained Skills: ITIL, Greenplum, OBIEE, Cognos 10, Informatica, Business Objects, Oracle, RDBMS

PROFESSIONAL EXPERIENCE:

Confidential

Principal Solution Architect

Environment: Tableau 9.3, Spotfire, Greenplum, Talend, BO, SAP BW Oracle R12, HVR, Microsoft technologies, Erwin, Informatica 9.6

Responsibilities:

• Worked closely with senior SME and critical business users to gather requirements to design/implement Modern data warehouse in AWS-Greenplum
• Designed and implemented logical and physical data models using Erwin.
• Planned, designed and implemented end to end Migration from legacy systems (Oracle/SQL Server/DB2) to AWS-Greenplum
• Optimized Greenplum databases for performance, scalability and robustness.
• Fine-tuned Sql queries for performance.
• Closely worked with BI team to understand and delivery data needs for analytics.
• Worked on process improvement.
• Worked with Data visualization team to fine tune reporting models and BI architecture
• Optimized legacy Greenplum data ware house ETL process
• Expert in process improvement, performance tuning database systems at various levels including query tuning.
• Worked with end users for report optimization and SME for Report Consolidation
• Engaged with application teams and guide them to migrate the Web- Applications onto AWS environment
• Worked on Greenplum features, benefits, and understanding architecture in terms of shared nothing and MPP design and how Greenplum supports redundancy and high availability
• Implemented Greenplum’s workload management for dynamic query prioritization.
• Designed and implemented table partitioning for handling very large tables.

Confidential

Solution Architect & Sr Manager

Environment: Informatica 9.6, Tableau 9.3, Spotfire, Greenplum, BO, SAP BW Oracle R12, Salesforce JDE, As400, Syteline, Oracle ERP, HVR

Responsibilities:

• Owns end to end design of data model and Implementation
• Joining the toll gate calls to review the progress
• Solution Design and Requirement gathering
• Acted as Business analyst in Gathering the requirement
• Acting as single point of contact on behalf of the team
• Preparing use cases and documenting the requirements
• Working continuously with team and stake holders to remove design and development bottle necks
• Providing the effort estimates and calculating the costs for new onboarding’s and enhancement requests and updating the team accordingly
• Creating Functional/Technical/Detailed design documents for prod releases.
• Proactively identifying potential risks and take steps to mitigate the risks.
• Following up with Offshore leads and resolving long pending issues in order ensure a smooth delivery
• Responsible for Customer communication, daily/weekly status reporting, risk management, managing escalation of issues, managing budget and timelines.
• Involved in preparing Estimation Models for New Onboarding’s

Confidential

Solution Architect & Manager -Projects

Environment: Informatica 9.5, Tableau 8.2, Oracle 11g, Salesforce JDEAs400, Syteline, Oracle ERP, SAP BW

Responsibilities:

• Design & Development of Informatica mappings to build business rules to load data.
• Identifying the deliverables and dividing the same in Story Points.
• Assigning the Story points to the team and preparing a burn down chart of the team
• Ensuing the customer deliverables and SLA’s
• Solution Design and Requirement gathering
• Acted as Business analyst in Gathering the requirement
• Acting as single point of contact on behalf of the team
• Involved in Performance Tuning of Informatica Code and solution Design
• Mentoring the Team if they tied up in any issues and pitching in incase of any escalations
• Providing the effort estimates and calculating the costs for new onboarding’s and enhancement requests and updating the team accordingly
• Creating Functional/Technical/Detailed design documents for prod releases.
• Acting as a SPOC on behalf of team and presenting a weekly update to Business
• Responsible for overseeing the Quality procedures related to the project.
• Handling new enhancements and development of modules.
• Proactively identifying potential risks and take steps to mitigate the risks.
• Following up with Offshore leads and resolving long pending issues in order ensure a smooth delivery
• Responsible for Customer communication, daily/weekly status reporting, risk management, managing escalation of issues, managing budget and timelines.
• Involved in preparing Estimation Models for New Onboarding’s
• Preparing RFP’s (Request for Proposals) for new projects

Confidential

Project Lead & Onsite Coordinator

Environment: Informatica 9.1, Cognos 10, Power Play 7.3 and Oracle 11g

Responsibilities:

• Ensuring the Delivery of the tickets
• Acted as onsite coordinator and responsible for team performance
• Created Mappings in Informatica using different transformations like Source Qualifier, Expression, Router, Joiner, Aggregator, Union, Lookup, Update Strategy, Sequence Generator, Sorter, Filter, SQL, Stored Procedure etc.
• Involved in Performance Tuning of Informatica Code.
• Mentoring the Team if they tied up in any issues and pitching in incase of any escalations
• Providing the effort estimates and calculating the costs for new onboarding’s and enhancement requests and updating the team accordingly
• Creating Functional/Technical/Detailed design documents for prod releases.
• Has to maintain Tickets SLA’s and addressing the issues then and there in case of any deviations
• Acting as a SPOC on behalf of team and presenting a weekly update to Business
• Responsible for overseeing the Quality procedures related to the project.
• Proactively identifying potential risks and take steps to mitigate the risks.
• Following up with Offshore leads and resolving long pending issues in order ensure a smooth delivery
• Responsible for Customer communication, daily/weekly status reporting, risk management, managing escalation of issues, managing budget and timelines.

Confidential

Senior Developer & Onsite Coordinator

Environment: Informatica 9.1, Cognos 8.1 and Oracle 11g

Responsibilities:

• Identifying the deliverables and dividing the same in Story Points.
• Assigning the Story points to the team and preparing a burn down chart of the team
• Ensuing the customer deliverables and SLA’s
• Requirement gathering
• Involved in Performance Tuning of Informatica Code and solution Design
• Mentoring the Team if they tied up in any issues and pitching in incase of any escalations
• Creating Functional/Technical/Detailed design documents for prod releases.
• Acting as a SPOC on behalf of team and presenting a weekly update to Business
• Responsible for overseeing the Quality procedures related to the project.
• Handling new enhancements and development of modules.
• Proactively identifying potential risks and take steps to mitigate the risks.
• Following up with Offshore leads and resolving long pending issues in order ensure a smooth delivery
• Responsible for Customer communication, daily/weekly status reporting, risk management, managing escalation of issues,

Confidential

ETL Developer

Environment: Informatica 8.1, Windows XP and Oracle 9i, Cognos 8.0

Responsibilities:

• Understanding existing business model and customer requirements.
• Design & Development of Informatica mappings to build business rules to load data.
• Used Informatica power center to extract, transform and load data from multiple input sources like relational sources and flat files to load the target systems.
• Following Quality procedures related to the project.
• Handling new enhancements and development of modules.
• Developed Simple and medium reports like list reports, cross tab reports, charts and drill through reports.
• Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Designing technical specification document for all the developed mappings.

Confidential

ETL Developer

Environment: Informatica 7.1, Cognos 8, Windows XP and Oracle.

Responsibilities:

• Understanding existing business model and customer requirements.
• Design & Development of Informatica mappings to build business rules to load data.
• Used Informatica power center to extract, transform and load data from multiple input sources like relational sources and flat files to load the target systems.
• Following Quality procedures related to the project.
• Handling new enhancements and development of modules.
• Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Designing technical specification document for all the developed mappings.
• Worked on Change Requests (CR) while integration testing and UAT are in progress