SUMMARY:

• More than 7 years of experience in teh 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 teh data to business warehouse.
• Actively participated and conducted in JAD sessions wif business users, technical leads and wif development personnel in all aspects of teh 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 teh 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 wif SAS data steps and procedures on various environments.
• Strong noledge 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 Studio

ETL 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

Data Analyst

Confidential, WI

Responsibilities:

• Participated in regular meetings wif 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 wif requirements between business and technology.
• Created new Star Schema to run cubes wif OLAP system for management analysis.
• Defined key facts and dimensions to support business requirements along wif Data Modeler.
• Created draft data models for understanding and to halp Data Modeler.
• Created Dataflow Diagrams to indicate flow of data from various source to teh target system and teh connection from which source we can get teh required information in future as well.
• Collaborated wif 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 teh business impacted by assigned projects.
• Developed SQL database for daily routing, analyzed routing efficiency, presented results to teh executives in MS PowerPoint.
• Used SQL queries for data-analysis and data extraction from database landscape and comprehend teh data to perform sensitivity analysis.
• Performed Data profiling to examine teh pattern of data coming from existing source systems for collecting teh statistics and information about teh 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, tan 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 teh OLAP cubes (Online and Offline) utilizing SSAS and MDX to create calculated members and KPI’s.
• Collaborated wif 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 teh business impacted by assigned projects.
• Worked on Data mapping, logical data modeling used SQL queries to filter data wifin teh 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 teh 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 teh 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 wifin teh development and testing teams.
• Tested applications and documented results and bugs including documentation of information useful in teh debugging process.

Confidential

Junior Data Analyst

Responsibilities:

• Executed acceptance tests and document results while assisting teh entire organization throughout teh SDLC.
• Studied in-house requirements for teh 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 wif business users to gather data warehouse requirements.
• Analyzed database requirements in detail wif teh 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 teh project team.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin.
• Used forward engineering to create a Physical Data Model wif DDL that best suits teh requirements from teh Logical Data Model.
• Data for modeling was collected using SQL by querying several tables. Teh 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 autantication.
• Involved in teh process of loading data into SQL Server and creating Process Flow Diagrams using MS Visio.
• Analyzed teh performance of teh job during teh project. Utilized standard techniques for enhancing teh performance.
• Authored User reference documents on all teh deliverables created for future reference by Business Users and conducted training sessions.
• Resolved teh data type inconsistencies between teh source systems and teh target system using teh Mapping Documents and analyzing teh 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 teh client requirement.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint Business Intelligence platform.