SUMMARY:

• Detailed - oriented professional with 13+ years of IT experience in the Healthcare, Financial, Government and Banking domain.
• Very passionate about projects and savvy with business requirements; translate them into clear and concise specifications; as well as extract and manipulate data from RDBMS in order to make cutting-edge and prudent decisions to improve the outlook of the organization.
• Always ready to unleash the skills and knowledge acquired over the years for the development and progress of the organization.

TECHNICAL SKILLS:

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases: MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, HL7 standards & interface

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, Cognos, Excel and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Data Modeler

Responsibilities:

• Pulling data from Facets and Nasco claims systems to create operational reports for applications
• Creating ad hoc queries, stored procedures, and programming scripts with SQL
• Utilizing SSIS for ETL data modeling, data migration, integration, and analysis
• Prepare high level analysis reports with SSRS, Cognos and Excel
• Prepare visual reports for high level consumption using Tableau
• Created and populated patient data using advanced SQL and PL/SQL queries and scripts and also performed Teradata SQL performance tuning
• Creating Business Objects and SSRS reports for monthly inventory analysis
• Supporting logical data designs/models by reviewing with Business stewards
• Using HL7 to define seamless integration of data and set data types between systems
• Working with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes
• Identifying data and solution patterns as well as taxonomies
• Creating source to target mapping at the element level including specifications for data integrity, referential integrity in support of the Actuarial Finance Systems

Data Analyst

Responsibilities:

• Creating SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases
• Utilize SSIS for ETL data modeling, data migration, and analysis
• Prepare high level analysis reports with Excel
• Provide detailed data analysis in SAS to aggregate and compare the currency fields
• Provides feedback on the quality of data including identification of billing patterns and outliers
• Analyze and Assess invalid and missing data in the All Payer Claims Data
• Import Data from SQL Server into SAS files per detailed specifications
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
• Carrying out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT as per business requirements
• Documenting the extent to which data fails to meet threshold reporting requirements

Confidential, Knoxville, TN.

Data Analyst

Responsibilities:

• Responsible for extracting data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
• Supporting data profiling activities
• Created and populated patient data using advanced SQL and PL/SQL queries and scripts and also performed Teradata SQL performance tuning
• Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010
• Created transformation and mapping by using Informatica Design
• Maintained data consistency, Oracle database integrity and reported instances of data corruption.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
• Performed numerous data extraction requests involving SQL scripts and UNIX
• Performed data migration between different environments and Third Party Databases
• Performed drill down analysis reports using SQL Server Reporting Services
• Created data dictionary for the clinical aberrancy rules
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities

Business/Data Analyst

Responsibilities:

• Provided data architecture and modeling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines.
• Perform data mapping for the process
• Inserted checkpoints in Oracle database to check the functionality and data integrity of the AUT.
• Performed ETL data loads from flat files, DB2, Teradata, PL/SQL etc. to transform data into complex scripts and codes for software application testing
• Enhanced the PL/SQL test scripts for data driven tests
• Developed and executed automated test case scripts Test for the Front-end applications
• Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements

Data Analyst

Responsibilities:

• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Developed several operational reports using SSRS.
• Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
• Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse
• Created numerous Permanent tables, Volatile tables and Global Temporary tables
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
• Ensured that data warehousing design was scalable and maintainable

Confidential

Business System Analyst

Responsibilities:

• Performed Teradata SQL performance tuning and created multi-set tables within the database
• Performed analysis and reporting using SAS
• Conducted Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data
• Developed analytical reports to include sales best practices, customer segmentation and market product pricing
• Conducted query performance tuning in order to locate issues with resource intensive queries
• Developed the competency to create various Ad hoc financial reports
• Retrieved all customers’ account(s) information and used SQL commands such as join to link and group all the accounts under a particular customer’s information
• Detection of defunct customer customer’s account information and the use of appropriate SQL queries to truncate and update the customers’ database
• Prepared Business Requirement Documents (BRDs) and used Rational RequisitePro to manage, analyze, and convert business requirements into functional specifications