SUMMARY

• Data Analyst with 5+ years of experience in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL environment.
• Expertise in Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Skilled in Excel, Power BI, Cognos and Tableau for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in architecture with different RDBMS platforms like Oracle, SQL Server and operating SQL Server suites like SSIS, SSRS and SSAS.
• Analysed and Developed reports to explore relationship between facts and Dimension and Forecast facts
• Documented and demonstrated client requirements to the developers
• Communicate with developers and clients to solve Business solution defect

TECHNICAL SKILLS

BI & Data Analysistools: Tableau, Excel, Power BI, IBM Cognos, SPSS, SAS, Power Pivot

Project Management tools: Jira, MTM, ClearQuest, Slack, Jaz Team Server

Databases: MS SQL Server, Oracle SQL Developer, Hadoop

Programming Languages: Python, R, C#, JAVA, PL/SQL, M language

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/Power BI Consultant

Responsibilities:

• Prepared documentation for all entities, attributes, data relationships, primary & foreign key structures, allowed values, codes, business rules, glossary evolve, & changes during project
• Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Develop Business and Sales reports using Power BI
• Create and maintain project artifacts such as Business Requirements Document, data flow diagrams
• Create and document other software related deliverable as and when required
• Data analysis usingSQL,DAX function in Excel, Power BI, Tableau and SPSS
• Involved in writing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively
• 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.
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Worked on different data formats, Flat files, SQL files, Databases, XML schema, CSV files.

Confidential

Data Analyst/Power BI Consultant

Responsibilities:

• Developed work plans, managed deadlines and coordination of project team and sub - team activities
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and ETL loading strategy designing.
• Developed mapping spreadsheets for ETL team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, Transformation Rules and corporate meta-data definitions.
• Designed and developedBusiness Application to calculate Sales Commission to HR and finance department
• Built dynamic Business solution and Dashboard with Excel Power Pivot, DAX, Power Query
• Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Involved in data mining, transformation and loading from source systems to target system.
• Verified and input Finance data to Workday

Confidential

Power BI Developer

Responsibilities:

• Developed mathematical modelsto reduce patient waiting time at hospital outdoor
• Developed key metrics and data visualizations that will enable prescriptive operations and optimize pipeline processes and transparency through increased data visibility.
• Developed report using Power BI and Cognos with RDBMS for different clients
• Involved in writing the SQL Scripts for report development, Power BI reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created business intelligence reports and dashboards utilizing Power BIimplementing complex hierarchical row level security
• Configure security for Power BI dashboards, reports to ensure right level of access
• Used on-premise SQL Server Reporting Services and Azure Machine Learning Studio to extract, transform and manipulate data for meaningful analysis
• Python Scripting for predictive Analysis
• Developed White Paper on Power BI for POCs to share concise information to the client

Confidential

BI Reports Tester

Responsibilities:

• Wrote SQL scripts to test mappings and developed Traceability Matrix of Business Requirements to Test Scripts & ensure Change Control in requirements for test case update.
• Supported QA/ETL teams in ensuring proper implementation of the requirements and developed test plans and test scripts for testing and UAT (User Acceptance Testing).
• Wrote SQL statements to test validity and reliability of business report
• Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Tested Security configuration of user access to report content
• Tested Ontario Immunization Management and Drug Repository business solution by developing test plans, test cases, and tested scripts
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.

Confidential

Data Analyst

Responsibilities:

• Wrote SQL statements to extract Data from SQL server database
• Manage research and Data Analytics team
• Developed yearly reports and presented to Board of directors
• Gathered, analysed, and interpreted research data and build reports Created questioner and Collected responses in SurveyMonkey and from community
• Developed Data collection and analysis plans and conducted analysis of datasets using various statistical techniques in SPSS and Excel
• Wrote of scientific manuscripts and grants applications