Summary

• A Data Analyst with over 7 years of experience in Insurance, Financial, and Healthcare domains using Oracle 11g/10g, MS SQL, Teradata.
• Experience in Data Modeling techniques employing Data warehousing concepts like star/snowflake schema and Extended Star.
• Knowledge in design and creation of database and database schema.
• Experience writing SQL Queries for Data Validation and Data Integration.
• Experience of working in the area data management including Data Modeling, Metadata, Data Analysis, Data Mapping and Data Dictionaries.
• Served as web analytics technology expert related to tagging and tracking enhancements, solution design and reporting - participating in various web tool integration projects.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle SDLC , Iterative Software Development Life Cycle Process, and Agile Scrum methodology.
• Experience in creation of data source and transform them into custom created datamarts.
• Extensive experience in visualizing the design of the system using UML diagrams, Activity diagrams, and Web page mock-ups.
• Strong expertise in building, Templates, Graphical analysis charts and Statistical reports using MS Excel and also expertise in MS Word, MS PowerPoint.
• Performed data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
• Developed Excel applications pivot tables, VLookups to streamline processes for analysis and reconciliation.
• Excellent presentation skills in preparing contingency plans, review logs, forecasting and planning work schedules with excellent comfort level in using Microsoft Project.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Experience in working with business users as well as senior management.
• Strong in analytical and problem solving skills, excellent planning and multi-tasking abilities with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.

Technical Skills

Professional Experience

Confidential

Sr. Data Analyst

The project involved in extracting data from different sources and loading into Data Marts. The major job involved in cleansing the data and transforming the data to the staging area then loading the data in the Data Marts. The Data Marts is an integrated Data Mine that provides feed for extensive reporting. It enables an insight into the current and future financial situation/needs based on the information received from the Data Warehouse.

Responsibilities:

• Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Dealt with conflicting scenarios when the requirements and the reverse engineering communicated different cleansing rules.
• Always patient in analyzing the root cause of data issues and clarifying it with the data owners.
• Performed Reverse Engineering of the legacy application using DDL scripts in Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Worked with DBA's to create a best fit Physical Data Model from the Logical Data Model using Erwin.
• Administered and maintained the model updates using Model Mart for the entire project team.
• Employed process and data analysis to model a Customer Information Business System.
• Conducted logical data model walkthroughs and validation.
• Conducted team meetings and JAD sessions.
• Developed data mapping documents for integration into a central model and depicting data flow across systems.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Developed the data warehouse model star schema for the proposed central model for the Project.
• Developed Process Methodology for the Reverse Engineering phase of the project.
• Developed and maintained the central repository, populated it with the metadata.
• Used Business Objects for validating the metadata and testing the data of reports.
• Designed and developed reports for the data in the Data Warehouse using Business Objects / excel.
• Analyzed data using Slice/Dice and Drill up/Drill down to analyze data to meet the end user's requirements.

Environment: Oracle 11g, Erwin 4.0, MS Visio, MS Office, MS Excel, SQL, SAP Sybase adaptive Server enterprise, SAP Business Objects 4.1,

Confidential

Data Analyst

Reporting features as part of website was required to be redefined to make money management more efficient for customers. The new reports helped customers track expenses and income by category, set budget goals and monitor performance against goal for all of their financial accounts.

Responsibilities:

• Performed source data identification and analysis to get a clean master data to report to customer
• Liaison between stakeholders, system users, clients and managers, software development team and the QA term to gather requirements.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Data analysis and reporting using MY SQL, MS Power Point, MS Access and SQL assistant.
• Monitored performance, integrity to optimize SQL queries for better efficiency
• Performed data cleansing, data validation and mapping as described in the business requirements.
• Write down the SAS programs for processing of data sets and perform data mapping in the data warehouse.
• Created interactive reports and dashboards using tool tips and customized features such as subtotal, alerts, color coding and drill maps to better understand business trends
• Proficient in downloading SAS flat files to Microsoft Word, Access or Excel for additional database for manipulation and analysis.
• Tested dashboards and reviewed the data for various KPI.
• Extensive use of EXCEL PIVOT tables to run and analyze the result data set and perform UNIX scripting.
• Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.
• Analyzed, build and documented the different Metadata and Data dictionaries that will be required
• Actively trained Business Users involved in User Acceptance Testing UAT and helped them understand UAT procedure
• Environment: SQL, MY SQL, Erwin, Data Stage 6.0, Model Mart, MS Sharepoint, PL/SQL and SAS.

Confidential

Business System Analyst

Responsibilities:

• Reviewed and gathered requirements from the Subject Matter Experts SME and Business Partners and created Scope and roadmap Documents.
• Written complex queries to profile the data and test the data readiness for the quick response code management data.
• Created artifacts such as Use Cases, Prototypes, and Business Flows and Work Flow diagrams for effective plans.
• Experience in creating blueprint of the system Database and helping the development team come up with the design of the database and maintaining the proper ER relationship.
• Effectively created Data Dictionaries, XML mapping spreadsheets for interface requirements based on design solution.
• Loaded and managed the business, system and data requirements using Microsoft Office and RM Track.
• Managed changes in requirements using a Change Control process as defined by the organization. Including interacting with the sponsor for getting any required approvals for CR raised by the technical / business team.
• Performed root cause analysis of any data related defects using RM Track.
• Helped in analyzing project goals, breaking down what needs to be created as WBS and attempted to negotiate the timelines and cost estimate for the project.
• Write detailed requirement for System Enhancement and making high-level flow charts.

Environment: SOA, Rally Agile planning tool, HP Quality Center, Rational RequisitePro, MS Visio, MS Word, MS Excel, MS PowerPoint, IBM Web sphere and SharePoint 2010, RM Track Bug tracking, XML

Confidential

Data Analyst

Migration project Objective was to move the existing Data Warehouse from Oracle to Microsoft SQL Server. The existing ETL job stream loading the Oracle Data Warehouse built in Business Objects Data Integrator was needed to be switched to loading the new SQL Server Data warehouse. The project involved end to end implementation of DW from data modeling, ETL and BI reporting system.

Responsibilities:

• Documented the existing the transactional system using ERWIN.
• Prepared the reports that are possible with the existing data and demonstrated to the managers in the JAD sessions, with slicing and icing options
• Prepared BRD / mapping documents based on the GAP analysis from the reporting requirements to the existing data in ODS.
• Prepared the Change data capture document for the additional data requirements
• Developed a dimension models using the facts and the dimensions and the Key performance indicator using ERWIN
• Used unified modeling language UML - use cases to create artifacts for the reporting related deliverables
• Prepared the ETL design for the dimension models
• Defined aggregations, partitions for the data model
• Created the ETL test specifications and test cases
• Tested the BI reports and done the user acceptances.

Environment: Oracle 11g, MS SQL 2005, Informatica, Cognos, Rational tools and MS Project