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, Confidential
• Extensive data architecture experience in designing OLTP & Data Warehouse applications with Kimball modeling like Star, Snowflake Schemas, and Confidential 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 HEATSpecial 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.

Key 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.

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.

Key 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.

Data Architect

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

Key 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.

Data Architect

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

Key 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.

Data Architect

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

Key Responsibilities 

• Worked as a Data Architect for RPAS Planning Analytics Data Mart.
• Understand the business requirements in business and technical perspective.
• Analysed and reviewed the functional requirement documents.
• Conducted brainstorm sessions with BI / DA team to understand the BI report complexities and proposed multiple solution options.
• Performed legacy system source analysis and prepared gap analysis report as per functional requirement.
• Prepared Conceptual data models with Kimball method dimensional modeling and discussed with team.
• Created data flow diagrams, and data profiling reports for Planning Analytics Data Mart.
• Prepared Key Design Decisions (KDD) and presented with Information Architecture Review Board and secured approvals.
• Developed few ETL Proof of Concepts to load huge volume of data sourced from big flat files or tables.
• Created Data volume estimates and proposed high level system requirements.
• Provided support to prepare Solution Architecture Design documents.
• Identified Master Data requirements and validated against Master Data Authority.
• Designed logical and physical data models using ERwin and prepared Source to Target ETL mapping document.
• Created Deployment Kit using PTC tool as per TJX standard and supported the EQA activities.
• Developed PL/SQL scripts and automated 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.

Confidential

Data Architect / Technical Architect

Environment: IBM DataStage Info. Server 7.5.2/8.1/8.7 , Teradata, Oracle, UNIX Scripts, Control-M, ERwin

Key Responsibilities

• Worked as a Data Architect and Technical Architect for DataStage/Teradata in ADM GDW team and handled following projects: BGL-Bordereaux data feed; Wills Referral data feed; HMRC; CSDC Rewards; and Verde.
• Analysed the business problems mentioned in the RFQ and prepared Impact Analysis document with proposed solutions.
• Performed Data profiling and data analysis for each RFQ with custom SQL scripts.
• Analysed the actual business requirements and provided recommendations to use UPI, NUPI, USI, NUSI or PPI.
• Created or updated logical, Physical data models using ERwin 7.6 and maintained the metadata repository.
• Built end-to-end data integration solutions using IBM DataStage 7.5/8.7 to implement new interfaces.
• Prepared Detailed Technical Design document for DataStage/Teradata Change Requests and finalize End to End Design for required problems / change requests listed.
• Prepared the source to target data mappings document, traceability matrix document, and provided technical support to development teams for all data related queries.
• Discussed with GDW panel and secured approvals for Impact analysis and DESIGN documents.
• Conducted peer design reviews, code reviews, and recommended best practices.
• Created or modified the logical / Physical data models (Teradata) and secured required approvals from Enterprise Architect team.
• Provided Technical training in DataStage, Teradata, and ERwin to build the competency resource pool.

Data Architect / Technical Architect (DataStage & Netezza)

Environment: IBM DataStage Info. Server 7.5.2/8.1, Netezza, Oracle, UNIX Scripts, Control-M, ERwin

Key Responsibilities

• Worked as a Data Architect and Technical Architect for DataStage and Netezza in Nielsen Media Programs Team.
• Participated in data architecture discussions with Enterprise architect team to finalize the conceptual data models.
• Represented as an offshore data architect in weekly meeting with enterprise Architect team and explained all in-flight projects architecture design status and open issues.
• Prepared weekly report with list of open issues and provided recommendations to address the issues.
• Prepared source to target data mapping document and provided support to respective development team for data mapping related queries.
• Actively involved in all Nielsen Media platform related Proof of Concepts.
• Extensively used IBM DataStage 8.1 and Netezza Twinfin.
• Designed and Developed the reusable components, Promoted design/develop for performance idea; ensured the client’s standards are followed by development teams.
• Supported Development Teams to implement coding standards and best practices in the project, conduct code reviews, test scenarios, and deployment plan reviews.
• Prepared NZ Scripts, stored procedures using NZSQL and NZload.
• Created and maintained Netezza database in lower environment for development and training.
• Created and modified the process templates and checklists. Ensured lessons learned were incorporated into new projects.
• Provided Technical training in DataStage and Netezza to build the competency resource pool for upcoming projects.

Data Architect & Technical Architect (DataStage/Netezza)

Environment: IBM DataStage 7.5.2/8.1, Netezza, Oracle, PL/SQL, Pro*C, UNIX Scripts, Control-M, ERwin, ER Studio

Key Responsibilities 

• Led 15 members of BI-Team (Onsite / Offshore) and delivered 24*7 supports.
• Kept the consistent track record of more than 97% of SLA for all critical incidents.
• On an average, 20% of incidents flow was reduced every quarter.
• Around 100 (per quarter) critical incidents / repeated incidents were converted into problem tickets. Based on priority Problem tickets were implemented and improved the performance and data quality.
• Approximately 10% of new applications were added into Production; maintained the SLA with existing resources. Cost to the company and customer was significantly reduced.
• Provided production support activities with existing PL/SQL scripts, Pro*C scripts.
• Partnered with enterprise architect team and played a key data architect/ technical architect role in all DWH/BI related projects.
• Performed source data analysis and data profiling on RMS (Oracle Retek Merchandising System) for various data warehousing projects.
• Prepared presentations with conceptual data models; explained to Enterprise Architect team; and finalized the approvals.
• Designed logical and physical data models using ERwin.
• Worked with Enterprise team to finalize data requirements, logical dimensional data models and system architecture for all new projects.
• Played major role in designing and implementing proof of concept for migrating the data from RDW (Retek Data Warehouse) to EDW (Enterprise Data Warehouse).
• Documented the interface processes in current data warehouse system and translated them into new ETL processes using IBM DataStage.
• Performed Data cleansing activities to improve the data quality.
• Automated all the new DataStage ETL jobs using UNIX shell scripts through Control-M scheduler and added data validation checks including business rules and referential integrity checks.
• Created and Implemented Industry standard procedures for maintenance, monitoring, backup and recovery operations for the DataStage applications.
• Analysed Netezza distributions on large tables and provided recommendations for performance improvements.
• Prepared custom scripts using NZSQL and nzload for project specific proof of concepts.
• Applied IBM’s best practice guidelines like regular Statistics collection, using groom option to recover the free space to improve the Netezza performance.
• Worked as a point of contact for all Netezza related discussions and acted as a backup DBA.
• Automated Netezza query history database alerts; prepared alert reports; discussed output with Enterprise architect team; and recommended performance tuning options.
• Worked with IBM support to analyse current workloads; configured different groups in Netezza; and utilized the Netezza work load management features to fine tune the performance.
• Defined various processes / procedures to streamline the batch processes and business communications.

ETL Technical Lead / Data Modeller

Environment: Ascential DataStage 7.5.1, Oracle, Netezza, UNIX Shell scripts, Autosys, ERwin

Key Responsibilities 

• Worked as a Data warehouse ETL Developer and Technical lead for offshore team and provided application support for RMS batch processing.
• Designed and Developed UNIX shell Scripts, DataStage jobs, job sequences, and Shared Containers to implement the business requirements.
• Created and updated Logical and Physical data models using ERwin.
• Analysed the Netezza distributions on large tables and provided recommendations for performance improvements.
• Prepared custom scripts using NZSQL and nzload for project specific proof of concepts.
• Applied best practice guidelines like regular Statistics collection, using groom option to recover the free space to improve the Netezza performance.
• Automated Netezza query history database alerts; prepared alert reports; discussed output with Enterprise architect team; and recommended performance tuning options.
• Prioritized the incident tickets in the HEAT incident management system. Assigned based on priority and delivered the support within SLA.
• Actively involved in all account level trainings and created a pool of DataStage and Netezza developers.

ETL DataStage Consultant

Environment: Ascential DataStage 7.5.1, Microstrategy, DB2 UDB, UNIX Scripts, Control-M, ERwin

Key Responsibilities 

• Involved in the design of EDW Stores architecture; performed code reviews of DataStage jobs; and implemented best practices.
• Created end-to end Process flow diagram for all ETL jobs.
• Designed and developed DataStage jobs, job sequences, Job Activity, Email Notifications, and Shared Containers to implement the business requirements.
• Created UNIX shell Scripts for file validation and scheduling DataStage jobs.
• Performed unit testing, system testing, functional testing; prepared test data and improved the error handling.
• Reviewed ETL and Microstrategy Design Documents with EDW Stores Business team.

 ETL-DataStage Developer

Environment: Ascential DataStage 7.5.1 (Server Edition), Microstrategy, Teradata, SQL Server 2005, DS job Control, ERwin

Key Responsibilities

• Prepared detailed ETL specifications based on business requirements.
• Performed data analysis to resolve issues with uncovered source data.
• Coordinated with Onsite team to understand the conceptual data model.
• Created logical and physical data models using ERwin.
• Designed and developed DataStage jobs, job sequences, Job Activity, Email Notifications, and Shared Containers to implement the business requirements.
• Developed custom BTEQ scripts and used Teradata utilities to load the data into Teradata tables.
• Created UNIX shell Scripts for file validation and DataStage jobs

ETL - DataStage Developer

Environment: Ascential DataStage 7.5.1, Oracle, DB2 UDB, UNIX Scripts, Control-M

Key Responsibilities 

• Developed Parallel DataStage jobs using various stages.
• Developed UNIX shell scripts to execute DataStage jobs.
• Created test cases and performed Unit test and system integrated testing.
• Provided support in post-deployment phase and completed the project transition to production support team.

Network Engineer

• Worked as a Network and Security administrator and maintained very large LAN / WAN networks.
• Strong hands-on experience with CISCO routers and Checkpoint firewalls.