Data Warehousing/ETL Design and Development/Data Analysis/System Analysis

Data Warehousing, Systems Analysis/ Data Analysis/ Data Mining, ETL Design and Technical Lead with extensive experience in different phases of project life cycle from gathering requirements, design, coding, client delivery, providing end-user support to sending marketing offers and end products to the customers.

Key Qualifications

• Data Warehouse Consultant with experience in wide variety of industries such as Finance, Healthcare, Telecommunications, Credit Risk, Retail, Auto etc.
• Over 14 years of experience in information systems focused on Database Design, Development, Administration, Analysis involving - Data Modeling, Data Extraction, Data Integration, Data Analysis, Systems Analysis, Data Profiling/ Segmentation, Data Mining etc. on databases like Teradata, Oracle, SQL Server, DB2 etc.
• 14years Data Warehouse experience - Usage of Teradata tools such as Macros, BTEQ, FastExport, FastLoad, MultiLoad, TPump, Teradata Administrator, Teradata Index Wizard, Visual Explain etc, Oracle scripts using SQL/PL-SQL, SQL Loader etc, SQL Server scripts using T-SQL and SSIS Packages and UNIX Shell scripts for high volume data warehouses.
• 12 years of experience in design and development of ETL processes using Ab Initio, Informatica etc.
• Data Analytics using tools such as SAS etc, creation of Marketing Campaigns using Complex SQL and tools like Unica Campaign, Infogix etc.
• Latest technologies such as Cloud Computing using IBM BlueMIX and Big Data using IBM BIG SQL.
• Project Lead - co-ordination and maintaining synergy between teams across the globe in various countries such as India, Philippines, Brazil, USA etc.
• System Analyst - Interviewing Stake Holders, Gathering Business Requirements and translating into Technical Reqs.
• Relational database theory and design including logical and physical structures, data normalization and star and snowflake schemas.
• End-2-End stages of a Development Lifecycle such as Business Requirements, Software Requirements, Software Quality Assurance, Software Management, Software Development Methodology etc.
• Agile, Lean and Six Sigma techniques such as Continuous Improvement Process Toyota Methodology , 5 Why - Root Cause Analysis, PDCA Plan-Do-Check-Adjust etc.
• Effective Team Player with excellent analytical, programming, written and verbal communication skills. Ability to quickly learn/apply new technologies that translate requirements into client-focused solutions.

Professional Experience

Confidential

Senior Managing Consultant

As a Managing Consultant with IBM Global Business Services, I have been working with various major corporations in various capacities such as Project Lead, Systems Analyst, Technical SME/Architect etc.

• Identified IT skills, resources and created LOE's required to successfully implement projects and supported the PM in defining project work breakdown structure, project plan, schedule etc. as needed.
• Worked on important projects such as Affordable Care Act ACA mandate to establish Health Insurance Exchanges HIXs to serve as a central marketplace for people to compare health plans, Credit Risk Metrics - Development of risk rating models for probability of default, loss given default and exposure at default to support sound credit decisions and maintain strong asset quality, Web Log Analysis to analyze clicks and web browsing patterns in order to target specific products and offers to customers,
• Currently I am working for WellPoint as a Project Lead on EDWard data warehouse and I own various functions ranging from identifying new opportunities to leading the implementation of the data warehouse projects from inception to implementation stage and resolving issues which are discovered during the deployment.
• Delivered Affordable Care ACT - Health Care Exchanges projects within the mandated government deadlines with minimal issues. Worked under high pressure, heavy workload, tight schedules, complexity to meet the government mandated dates for the client.
• Collaborated with various teams across the globe in countries such as India, Philippines, Brazil, USA etc and maintained synergy among the teams and ensured successful delivery of quality results on time, with minimum defects and within the allocated budget.
• Partnered for clients success by ensuring that projects are implemented on schedule within the budget. Understood client business and their priorities and made sure their priorities are addressed on time. Gained client confidence by offering expertise from my extensive data-warehousing experience.
• Identified and provided recommendations to clients on resolving various types of issues such as Data Quality Issues, Performance Issues, Data Reconciliation Issues etc.

1. Trained on latest technologies such as Cloud Computing using IBM BlueMIX and Big Data using IBM BIG SQL.

Environment: Teradata v14.0, Oracle 10g, Informatica 9.1.0, Quality Center, ClearCase, XML, Infogix, Big Data, Hadoop, BIG SQL, Cloud Computing, IBM BlueMix etc.

Confidential

Data Warehouse Consultant/Systems Analyst

Worked with Capital One for more than 7 years in various teams and projects in different roles. Most recent role was as a Data Warehouse Consultant/Business Systems Analyst with the Retail IT team for BASEL II regulatory compliance project for Capital One's retail portfolios credit cards, home-loans, auto finance, etc. .

• Worked as Data Warehouse Consultant/Systems Analyst for Capital One's US Card and Canada Card lobs for implementing BASEL II risk compliance statistical models.
• Worked closely with Stakeholders, Business Data Stewards, Statisticians, SME's, Development and QA teams to understand the project objectives and to implement solutions.
• Performed Gap Analysis to determine data gaps in existing production systems and devised solutions to resolve the gaps. Conducted Feasibility Analysis, created Business Requirements, Data Requirements, Data Mapping, Source to Target mapping documents and Traceability Matrix to deliver the data for further process/technical solutions.
• Created Teradata SQL/BTEQ scripts and load scripts using utilities such as FastLoad, MultiLoad, FastExport etc. and Ab Initio to load the Teradata warehouse from various sources.
• Worked with the technical teams to source data from various sources such as databases, flat files, SAS datasets and consolidate and load into target data warehouse.
• Acted as a liaison between the business and technical teams and was instrumental in resolving conflicts and issues.

1. Supported user acceptance testing with stakeholders for the implemented solutions.

Environment: Teradata v13.0, Oracle 10g, Ab Initio, SAS, Unica Campaign, Quality Center, Rochade.

Confidential

Data Mining Analyst

Business Systems Analyst/Data Mining Analyst for rationalization of reports currently running on Pennsylvania's PACE Pharmaceutical Assistance Care for the Elderly and PDA legacy systems to produce a consolidated set of reports on new Cognos platform. Reduced the total number of reports from 2000 to 250.

• Interviewed on-site and off-site business stakeholders and gathered report requirements.
• Understood/Articulated business requirements converted them into process/technical solutions and specifications.
• Cataloged Metrics, Dimensions and Attributes and consolidated the reports by grouping eliminating repetitions. Presented consolidated view of the data and recommendations to the clients.
• Created Data Mapping documents to map the data elements between legacy Mainframe to new Oracle platform.
• Extracted and documented the Business process logic/rules from legacy programs to implement the actual logic required for new production system.
• Created ETL jobs to integrate data from various sources such as databases, flat files and consolidate and load into target ODS/EDW data warehouse using Informatica.

Environment: Oracle 10g, SQL Server 2008, MS Access, Informatica 8.6.1, Cognos, Windows XP, Mainframe, TOAD.

Data Warehouse Consultant

• Various roles such as Data Analyst, Data Engineer, Data warehouse consultant etc in different teams mentioned above on Business and as well as Technical side.
• Performed Data Analysis, Segmentation and Executed Campaigns to market to existing customers. Validated and Approved Campaigns created by our team to ensure that the business intent is met.
• Successfully managed multiple projects with competing priorities and worked within tight time lines. Prepared ad-hoc reports to analyze specific scenarios based on a situation etc using BO.
• Worked on setting up important campaigns like Capital One flagship product Venture Card, Customer Card Lab, Consultative Sales, Balance Build, Change in Terms CIT etc.
• Executed Portfolio Defense Strategies to manage risk of Capital One's US Card portfolio through programs like Exposure Reduction Credit Limit Decreases , Credit Management Inactive Risk Management , CIT Change in Terms etc., during the economic downturn.
• Created SAS scripts on Windows and UNIX environments to load data into Teradata tables/flat files and to analyze and extract Customer data.
• Created Raw SQL processes to load tables and reduced runtime of existing processes from hours to mere minutes.
• Actively participated in departmental Continuous Improvement and monthly metrics meetings and provided inputs on improving the existing processes. Implemented Lean Six Sigma methodologies Speed through removal of waste - Owned various Continuous Improvement ideas, Performed Root Cause Analysis using 5-Why methodology and devised permanent solutions to problems instead of temporary fix using the PDCA methodology.
• Designed/Developed ETL processes/database applications for databases such as Teradata, Oracle, SQL Server, DB2 using UNIX Korn shell scripting, ETL tool Ab Initio database utilities such as PL/SQL, SQL Plus, SQL Loader, MultiLoad, FastLoad, FastExport, BTEQ etc.
• Designed data scrubbing functions to scrub sensitive data before providing it to development, testing teams across Capital One. Ensured that the sensitive data transformation is not reversible.
• Worked with 100's of Gigabytes of data, increased performance of applications by 50 by implementing parallelism via Multifile systems, Partition Components etc in Ab Initio graphs. Used various components such as Reformat, Join, Lookup, Rollup, Filter by Expression etc. to implement the business rules.
• Used Ab Initio EME to perform Dependency Analysis, Check job status, details etc and to manage Business and technical metadata and for Source Code Control. Created Ab Initio Shop for Data graphs for use by analysts to generate reports and analyze data.
• Created Oracle Stored Procedures and Functions for TDG application for the Credit card application-processing platform. The application is created using Perl, Java, PL/SQL.

Environment: Teradata V12.0, Oracle 9i/8i, DB2, Unica Affinium Campaign 8.1, Ab Initio Co>Operating System V2-14-87, GDE 1.14.27, EME, Shop for Data Version 2, PERL, XML, HP UNIX, SAS 9.1.3, Business Objects, Visio, Clear Case.

Data Warehouse Consultant

WellPoint is building a new data warehouse called as Enterprise Data Warehouse And Research Depot EDWard . The goal of EDWard is to source data directly from the Operational systems to improve latency and to retire current regional warehouses. Database is Teradata and Informatica is the primary ETL tool.

• Data warehouse Lead with the Edward Lights-On Team for Well Point's IM Data Solutions department. The team is responsible for fixing Production Issues related to Data Integration/ Break Fixes and Minor enhancements to applications and servicing ad-hoc requests from Business Users.
• Lead the project team by adhering to Well Point's Software Development lifecycle standards through different stages such as Development, SIT, UAT, Implementation Ready and Production etc.
• Coordinated between WellPoint clients and Cognizant offshore team to get the production issues fixed by guiding the team to identify the root cause and leading through fixing of the issues. Created load jobs using Shell scripting, ETL tool Informatica and Teradata utilities MLOAD, FASTLOAD, FEXP etc.
• Developed standard and re-usable mappings mapplets using various transformations in Informatica like expression, aggregator, joiner, source qualifier, router, lookup and filter. Performance tuning on Targets, Sources, Mappings and Sessions etc to maximize efficiency.

Environment: Teradata V12.0, TTU 12.0, Informatica 8.6.1, WLM Workload Manager , UNIX, Windows XP.

Technical Designer/Lead for the MST project

• The MST program was targeted to replace the merchandising functionality on Circuit City's legacy systems with state-of-the-art packaged software applications, composed primarily of Oracle / Retek products.
• Technical Designer for the MST's Replenishment Workstream.
• Optimization of the Inventory Management and Supply Demand chain processes. The databases were Oracle, DB2 and the OS was IBM-AIX. The ETL was performed using Informatica.
• Developed PL/SQL stored procedures, Triggers, SQL scripts and Korn shell scripts to extract and convert legacy data.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data

Environment: Oracle 9i, DB2, Informatica 7.1.2, IBM-AIX, AS/400, Windows XP, WinSQL.