SUMMARY

• Dynamic technology professional with more than six (6) years of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing.
• Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management.
• Keen researcher with robust resolution pedigree; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Excellent knowledge and usage of reporting and visualization tools such as Tableau, PowerBI
• Experience in data scrubbing and cleansing.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Self - motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Strong ability to write SQL queries usingPROC SQL.
• Excellent knowledge and usage of reporting tools such as Tableau and SAS.
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4. x.
• Exceptional organizational and time management skills and the ability to work independently.

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, ER Assistant

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

Querying language: SQL, PL/SQL, TSQL

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

Programming language: SAS, SQL

PROFESSIONAL EXPERIENCE

Confidential, DENVER, CO

Data Analyst/Tableau Developer

Responsibilities:

• Supports the company’shealthcare software functions, implementation and training.
• Makes business recommendations based ondata collected to improve business efficiency.
• Collectsdata from all clients and made recommendations for improvement.
• Ad-hocdata extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.
• Supports business lead for special assignment and to ensure staffing efficiency.
• Dataanalysis, reporting using Tableau and SAS.
• Creates rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Connects to Tableau server to publish dashboard to a central location for portal integration.
• Generate KPI’s for customer satisfaction survey results.

Confidential, DENVER, CO

Senior Data Analyst/ Tableau Developer

Responsibilities:

• Worked with end users, business and IT users to understand, elicit and analyze reporting requirements.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Performed Tableau type conversion functions when connected to relational and SAP BW data sources.
• Created incremental refreshes for data sources on Tableau server.
• Prepare high level analysis reports with SSRS, PowerBI and Excel

Confidential, Denver, CO

Senior BI / Data Analyst

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Performed numerous data extraction requests involving SQL scripts.
• Involved in analyzing the source data coming from different Data Sources
• Performed in depth analysis of data & prepared weekly, biweekly, monthly reports using MS Excel and SQL.
• Extensively used SAS functions such as Proc Report, Proc Tabulate, Proc Summary, Proc Print and Data Null Reports.
• Performed Data Analysis, created GAP Analysis Document, and performed Data Quality Checking.
• Compiles detailed reports using data tools such as but not limited to: SQL and SSIS
• Supports business organizational teams by creating flow charts, process and prioritize goals and develop KPI’s and other management reporting
• Create an action plan for future automated statistics available by dashboard