OBJECTIVE

• An IT professional with over five (5) years' experience in various domains such as Finance, Insurance, Retail and Healthcare. An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources.
• Proven ability to learn, utilize in - house databases and systems to maintain strategic vision of the organization and link it with everyday work.
• Able to perform multiple duties in business analysis, project or program management and functional leadership.
• A wonderful team player who can relate and work efficiently with diverse groups.

SUMMARY

• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Experience with DATA MINING.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow Flake Schedma, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4.x.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Hands on experience in SAS programming for extracting data fromFlat files,Excel spreadsheets and externalRDBMS (ORACLE) tablesusingLIBNAME and SQL PASSTHRU facility.
• Experience in working with SASENTERPRISE GUIDE SOFTWAREfor reporting and analytical tasks.
• Strong ability to write SQL queries usingPROC SQL.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Good knowledge of portfolio analysis, management and customer segmentation.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS

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

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

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

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

Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL DeveloperQuerying language: SQL, TSQL

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

Programming language: SAS

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential, Owings Mills, MD

Responsibilities:

• Analyze architecture and data for needed updates and patches
• Work with business intelligence/reporting systems such as Tableau Business Objects Microsoft Excel SharePoint and other Office products
• Developing report/models for data using scripting languages such as SQL
• Performs routine data analysis/programming activities according to project specifications
• Performed required data analysis, interpretation, correction and document presentation for various assignments.
• Created quarterly reports for investment accounts and stakeholders
• Performed profit and loss analysis for on financial investments datasets
• Document and maintain data process procedures to serve as ; adhere to established controls to ensure data quality.
• Prepared project progress reports and status reports and submitted to the management team on an ongoing basis.
• Provided BI Analysis for the marketing team to review impact on key metrics in relation to program

Senior BI Data Analyst

Confidential, Ellicott City, MD

Responsibilities:

• Created SQL scripts during Extract, Transform and Loading processes and aggregated various data sources across the Bank used in analysis and modeling.
• Support presentation and visualization of data through standard tools (e.g. Tableau)
• Create Technical / design specification based on business requirements in clear and concise formats
• Design and use of Tableau Analysis/Reporting tool
• Proven ability to manage and analyze large data sets, with careful attention to detail.
• Strong interpersonal skills, with an equally strong desire to learn advanced computer skills and strong knowledge of pertinent word processing, spreadsheet and database software.
• Experience using SQL, SAS or related language.
• Designing automated processes to move, format, standardize and scrub large amounts of data.
• Building databases for data standardization, data archiving and reporting.
• Creating, maintaining and managing SQL Server Integration (SSIS) packages.

Senior Data Analyst

Confidential, Bloomfield, CT

Responsibilities:

• Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
• Wrote queries to fetch data from different table by using JOINS, Sub-queries, Correlated subqueries
• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases
• Utilize SSIS for ETL data migration of EDI 837 and 835 files from various Sources to MSSQL database
• Responsible for error handling, stored procedure, creating tables, views, triggers etc.
• Prepare high level analysis reports with Excel
• Provides feedback on the quality of data including identification of billing patterns and outliers
• Analyze and Assess invalid and missing data in the Claims Data
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
• Documenting the extent to which data fails to meet threshold reporting requirements