Introduction

• Data Warehouse Analyst with over 9 years of consulting experience in design, development and implementation of Data Warehousing and Reporting projects, primarily in the Financial and Federal Government sectors. Ability to contribute in all phases of SDLC including business requirements gathering/analysis, design, development and testing. Excellent team player with the ability to work in groups as well as independently with minimum supervision. Professional and technical capabilities include:
• Eliciting and documenting Requirements Specifications from users and generating a Requirements Traceability Matrix to tie in the requirements during various phases of the project
• Experience in Business Process Modeling, Data Flow Modeling, Work Flow Analysis and Use Case Analysis
• Expertise in data analysis and reporting using Business Intelligence tools like Business Objects, Cognos, Crystal Reports and creating visual representation of data using Tableau
• Adept at utilizing Microsoft Excel and Access to create complex data sets, using array formulas, pivot tables, vlookup functions, linked data sets, importing data from various sources, as well as other advanced functions
• Writing Excel Macros using Visual Basic to generate financial models and automate data extraction
• Experience in database design, modeling, development and maintenance including creating ETL procedures using tools like Informatica, Ab Initio, Data Stage, SQL Loader
• Querying data from a variety of data sources, joining tables to pull data together, verifying data and creating executive level dashboards and graphs
• Experience in integrating databases in Client/Server applications with Oracle and SQL Server as the backend and in writing stored procedures, functions, views, database triggers
• Creating data model structures for enterprise data aiming at both OLTP and OLAP decision support systems
• Passed government OPM security clearance and responsible in handling highly classified NPI data
• Proficient in querying a variety of databases like Oracle, SQL Server, MS Access using SQL, PL/SQL
• Working with complex data transformations such as multi joins on heterogeneous flat files, connected/unconnected lookups and routers
• Developing test cases and test scripts to verify data integrity and logging defects using tools like Sharepoint, and Mercury Quality Center
• Generating Process Flow diagrams, Sequence diagrams and Data Flow diagrams using MS Visio
• Solid communication skills with all levels of management along with experience in coordinating various client meetings, presentations and JAD sessions

Technical Skills

• ETL Tools: Informatica 8.2/7, Oracle Warehouse Builder 10g, 9.2, Data Stage 7.5, Ab Initio
• Reporting tools: Business Objects XI R2, Cognos 6x/7x, Crystal Reports 2008
• Databases: Oracle 10g/9i/8i/7.x, DB2 EE 8.2, Sybase, SQL Server 2000/2005, MS Access
• Languages: SQL, Visual Basic, C , JAVA, PL/SQL, XML
• Data Analysis Tools: Excel 2007, TOAD, Tableau 4.0, SAS
• Tracking Tools: Clear Case, Clear Quest, Mercury Quality Center
• Miscellaneous: MS-Office suite, MS Sharepoint, MS Project 2005, MS Visio

Professional Experience

Confidential

Role : Senior Data Analyst

The project involves identifying properties with high risk and working with Servicers to provide various loan modification options. And in cases where the modification options fail, liquidating them sooner by marketing them through various programs like Pre-Foreclosure Sales, Third Party Sales and Foreclosure.

Responsibilities:

• Analyzing various data sources existing within the organization to compare high risk properties against MLS, REO data etc to identify properties where there is a opportunity to help the borrower
• Working with the business team and the technical team for requirements gathering and analysis
• Created servicer specific performance reports for the top servicers to understand the performance of different modification/liquidation programs, and participated in calls with the servicers to determine areas of improvement.
• Responsible for creating the monthly reports to show the performance of each of the pilot programs
• Preparing regression charts and graphs to highlight loans with potentially high loss and risk involved and performing comparative analysis on how the model would help in such cases
• Using Toad in querying data and generated ad-hoc reports requested by OIG and FHFA
• Generated high level consolidated reports for business and upper management to show performance of modification and liquidation products.
• Provided summarized views showing that the loans were worked on early in the delinquency period because of the roll out of Tier incentive payment structure based on servicer performance.
• Segmented loan lists to identify populations that did not go through a modification.
• Performing Gap Analysis on the existing data models and identify changes needed to handle the data and reporting requirements
• Using VizQL tools like Tableau to identify data trends and anomalies by creating visualization reports
• Writing Excel Macros using Visual Basic to generate financial models and automate data extraction

Environment: Oracle 10g, SQL and PL/SQL, Excel 2007, Business Objects, Tableau 5.0, Toad, MS Visio, MS Project, MS Access 2003, SAS

Confidential

Role : Senior Data Warehouse Consultant

There are multiple projects at Veteran Benefits Administration of which our team worked predominantly on Education benefits for veterans. The objective of the project is to maintain the data warehouse named EDW that reports all payments made till day and the work load in processing all the claims. Report on different benefits eligible by the veterans and perform analysis to determine how the payments are linked to benefits and report the cash flow for various Chapter benefits.

Responsibilities:

• Understanding Business operations and requirements to create various SDLC documents, including Development Plans ROMs to prepare estimates for design, development and deployment.
• Play a significant role in Project Management areas such as Business and Technical Issue Management, Project time line decisions
• Responsible for maintaining the Education payment information to date and generating reports to show the total payments on a daily and monthly basis
• Creating a Business Objects dashboard with materialized views tracking the Education workload. These reports help to determine the pending claims, claims processed each day, number enrolled and amount paid for an enrollment period.
• Working with accounting teams to ensure payments have been correctly posted for various claims
• Design ETL mappings and workflows using Informatica to automate the existing daily loads
• Develop scripts to do all the necessary preliminary check for loading the file and send appropriate alert messages to the team for minimizing manual intervention on a daily basis
• Querying various databases using PL/SQL and Toad for various adhoc requests from clients
• Provide drilled down views and packages for various canned reports that needed further analysis
• Setting up group mailing lists to distribute project updates and reports to everyone in the team
• Documenting methodologies using PowerPoint and Visio diagrams to present to upper management
• Provide recommendations for changes and enhancements at different stages of the project to accommodate for change management requests
• Involved in unit, performance, regression and integration testing of data load jobs and maintaining a defect tracking list in Sharepoint
• Attending monthly knowledge transfer meetings to help Database Administrators understand the process for production support

Environment: Informatica, Work Flow Manager, Warehouse Designer, Oracle 10g, SQL and PL/SQL, Excel 2007, Business Objects, Oracle Discoverer, Tableau 5.0, Toad, MS Visio.

Confidential

Role : Data Warehouse Consultant

Confidential is a leading global research driven pharmaceutical company. It discovers, develops, manufactures and markets vaccines and medicines to address medical needs of the society. Confidential is internally divided into two business units namely, the Confidential. The project focuses on building a Financial Performance Management System FPM , which extracts financial, hierarchical and head count information from various systems that exist within the organization.

Responsibilities:

• Collaborate with business users and the technical team for requirements gathering and analysis
• Reviewing the overall system design documents for sign off on integration of the database components
• Ensure that referential integrity is maintained across the data model and updated the database structure to handle the new data requirements
• Perform source data assessment and identify the quality and consistency of the data for data scrubbing
• Designed procedures to handle data from various source systems to the centralized FPM Repository
• Supported the extraction, transformation and loading process ETL for a data warehouse from their legacy systems using Ab Initio
• Developed small EUCs using MS Access to handle quick data analysis or reporting prototypes
• Generating monthly reports and graphs using Tableau to identify budget trends and ensure that the unit is meeting the monthly constraints and goals
• Performing transformation of source data with transform components like Join, Match sorted, denormalize reformat, filter by expression, rollup etc
• Responsible for performance tuning and backup recovery of the reporting features
• Writing UNIX shell scripts for scheduling and pre/post session management jobs
• Preparing the Standard Operating Procedure Knowledge Transfer document, which provides necessary information, required for the Maintenance and Operation of the application
• Creating Universes using Business Objects to show aggregated views of business metrics
• Validating production reports by creating equivalent data extract in Excel and Access
• Training end users to utilize the reports and Adhoc reporting features developed in BO
• Enhance report performance by refining joins, refining calculations at report and package level

Environment: Ab Initio, Oracle 10g, PL/SQL, Toad, MS Project, UNIX, Tableau 4.0, Business Objects, Excel 2003, MS Access 2003

Confidential

Role: Data Analyst

• Confidential is one of the nation's biggest financial corporations engaged in commercial and retail banking.
• The Project focuses on integrating the three lines of business i.e. Financial, Confidential into one separate system called Enterprise originations. The data is loaded from this system to the EDW, out of which the data marts are created for reporting.

Responsibilities:

• Responsible for developing the technical specifications document based on the business requirements

• Created data mapping documents to capture the business logic involved in loading the data mart from the source warehouse
• Analyzing various data sources existing within the organization to identify high risk loans where there is an opportunity to avoid default
• Developed risk analysis reports using the data analysis software Tableau to analyze loan level information
• Highlighting various risk attributes in the reports like Delinquency status and Severity
• Manual verification of data populations that was not verified by the System by analyzing the uniqueness of each loan and identifying the parameters that could be used to help verify such loans
• Used Data Stage Director to schedule and run jobs as well as to monitor logs
• Mapping internal data to external vendor XML schema formats, to capture loans with exotic mapping
• Developed PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management
• Executed UNIX shell scripts for data loading, job scheduling and SQL script execution
• Developed Business Intelligence reports to track Financial Metrics using Business Objects
• Created multiple views of reports in BO based on characteristics identified by users. For example having a cut by loan count and one by dollar amount or having monthly and quarterly views.
• Administered and scheduled the nightly loads from the warehouse to the data marts

Environment: Data Stage, Business Objects XI, Oracle, MS Visio, Tableau, MS Access 2003, MS Sharepoint, SQL Developer, XML, Excel 2003

Confidential

Role : Business Analyst

The project focuses on building a Credit Risk Analysis System, which extracts financial information from various systems that exist within the organization. The source systems involved a variety of interfaces like Oracle, DB2, XML files and flat/CSV files.

Responsibilities:

• Interact frequently with the business users to gather and document the business requirements and functional reporting requirements

• Facilitated meetings between business users and the development team to discuss issues and developments
• Analyzed the existing transactional database to understand the data hierarchy between the tables
• Analyzed data issues for mapping to existing database structures, OLAP processing, developing and applying business rules
• Used MS access extensively to load csv and xml files and join with other tables to perform data integrity and validation checks
• Developing Risk analysis reports using the data analysis tools to analyze loan level information
• Extracted, Transformed and Loaded data from Oracle database and flat files into the staging area
• Designed and Developed pre-code technical transformation documents which define the ETL logic
• Developed Test Cases and prepared test scripts using SQL to test transformation logic in the data
• Identified and logged issues and defects using Mercury Quality Center
• Involved in integration and user acceptance testing and worked closely with the testing team and fixed the bugs by interacting with the development team
• Training users to use the system and to customize their data analysis reports in Cognos
• Attend weekly status meetings to discuss the accomplishments and project milestones

Environment: Cognos, Mercury Quality Center, Toad, Excel 2003, SQL, PL/SQL, MS Access 2003, Oracle.