SUMMARY:

• Four 7 years of Business and Data Analysis in various domains.
• Extensive IT experience with in - depth understanding of Business Re-engineering, System Architecture, Application Design, Information Security, Data Warehousing, Business Intelligence and Project Management.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mappings for operational Data Stores, Enterprise Data Warehouse, Data Marts, other databases.
• Expertise in conceptual, logical and physical designing and development of Data Models, Data Normalization, OLTP and OLAP Database and Data Warehouse.
• Expertise in SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints.
• Expert in ETL tools like Import/Export wizard and SSIS for transferring Data from different sources to a centralized Database, staging area or repository.
• • Hands on experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions. Developed custom dashboards/reports using Qlikview.
• • Extensively worked on Tableau Administrator and Tableau Server. And effectively used data blending feature in tableau.
• Hands on experience in Implementation of Enterprise Business Intelligence solutions using BI tools such as Tableau, POWER BI, SSRS and Crystal Reports.
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data.
• Experience with Data analysis and SQL querying with database integrations and data warehousing for large financial organizations.
• Experience in business/data analytics using advance EXCEL (VBA, V-LOOKUP, Macro, Pivot Table, Power Pivot, POWER BI, slice & dice executive DASHBOARD) and TABLEAU.
• Experience using SQL for data manipulation using MS SQL Server, Oracle SQL Developer and PostgreSQL
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Strong knowledge of SQL, stored procedures, data analysis and data validation using SQL.
• Strong background in Data Warehousing systems proficient on designing and implementing SQL queries for reporting / data validation using Oracle, SQL Server and DB2.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Experienced in Stakeholders engagement at all levels for requirement gathering, issues management, change management, scope management, risk management and other project constraints
• Extensive experience in creating and maintaining source to target data mapping documents.
• Documented Traceability Matrices based on defined business rules in Microsoft Excel.
• Strong documentation and analytical skills, strong problem-solving skills.
• Experience in both AGILE SCRUM and traditional WATERFALL environment
• Comprehensive knowledge and experience in all aspects of SDLC, which includes Requirements Gathering, Analysis, Design, Development, Testing and Implementation.
• Facilitated weekly and monthly business review meetings to keep SME's, Stakeholders, product managers, executive staff and team members apprised of goals, project status, resolving issues and conflicts and preparing product demonstrations.
• Solid business communication, and presentation skills, written correspondence, web-based products, reports, (project status reports, PowerPoint presentations, e-mails).
• Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision.
• Competent, confident and strategic decision maker organized with effective Time Management and Prioritizing skills in conflicting demands to execute business objectives

TECHNICAL SKILLS:

Data analysis,SQL, Excel, Servers, Data mapping, Data modelling, Data cleansing, Data profiling, SQL, R, SAS, Mathematical, Analytical Skills., Informatica, Power center, MDM, teradata, ETL, BI, Data warehouse, Data mart, OLAP, OLTP, JIRA, Tableau,FileMaker Pro developer, Microsoft Office (Excel, Word, Access developer, Powerpoint), Adobe Acrobat, SQL, data analysis, data mining, trouble-shooting, computer training, desktop publishing

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential, Windcrest, TX

Responsibilities:

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems.
• Participated in brain storming sessions with application developers and DBAs to discuss about various de-normalization, Partitioning and Indexing Schemes for Physical Model.
• Created the Conceptual Model for the Data Warehouse using ERwin Data Modeling tool.
• Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Designed the physical data models using data provisioning and consumption techniques in Oracle environment.
• Utilized ERwin's forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Analysed the existing logical model of the ODS to understand the relationships between different entities.
• Worked on Requirements Traceability Matrix to trace the business requirements back to Logical Model.
• Reviewed the Logical Model with Application Developers, ETL Team, DBAs and Testing Team to provide information about the Data Model and business requirements.
• Normalized the tables/relationships to arrive at effective Relational Schemas without any redundancies.
• Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.
• Created Multi-Way Aggregate Fact Tables as a specific summarization across dimensions of product, region and date.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created Snowflake Schemas by normalizing the dimension tables as appropriate, and creating a Sub Dimension named Demographic as a subset to the Customer Dimension.
• Created refined data models pertaining to reassessed business requirements conforming to applicable data standards and successfully documenting the existing system model and changes proposed/applied to the model.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Extensively used Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Applied Data Governance rules (primary qualifier, class words and valid abbreviation in Table name and Column names).
• Involved in capturing Data Lineage, Table and Column Data Definitions, Valid Values and others necessary information in the data models.
• Worked on Forward Engineering to enhance the Data Structures of the Existing Database and Creating New Schemas.

Environment: ERwin r9.0/8, Oracle 10g/11g, Windows XP, SQL Server 20012, SSRS, Microsoft Excel.

Techno functional Data Analyst

Confidential, Atlanta, GA

Technical Scope: Tableau, SSRS, Crystal Reports, Teradata, SQL, Oracle, Shell Scripting, TFS

• Senior IT Data Analyst, Developer and Consultant responsible for the migration efforts of the United States claims data from the new DCT Application processing system to our compiled IDP (Integration Data Processing) SQL Server and all modifications and normalization processes required for the FIP (Future Integrated Process) reporting solution
• Perform gap analysis and thorough data mining processes to identify missing metrics within the DCT Application and data that has funneled through our DCT server that is required for the integration and normalization process necessary to align the new DCT Data with the current CWS, Claim Work Station, International claims data
• Utilize Alteryx to integrate and compile data extracted from multiple server platforms and applications to then develop workflows and data models for CWS and DCT
• Workflows and data models are used to track data integration process and status
• Identify required metrics that are missing at any point in the data flow
• Validate and perform root cause analysis
• Develop custom SQL queries to extract, validate and publish tables, views and stored procedures that are utilized for ad hoc data extractions and report development
• Develop server based reporting solutions utilizing Microsoft Power BI, Microsoft Excel, Tableau and SSRS
• Responsible for establishing and maintaining an agile work environment for the Alpharetta BI Team
• Host weekly scrum meetings to discuss current projects, sprints, priorities amongst the team and more
• Establish business logic and develop custom complex SQL queries required for ad hoc reporting objectives
• Developed a DCT validation tool via SSRS, available to all end users via SharePoint Front End User System
• Liaison between the line of business, the development team and the software development team
• Responsible for the documentation, tracking and progress status updates for all DCT and FIP project objectives
• Conduct UAT and Regression Testing for new data metrics prior to deployment to our production environments
• Currently assisting the data scientist team in the SQL Development, extraction, regression testing, design and modeling of a new integrated data mart to be utilized for predictive analytics and market research

Business Analyst

Confidential, Tysons Corner, VA

• Act as a liaison between client and technical solutions/ support groups, using strong communication skills to elicit, document, analyze and validate business processes, systems, and solution requirements.
• Research, identify, and specify solutions to problems.
• Support and conduct visualization, user experience and configuration elements of solution design.
• Document requirements specifications using high-maturity methods, processes and tools.
• Support requirements management and change management processes.
• Support aspects of the business cycle, including proposals, feasibility studies, and implementations.
• Consider the business implications of the application of technology to the current business environment.
• Support change management and aspects of the business cycle by functioning as a liaison between the client and technical solutions groups.
• Participate in the elicitation, documentation, analysis and validation of business processes, systems, and solutions.
• Document requirements specifications using requirements traceability matrixes; and writing SQL scripts as needed.
• Support aspects of the business cycle, including feasibility (impact) studies and implementations.