SUMMARY

• Over 7 Years of Data Modeling/Business Data Analysis and IT experience as a professional, streamlining and reengineering business processes for Banking, Mortgage, Insurance and Health Care.
• Extensive experience with full Software Development Life Cycle (SDLC) implementation of data warehousing and BI solutions with commendable success in modeling and analyst roles.
• Core experience in creating Conceptual, Logical and Physical data models for both OLTP and OLAP database environments using tools like Erwin.
• Experience in managing the online Master Data Management (MDM) request tool for new requests ensuring proper decision - making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turn-around time.
• Experience in managing the Integrated Consumer Data Warehouse (ICDW), Consumer Data Hub Info1 and legacy Enterprise Data Warehouse (EDW) etc.
• Proficient in MS Excel Functionalities (Pivoting and other BI).
• Very Strong knowledge in Enterprise Data Warehouse environment, Dimensional/ Hierarchical data modeling and created data models and data marts using Star/Snowflake schema concepts with considerable flexibility based on user requirements.
• Good knowledge in implementing Normalization and Denormalization techniques for optimum performance in OLTP/OLAP database environments.
• Knowledge on building reports using Crystal Reports and Micro Strategy.
• Experience in Designing and Deployment of Reports for the End-User requests using SSRS.
• Well versed with various software development methodologies (Water Fall, Agile Methodology).
• Full understanding of the ETL (Extract, Transform and Load) solution concepts and functional knowledge of Informatica.
• Experience in Business Objects, a Business Intelligence reporting tool to generate ad hoc reports for non IT users.
• Strong Database programming experience on performance tuning & T-SQL concepts.
• Expertise in using different core components of SSIS connection managers, control flow, data flow, Event Handlers & variables.
• Experience in developing applications PL/SQL Cursors, Triggers, Exceptions, Packages, Stored Procedures and Functions.
• Excellent ability in problem solving, data analysis, complex reports generation using SAS.
• Experienced working with clients on-site, analyzing software requirements and developing solutions and procedures.
• Proficient in creating documentations like BRD, SRS, FRD, RFP, RFQ, RTM; Wireframes, Mock-ups and conceptual design; creating Use Cases, specifications and Use case scenarios.
• Experience of creating Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Proficient in analyzing and creating Use Cases, Use Case Diagrams, Data Flow Diagrams, Activity diagrams, Class diagrams and Sequence diagrams using MS Visio.
• Experience in Conducting JAD/RAD sessions and elicited customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs).
• Experience in conducting GAP analysis, SWOT analysis, Cost Benefit analysis and ROI analysis.
• Extensive experience in handling multiple projects at the same time with commendable results in terms of deliverables and user appreciation.
• Efficiently involved in interacting with Business Analysts, Department Managers and Business Users.
• Involved profusely in Production support, deployment and Report Testing.
• Good problem solving, reporting and statistical skills with excellent communication and inter-personal skills. Demonstrated ability to work both in independent and team-oriented environments.

TECHNICAL SKILLS

Operating Systems: Windows 10/7/ Vista/ XP/2000

Databases: Oracle, SQL Server, Microsoft Access, Teradata, DB2, Sybase

Statistical: Microsoft Excel, SAS

Business Intelligence Tools: InfoView, Web Intelligence, Informatica, DataStage, Microsoft SSIS, SSRS, SSAS

Data Modeling Tool: ERWIN

Business Tools: Rational Suite, MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm

Languages: UML, HTML, Java, J2EE, .Net, JavaScript, SQL, PL/SQL

Testing Tools: Test Director, Win Runner, Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Binghamton, NY

Business Data Analyst/Modeler

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects and ETL developers.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Normalized the database to put them into the 3NF of the data warehouse.
• Created Excel formulas for various purposes.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Performed data analysis with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Performed routine functions in Informatica like loading data from a flat source file into a target and apply transformations for the data according to the requirements.
• Prepared Business Requirement Documents (BRD) and used Requisite Pro to manage, analyze, and convert business requirements into functional specifications.
• Used RUP methodology to analyze and translate business requirements into system specifications, communicating with the business on a broader scale and with an in-depth view too.
• Written complex SQL queries for validating the data against different kinds of reports generated.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generated DDL scripts for database modification, views and set tables.
• Worked with DBA to create Physical Model and tables from the logical model.
• Coordinated with testers and helped in the process of Integration testing.
• Coordinated changes with developers, technical writers and end users.

Environment: Oracle 10g, DB2, SQL Server, Teradata, Erwin 7.3, Toad 9.6, Windows XP, XML, Excel, MS Access, MS Visio, Informatica, Buisness Objects, SharePoint.

Confidential, Dallas, TX

Data Analyst/Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams.
• Hence developed and documented conceptual design of Application in System Specification Document.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Metrics reporting, data mining and trends in helpdesk environment using Access.
• Generated data models using basic concepts of ERWIN.
• Created detailed Control Requirements for the various roles and responsibilities identified in the organization.
• Performed Gap Analysis and Participated in the initial Risk analysis.
• Created Aggregate Tables wherever necessary.
• Defined data definitions, and created target tables in the database.
• Built some complex queries using SQL and wrote stored procedures using T-SQL.
• Wrote PL/SQL procedures to resolve critical update issues using TOAD.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding a defect status and fixes on daily basis

Environment: RUP, UML, Datastage, DB2, SQL Server, Informatica, XML, Business Objects-Web Intelligence and Desktop Intelligence, MS Office Suite (Word, Excel, Access and PowerPoint).

Confidential, Austin TX

Data Analyst

Responsibilities:

• Conducted one on one sessions and team meetings with the team leads and SME’s to understand the business requirements.
• Prepared the Charter/BUR and functional design document.
• Updated the functional design document for NPI related changes in the Encounters project.
• Arranged meetings with other teams to gather the functional and system requirement for EPC project.
• Using SQL queries, investigated data discrepancies between various source systems such as INTERACT, COACT, CARS/IS, Rebates- Chargeback and the Data Warehouse and the PricePoint and Sales Data Marts.
• Analyzed encounters claims file (837 P, I, D) using Spec Builder.
• Helped to develop a more efficient manner for filing pharmaceutical claims.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Developed straightforward DBMS queries, knowledge of HL7 and XML interface messaging.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Responsible for architecting integrated HIPAA, Medicare solutions, Facets.
• Identify Member, Provider, Coverage, Medicare, and Medicaid.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Uploaded the test cases in the Test Director and executed them.
• Responsible to investigate data discrepancies between the existing reporting system and a new data warehouse system.
• Created and Maintained Access Databases, using Modules, Reports, Queries and Access SQL, for Call Center.
• Involved in troubleshoot data issues using SQL Server Query Analyzer, and Enterprise Manager Tools.
• Extensively implemented and governed the corporate naming standards according to the company-specified standards.

Environment: Edifecs SpecBuider 6.1, EDI ANSI X12/HIPAA, PL/SQL, DB2, MS OFFICE,TESTDIRECTOR 7.0, XML, WINDOWS XP, MS Word, MS Excel, MS Access, MS PowerPoint, MS Project.

Confidential, Scottsdale, AZ

Data Analyst/ Modeler

Responsibilities:

• Understand and articulate business requirements from user point of view and then convert requirements into technical specifications Documents.
• Responsible to investigate data discrepancies between the existing reporting system and a new data warehouse system.
• Worked with several clients on developing streamlined claims process.
• Developed process manual for inputting claims into the company computer system when it was installed.
• Implementing source procedures to the existing logic to help identify whether the new data warehouse matches that logic.
• Used profile data to understand potential weak points in the reporting data.
• Document Database Issues and Send to Information Technology for Correction.
• Communicate with ETL developers in order to figure out where and why a data discrepancy exists.
• Created and Maintained Access Databases, using Modules, Reports, Queries and Access SQL for Call Center.
• Recommend System Changes and Enhancements.
• Involved in troubleshoot data issues using SQL Server Query Analyzer, and Enterprise Manager Tools.
• Create Custom Reports and Queries using Inner and Outer Joins.
• Performed Sales analysis and projections using Access and Excel.
• Created, published, scheduled and maintained Business Objects 6.1 InfoView reports publisher, Business Objects 6.1 Console Management.
• Generated data models using basic concepts of ERWIN.
• Extensively implemented and governed the corporate naming standards according to the company-specified standards.
• Interacted with SME accumulate knowledge about business processes and documented those for future purposes.
• Involved all design reviews of mapping according to High level design Mapping Documentation and standards followed for project.

Environment: SQL Server, Informatica 7.1.1, Business Objects 6.1, InfoView, ERWIN, MS Access and MS Excel, TOAD, XML.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Understand and articulate business requirements from user point of view and then convert requirements into technical specifications Documents.
• Responsible to investigate data discrepancies between the existing reporting system and a new data warehouse system.
• Navigate table relationships through both 3NF system and star schema.
• Implementing source procedures to the existing logic to help identify whether the new data warehouse matches that logic.
• Used profile data to understand potential weak points in the reporting data.
• Document Database Issues and Send to Information Technology for Correction.
• Communicate with ETL developers in order to figure out where and why a data discrepancy exists.
• Report writing using Business Objects 6.1.
• Created and Maintained Access Databases, using Modules, Reports, Queries and Access SQL, for Call Center.
• Recommend System Changes and Enhancements.
• Involved in troubleshoot data issues using SQL Server Query Analyzer, and Enterprise Manager Tools.
• Create Custom Reports and Queries using Inner and Outer Joins.
• Performed Sales analysis and projections using Access and Excel.
• Created, published, scheduled and maintained Business Objects 6.1 InfoView reports publisher, Business Objects 6.1 Console Management.
• Performed routine functions in Informatica like loading data from a flat source file into a target and apply transformations for the data according to the requirements.
• Extensively implemented and governed the corporate naming standards according to the company-specified standards.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Interacted with SME accumulate knowledge about business processes and documented those for future purposes.
• Involved all design reviews of mapping according to High level design Mapping Documentation and standards followed for project.

Environment: SQL Server, Informatica 7.1.1, Business Objects 6.1, InfoView, ERWIN, MS Access and MS Excel, TOAD, XML.

Confidential

SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design.
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.