SUMMARY

• Proven track record of leveraging systems and data management to achieve business objectives in extensive and diverse environments.
• Extensive expertise in enterprise data integration architecture with specialized skills in MDM, ETL, Data Quality, Data Governance and Business Intelligence tools.
• Prescribe quality solutions, best practices, and implementation guidelines to clients with needs in data integration solutions.
• Over 13 years of experience in solution architecture, leadership, analysis, design, modeling, development, implementation and testing of applications in data warehousing and client/server environment
• In - depth data warehousing solution expertise with a strong understanding of ETL tools like Informatica, Datastage, Talend, Alteryx and Pentaho.
• Experienced in leading a team of 5-12 resources in a complex development project and delivered the solutions in a timely manner.
• Excellent communication skills and ability to work within a group effectively as a team member, across project teams, and independently.
• Technical expertise in all phases of Software Development Life Cycle (SDLC)
• Expert in dimensional data modeling, star schema modeling, snow flake modeling, fact and dimension table design, physical and logical data modeling using Erwin
• Experienced in analysis, design, development and implementation of business intelligence/ OLAP applications
• Expert in Big Data ecosystem components

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Enterprise Data Architect

Responsibilities:

• Design and implementation of the Confidential 's corporate account data management using Informatica MDM
• Design and implementation of Global Address standardization and verification using AddressDoctor
• Design and implementation of Confidential 's Global Sales Administration process to identify the revenue from major corporate clients
• Established Guest data management procedures for cleansing, standardizing and validation of guest information across global Confidential properties
• Implementation of Hadoop ecosystem components to analyze and identify meaningful insights based on guest comments on social media.
• Design and implementation of migrating Confidential ’s HR data into EDW.
• Established Data governance procedures to maintain consistent, reliable and quality data.
• Design and implementation of De-identification and masking procedures for guest’s personally identifiable information (PII).

Environment: Informatica Master Data management (MDM) 10.1/9.7,Informatica Powercenter 9.6, Informatica Data Quality (IDQ), Informatica Developer, Informatica Data Transformation Studio, Informatica Data Director (IDD), IBM Cognos, Alteryx, Tableau, Pentaho, Hadoop, Hive, hbase, nifi, Spark, Scala, Sqoop, Informatica BPM (Active VOS), Informatica SIF APIs, REST APIs, Java, UserExits, Messaging triggers and queues.

Confidential, Chicago, IL

MDM Architect/ Team Lead

Responsibilities:

• Leading and mentoring team of 6-10 offshore datastage developers.
• Worked with global team with team members from different parts of the world.
• Involved in requirement gathering and legacy system analysis.
• Worked on allocating and prioritizing tasks for developers and business analysts.
• Established and governed the process around implementing architectural standards and guidelines, as well as review process.
• Resource acquisition and retention activities.
• Established and implemented the standards for Quality checks throughout the life cycle which helped in identifying the data issues early in the process.
• Worked as a Liaison between development and QA teams.
• Load analysis of the system to acquire optimal software licenses and hardware.
• Designed solutions using IBM Websphere Quality stage to standardize and cleanse the data from various sources.
• Designed solutions using IBM Websphere Quality stage to standardize address, name and phone numbers.
• Designed web services for the business users to create/retrieve the keys from user interface.
• Implemented Service Oriented Architecture (SOA) for uniform generation of keys across multiple applications.
• Established the Source code management procedure for automated promotion of datastage and Java artifacts.
• Extensively worked with Slowly Changing Dimensions (SCD) for loading deltas (CDC).
• Created and implemented automated procedures for the migration projects for multiple versions of IBM Websphere Datastage.
• Worked extensively to fine tune loading and retrieving data from oracle Exadata server.

Environment: Master Data Management, IBM Information Server Websphere DataStage v. 8.7/8.5/8.1/8.0 and QualityStage v. 8.7/ 8.5/8.1/8.0 , Linux, DB2, Oracle Exadata, Oracle 11G, SQL, Websphere Information Analyzer 8.1/8.0, ClearQuest, Web Services, Control-M

Confidential, Downers Grove, IL

Industry Solutions Architect

Responsibilities:

• Extensively designed the Solutions with the Grid based architecture where the data definitions are stored in the database and the data is stored on the data grid.
• Extensively designed and organized the structure of the data warehouse to obtain the optimum usage of the grid and to obtain utmost performance.
• Worked with the DBA’s to fine tune the database to increase the performance of the loading and retrieval.
• Extensively worked with project managers in creating the project plans, resource selection, resource allocation and time allocation.
• Extensively worked in a Client-facing role and took part in the requirements gathering, determining the duration of the project and resolving issues in time.
• Extensive work on datastage jobs’ performance tuning using combination of business and datastage knowledge to achieve optimal performance.
• Created the datastage standards for the project and implemented them successfully throughout the project.
• Created and implemented the migration plan for moving the project from Dev to Test and Test to Prod.
• Extensively worked with the QA teams to help them understand the solution, reviewed the test plan and review the test cases to certify that all the critical areas of the project are covered.
• Worked on creating load charts for grid nodes to do load balancing for optimal usage of grid’s processing capacity to avoid unnecessary processing backups and idling.
• Designed and developed the extractor (Harvester) using datastage, Unix scripts and Confidential in-house technologies.
• Used Parallel extender while running jobs for bulk data splitting and to pass the data into subsets to all available nodes for best job performance.
• Created the technical specifications/unit test cases/ source-to-target mappings for each job. Involved in the creation of jobs using DataStage Designer.
• Worked with in-house custom operators for writing and reading data from flat files for the grid environment.
• Worked with Oracle and flat files as the sources.
• Designed and implemented the strategy for datastage code migration from 7.0.1 to 7.5.

Environment: Datastage Enterprise Edition 7.0.1/7.5, Linux, Oracle 9i, SQL, MS Visio2003, C++, ILOG, Grid Based Computing, SourceForge, Share Point, Subversion, Remedy, Generic services, bundle build.

Confidential

Datastage Developer

Responsibilities:

• Extensively involved in the Analysis, Design and Modeling.
• Involved in analyzing scope of application, defining relationship within and between groups of data, star schema and snow flake schema and analysis of present schema and data model
• Used Data Stage manager for importing metadata into repository and also used for importing and exporting jobs into different projects
• Designed the ETL process by gathering the requirements from both divisions and the users.
• Designed Data Stage server Jobs and executed them in batches
• Developed Job Control Routines.
• Change Data Capture from the Source Systems was consolidated by the Data Stage Agent into the Warehouse.
• Changes are captured by the CDC on a daily basis and are consolidated at the end of the month.
• Worked with Data Modeling, Data Elements, Issue/Question Resolution Logs and Source to Target Mappings, Interface Matrix and Design elements.
• Optimized Query Performance, Session Performance and Reliability.
• 24x7 Production support.

Environment: Data Stage 5.0/6.0, Oracle9i, DB2 UDB 7.2, MS SQL Server2000, Developer Suite, PL/SQL, SQL*Plus, SQL Loader, SQL Navigator, Toad, WindowsNT4.0, Windows2000