SUMMARY:

• Over seven years of experience as a data analyst/SQL developer, with a strong focus in performing data analysis and data modeling including development and implementation of client - server applications and database systems using MSSQL 2012/2008.
• Proficient in extracting, transforming and loading data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by Informatica/SSIS.
• Involved in facets system implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and Extensions, Load and Extraction programs involving HIPPA and proprietary format files and reports development.
• Experience with Crystal Reports, Cognos and SSRS, query, reporting, analysis and enterprise information management.
• Worked with providers and Medicare and or Medicaid entities to validate the EDI transaction sets or internet portals.
• Experienced in building data integration and workflow solutions, and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Services.
• Ability to interact and coordinate with internal stakeholders in the projects, IT groups, business analysts groups, user acceptance groups, operations groups, third party vendors, change management groups and production support groups.
• Expert in creating and using Stored Procedures, Views and User Defined Functions.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical data modeling and data warehousing
• Strong knowledge of data warehouse methodologies, including Star Schema, Snowflake Schema, Fact and Dimension tables: worked with high volume databases with partitioned data.
• Hands on experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Created Jobs, SQL Mail Agent, Alerts and Schedule SSIS and DTS Packages.

TECHNICAL SKILLS:

Operating System: Windows NT/XP/2003/2007/Vista, Windows Server 2008R2/2012, UNIX

Language: T-SQL. PL/SQL, HTML

Data Warehouse Tools: Business Intelligence Development Studio, TOAD

Database: MS Access, MS SQL Server2008/2012, Oracle10g/11g

Tools: Utility Enterprise Manager, SQL Server Management Studio (SSMS), SSISInformatica, BizTalk Services, SharePoint

Reporting Tools: Excel, SQL Server Reporting Services 2012 (SSRS)

PROFESSIONAL EXPERIENCE:

Operation Data Analyst

Confidential, Baltimore, MD

Responsibilities:

• Performed analysis on enterprise data/report integration and provided functional specification to the development teams to build the Enterprise Reporting Systems.
• Designed the process working with both SOA services and SQL developers to ensure seamless conversion.
• Used various SSIS tasks such as conditional split, derived column before loading the data into the data warehouse.
• Built and maintained strong relationships with the business and external customers.
• Analyzed and researched the data quality issues and drove them to resolution with external partners and customers.
• Interacted with business and IT teams to identify long term solutions to data quality issues.
• Worked closely with the developers and the testers to ensure the requirements and functional designs were translated accurately into working technical designs and that the test plans scripts served the customer’s needs.
• Supported ongoing production maintenance, including production support and cross-team communication.
• Improved data quality by providing consistent codes and descriptions, flagging or fixed the bad data.
• Helped to restructure the data so that it delivered excellent query performance, even for complex analytic queries, without impacting the operational systems.
• Provided guidance and issue resolution on testing plans, provided timely and accurate data quality reconciliation reports to the customers.
• Worked with the front end and back end of financial systems. Mostly worked with virtual teams which included business analyst, QA’s and developers.
• Used SSIS as an ETL tool to load data from flat files/XML files databases into the SQL server.
• Use MIDAS (Multidimensional Insurance Data Analytics System) for the Affordable Care Act (ACA) which handled the data reporting and analytics.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) and supervised the development of user manuals for the customers.
• Actively involved in understanding the business requirements, collecting data, performing data analysis and data migration as per the business needs to maintain data warehouse/data mart.
• Validated and ran numerous SSIS packages and SQL scripts according to the operation’s ICD.
• Worked on querying data and created on-demand reports using excel, report builders in SSRS reports and sent the reports via email.
• Extracted, generated and troubleshoot 820s DHS (remit advices) files which are out of balance and once they passed validations they were sent to the bank for distribution to the issuers.
• Dealt with different kinds of errors (including Store Procedure, Index and Triggers) when processing enrollments or cash (EFTs and checks) and fixed them accordingly.
• Used BizTalk services for the payment processing which included EFTs and checks, business-to business interactions, real-time decision making and reporting.
• Generated everyday report (Recon report, pre-cancellation reports, monthly invoices, delinquency notices) and sent to the intended departments/destinations.

Environment: RUP, UAT, GAD (Gap Analysis Document), Cognos, SQL Server 2012, Windows Management Console, Remedy, Microsoft Office 2007 (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint and TFS.

Data Analyst

Confidential, Detroit, MI

Responsibilities:

• Played a key role in the System Development Life Cycle process consisting of design and gap analysis, business requirements, systems requirements, test criteria and implementation to have the outputs of projects that dealt with the automation of correspondence directed to the insurance policy owners.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Responsible for interacting with the business analysts and the business partners to identify information needs for the business requirements for DAR.
• Involved in Facets System implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and extensions, Load and Extraction programs involving HIPPA 835 and proprietary format files and reports development.
• Worked with the ETL specialists to migrate data into DWH & involved in data modeling.
• Responsible for checking member eligibility, provider enrollment and member enrollment for the Medicaid and Medicare claims.
• Defined functional test cases, documented and executed test scripts in the Facets system.
• Performed data mapping for the application, confirmed and vacillated the requirements at time of testing.
• Worked on HIPAA transactions and code sets standards according to the test scenarios such as 837 health care claim transactions.
• Performed complex ad hoc SQL queries from BAs in both SSMS and Teradata SQL Assistant.
• Worked with providers and Medicare or Medicaid entities to validate the EDI transaction sets or internet portals. This includes HIPAA 837, 835, 270/271, and others.
• Researched the existing client processes and guided the teams in aligning with the HIPAA rules and regulations for the systems for all the EDI transaction sets.
• Gathered requirements and modeled the data warehouse and the underlying transactional database & performed Gap analysis of the processes to identify and validate the requirements.
• Identified/documented data sources and transformation rules required populating and maintaining the data warehouse content.
• 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.
• Use cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: SQL 2012 , RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2007 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003 and HTML.

Data Analyst

Confidential, Washington, DC

Responsibilities:

• Performed extensive testing in Facets subscriber/member, tested groups, eligibility and enrollment and validated outbound 834 Extracts to the different vendors.
• Responsible for architecting integrated HIPAA, Medicare solutions and Facets.
• Worked with the clients to better understand their needs and present solutions using a structured SDLC approach.
• Developed schemas for extraction, transaction, and loading (ETL) to expedite data integration between systems.
• Responsible for creating use case specifications for Service-Oriented Architecture / SOA services.
• Ensured data consistency by cross-checking sampled data upon migration between the database environments.
• Worked on the electronic Medicaid eligibility verification system and the Medicaid and Medicare intermediary along with their roles in claim processing.
• Experience in data governance/data stewardship business/systems analyst needed to work as part of a team on data governance and wrote SQL queries.
• Improved the performance of the SSIS packages by implementing parallel execution, removing unnecessary queries and sorting to use optimized queries.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand the repository objects that supported the business requirements and processes.
• Analyzed data and created Class Diagrams and ER Diagrams for designing databases.
• Performed felid-by-field mapping of interface between parent EMR system and downstream system
• Planned and defined Use Cases created Use Case Diagrams, scenarios and use case narratives using the UML methodologies.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing the Medicaid claims.
• Configured the loading of data into slowly changing dimensions using slowly changing dimension wizard.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing excel data sources.
• Used ETL transformations to copy columns and load data from data sources to the destination databases.
• Worked on technical knowledge specific to Cognos tools and the existing data models to other team members.
• Data mapping, logical data modeling, created Class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Experience in using SSRS and Cognos in creating and managing reports for an organization.

Environment: SQL 2008 , J2EE, Windows, UNIX/Oracle Platform, MS Visio, RUP, UAT, Rational Rose, Rational Requisite Pro

Data Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Involved as a developer for the commercial business group data warehouse.
• Development of source data profiling and analysis, reviewed the data content and metadata would facilitate data mapping and validate assumptions that were made in the business requirements.
• Created logical and physical designs of the database and ER Diagrams for Relational and Dimensional databases using Erwin.
• Extracted data from relational databases Oracle and flat files.
• Developed complex transformations, Mapplets using Informatica Power Center 8.6.1 to Extract, Transform and load data into Operational Data Store (ODS).
• Lead, created and launched new automated testing tools and accelerators for SOA services and data driven automation built within our practice.
• Designed complex mappings using Source Qualifier, Joiners, Lookups (Connected and Unconnected) and Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored procedure and Normalizer transformations.
• Ensured the data consistency by cross-checking sampled data upon migration between the database environments.
• Developed a process to extract the source data and load it into the flat files after cleansing, transforms and integrating.
• Designed SSIS packages to Extract, Transfer and load the (ETL) existing data into SQL server from different environments for the SSAS cubes.
• Extensively worked on developing and deploying applications using, SQL server 2005/2000, Microsoft office, VBA and macros.
• Worked as an architecture and modeling teams and used Middleware SOA services.
• Performed data alignment and data cleansing and debugger to test the mapping and fixed the bugs.
• Created Sessions, Sequential and Concurrent sessions for proper execution of mappings in workflow manager.
• Provided SSRS and SSIS support for internal IT projects requiring report developments.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT)

Environment: Informatica 8.6.1, Oracle, SQL Server 2005, RDBMS, Fast load, FTP, SFTP