SUMMARY

• Overall 6 years of experience as a Data Analyst including working with Data Analysis/ Data warehousing/ Data modeling in financial, healthcare, retail and telecommunication domains.
• Performed Source - to-Target mapping on many projects.
• Handled modeling changes to legacy and future databases, using Powerdesigner and implemented them on Development and Test databases and moved the same to Production Instances during the production release.
• Documented using the Metadata Repository (MDR) and the business rule spreadsheet (BRS) from the Corporate Data Warehouse (CDW) and the Integrated Operational Data Store (IODS) for financially reported Critical Data Elements (CDEs).
• Experienced to develop a customized mortgage accounts management solution to provide home mortgages, home refinancing, and home equity loans to consumers
• Expert in working with Data Modeling tools including ERwin and Sybase PowerDesigner.
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema.
• Developed Data Migration and Cleansing rules for Integration Architecture (OLTP, ODS, DW)
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experience in designing/developing SQL statements and queries for Oracle and SQL Server 2005/2008 databases for Data profiling and development.
• Experience in writing/optimizing SQL queries in Oracle and SQL Server 2005/2008.
• Skilled at conducting requirement analysis, use case design, test plans design and database schemas Development based on the logical models.
• Extensive experience in configuring data mapping between different databases.
• Facilitated/participated in Joint Application Development (JAD) sessions, and white board sessions with SMEs to keep executive staff and team members apprised of goals, project status, and issue resolution.
• Experienced in design/development of Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (8.1/7.x/6.x/5.x) /Power Mart 4.7, Datastage, Mainframes, SAS, SSAS, SSIS, OLTP, OLAP and Business Objects.

TECHNICAL SKILLS

Testing Tools: HP Quick Test Professional (QTP), Quality Center (QC)

Languages: C, VB Script, Java, HTML/XML

Databases: MS SQL Server

Software Tools: MS Office Suite (Word, Excel, Power Point)

Operating Systems: Windows 98, 2000, XP, Windows 7, Windows 8

Others: SharePoint, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Data Analyst

Responsibilities:

• Worked in a team with Project Manager and other members in creating data model for different aspects.
• Produced functional decomposition and logical models into an enterprise data model.
• Designed conceptual and logical data models of Data Warehouse and tables for ETL Process.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Employed process and data analysis to model a Customer Information Business System.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams for ETL.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Developed and maintained sales reporting using MS Excel queries, SQL in Teradata, and MS Access.
• Produced functional decomposition diagrams and defined logical data model.
• Logical data model was developed using ER diagrams
• Created SQL tables with referential integrity and developed queries using SQL
• Wrote specifications for Web pages based on Use case analysis
• Conducted team meetings and JAD sessions
• Helped DBA in creating the physical database design and QA team in their testing
• Implemented the reporting sub system via Crystal Reports

Environment: Environment: HIPPA, EDI, Facets, Medicaid/Medicare, Oracle 11g, SQL, PL/SQL, Cognos, MS Excel, MS Visio.

Confidential, Irving, TX

Data Analyst

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with the better understanding of the data related to mortgage, origination, lien, and default.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their format.
• Worked extensively in creating the DMR Mapping Spreadsheets, Source to Target Mapping documents.
• Analyzed the transformation rules and Joins/Filter logic documents.
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Reverse Engineered databases to understand the relationship between already existing tables.
• Created an initial data model (conceptual) to incorporate the new data elements for new functionality.
• Created Logical/Physical data models from the conceptual model identifying the cardinality between the tables.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Generated DDL scripts for the developed physical model.
• Created Source to target Mapping Matrix for the ETL developers in loading the data to Dimensions and Fact Tables using SAS.
• Worked with data modelers to handle the modeling changes to legacy and future databases, and implementing them on Development and test databases and moving the same to Production Instances during the production release.
• Worked with Central Distribution Hub (CDH) team in developing strategies to handle data from EO to CDH and then from CDH to downstream systems.
• Created use case scenarios to test performance of the Finance Data Store.
• Worked with the CCG (Consumer and Credit group) team to develop a star schema for the CCG - Collections Data Mart identifying the Fact and Dimension tables.
• Involved in Semantic layer design. Building views based on requirements given by users.

Environment: Oracle, SQL Server 2008/2005, Windows 2008, Microsoft Access, Microsoft Visio, Microsoft Excel, Remedy.

Confidential, Orlando, FL

Data Analyst

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.

Environment: Erwin r7.1, Informatica 7.1.3, Windows XP/NT, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, Ashburn, VA

Data Analyst

Responsibilities:

• Worked on multiple projects with different business units including Insurance actuaries
• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models;
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.

Environment: CA ERWIN r7, Oracle 10g, SQL Server 2008, PL/SQL, Toad, Informatica, Power Centre 6.0, Case Management System, Business Objects