Snr. Data Analyst Resume Hartford, CT - Hire IT People

SUMMARY

Detailed - oriented IT professional with over 6 years of experience in the Healthcare, Finance and Banking domains.
Extensive experience in Data Analysis, Data Extraction, Data Manipulation, research and reporting in different Visualization formats from various sources.
Able to perform multiple duties in business analysis, project or program management, and functional leadership.
A team player who can relate and work efficiently with diverse groups.
Proven ability to learn, utilize in-house databases and systems to maintain strategic vision 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 , Confidential 12/13, MySQL 5.2, 5.7, Confidential 9i, 10g, 11g, DB2

ETL/Other Tools: SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

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

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

Querying language: SQL, PL/SQL, TSQL

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

PROFESSIONAL EXPERIENCE

Confidential

Snr. Data Analyst

Responsibilities:

Writes complex SQL queries using advanced SQL concepts like Aggregate functions.
Performs ad-hoc reporting analysis; manipulates complex data on MS SQL server.
Writes complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries; utilizes concepts like Explain, Stats, Cast and volatile tables on SQL server.
Analyzes data for errors or duplicates; provides resolution for interdepartmental monthly reports.
Uses SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data.
Utilizes IMPORT and EXPORT features in MS SQL to load data onto the data warehouse.
Creates numerous Permanent tables, Volatile tables and Global Temporary tables.
Writes standard SQL Queries to perform data validation and creates excel summary reports (Pivot tables and Charts).
Ensures that data warehousing design is scalable and maintainable.

Confidential, Hartford, CT

Snr. Reporting Data Analyst

Responsibilities:

Prepared reports working with database structures and data modeling including working knowledge of SQL.
Handled Strong healthcare material including experience with transaction standards e.g. HIPAA.
Conducted self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospital, and rehabilitation facilities.
Gathered Information, analyzed reports and presented reports.
Analyzed Center for Medicare and Medicaid Services and health care provider data and online data submission process.
Used state-of-the-art decision support and neutral network tools to detect potential fraud and support investigations.
Organized case files, researched violations, and thoroughly documented all steps taken in project development.
Provided data analysis report in support of fraud investigation.
Created SQL stored procedures using SQL Queries.

Confidential

Snr. Data Analyst / Tableau Developer

Responsibilities:

Responsible for error handling, stored procedure, creating tables, views, triggers etc.
Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
Used DTS to migrate the tables to the Data Warehouse.
Handled Different DSS (Decision Support System) for various applications.
Configured Data mapping between Confidential and SQL Server.
Used Query Analyzer, Execution Plan to optimize SQL Queries.
Used SQL High for level proficiency in database manipulation.
Created SQL scripts for demonstrating prototypes and for verifying the result sets.
Created User Interface Specifications and wire frames.
Used advanced SQL concepts like OLAP, Group By and aggregate functions.
Used complex SQL queries in advance to fetch data from other tools.
Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Confidential platform.
Worked with ETL Process which includes SSAS, SSIS, and SSRS. Worked with Business Intelligent tool like Tableau and Power BI on SQL server mainframe.
Developed stored procedures, views, triggers, executed test cases and defect management for ETL and BI systems.