SUMMARY

• More than 7 years of experience in the field of data analysis, business analysis, software requirement gathering and analysis, Business process flow analysis, documentation
• Experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as SSIS and Informatica.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Proficient experience as a Data Analyst in gathering data from various sources, data profiling, data definition, and loaded the data to business warehouse.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Expertise in creating Unified Modeling Language (UML) diagrams including Use Case diagrams, Class diagrams, Sequence diagrams and Activity diagrams.
• Proficient in development of effective dashboards and reports in Power BI, Tableau using visualizations by using actions, local and global filters as per the end user requirement.
• Experience in conceptual design, logical design, & physical design of data models, Star Schema/Snowflake modeling, FACTs & Dimensions tables using Erwin and ER Studio.
• Experience in designing and developing efficient Error handling methods for ETL mappings and workflows.
• Experience in data migration, data manipulation, data cleansing and generating customized reports with SAS data steps and procedures on various environments.
• Strong knowledge of database management writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• In depth understanding of AS-IS and TO-BE business processes and experience in converting these requirements into Functional Specifications.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Oracle SQL

RDBMS: Oracle, SQL Server, Teradata, Sybase, DB2

Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management StudioETL Tools Informatica Power Center, Erwin, SSIS, Toad, Crystal Reports

BI Tools: Business Objects, Cognos, MicroStrategy, SSRS, Tableau, Power BI

Environment: Windows, IBM Mainframes, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Participated in regular meetings with Product Management, Development Teams, & Clients to facilitate understanding, clarification, and implementation of product execution projects.
• Responsible for developing specifications for user interfaces, workflows, and resolving any conflicts with requirements between business and technology.
• Created new Star Schema to run cubes with OLAP system for management analysis.
• Defined key facts and dimensions to support business requirements along with Data Modeler.
• Created draft data models for understanding and to help Data Modeler.
• Created Dataflow Diagrams to indicate flow of data from various source to the target system and the connection from which source we can get the required information in future as well.
• Collaborated with Enterprise Data Governance to analyze and consolidated enterprise critical data elements and definitions across various business lines.
• Published various kinds of interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Develop insightful dashboards that Management used for well-informed business decisions.
• Connected Tableau to various databases to establish live connections. Created schedules for incremental refreshes for data sources on Tableau server.
• Developed a thorough understanding of AS-IS and TO-BE data work processes, user needs and client needs for segments of the business impacted by assigned projects.
• Developed SQL database for daily routing, analyzed routing efficiency, presented results to the executives in MS PowerPoint.
• Used SQL queries for data-analysis and data extraction from database landscape and comprehend the data to perform sensitivity analysis.
• Performed Data profiling to examine the pattern of data coming from existing source systems for collecting the statistics and information about the data.
• Created and manipulated various management reports in MS Excel for sales metrics using VLOOKUP and Pivot tables.
• Coordinated planned upgrades, enhancements and maintenance outage windows including monitoring for potential system upgrades, service packs and fix packs.

Confidential

Data Analyst

Responsibilities:

• Involved in data gathering, data analysis framework involving data cleaning, processing, analysis, and visualization.
• Monitored & analyzed ETL jobs to pull data from source system to staging, then warehouse.
• Moved product hierarchy design and SQL Views to various environments and supporting implementation and postproduction activities.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Worked on developing complex reports using custom SQL scripts to extract and present data.
• Created the OLAP cubes (Online and Offline) utilizing SSAS and MDX to create calculated members and KPI’s.
• Collaborated with Enterprise Data Governance to analyze and consolidate enterprise critical data elements and definitions across various business lines.
• Developed a thorough understanding of AS-IS and TO-BE data work processes, user needs and client needs for segments of the business impacted by assigned projects.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables
• Developed and maintained reports using relational databases as data sources for internal and external client reporting
• Prepared high level and detailed system requirements documents for the application and prepared system requirement documentation.
• Used advanced MS Excel to create pivot tables, used VLOOKUP, and other Excel functions
• Wrote complex SQL queries using joins, aggregate functions, inline and nested subqueries to automate tasks.
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into base tables.
• Designed executive reports using in-house tool, generating on-demand, and scheduled reports for business analysis or management decision using SSRS.
• Develop and execute Unit Test cases, scripts and plans in Quality Center. Facilitate testing activities within the development and testing teams.
• Tested applications and documented results and bugs including documentation of information useful in the debugging process.

Confidential

Junior Data Analyst

Responsibilities:

• Executed acceptance tests and document results while assisting the entire organization throughout the SDLC.
• Studied in-house requirements for the Data warehouse to be developed.
• Analyzed, retrieved and aggregated data from multiple centers to perform data mapping, in order to precisely append either incorrectly mapped
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Documented and delivered Functional Specification Document to the project team.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Data for modeling was collected using SQL by querying several tables. The extracted tables were further appended or merged to create tables for modeling.
• Modeled data structure for analytical team to maintain their data for future analysis to overcome and avoid cheating in real time authentication.
• Involved in the process of loading data into SQL Server and creating Process Flow Diagrams using MS Visio.
• Analyzed the performance of the job during the project. Utilized standard techniques for enhancing the performance.
• Authored User documents on all the deliverables created for future by Business Users and conducted sessions.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint Business Intelligence platform.