SUMMARY:

• A Data Analyst with over 7+ years of experience in Insurance, Financial, and Healthcare domains using Oracle 11g/10g, MS SQL, Hadoop and 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 & toolintegration 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:

Analysis Methodologies: Scrum, UML, Agile methodology, Waterfall methodology, SWOT, Cost-Benefit Analysis, Gap Analysis.

Databases and Tools: MS SQL Server 2008, SAP Sybase, MySQL, DB2, Oracle, Hadoop

Operating Systems: Microsoft Windows XP, UNIX

Quality Management: HP ALM, Quality Center, RM Track

Business Modeling Tools: Microsoft Visio, Share Point

Reporting: Crystal Reports, Business Objects, QlikView

Project Management: Microsoft Project, Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Monterey Park, CA

Sr. Data Analyst

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 Confidential t 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.
• Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract the data from SQL Database using Hadoop.
• 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, Hadoop, SAP Sybase adaptive Server enterprise, SAP Business Objects 4.1

Confidential, San Francisco, CA

Data Analyst

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, New York City, NY

Data 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, Boston, MA

Data Analyst

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