SUMMARY:

• 15+ years of ETL design, development experience using Informatica Datastage, Oracle Warehouse builder and Oracle PL/SQL
• An effective Leader with proven abilities in leading teams,, mentoring and guiding team members and enabling knowledge sharing among the team
• Have worked with customers across the globe and have been instrumental in setting up strong foundation for long term work relationships in most of my roles
• Work with customers like Confidential, Confidential, LG, Confidential, Confidential, Sanofi - Aventis, Confidential, Confidential, Cadbury, Confidential, Confidential, Bell & Confidential

TECHNICAL SKILLS:

Technology and Tools: ETL - Informatica 5.x, 6.x 7.x & 8.x, 9.x, Oracle Warehouse Builder 9.x, 10.x, Data Stage 7.x/8, PL/SQL, Power Exchange,ODI 11G Reporting- Business Objects, Oracle Express,Tableau 9, Qlickview 9,tableau 9 Oracle 8i, 9i and 10G, SQL, PL/SQL, SQL Server,Teradata Unix Shell scripting Hadoop: Cloudera 5, Hortonworks 2.3, sqoop, Oozie, PIG,Spark, HBASEand Hive, NIFI

PROFESSIONAL EXPERIENCE:

Confidential, West Chester pa

Data Architect

Platform: Hbase, Hive,hortonworks 2.6, Informatica Metadata Manager, Atlas, Power Designer, Kafka, Apache Ranger,Rally(Agile planning).

Responsibilities:

• Work with business partners in understanding and translating business requirements into solution designs
• Profile, design, and model data and provide data product solutions using multiple data platforms.
• Lead and provide suggestions and best practices for end to end data delivery
• Data Analysis for Omniture data
• Design Data mart layer for Customer/Prospect Clickstream (Omniture),Demograhics,PI,Cart Abandon,Dotcom Activity,Equipment,Product data
• Design and architect to accommodate data security and privacy
• Prepare Conceptual, Logical and Physical data model(Hive)
• Lead Design sessions with Business Stakeholders & Sponsor.
• Prepare User Stories for Design & Development
• Design and architect to integrate multiple, complex data sources that are transactional and non-transactional, structured and unstructured data
• Maintain data dictionaries and data lineage
• Prepare Source to Target mapping documents.
• Lead & Mentor 5 Hadoop Developers

Confidential

Architect (ETL,hadoop & Data Management)

Platform: Hbase, hortonworks 2.4,spark 1.6.2,sqoop,Spark Streaming

Responsibilities:

• Analyze Business requirements
• Source system Analysis
• Prepare Solution Design Document to Ingest data into Hadoop
• Design data model in HBASE to ingest over 300GB per day of streaming data from IPTV.
• Prepare Detailed design Document to Ingest data into Hadoop
• Get approval for solution design from BIG data Innovation Team.
• Design new data model in hive and Hbase on Hortonworks.
• Solution Design to ingest data into hive using sqoop /Java Custom framework
• Assign/Review work from offshore team

Confidential

Architect (Hadoop,ETL & Data Management)

Platform: UNIX, SQL Server, SAP BODS, TIBCO Spot fire, Cloudera Hadoop 5.5, Hive, Sqoop, Oozie,Impala, Spark 1.5,Scala,PIG,Hbase

Responsibilities:

• UnderstandingExisting ATM operational reporting ETL in SAP BODS.
• Design solution using sqoop to ingest data from source database and files into Hadoop for ATM operational reporting.
• Design ETL solution using Spark in Scala to perform Data Quality checks and transform data for ATM operational reporting Tables
• Design Solution to convert existing ETL in PIG scripts for Call Center reporting to Spark in Scala .
• Design Solution to load data into Hive Tables using HiveQL and Parquet format
• Design & Develop Hive views to be accessed by reporting team.
• Performance tuning of hive tables and used oozie for scheduling jobs.
• Prepare solution design to provide data in Json format for downstream applications.
• Design Load Strategy to ingest data into Hadoop/Hive.
• Assign/Review work from offshore team
• Responsible for ensuring Data Governance standards are followed in Hadoop projects.

Confidential

Architect(Hadoop,ETL & Data Management)

Platform: UNIX, Oracle 10.2, Informatica 9,Hortonworks 2.3,PIG, Sqoop, PIG, Hive, Tableau 9 and AWS

Responsibilities:

• Analyzing Reporting requirements for School Board Enrolment projections Data & Census Canada data integration
• Solution Design for integrating Student High school GPA Data in Data Warehouse
• Design Data model for staging, ODS & data mart
• Design solution to provide Active Archive for 10 years of Applicant Information Using Hadoop on AWS on Hortonworks.
• Perform POC to implement provide data online in Hadoop instead of Archiving.
• Design ETL process using Sqoop and PIG to load data in to Hadoop.
• Design and Develop Tables in Hive using ORC format for analytics using Tableau
• Present Solution design to the Customer and get sign off
• Provide estimates for development
• Communicate PWC project status and provide timely escalation of issues, deviations to requirements
• Provide guidance to development team during the build
• Design dashboard for converting existing adhoc reports using Tableau.
• DataModelling, Dimension Modelling, Database Designing using Erwin.
• Assign & review work of offshore team

Confidential

Solution designer /Architect (ETL & Data Management)

Platform: UNIX, Oracle 11.2, Informatica PowerCenter 9, Power Exchange, Informatica Data Quality(IDQ)

Responsibilities:

• Data Model Design for Statiscs Canada Reporting Data Mart.
• ETL Design for CDIC Datamart.
• Design & Implement Customer Contact Data Quality validation using Informatica Data Quality
• Conduct impact assessment and determine size of effort based on requirements.
• Data Model Design for Return on Insurance Deposit Data Mart
• Analyze performance bottlenecks and provide solution for performance improvements
• ETL Code review
• Provide effort estimates for new projects and initiatives
• Prepare/Present & get Approval for Project Production Deployment plan in Change Control Board.
• Present Senior Management Technical solution options in key projects.
• Represent the Project team in Quality Assurance meetings.
• Represent Project in Gating sign off.
• Provide Development status to Project/Program Manager
• Technical Lead for CDIC DataMart Maintenance project
• Involved in Data Discovery phase of key projects.
• Liaised with Business Analysts, QA Analysts, & DBA throughout project lifecycle to ensure project requirements are met.
• Worked with internaldatagovernancegroups in terms of polices and processes to improve overall dataquality

Confidential

Solution Designer

Platform: Unix, Teradata, PL/SQL, Informatica PowerCenter 8.6.1, Cognos

Responsibilities:

• Designed and implemented ETL solutions for business intelligence reporting for voip telephone business customers with Informatica and Control-M.
• Deliver Solution Design Document (SDS)
• Data model design
• Review & Close Solution Design with Enterprise Solution Architect
• Represent Project in Gating sign off.
• Provide development status to project manager

Confidential, NJ

Data Warehouse Architect

Platform: Windows, DataStage 8.5, OBIEE 10g, Oracle 10g, Erwin

Responsibilities:

• Conducted Requirement Gathering workshops with Business Units heads for sales & marketing Data Warehouse
• Build Data Model for Staging & Data Mart Layer
• Managing a team of 8 including ETL Developers, tester and Report Developer in onsite/offshore model.
• Analysed the existing Information Management state and prepared the architecture for future information management
• Involved in the source system analysis (SAP, IMS etc.) and reports rationalisation
• Report, ETL & Data Model Design review
• Code review for ETL programs
• Managing System integration testing of the ETL & Reporting solution delivered
• Responsible for Quality and timeliness for all deliverables.
• Work with Business Development team on RFP.

Confidential

Technical Lead

Platform: UNIX, Oracle 10, Qlikview 9, Informatica PowerCenter 8.6, Erwin

Responsibilities:

• Responsible for managing team comprising of ETL & BI developers in onsite/offshore model.
• Analysed the existing commercial reports
• Responsible for Technical Delivery from offshore for quality, functionality and timelines
• Designed commercial reports using Qlikview
• Designed ETL strategy and reviewed ETL mappings
• Developed mappings to load Aggregate Fact Tables
• Worked with business users during UAT and received sign off
• Responsible for QA, Production Deployment and Support
• Responsible for Setup of complete Qlikview environment
• Responsible for Knowledge Acquisition, Project Planning and scheduling
• Presented Demo and POC to client to convert existing reports in Qlikview
• Work with Business Development team on RFP.

Confidential, NY

Data Warehouse architect

Platform: UNIX, Oracle 10, Business objects XI, Informatica PowerCenter 8, Erwin

Responsibilities:

• Responsible for managing team comprising of designers, developers and testers in onsite/offshore model.
• Analyzed pre-existing ETL written in SQL server stored procedures
• Review and Analysis done for understanding pre-existing reports that were developed using crystal reports
• Designed ETL strategy, Error Handling and Audit logic for new data warehouse
• Review Data model Design
• Estimate the effort required to migrate reports in Business objects and Develop ETL using Informatica
• Ensure quality, timely delivery of work products and adherence to quality standards

Confidential, CA

Data warehouse Architect

Platform: UNIX, Oracle 10, Oracle Warehouse Builder 10g

Responsibilities:

• Reviewing the existing Sales Performance Dashboard phase-1 Data Warehouse production infrastructure and Data Architecture and providing recommendation for changes to achieve scalability and performance
• Understand and Analyse existing Confidential Data Warehouse (ETL, Data model & Database Design).
• Analysed the existing Oracle 9i database setup
• Provide recommendations related to Data model, ETL and database
• Develop and present the roadmap towards new Architecture

Confidential

Technical Manager

Platform: UNIX, DB2 9.1, Datastage 7.1

Responsibilities:

• Lead a team of 12 consultants to manage and support the Application in onsite/offshore model.
• Keep Customer & Senior management updated through Weekly Status Report
• Ensure proper processes are followed for Production Support and Development activities
• Review the team’s work on Analysis/Coding/ Testing and production rollout
• Interact with the users to gather enhancement requirements
• Participate in ETL design and review estimates
• Meet project Quality objectives and ensure zero post implementation defects

Confidential

Solution Architect

Platform: UNIX, Oracle 9i, OWB 10, Business Objects XI

Responsibilities:

• Lead a team of 10 personnel to make the necessary changes to Confidential Loans Data warehouse to fulfil customer requirements
• Support the day-to-day productions issues and ensure SLA are meet
• Involved in the proof of concept to choose ETL tool
• Migrating existing ETL developed in PL/SQL to OWB
• Developed ETL Strategy
• Tuning existing PL/SQL ETL programs to improve monthly ETL performance
• Interacting with the GE Consumer Finance Data Centre and Vendors for production support
• Successful Migration of reports developed using crystal reports to business Object XI

Confidential

Development & Production Support lead & ETL Architect

Platform: UNIX, Oracle 9i, Informatica PowerCenter 6 & 7, Cognos 7.3

Responsibilities:

• Development & Production Support lead for Cadbury Schweppes Data Warehouse at Canada
• Translating business user requirement into functional specifications and assigning work to offshore team
• Analyzed the Functional Specification provided by the business users and created Technical Specification Documents, High level Design Document and low level documents for all the mappings
• Involved in developing Informatica mappings based on documents that are developed during Analysis
• Created Mapplet and used them in different Mappings
• Involved in Performance Tuning
• Participation in work prioritization meetings with business
• Escalate any project issues to the Project Manager
• ETL Design Review and identifying improvements in the existing process
• Provide on call production support during night & Weekends
• Ensue all reports & cubes are available within the business SLA
• Involved in the migration from informatica 6 to 7

Confidential

Senior ETL developer

Platform: Compaq Tru64 UNIX 5.1b, Oracle 9.2.0.2, Business Objects, Informatica PowerCenter 5.1, Oracle Express 5

Responsibilities:

• Interacting with business users, to understand and finalize their requirements
• Assign work to the offshore development team and tracking the same to closure
• Status updating to the Confidential Project Manager
• Interacting with Confidential data centre for production support
• Review Design document, Unit Test Specifications and system test plan
• Created various UNIX Shell Scripts for scheduling various Data cleansing scripts and loading process
• Worked on Informatica Power Centre tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer
• Maintained Warehouse metadata, naming standards and warehouse standards for future application development
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target table in efficient manner
• Used SQL*LOADER for huge data loads
• Created Universes by defining connections and retrieving data from database
• Created standard and Ad hoc reports using Business Objects
• Provide on call production support during night /Weekends and ensure Business SLA are meet

Confidential, NY

ETL developer

Platform: HP UNIX 5.1, Oracle 8.1.7.2, Informatica PowerCenter 5.1

Responsibilities:

• Impact analysis of replacing the existing ETL module with Informatica
• Developed Data Cleaning utility using Oracle Pro*c to be executed in server manager pre-session
• Developed utility to automate Database Table maintenance in case of change in Informatica target metadata
• Created update strategy and Incremental aggregation for Month to Date source loading
• Developed driver Programs for running Informatica Sessions from UNIX
• Implemented Informatica in Japan Banking Data Warehouse as the ETL tool
• Tested all the business application rules with test and live data.

Confidential

Data Warehouse developer

Platform: Compaq Tru64 UNIX 5.1b, Oracle 8i, Business Objects 5.x

Responsibilities:

• Designed and developed Operations Menu using Shell script. This Operations menu will be used by the Confidential Data Centre to execute DWH jobs
• Participated in the successful migration of Data Warehouse for Confidential Taiwan, Japan, Malaysia, Bharain, Oman, Singapore & Pakistan to DWH 4.3, Oracle 8i, and Oracle express 6.2
• Improved performance of Data Transformation Programs
• Partitioned data using Oracle range partition
• Developed program using pro*c convert non-partition table to partition table; designed and developed various programs to automate daily, weekly and monthly jobs

Confidential

Data Warehouse developer

Platform: UNIX, Oracle 7, Oracle Express, Oracle Sales Analyser

Responsibilities:

• Analyzed the Functional Specifications provided by the Business Analyst and created Technical Specification documents, High level Design document and low level documents for all the mappings
• Developed ETL programs using PL/SQL & Pro*c to load data into staging & dimensional layer
• Created and maintained several custom cubes for the client using Oracle express
• Responsible for providing production/implementation support to the end user.
• Provide on call production support during night/weekends and ensure Business SLA are meet

Confidential

Data Warehouse developer

Platform: UNIX, Oracle 7, Oracle Express, Oracle Sales Analyser

Responsibilities:

• Maintain ETL programs using PL/SQL & Pro*c
• Test and maintained several custom cubes for the client using Oracle express
• Monitor data warehouse daily, weekly & monthly batches
• Fix production issues encountered
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process
• Provide on call support to Data Warehouse jobs during night & weekends to ensure Business SLA are meet