OBJECTIVE:

To deliver quality solutions to complex business problems using new technologies within a high - tech environment.

SUMMARY:

• More than 4 years of experience in end-to-end Business Intelligence solutions.
• Recognized as the best analyst for my work in data analysis.
• Handled Data for Data Analysis from various industries Retail, Telecom, Healthcare and Finance.
• Excellent programming skills in SAS and SQL.
• Extensively worked on sales and marketing data.
• Good Understanding of Data warehouse and Data Mining, OLAP and OLTP concepts.
• Proficient in design and development of various dashboards/ reports for Data Visualizations using Tableau.
• Experience in writing PL/SQL Data Extraction, Transformation and Loading (ETL) in various Database applications.
• Hands on experience in all phases of Data Modelling - Conceptual, Logical and Physical modeling.
• Experienced with business requirements analysis, entity relationship planning, database design, reporting structures.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Create statistical models using SAS Base for business requirements.
• Experienced on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.

TECHNICAL SKILLS:

BI Tools: SAS, Tableau

Data Modelling tools: CA ERWIN, PowerDesigner, Oracle Toad Data Modeler

Database: IBM DB2, Oracle(9i/10g/11g), Microsoft SQL Server (2008, 2012), Teradata, HP Vertica

Operating System: Windows XP, Windows 7, Unix

Software s: SAS Enterprise Guide, Toad, SQL Server Management Studio, Agile

Other Skills: MS Office, ETL - Informatica, Talend, MS Visio, AWS

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Sr. Data Analyst\Data Modeler

Responsibilities:

• Develop Data Models - Logical and Physical Data Models using CA ERWIN.
• Create and Update source to target mapping documents required for ETL migration.
• Perform Data analysis and Data Mining for various business requirements.
• Perform Ad-hoc analysis on various databases and SAS datasets.
• Perform regular data profiling and data quality checks.
• Build risk models and forecast the future trends for the business.
• Create, modify and truncate various tables and write complex SQL.
• Support all phases of application building (DEV\QA\UAT\PROD).
• Generate DDLs for project\client requirements.
• Support Tableau teams with dashboard and report generations.
• Perform Data validation to ensure smooth transition of data over different environments.
• Create business documents and ETL flows for Development and testing teams.
• Create and maintain SAS datasets required for the SAS programs.
• Update and move data files to be used as source for the SAS programs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins.
• Worked with the project management team within Agile methodology to ensure the quality and schedule of the application releases are met the requirements.
• Conduct proof of concept for code migration from SAS to Talend.

Confidential, Chicago, IL

Data Analyst\Data Modeler

Responsibilities:

• Develop Data Models - Logical and Physical Data Models using PowerDesigner.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Experienced in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
• Performed data analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Created SAS datasets by extracting data from Excel, Flat Files.
• Identified and recorded defects with required information for issue to be reproduced by development team.
• Created the ETL data mapping documents between source systems and the target for data warehouse.

Confidential, Jacksonville, FL

Data Analyst\Data Modeler

Responsibilities:

• Develop Data Models - Logical and Physical Data Models using CA ERWIN.
• Developed SQL ETL scripts to load the mapped data from source to Common Staging target. Data coming from different sources were de-normalized into a common format and loaded back to Teradata.
• Creating, modify and delete various tables and write SQL queries for Teradata database.
• Created sas proc sql code to transform the original datasets to target database for complex requirements using ETL process.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using sas tools - sas/base, sas/macros and sas/graph, sas/sql, sas/connect, sas/access.
• Understand the business requirement and develop the ETL flows using MS Excel.
• Perform regular data quality and data profiling.
• Query optimization and performance tuning.
• Develop Data Visualizations reports and dashboards using Tableau.
• Attend daily scrum meeting and follow agile software development methodology.
• Attend JAD sessions and User Acceptance Testing sessions with business.
• Create and gather business documents and matrix documentation as per the requirements.

Confidential, Detroit, MI

Student Assistant

Responsibilities:

• Managing general office work and providing assistance.
• Set up audio and video for the events.
• Scheduling and organizing the events.

Confidential

Data Analyst

Responsibilities:

• Generate various weekly, monthly and Ad-Hoc reports using SAS Enterprise Guide and SAS Base.
• Enhancing various existing reports with new analysis techniques and generating new reports as required.
• Review the existing Teradata SQL code and make new changes upon business needs.
• Created and maintained SAS datasets that are extracted from an Oracle Database.
• Accessed External Excel files, Stored and Retrieved SAS data sets moving data through multi platforms.
• Presenting analyses results and insights to different departments as needed.
• Developed PL/SQL queries for data migration and analysis from Microsoft Excel/Access to Oracle.
• Extracted sales data from the database using sas/proc, sas/sql procedures and created datasets.
• Developed programs and datasets in SAS that can be used for data analysis and presentation.
• Organized and analyzed data to prepare and present report to senior business management and involved in data transformation and cleansing operations.
• Build statistical models by using data from different databases like IBM DB2, Teradata and SQL Server to predict the future market trends.
• Retrieved the data and produced reports from the databases using ad-hoc queries.
• Provided statistical programming expertise in the production of analyses, tabulations, graphs and listings obtained from the excel data.