Resume

Sign in

Sr. Technical ETL & DW/BI Architect

Location:
Austin, Texas, 73301, United States
Posted:
February 21, 2018

Contact this candidate

Deepa Chatriki

ac4j9d@r.postjobfree.com

Employer Details:

Ganesh

ac4j9d@r.postjobfree.com

814-***-****

SUMMARY OF QUALIFICATIONS:

** ***** ** ********** ** IT with eight plus years of experience in managing and leading DW/BI efforts from requirement gathering to its implementation for both waterfall and Agile.

Significant business knowledge in finance, hospitality, health care and pharmaceutical.

Large amount of experience in gathering user requirements and translating them into technical and system specifications. Managing clients, vendors, and partner relationships.

Extensive experience as a solution architect for business information systems, focusing on database architecture, data modeling, data analysis, software design, programming and application integration.

Very good knowledge of Data Warehouse/Data mart concepts with BigData and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.

Experience with Relational and Dimensional data modeling using ERWIN, understanding of Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions.

Provide tier-1, tier-2 and tier-3 level support and track issues/requests for system enhancements.

Strong “hands-on” knowledge with application development, DW platforms and databases (Oracle 10g, Netezza, MS-SQL, DB2,Azure): data warehousing, application software SDLC and business reporting.

In-depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools.

Experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center (8.5.1/7.1/6.1) and Informatica Big Data Management.

Experience in performance tuning both at ETL and database level.

Experience in UNIX and Windows environments, as well as operating system specific shell scripting.

System administration skills such as installation and configuration, management, performance tuning and troubleshooting.

Experience in configuration management: Identifying and controlling the release of a product and its changes. Ensuring completeness and consistency of product among components. Managing the process and tools used for builds and making sure every defect has traceability back to the source

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP, HP-UX, Sun Solaris, UNIX/LINUX

RDBMS: Oracle 10g (PL/ SQL), Microsoft SQL Server 2012, Netezza 7.2

Data Modeling tools: ERWIN 7

Bigdata: Informatica Bigdata Developer, Hadoop, HIVE, MS Azure.

ETL: Informatica 6.2-9.5.1, Data Stage, MS-SQL SSIS.

Schedulers: UC4, Informatica Scheduling, Autosys

OLAP/Reporting: Business Objects, Qlikview, Qliksense, Micro Strategy

Languages: C++, C, ASP, HTML, Java, JSP, EJB, Shell Scripting/Programming (UNIX),

Network & Security: SSL, network protocols- FTP, telnet, HTTP(S), and SSH, Public Key Infrastructure (PKI), Encryption with US Data Encryption Standard (DES), PGP, RSA Digital Signing in accordance with RSA Data Security Inc, Public Key Cryptographic Standards (PKCS#1).

PROFESSIONAL EXPERIENCE:

Working with Accenture Pvt Ltd after graduation since 2004. Below are different clients I worked for.

Nov 2012 – till date Shire Pharmaceuticals, Wayne, PA USA

Sr. Technical ETL & DW/BI Architect/ Project Owner (Agile Implementation)

Accenture will provide application development, performance improvement and Production Support services to Shire within their Specialty IT division. Accenture team will be capturing the business requirements, designs, build & deployment and for application maintenance and production support activities. Accenture will provide support for level 1& 2 issues for Shire's Specialty Pharma applications within Commercial IT. The project consists of over 10 applications that utilize Siebel, Informatica, Business Objects, Netezza, Oracle, SQL Server UC4 technologies.

Responsibilities:

Liaise with business subject matter experts in analyzing business requirements, understand the various data sources.

Architect the productivity data mart. Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.

Design and develop the technical/functional specification for ETL development and implement using Informatica. Analyze dependencies for workflow for various ETL processes, handle exception, and maintain logs.

Estimates the enhancements, fixes; develop work plan and assignment. Manage the releases and time of the resources both offshore and onshore.

Establish project standards; establish good working relationship with clients as well as team.

Managed team in different zones/countries for multiple implementations.

Worked as Product owner for ETL for a salesforce implementation.

Environment: Informatica BDM, AZURE,Informatica Power Center 9.5.1, MS-SQL SSIS, UNIX, Netezza, Oracle 10g – PL/SQL, Erwin DM r7, TOAD 12.1, Business Objects, Qlikview, Qliksense, PGP Encryption, network protocols- FTP/SFTP, telnet, HTTP(S), and SSH.

April 2012 – Nov 2012 WellCare Health Plans Inc, Tampa, FL USA

DW/BI Architect

WellCare Health Plans, Inc. provides managed care services exclusively for government-sponsored health care programs, focusing on Medicaid and Medicare. Headquartered in Tampa, Florida, WellCare offers a variety of health plans for families, children, and the aged, blind and disabled, as well as prescription drug plans. The Company served approximately 2.2 million members as of March 31, 2010.

Responsibilities:

Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database.

Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process in Informatica.

Architect the database schema and implement dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.

Map source system data elements to target system and develop, test, and support extraction, transformation and load processes.

Based on business rules, load health (medical prescription) related data, develop Informatica mappings, create sessions, workflows to load and process data received from pharmacies.

Defines and captures metadata and rules associated with ETL processes.

Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.

Environment: UNIX, Shell Scripting, Oracle 10g – PL/SQL, Erwin, TOAD, Informatica Power Center 8.6

April 2010 – March 2012 Starwood Hotels and resorts, Whiteplains, NY, USA

Senior Lead Consultant and Data Architect

Project: Enterprise Data Warehouse

Starwood Hotels & Resorts Worldwide, Inc. is a hospitality ownership and management organization, headquartered in White Plains, New York. One of the world's largest hotel companies, it owns, operates, franchises and manages hotels, resorts, spas, residences, and

vacation ownership properties under its nine owned brands.

Responsibilities:

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.

Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.

Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.

Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments

Worked on Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.

Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow

Defines and captures metadata and rules associated with ETL processes

Review and analyze database performance, cubes and reports generated using Microstrategy.

Environment:UNIX, Shell Scripting, Oracle 10g – PL/SQL, TOAD 9.0.1, Informatica Power Center 8.1.1., Microstrategy.

April 2009- March 2010 Takeda Pharmaceuticals North America, Inc., Deerfield, IL

Lead Consultant

Takeda is a research-based global pharmaceutical company. As the largest pharmaceutical company in Japan and one of the global leaders of the industry.

Responsibilities:

Manage and support development of the Customer Data Warehouse (CDW) and Data Mart (DM).

Perform requirements analysis: Interact with business analysts to get functional requirements, interact with end users to determine reporting needs, and conduct discussions with the project team to identify additional requirements.

Create and Maintain a conceptual data model, a logical data model, and a physical data model in ERWIN. Design a dimensional data model and perform Star Schema/Snowflake Schema modeling for data mart. Create FACT and Dimensions tables.

Identify data sources (UDB/DBW, Oracle, MSSQL), design and develop the technical/functional specification for ETL development and the Data Warehouse (DW) Generate the necessary DDLs for creating the Database Objects (Tables, Views, Stored Procedures, and Triggers).

Utilized Informatica Server Manager to create, schedule and monitor sessions and send pre and post session emails to communicate success or failure of session execution. Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance

In informatica created mappings and utilized aggregate, expression, lookup, update strategy and router transformation. Utilized joiner transformation to extract data from multiple sources. Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.

Provide subject matter expertise to systems programs in the form of knowledge of data systems, interpretation of source data including data cleansing, data testing and validation in multiple systems

Configuring, Monitoring and managing batch processing jobs using Control-M graphical tool.

Liaise with the vendor on interface development and its implementation and provide support for Tera data, Oracle, Informatica ETL code migration, troubleshooting for DEV, SIT, UAT and the production environment.

Environment: UNIX, Shell Scripting, Oracle, PL/SQL, Informatica Power Center 8.1, Toad, ERWIN, Control-M.

Nov 2008 - Apr 2009 Novartis Pharmaceuticals.

Technical Consultant/Project Leader

Novartis International AG is a Swiss multinational pharmaceutical company based in Basel, Switzerland. It is one of the largest pharmaceutical companies by both market cap and sales.Novartis has determined that the current roster system is unable to support future sales force business models and needs a new system is required.

Responsibilities:

Gather and document the Roster system's current requirements and system interface integration points

Identify future requirements needed to support new sales force models and emerging business initiatives

Create a conceptual design and recommendation for a future Roster system platform

Facilitate a software selection process with Novartis to choose a software platform

Identify the gaps and effort required to move from the current to future platform

Define a road map and implementation plan to describe the approach to migrate

Ensure that ETL jobs are running without any problems and data is available to users in real-time.

Architect and adapts ETL processes to accommodate changes in source systems and new business user requirements using DataStage ETL tool.

Implement and carry out application specific development and enhancement.

Environment: HP UNIX, Oracle, PL/ SQL, Shell Scripting. Data Stage 3.1, Siperian(Informatica MDM).

Jun 2008 – Nov 2008 Pfizer Pharmaceuticals, New York, NY

Solution Architect/Senior Consultant

Pfizer is the world's largest research-based biomedical and pharmaceutical company. Pfizer's corporate headquarters are located in New York, with major research and development locations in the United States and England.

Pfizer wanted to re-architect and migrate their current RM solution marketing Hub which includes custom customer master solution (currently MTDB and CCM) to a standard industry solution using Siperian and Oracle and a highly customized Siebel 7.8 Marketing and Analytics installation to an improved Siebel Marketing and Analytics solution (the "Project"). As part of this IT strategy Pfizer expectations are:

- Reduce architecture complexity

- Enable a lower cost support model

- Improve core consumer master functionality

Responsibilities:

Involved in requirement gathering and performed ETL Process.

Created Dimension Tables and Fact Tables based on the warehouse design.

Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates

Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.

Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema

Created the Source and Target Definitions in Informatica Power Center Designer

Created Reusable Transformations and Mapplets to use in Multiple Mappings

Developed and updated documentation of processes and system.

Installed Informatica in Unix server and maintained for development process.

Environment: SUN Solaris, Oracle, PL/SQL, Informatica 8.1, Siperian(Informatica MDM), HTML, Shell scripting.

Oct 2004 – Dec 2007 Washinton Mutuals Credit Card Services, Pleasanton, CA

Senior Consultant

Washington Mutual, Inc., abbreviated to WaMu, was a savings bank holding company and the former owner of Washington Mutual Bank, which was the United States' largest savings and loan association until its collapse in 2008

Responsibilities:

Involved in requirement gathering and performed ETL Process.

Created Dimension Tables and Fact Tables based on the warehouse design.

Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates

Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.

Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema

Created the Source and Target Definitions in Informatica Power Center Designer

Created Reusable Transformations and Mapplets to use in Multiple Mappings

Developed and updated documentation of processes and system.

Environment: SUN Solaris, Oracle, PL/SQL, Informatica, Shell scripting.

Education:

Bachelor of Engineering in Computer Science and Engineering completed in 2004

From

SDM College of Engineering and Technology, Dharwad, Karnataka, India



Contact this candidate