Architect( Data Management & Etl) Resume
SUMMARY:
- 13+ years of Software industry experience with extensive 7+ years in Data Warehouse development and production support using various ETL & BI Tools in multi - platform environments
- 12+ years of ETL design, development experience using Informatica,and Oracle PL/SQL
- An effective Leader with proven abilities in leading teams, training, mentoring and guiding team members and enabling knowledge sharing among the team
- I have experience in varied industries including Telecom, Media, Pharmacy, Financial services, Insurance and Logistics. I have worked with customers across the globe, and have been instrumental in setting up strong foundations for long term work relationships in my last couple of roles.
IT SKILLS:
- ETLInformatica 6.x 7.x & 8.x, 9.x, Power Centre, Power Exchange,Datastage 8.5,Talend
- Oracle 8i, 9i and 10G, SQL, PL/SQL, SQL Server
- Unix Shell scripting
- ETL-Informatica, Oracle PL/SQL, DataStage 8.5
- Java
- Hadoop, Hortonworks 2.4, sqoop, HBASEand Hive
- Agile and Waterfall methodolgies
PROFESSIONAL EXPERIENCE:
Confidential
Architect( Data Management & ETL)
PlatForm: Informatica 9 Powercentre, Oracle 11.2 Oracle Enterprise Data Quality(EDQ), AWS,ERWIN 7.3.4, Power exchange
Responsibilities:
- Analyzing Reporting requirements for data integration
- Conducted JAD sessions with business users and SME's for better understanding of requirements
- Deliver Detailed Design document
- Design Data model for staging, ODS & data mart
- Present Solution design to the Customer and get sign off
- Design & Develop solution to generate unique customer id using Oracle Enterprise Data Quality
- Design & Developed EDQ jobs for address standardization using LOQATE
- Design ETL using sqoop to ingest data in hadoop on AWS
- Provide estimates for development
- Communicate project status and provide timely escalation of issues, deviations to requirements
- Provide guidance to development team during the build
- Data Modeling, Dimension Modeling, Database Designing.
- Assign & review work of offshore team
Confidential
Lead Data Quality Solution Design Architect
PlatForm: Informatica 9 Powercentre, Teradata, Informatica IDQ
Responsibilities:
- Lead Solution Design for data quality rules using Informatica IDQ (Developer and Analyst)
- Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.
- Develop, execute and evaluate data quality test plans as well as the results and quality of the data as per business needs.
- Provide guidance for IDQ development team
Confidential
Architect( Data Management & ETL)
PlatForm: Informatica 9 Powercentre, Oracle 11G, Informatica IDQ, Power exchange
Responsibilities:
- Solution design for DWBI.
- Develop, execute and evaluate data quality test plans as well as the results and quality of the data assuring compliance with business expectations.
- Perform systems and data analysis to Develop ETL design.
- Develop technical specifications for data acquisition, transformation, and load processes from a variety of sources
- Analyze performance bottlenecks and provide solution for performance improvements
- Provide effort estimates for new projects and initiatives
- Present Senior Management Technical solution options in key projects.
- Represent the Project team in Quality Assurance meetings.
- Involved in Data Discovery phase of key projects.
- Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.
Confidential
Role: Data Architect
PlatForm: Informatica 8.6 Powercentre, Oracle 10G, HP Quality Centre,Autosys, Erwin 7.3.4,Power exchange
Responsibilities:
- Analyzing Reporting requirements for Employee Compliance data mart
- Source system Analysis
- Prepare Source to Target mapping
- Design Logical & Physical Data model for staging, ODS & data mart
Confidential
ETL Solution Architect
PlatForm: Informatica 9 Powercentre, Oracle 10G, HP Quality Centre,Autosys, IDQ
Responsibilities:
- Analyzing Business requirements for data integration
- Solution Design for integrating data from desperate sources.
- Design & Implement Customer Contact Data Quality validation using Informatica Data Quality
- Prepare Detailed Design documents
- Present Solution design to Confidential Solution design team for approval.
- Design Data model for staging, ODS & data mart
- Liaised with business teams to ensure project success.
- Provide estimates for development
- Communicate project status and provide timely escalation of issues, deviations to requirements
- Provide guidance to development team during the build
- Assign & review work of offshore team
Confidential
Technical Project Lead
PlatForm: Datastage 8.5, Oracle 10G, HP Quality Centre,Autosys
Responsibilities:
- Build credibility, establish rapport, and maintain communication with Project Manager to keep him updated on issues and risk factors through careful analysis to anticipated and manage change in the requirements
- Analyse and escalate issues & incidents and track those to the closure
- Interacting with Development, Configuration and QA team during execution
- Help Project Manager Create Dashboards for weekly and Monthly Status reporting to the Director
- Release planning with Project Manager, sign off and Management
- Review ETL design
- Review & Test ETL code developed in pl/sql
- Responsible for Quality and timeliness for all deliverables
Confidential
Technical Project Manager
PlatForm: DataStage 8.5,Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8,Erwin 7
Responsibilities:
- Interacting with Development team in India for Status and Project meetings
- Utilized Quality Centre for requirement and defect tracking during a project SDLC
- Prepare logical Data Model and review with the Lead Data Architect
- Developed key mappings to Load data into Aggregate Fact Tables
- Develop ETL Design
- Review & Close ETL design with Solution Architect
- Estimate Development Effort
- Coach, mentor and lead personnel within a technical team environment.
- Responsible for the recruiting, management and career development of consulting staff.
Technical Project Manager
Confidential
PlatForm: DataStage 8.5, Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8
Responsibilities:
- Report design review
- Review the team’s work on Analysis/Coding/ Testing and production rollout.
- Developed ETL design.
- Prepare logical Data Model and review with the Lead Data Architect
- Provide Estimate for ETL & Cognos Report Design.
- Track and improve team performance. Managing Vendors.
- Identify areas of improvement in the project processes & implementing the required actions.
- Meet project Quality objectives and ensure zero post implementation defects.
- Review & ensure closure of all SEPG project audit points.
- Responsible for hiring initiatives & defining of KRAs; to be used for direct reports reviews, appraisals and creation of development plans.
Confidential
Technical Lead/Lead Developer as part of the Falcon project for the client Datascan technologies USA
Platform: Informatica 6.2, Oracle 9i, Cognos 7.3, Autosys
Responsibilities:
- Requirement Analysis, Team Management, Coding, Code Reviews, Unit Testing other Project Document review
- Estimation using FP.
- Managing a team of 8-10 personnel.
- Interacting with client, on-site Confidential peers and QA teams.
- Reviewing the code and documentation.
- Developed ETL design Data Mart Layer
- Provide estimates for development.
- Tuning existing PL/SQL ETL programs to improve monthly ETL performance.
- Analyzed the functional specs provided by the business users and created technical specs documents for all the mappings and Design high level document to low level document.
- Involved in developing Informatica mappings based on documents that are developed during analysis.
- Created Mapplet and used them in different Mappings.
- Review ETL mappings