CAREER OBJECTIVE:

To secure a challenging Data warehouse solution architect position in an IT/ITES corporation where breadth of knowledge, creativity, cohesive team skills and meticulous attention to detail and quality are required and duly rewarded.

PROFESSIONAL PROFILE:

• Works on significant and unique issues where analysis of situations or data requires an evaluation of intangibles
• Designs ETL integration modules that will work together to produce desired solutions
• Evaluates new technologies, development frameworks and software products to determine feasibility and desirability of incorporating within the ETL framework solution
• Exercises independent judgement in methods, techniques and evaluation criteria for obtaining results
• Works closely with end user community to enhance and improve the user experience architecture look and feel
• Hands on in Data transformation improvisation, ETL optimization and performance tuning by means of various approaches like partitioning
• Assist in evaluation and acquisition of solutions best suited for enterprise project needs
• Estimate and organize the development effort for ETL and solutions

TECHNICAL SKILLS:

Operating System: Windows XP

Data Warehousing Tools: Ascential Data stage v8.5, Ascential Data stage v7.5.1, Hyperion Brio reporting, People soft SQR reporting, Unix shell scripting

Databases & Tools: DB2 UDB v8.0, Teradata, SQL Server 2008, Mongo DB

Other Utilities: IBM Control - M, ESP Mainframe monitoring tool, HP Quality Center, PVCS, Visio, Mercury Test Director, IBM ManageNow Ticketing tool

RELEVANT PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Analyzed the existing legacy data from Mainframe and designed data mapping from legacy to Policy Center for Data, Costs and Actual premium
• Created mapping documents, lineage documents, SQL scripting as per requirements
• Authored technical design documents, Mapping documents and ETL flow presentations
• Handled complex transformations for Ocean Marine, Personal Umbrella, Dwelling Fire and Confidential policy creation business attributes
• Automation of ETL jobs and end to end data migration from Stage DB to Policy Center DB
• Created reconciliation scripts to validate record counts after conversion for all Data Groups
• Enabled Business Rule integration check and Rating Engine to identify cost variance
• Provided support procedures to facilitate flawless deployment
• Performance tuning of ETL jobs and created accelerators and reports after conversion

Confidential

Responsibilities:

• Analysed the project’s module scope on Enterprise Data Warehouse
• Preparation of Understanding document that pictures the upstream and downstream applications and data movement
• High level design and low level design docs preparation
• Review team’s contribution and coordinated with onsite team for HLD and LLD deliverables

Confidential, Greensboro, NC

Responsibilities:

• Prepared Data model, Detailed design & Test case documents for GT Nexus, Lee.com POS feed to Data Warehouse, Walmart table for DC inventory, TAN, Automate Asia Payments, Alternate Payments Backend Changes, IP enhanced feed to BW, Outdoor Inventory Reconciliation, WCS custom shoe & order retrieval, Vans Latin America, Splendid/Ella Moss data to POS DW & Image wear Cognos projects
• Developed ETL Unix shell scripts for Data Warehouse & Business Warehouse projects
• In addition, developed SQR reports for BW Vans Latin America
• Developed data integrity flow for Data Warehouse projects
• Contributed in System and Integration & UAT testing phase
• Provided warranty support upto 4 weeks for the freshly production moved projects
• Prepared support docs that assists Confidential -DW support team to fix the issues in maintenance period
• Received commendations from clients, Sr. Project Analysts and Application BA for quality project deliverables

Confidential

Responsibilities:

• Participated in Knowledge Acquisition Plan sessions with Client and gathered the requirements that are essential to provide the production support to Data Warehouse application
• Contributed in delivering the major deliverables during the initial period of the project acquisition
• Responsible for training the team members in UNIX and Data warehousing concepts
• Taken sessions on Unix to various teams that are involved in supporting various Confidential applications
• Solved various production issues during the partially supporting period wherein the client SME will be monitoring our works
• Involved in giving the status to the BTS middle level management as this is a new engagement for Wipro with Confidential Corp.
• Taken complete ownership of solving issues that arises from various corners of the application
• Analyzed Java Programs and gave support knowledge to team
• Prepared Ticket Solving Knowledge doc which speaks about all the scenarios with resolution steps in detail 10. Understood basic SAP BW concepts to write and provide assistance to SAP BW support group to write SQR reports
• Closed all production tickets with appropriate resolution within SLA metric defined time
• Delivered all the assigned PPMS without defects
• Learnt SQR on my own and provided support to SAP BW support team
• Received commendations from clients for the quality of work and deliverables shown in small and medium PPMS

Confidential

Responsibilities:

• Contributed during ADW PROD Refresh period which involved moving the whole existing ADW environment (comprises of more than 1000 ETL jobs) to a stabilized efficient networked environment. BI-ACE team was the only team from Wipro participated with the whole ADW Client Business Team during the PROD refresh activity
• Worked the SCR's that been served as enhancements on the business point of view
• Prepared Unit Test cases, System Test cases and prepared a good volume of test data
• Contributed to the n number of UAT runs as required by the Business Team
• Contributed in running the whole project for testing a new change as part of my assigned SCRs’
• Prepared Design documents with all the required job level details
• Implemented my design approach after STA and DBA approval
• Prepared Design documents with perspective to the job level details across different projects
• Prepared Visio diagram for depicting the ETL process flow
• Contributed in reviewing Team member’s tasks and in giving review comments
• Imported and Exported Data stage jobs across Different Environments
• Uploaded the test cases in Quality Centre and executed the test cases
• Checked out/in the existing/modified production code from/into PVCS before/after working on the code to solve the issue
• Created WBSD package for deploying the objects in Production environment
• Monitored the deployment activities
• Prepared a check list of items that need to be moved to production during each release and ensured on the quality of the code being deployed
• Prepared LAM docs and Traceability Matrix documents
• Monitored the Schedules of the Data stage jobs in CONTROL-M scheduler during Implementation
• Prepared Traceability Matrix and Test Audit docs
• Been a key resource in the offshore team and been appreciated for deliverables by Project Manager
• Received commendations on my work from Onsite coordinators.
• Received appreciation mails from Business Team for the successful implementation on the assigned SCR’s as a huge Business benefit was achieved.

Confidential

Responsibilities:

• Stabilized one of the core business projects in the ADW by solving various performance issues. This was done by splitting the job based on the load each handles and reduced the number of stages been used to process the records and covered all the ETL best practices, thereby, reducing the execution time of the whole schedule
• Reduced the load factor on the ware house loading jobs by bringing in the mutual exclusivity on the project areas
• Prepared the related Confidential standard Approach Analysis documents with the problem resolution to be addressed for the given issue
• Prepared Design documents with perspective to the job level details across different projects
• Prepared Unit and System test case documents and Performed Unit and System Testing Developed UNIX scripts for implementing new concepts in order to reduce the job reusability
• Prepared High level design documents explaining the complexity of the retrieving the data from various sources
• Prepared Visio diagram for depicting the overall projects dependency in ADW environment
• Prepared the Confidential to source mapping xls for all the ware house tables in ADW and DB2 spanning documents
• Contributed in reviewing Team member’s tasks Worked in the Test Director tool in order to create Test Plan, Associated Test sets and Defects and Ran the Test cases
• Checked out/in the existing/modified production code from PVCS before/after working on the code to solve the issue
• Created WBSD package for deploying the objects in Production environment
• Monitored the deployment activities
• Prepared a check list of items that need to be moved to production and ensured on the quality of the code being deployed
• Received 'Thanks A Zillion' award for great team work and the outstanding quality of deliverables in the ADW-STABILITY Phase II project from Onsite Coordinator
• Received commendations from Confidential Technical Architect (Client) as 'Super Star Developer'
• Received 'Feather in My Cap' award from Project Manager

Confidential

Responsibilities:

• Worked on the 100 jobs (approx) that have issues related to bugs, environmental issues, performance issues etc across different projects that load the different Warehouse tables
• Prepared the related Confidential standard Approach Analysis documents with the problem resolution to be addressed for the given issue
• Prepared Design documents with perspective to the job level details across different projects
• Performed Unit and System Testing on the above Data stage Jobs in Development and Test Environments
• Developed and tested the restartability in the ETL flow via Left outer join concept with the Confidential table, upsert mode
• Developed UNIX scripts in order to initiate the restartability Process for the Data stage Jobs
• Prepared Unit and System Test case documents for all the Data Stage jobs across different projects so that it uncovers all the possible scenarios
• Imported and Exported Data stage jobs across different environments
• Worked in the Test Director tool in order to create test plan, associated test sets and defects and ran the test cases
• Extended support during the Production phase and Transition period by solving the issues proactively
• Monitored the Schedules of the Data Stage jobs in CONTROL-M scheduler during Implementation
• Checked out the existing production code from PVCS before working on the code to solve the issue
• Checked in the modified production code into PVCS after the transition period ends
• Created WBSD packages for deploying the newly tested code into Production, thereby overwriting the existing ETL jobs
• Monitored the deployment activities
• Monitored the ETL jobs execution in IBM CONTROL-M scheduler during Implementation
• Received 'Thanks A Zillion' award for Team effort & excellent contribution on project deliverables

Confidential

Responsibilities:

• Prepared Detailed Design Documents for Store and Web DPS
• Developed ETL jobs for Store and Web DPS
• Developed ACR ETL Jobs for DPS store Unassociated account and DPS Store Guest and PCAT to Item Xref
• Prepared Unit Test Cases for the jobs developed in design phase and tested the same so that it uncovers all the possible scenarios
• Contributed in System and Integration Testing Phase and was able to produce a quality output
• Contributed in UAT Implementation Phase by proactively solving the defects raised in the UAT phase
• Extended support during the Production phase by solving the issues proactively
• Prepared post production support docs

Confidential

Responsibilities:

• Designed and developed ETL jobs
• Developed Shell Scripts
• Prepared Unit Test Cases for the jobs developed in design phase and tested the same so that it uncovers all the possible scenarios