SUMMARY:

• 7+ years of Industry experience as a Data Analyst/Business Systems Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Experience as Business Intelligence/Systems/Data/Business Analyst with expertise in Insurance, Healthcare processes, Business Process Engineering, Finance & Communications, Strategic Planning, and Systems Analysis.
• Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Worked with different Business Areas like Claims and Enrollment to document proposed ICD 9 - 10 Code changes.
• In-depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Knowledge in the Informatica/ ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Knowledge in Data Migration, Data Conversions using DTS, Data Junction and SQL Loader
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version and translation of ICD 9 codes into ICD 10 codes.
• Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Managed all aspects of the data warehouse such as data migration, validation, integration, cleansing, database/query optimization, stored procedures, functions, view, creating index, reporting. Extensive experience in all phases of RUP and SDLC processes
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
• Strong oral and exceptional written business communication skills

TECHNICAL SKILLS:

Software/Hardware: ERWIN, ETL: Ascential Data Stage (7.x, 6.x, 5.x), Star-Schema Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Micro strategy, Erwin 4.x, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, SQL Server, SOA, SAP SD, MySQL, Oracle 8i,Visio, Sybase ASA (6 - 9).ASP/ASP.net, PHP, Unix, MVS, MS Windows/95/98/NT/2000/XP, Office Tools: MS Project, MS Office suite including MS Excel (VBA, Pivot tables, lookups), Dashboards.

EXPERIENCE:

Confidential, Iowa

Business Systems Analyst/ Data Analyst

Responsibilities:

• Extensively use Informatica client tools. The objective is to extract data stored in Access database and Business Objects Universe, flat files to load finally into a single data warehouse repository, which is in Access.
• Create internal and external reports using stored procedures from the Reporting Data Warehouse.
• Utilizing Business Objects to create & implement data query templates to efficiently gather data.
• Worked with the client and the database administration team to design database structure for different modules. Use pivot tables in Excel to replicate the reports that can be expected.
• Assist in creating wireframes for web interface with the GUI design team.
• Perform conversion on Excel files created on different versions of Excel. Conversion of reports from 2003 and 2007 version to MS Excel 2010.
• Enhance the Resourcing Reports using power pivots, slicers and sparklines.
• Provide ad-hoc data and reports as needed from resourcing tools and databases.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and using SQL queries to filter data within the Access database
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Extensively use Excel and Access Macros and VBA with Excel Forms
• Gather user and business requirements through open-ended discussions, brainstorming sessions and role-playing
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling (BPM).
• Write SQL statement in Access for extracting as well as writing data.
• Responsible for designing and developing universes for development of reports using business object designer
• Documenting business and system needs via the creation of a variety of documents including Scope documents, GUI wireframes and Software Requirement Specifications.
• Document step by step procedure for the development of resourcing tools for purposes.
• Ensured that project requirements are properly tracked and documented.
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
• Ensured completed activities meet project specifications, requirements and Confidential Standards.

Environment: UAT, GAD (Gap Analysis Document), Microsoft Office 2007, 2010 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2010, SQL, PL/SQL

Confidential, Washington, DC

Sr. Data Analyst

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Creating internal and external reports using stored procedures from the Reporting Data Warehouse.
• Utilizing Business Objects to create & implement data query templates to efficiently gather data.
• Led the development of a program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
• Expert in ICD 9 - 10 Conversion Analysis. Full knowledge of the Diagnosis and Procedural Code changes for Healthcare Entities like Payers, Employer Groups and Providers.
• Worked with the client and the database administration team to design database structure for different modules. Used pivot tables in Excel to replicate the reports that can be expected.
• Assisted in creating wireframes for web interface with the GUI design team.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Performed conversion on Excel files created on different versions of Excel.
• Designed High level design, for New process, integrating with legacy and Facets
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling (BPM).
• Performed GAP and Impact analysis for ICD - 10 changes and HIPAA EDI 5010 changes.
• Excellent in Developing and evaluating business process Models.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Extensively involved in data modeling.
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version and translation of ICD 9 codes into ICD 10 codes.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducting requirement sessions and successfully translating of those requirements into Use Cases and GUI wireframes.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• 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.
• Extensively used Excel and Access Macros and VBA with Excel Forms
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.

Environment: RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003, ERWIN, SQL, PL/SQL.

Confidential, Chicago, IL

Sr. Data Modeler / Analyst

Responsibilities:

• Gathered business requirements through several discussions and meetings with users and business analysts.
• Involved in preparing Conceptual Data Models and conducted controlled brain-storming sessions with project focus groups.
• Conducted team meetings and JAD sessions
• Identified the Objects and relationships between the objects to develop a logical model in ERWIN 7.2 tool and later translated the model into physical model using the Forward Engineering technique in ERWIN tool.
• Used Model Marts to understand different versions of data models existing in the system.
• Created logical data model from the conceptual model and it’s conversion into the physical data models.
• Extensively used Star and Snowflake Schema methodologies in building and designing the logical data model into Dimensional Models.
• Involved in dimensional modeling, identifying the Facts and Dimensions and different hierarchies.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions, Role-Playing and Multi-Valued Dimensions.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Performed data analysis and profiling using TOAD and SQL extensively
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Worked extensively on SQL querying using Joins, Alias, Functions, Triggers and Indexes.
• Managed all indexing, debugging, optimization and query optimization techniques for performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL code to implement business rules.
• Developed Logical data model using Erwin and created physical data models using forward engineering.
• Denormalized the database to put them into the star schema of the data warehouse.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Helped in creating Source-Target Mapping document.
• Worked with business analyst to design weekly reports using combination of Crystal Reports.
• Understood existing data model and documented suspected design affecting the performance of the system.
• Conducted logical data model walkthroughs and validation.

Environment: SQL Server, Erwin, Crystal Reports, Windows XP, TOAD.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
• Deliver platform related specifications such as security, performance, and capacity, Standard code sets such as ICD-9 (preparing for ICD-10), HIPAA EDI, CPT and DRG etc.
• Developed business process models in RUP to document existing and future business processes.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Responsible for designing and developing universes for development of reports using business object designer
• Documenting business and system needs via the creation of a variety of documents including Scope documents, Use Case Storyboards, GUI wireframes and Software Requirement Specifications.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Environment: SQL, PL/SQL, Windows 2000 Advanced Server, Liberty,UNIX / Oracle Platform, MS Visio, RUP, UAT, ERWIN, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential, Plano, TX

Data Modeler/ Data Analyst

Responsibilities:

• Participated in a numerous meetings with the business, DBA and business analysts to understand the scope and the requirements of the project.
• Participated in JAD sessions and other meetings to clarify the naming conventions followed with the Business Analysts.
• Reviewed the Business Requirement Documents (BRDs) and created a high level Bus Matrix.
• Performed Data Profiling to understand the operational data.
• Created a high level dimensional model and produced several attributes list based on the requirements.
• Participated in peer reviews and maintained an issue list.
• Used ER Studio to create the logical and physical models.
• Created and used Source-to-target document to record how the data is moved from source to target databases.
• Understood the need for the different fact tables and the dimension tables.
• Good experience with slowly changing dimensions and mini dimensions.
• Used several conformed dimensions across different star schemas or data marts.
• Accumulating snapshots
• Degenerate dimensions/Role-playing dimensions/junk dimensions
• Building reports using SSRS

Environment: ER Studio, SQL Server, Sharepoint, MS Access, MS Office, SSRS