SUMMARY:

• Dedicated data warehouse, ETL and Data Architect having 18 years of IT experience including 12 years of Data Warehousing project experience with global retailers including Target Corp., Home Depot Supply, The Nielsen Company, Michaels Stores Inc., TJX Companies Inc., and Banking giant Lloyds Banking group, UK.
• Extensive data architecture experience in designing OLTP & Data Warehouse applications with Kimball modeling like Star, Snowflake Schemas, and Bill Inmon of 3NF & ER Modeling. Worked on all phases of data warehouse development lifecycle, including requirement gathering, data analysis, development, testing, deployment, and production support.
• Profound experience to understand Functional Requirements and convert them into Conceptual, Logical and Physical data models using tools such as ERwin, ER Studio and MS Visio.
• Demonstrated ETL architect expertise utilizing ETL tool IBM InfoSphere Information Server (DataStage), IBM InfoSphere Change Data Capture, SSIS, IBM Netezza appliance, and Teradata.
• Designed and developed Mload, Tpump, BTEQ scripts and used Teradata utilities to load the data into Teradata tables - FASTEXPORT, MULTI LOAD, and FASTLOAD.
• Have top-notch communication skills, with the ability to interface with senior management from information technology and business users to understand the business needs behind the IT solutions which are needed.
• Proven leader with experience to mentor junior staff and conduct code reviews, performance related recommendations in the data warehouse and ETL systems. 

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL, Pro*C, UNIX shell scripts, Java and Java script.

Database:  Oracle11g,10g/9i/8i/7.x, Teradata V2R5/V13, Netezza 4/6, SQL Server 2008/2012, and DB2.

Tools: ERwin 7.3/8.6/9.5, ER Studio, Aginity, TOAD, SQL*Navigator, SQL Developer, IBM Rational Clear Case, PVCS, Visual SourceSafe, Remedy, HP service desk, HP Project and Portfolio Management Workbench(PPM), PTC Integrity 10, WinSQL, and HEAT

Special Software: IBM InfoSphere Information Server 8.7/8.1, IBM DataStage 7.5.x, IBM InfoSphere Change Data Capture 10.2.0, Cognos, Microstrategy, Control-M, Auto Sys, IBM Connect Direct, and Microsoft Project Professional Server 2007

PROFESSIONAL EXPERIENCE: 

Confidential, Boston, MA

Database Architect

Environment: Microsoft SQL Server 2005/2008/2014 , SSIS 2008, Erwin 9.64, Microsoft TFS and IBM Blueworks.

Responsibilities:

• Studied the existing legacy databases and propose consolidated data model for Application Rationalization SAM Project (OLTP System)
• Understand the existing business processes flows and dependencies in between applications.
• Prepared data components inventory list with application SCREENs table, column level data mapping.
• Analysed existing SSIS packages and updated ETL technical mapping document.
• Discussed with business analysts and SMEs to understand the User Stories and prepared the data lineage document/technical mapping document for each Sprint.
• Analysed existing data sources for each user stories and prepare high level data profile documents.
• Performed detailed data profiling and prepared data analysis report for each subject area.
• Discussed with Business and documented the business rules /clean-up approach for data quality.
• Created data migration scripts with required data conversions rules, data quality business rules and performed the Unit testing.
• Created Conceptual data model and discuss with enterprise architecture team to get approval.
• Created Logical and Physical data model with Entity Relationship data modeling (OLTP)
• Setup the Identity Server related databases with LDAP Directories for security login page.
• Created and supported database activities related to app specific shared folders.
• Created deployment tasks and work with DBA team to finalize the deployment tasks.
• Actively participated SQL Server database upgradation activities in SQL Server 2008 to 2014
• Reviewed test deign/ test cases for each Sprint and validate the results.
• Provided support to development team for data related clarifications and issues.
• Actively participated along with scrum team in daily Scrum meeting, Sprint review/retrospective meeting and Sprint planning meetings.
• Provided support to Product owner to prepare the Product Backlog Items.

Confidential, Marlborough, MA

Data Architect and ETL Architect

Environment: IBM InfoSphere DataStage and QualityStage 8.7, IBM InfoSphere Change Data Capture 10.2.0, MS SQL Server 2012, Oracle, Netezza, UNIX Scripts, ERwin 7.3/9.5,TOAD, HP’s PPM, PTC Integrity 10.

Responsibilities: 

• Worked as a Data Architect and ETL Architect for RMS EDW Release 2 (POEM ODS) projects.
• Provided Post Implementation warranty support for R2A and R2B1 releases.
• Analysed R2B1 requirements and created Incremental Data model for EDW POEM ODS, Source to Target Mapping Document.
• Modified and maintained the changes in Buying Subject area’s EDW data model ( Kimball’s Dimensional model)
• Worked on R2B1 related ETL Design, Development, Testing, deployment and post prod support activities.
• Created Data Migration and Data Conversion scripts for additional business requirements.
• Automated Data Integrity Check (ADIC) Summary process - Framework is designed and developed as part of R2B1 release to provide high level validation between Source and Target databases.
• Worked closely with other IT teams (POEM /RMS Application team, EQA, DBSG, CDC Admin) for End to End System Integration testing.
• Created and modified PL/SQL scripts for CRs.
• Created Project artefacts including ETL design documents, Deployment build notes, and UAT validation documents to meet the TJX Integrity deployment process.
• Worked on EDW related R2B1 deployment plan activities and aligned with GMI program level deployments.
• Prepared R2B1 back-out strategy plan for R2B1 deployment activities and tested the back-out steps.

Confidential, Marlborough, MA

Data Architect

Environment: IBM DataStage7.x/ 8.x, Netezza, Oracle, UNIX Scripts, ERwin 7.3/9.5,TOAD, PPM, PTC

Responsibilities: 

• Worked as a Data Architect for EDW RMS/ReIM Invoice Matching subject area.
• Analysed TJX legacy Merch Payable system Lawson and understood the business context.
• Analysed the business reporting requirements and discussed with business SMEs to complete functional requirements and technical requirements.
• Discussed with business groups to analyse and review the functional requirement documents.
• Prepared Technical mapping document from Functional Requirement Documents (FRDi), with required technical transformation rules and reviewed with SMEs.
• Created Data Migration scripts for Sandbox environment.
• Prepared Conceptual data models, data flow diagrams, and data profiling reports.
• Master Data requirements are identified and validated against Master Data Authority.
• Analysed Oracle RMS /ReIM OLTP data model and prepared multiple solution approach with de-normalization process for EDW-Invoice Matching Subject area and subsequent data mart requirements.
• Prepared both 3rd Normal form & Kimball methodology dimensional model with GRAIN details and discussed with Enterprise architecture team. Finally secured the approval for the Kimball’s dimensional model.
• Designed logical and physical data models using Erwin.
• Prepared Bus Matrix for Invoice Matching subject area and maintained the document as per TJX data governance/ standards policy.
• Created Invoice Matching Data Mart using Kimball method dimensional modeling and ensured to build 50+ reports.
• Prepared Source to Target ETL mapping documents with detailed ETL load logic and ETL transformation rules.
• Prepared data volume estimations based on business requirements and proposed high level Database /BI system capacity plans.
• Prepared Key Design Documents (KDD) and presented with Information Architecture Review Board and secured approvals.
• Provided support to prepare Solution Architecture Design documents.
• Presented the data models with Information Architecture Review Board and secured approvals.
• Created Deployment Kit using PTC tool as per TJX standard and supported the EQA activities.
• Reviewed ETL UTC documents, UTC results and provided support to ETL development activities.
• Developed data validation process for basic data quality checks to adhere with TJX data governance policy.
• Prepared Source/Target mock-up data as per Invoice Matching data model and supported Data Mart related requirements.
• Provided support to ETL/BI team clarifications to meet Invoice Matching SPRINT timelines.
• Analysed Netezza distributions on large tables and provided recommendations for performance improvements.
• Prepared custom scripts using NZSQL and nzload for few of the Ad hoc requirements.
• Applied IBM’s best practice guidelines like regular Statistics collection, using groom option to recover the free space to improve the Netezza performance.
• Discussed with DBA team to provide required work group level assignments in all Netezza environments.

Confidential, Marlborough, MA

Data Architect

Environment: IBM DataStage7.x/ 8.x, Netezza, Oracle, UNIX Scripts, ERwin 7.3/9.5,TOAD, PPM, PTC

Responsibilities: 

• Worked as a Data Architect for EDW Foundations-Buying subject area.
• Re-designed EDW buying subject area data model.
• Understand the business context and analysed the requirements in business and technical perspective.
• Evaluated current ODS data models, data base schemas, and prepared the gap analysis report.
• Prepared the solution approach to address the gaps in data models and data base schemas.
• Modified PL/SQL scripts with additional business requirements.
• Discussed the gap analysis report with Enterprise Architecture team and finalize the approach for change in ODS / EDW (Kimball’s dimensional model) and data marts.
• Executed clean-up activities to sync the metadata in all lower environments.
• Worked with other support team to incorporate the ODS / EDW /Data Mart changes.
• Developed automated data integration check validation scripts for buying subject area.
• Performed data analysis for Change Request requirements.
• Presented the data models with Information Architecture Review Board and secured approvals.
• Created Deployment Kit using PTC tool as per TJX standard and supported for EQA activities.
• Developed data validation process for basic data quality checks to adhere with TJX data governance policy.
• Analysed Netezza distributions on large tables and provided recommendations for performance improvements.
• Prepared custom scripts using NZSQL and nzload for few of the Ad hoc requirements.
• Applied IBM’s best practice guidelines like regular Statistics collection, using groom option to recover the free space to improve the Netezza performance.
• Discussed with DBA team to provide required work group level assignments in all Netezza environments.