Data Analyst Business

Meet Singh

Sr. Data Analyst /Business & Project Analyst

: *************@*****.***

PROFESSIONAL SUMMARY:

●18+ years of experience in Information Technology with more than 15 years in Power BI, OLAP and data warehouse, Relational Database Systems, Client /Server Applications, Simulation, Data Visualization worked on various projects requires strong analytical and project management skills.

●Experienced in SQL Server 2000,2005, 2008,2012,2016 and 2017, Oracle 8i/9i/10i/18.1.

●Complex queries, DTS packages, SSRS, Stored Procedures, Triggers, SQL * Loader.

●Extensive knowledge in BusinessObjects XI/6.x/5.x, Full Client & Thin Client Environment.

●Excellent understanding of Relational Databases, Client/Server applications and cloud technology.

●Experienced in converting Business and Data requirements into Functional, Business and technical specification.

●Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail etc.

●Experience in complete Software Development Life Cycle (Requirement Analysis, Design, Development and Testing).

●Extensive experience in Data Warehousing, Data Modeling, Normalization, Business Process Analysis, Logical & Physical database design.

●Excellent communication and interpersonal skills with result-oriented dedication towards goals.

SKILLS:

●Complete Understanding of Software Development Life Cycle (SDLC).

●Formulating Design Plans, ER Diagrams, Data Flow Diagrams and Designing Databases based on the User Requirement Documents.

●Can perform responsibilities in stressful environments with fixed deadlines.

EDUCATION & CERTIFICATIONS:

●Masters in Computer Science (MCA), Kurukshetra University, India (In 2003) .

●Bachelor in Science (BSc), Delhi University, India (In 2000).

●Microsoft Certified Professional (MCP) in Designing and Implementing Desktop Applications (957/1000) and Distributed Application (928/1000) with Microsoft Visual Basic 6.0.

●Business Object Certification in Core Reporting.

●SAS Certified Professional in SAS-MA, Enterprise Guide, Infomap and Management Console.

TECHNICAL SKILLS:

OLAP Tools:

BusinessObjects XI/6.x/5.x, Data Integration 6X, WebI6.x/5.x, BCA, SDK, ZABO, Crystal Reports, SAP, SAS, Tableau, Power BI.

Database:

MSSQL7.0/2000/2012/2016/2017/2020, MS-ACCESS 97/2000, ORACLE8i/9i/18.1, Teradata, SAP.

Languages:

C,VB, VB.NET, ASP.NET, C++, COBOL, SQL, TSQL,SQL*Plus, C#, XML, HTML, VB Script, VBA, IIS

GUI:

SQL Enterprise Manager, Query Analyzer, DTS Package, SQL Navigator, SQL * LOADER, MS PowerPoint., MS Project, Power BI, Tableau

Data Modeling:

Erwin 4.1

OS:

Windows2X/NT/9X/365

WORK EXPERIENCE:

Tmobile (National) Oct 2022 – Till Date

Sr. Data and Reporting Analyst - Contract

Regional Network Engineering and Ops Team.

Responsibilities:

●Designed and Created various Power BI reports like Ops_Trend, High Temperature Sites, LTE+5G, Generator Running, Total DownTime Report and many more .

●Created various Power BI Automate flows, Gateways, Grant/Revoke User rights for the various PBI dashboard.

●Build Time and Motion study tool for measuring Tech and Manager performance in their specific market.

●Created various Ad-Hoc Power BI reporting and worked on various Ad-Hoc Data Analysis for the various projects and customers.

Environment:

SQL Server, Power BI, MS PowerPoint, MS Excel, SharePoint, JIRA, Confluence.

Microsoft (Issaquah, WA) May 2021 – Oct 2022

Sr. Data and Reporting Analyst - Contract

OG Design and Management Enhanced.

Responsibilities:

●Designed and Created various Power BI reports like ODM, Discount Analysis, Proactive Services, Support Offering, Enhanced Solution Customers, Budget, Cloud Impacting, Flex Allowance Dashboards.

●Lead many data analysis projects and give my recommendations to the higher management.

●Created various Ad-Hoc Power BI reporting for the various projects and customers.

Environment:

SQL Server, Power BI, MS PowerPoint, MS Excel, SharePoint, JIRA, Confluence.

Novartis Pharmaceuticals (New Jersey, NJ) Apr 2021 – May 2021

Sr. Business Process and Data Analytics Consultant (Simulation) - Contract

Process Design & Improvement.

Responsibilities:

●Developed Pharmaceutical Process Maps for various Drugs like Entresto, Cosentyx and Leqvio.

●Created Simulation package for different drugs mentioned above in Adonis and Simul8 Tool.

●Wrote SQL queries to do data analysis and give my recommendations to the higher management.

●Developed various PULSE reporting and Ad-Hoc reporting for the various projects and customers in Power BI and Tableau.

Environment:

SQL Server, HUE, HIVE, Impala, Oracle, MySQL, ADONIS NP (10.0.3), Simul8, Power BI, MS PowerPoint, MS Excel, Tableau 10.5, SharePoint, JIRA, Confluence and VSTS.

Intelsat Inc (McLean, VA) Jul 2020 – Jan 2021

Sr. Data and Reporting Analyst - Contract

Client Value Tools - Satellite.

Responsibilities:

●Created Internal and External Customer reports.

●Created and Modified Affiliate Site Matching Generator Internal Tool in MS Excel VBA.

●Wrote SQL queries to do data analysis and give my recommendations to the higher management.

●Developed various Ad-Hoc reporting for the various projects and customers.

●Created various Power BI, Tableau and Power Pivot reports.

Environment:

Oracle 18.1.0, Power BI, MS PowerPoint, MS Excel, Power Pivot, Macros, Tableau 10.5, Visual Studio, SharePoint, JIRA, Confluence and VSTS.

Microsoft (Sammamish, WA) Jan 2019 - Jun 2020

Sr. Business and Data Analyst - Contract

Premier Unified Business Strategy Modelling Team.

Responsibilities:

●Created SQL queries to do data analysis on the various data sets and give my suggestions and recommendations on the basis of data trending and analysis to the higher management.

●Developed various Ad-Hoc reporting for the various projects and customers.

●Worked on Power BI and Power Pivot for doing analysis on various projects.

●Worked with Onshore and Offshore team members to lead various short-term and long-term projects.

Environment:

MS SQL Server Management Studio 2017, Power BI, MS PowerPoint, MS Excel, Power Pivot, Macros, Tableau 10.5, Visual Studio, SharePoint, JIRA, Confluence and VSTS.

Nokia (Bellevue, WA) Jan 2017 – Jan 2019

Sr. Data & Reporting Analyst - Contract

Care Team.

Responsibilities:

●Created complex logical, conceptual data models using Erwin

●Developed and executed Daily, Weekly, Monthly, Quarterly, Half Yearly and Yearly Reports.

●Worked on various reports on BOXI (Testbed, Nontestbed, EBCSS, SLA, TRM, ORM, Install base, HWS, Objective data, SDM reports).

●MS Project to scheduled various projects.

●Wrote Queries in SQL. Performed data analysis on the various data sets and give my suggestions and recommendations on basis of data trending and analysis.

●Did Ad-Hoc reporting by using Tableau and Data Analysis on the various projects.

●Trained team in various technologies and reports.

●Created Various Care Reporting on Tableau 10.5.

●Took Power BI and Power Pivot training to ran CARE reporting.

Environment:

SQL Server 2012, Power BI, BOXI, TSQL, DTS Package, Query Analyzer, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, MS Word, Erwin 8, Tableau 10.5, JIRA, Confluence, BOXI 14.1, Power BI and Power Pivot.

T-Mobile (Bellevue, WA) Nov 2015 - Dec 2016

Sr. Source System & Data Analyst - Contract

Source System Analyst Team.

Responsibilities:

●Worked on source system analyst team to created various source system analyst document for various different projects.

●Worked on various projects (including Confidential and Dark projects) like Marketing Sprint, SCM and DL Sprint, Red Team, NPI (New Product Introduction), Rushmore, Sedona and so on for creating SSA documents.

●Worked with Data Classification team to classify data as a Restricted, Confidential or Internal etc for various different source system like ACC, ASSURANT, OMNI, CHUB, EIP, Ericsson, IDS, RPX, SAMSON, SAP, HADOOP, IDW and so on.

●Handled lots of ad-hoc data analysis request from different teams in T-Mobile like Revenue, IDW, Hadoop, Marketing, Ericsson and so on.

●Did Data Analysis on various reports with Tableau.

Environment:

SQL Server, Ericson, SAP, Teradata, Oracle TSQL, DTS Package, Query Analyzer, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, MS Word, Erwin 8, Hadoop, JIRA, Confluence, Big Data, Hive, Power BI, Tableau.

Nokia (Redmond, WA) April 2012-Oct 2015

Sr. Data and Reporting Analyst - Contract

Care Team.

Responsibilities:

●Created complex logical, conceptual data models using Erwin

●Developed and executed Daily, Weekly, Monthly, Quarterly, Half Yearly and Yearly Reports.

●Worked on various reports on BOXI (Testbed, Nontestbed, EBCSS, SLA, TRM, ORM, Install base, HWS, Objective data, SDM reports).

●MS Project to scheduled various projects.

●Wrote Queries in SQL 2008. Performed data analysis on the various data sets and gave my suggestions and recommendations on basis of data trending and analysis.

●Did Ad-Hoc reporting and Data Analysis on the various projects.

●Trained team in various technologies and reports.

Environment:

SQL Server 2008, BOXI, TSQL, DTS Package, Query Analyzer, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, MS Word, Erwin 8.

Morphit Solution (Bellevue, WA) Oct 2011 – March 2012

Sr. Data Analyst

Sales & Marketing Team.

Responsibilities:

●Created complex logical, conceptual models using Erwin

●Developed and executed Daily, Weekly, Monthly and Quarterly Report

●Write Queries in Teradata, SQL 2008 and Oracle. Then performed analysis on the data sets.

●Ad-Hoc reporting and Data Analysis.

●Analyzed and Fixed Bug in Data.

Environment:

TSQL, DTS Package, Query Analyzer, TeraData, Toad, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, VSTS, MS Word, SQL Server 2008, Erwin 8.

T-Mobile (Bellevue, WA) April 2011 – Sep 2011

Sr. Data & Marketing Analyst - Contract

T-Mobile Customer Marketing Support Team

Responsibilities:

●Developed Data Dictionary for SAS-MA.

●Create and execute campaigns in SAS-MA i.e Legal Notification, Rate Plan Upsell – On Device/Telesales/Customer Care, Paperless Billing, AAL, MBB and Telesales and so on.

●Wrote Queries in Teradata, SQL 2008 and Toad for Data Analysis.

●Ad-Hoc reporting and Data Analysis.

●Analyze and Fix ETR/SAS issues.

Environment:

SAS – MA/Enterprise Guide/Infomap/Management Console, VBA, TSQL, DTS Package, Query Analyzer, Tera-Data, Toad, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, VSTS, MS Word, Testing, SQL Server 2008, Erwin 8.

Microsoft (Redmond, WA) October 2009 - March 2011

Sr. Business & Data Analyst - Contract

Customer Sales and Marketing Data Readiness Tool

Responsibilities:

●Created Various Reports like Organization/Individual/Account Summary Report, Organization/Individual/Partner Summary Detail Report and Defect Org Detail/Trend report in MS SQL SSRS 2008.

●Created Various AD-Hoc Reports as per Business User request in MS SQL SSRS 2008.

●Worked on Business Requirement Document for getting business demands and requirements in Reporting Arena.

●Created Logical and Physical Data Model using Erwin 7.

Environment: SAP, VBA, TSQL, SQL Enterprise Manager, DTS Package, Query Analyzer, SQL server 2010, SSIS, SSRS, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, VSTS, Erwin 7.

AT&T (Redmond, WA) August 2007 – September 2009

Sr. Data and Business Analyst - Contract

AT&T Mobility Group and mCommerce Platform Team

Responsibilities:

●Created Various Databases and Tables in Microsoft SQL Server 2005 to support Analysis and Reporting environment (SSRS). Imported/Exported data into various tables/databases.

●Worked on various daily, semi-monthly and monthly reports like Daily Sales, Financial Control Report, Profanity FDDE Report, Daily Duplicate Report, Q-pass Micro payment Report, Semi-Monthly Unguided Account Closure Report, Semi-Monthly API report, Monthly Naming Convention Compliance Report, Monthly Off-Portal CP Migration Report, Monthly Off-Portal Sales Report, Monthly Product Listing, and etc.

● Analyzed data on different database/reports for various requirements. Also wrote and ran the script then communicated end result to different managers/stakeholders across the team.

●Ran script, then analyzed the various reports and uploaded reports to Share point sites using SSRS.

●Worked with Release Manager/ Product Manager of upcoming releases regarding validation/quality/testing of data received from third party vendor (Q-pass).

●Created various databases on Access and SQL server according to business requirements and rules. Also, ran various daily, weekly, semi-monthly and monthly report from it in SSRS.

●Handled various data and reporting issues with existing database from different stakeholders (Internal and External) and provided solutions as per request and priorities to user.

●Created Various Logical, Physical and Conceptual Data model using Erwin 7.

Environment: SAP, VBA, TSQL, SQL Enterprise Manager, DTS Package, Query Analyzer, SQL server 2005, SSRS, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, VSTS, MS Word, Testing.

Microsoft (Sammamish, WA) Duration: January 2007- August 2007

Business Analyst - Contract

Microsoft Marketing & Analysis Planning Support System

Responsibilities:

●Involved in Data gathering, analyzing, and documenting business requirements, functional requirements, Business Analysis and data specifications for MAPSS project.

●Worked on various reports like SAP, Invoice, PO, SSRS marketing, forecasting and etc.

●Created data models like logical data model and conceptual data model. Also, created Microsoft Threat Model and Analysis Model 2.1version.

●Arranged JAD with Test, Dev and Business team to get good Functional Spec.

●Created and executed SQL 2005 scripts for data validation from upstream and downstream system. Communicated end result to reporting manager and others managers in various teams.

●Participated in Triage to fix the bug raised by the team.

Environment: SAP, VBA, TSQL, SQL Enterprise Manager, DTS Package, Query Analyzer, SQL server 2005, SSRS, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs, VSTS, Microsoft Threat Model & Analysis ver2.1.

Nokia (Redmond, WA) February 2005 – January 2007

Project Analyst and Data Analyst - Contract

NOKIA

The project scope was to design and build a business intelligence solution extracting data from data warehouse for decision support for personal.

Responsibilities:

●Involved in data gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Reports.

●Interacted with Business Users, Business Owners to know their business views in developing and modifying different Reports including AD-HOC reports and SSRS accordingly.

●Exported Business Objects reports in various formats for further analyzing and investigation.

●Excellent Understanding on Project Management side. Worked as a Project Analyst. Used MS Project for management point of view, MS PowerPoint for delivering presentations to reporting managers and MS Excel for the status of project (Actual VS Forecast).

●Worked on various reports (Business Objects, SAP, Rollo, Nelle, SSRS tools) creating Dashboard report for various projects and using MS Project to manage it.

●Analyzed and gathered data from the different databases for Invoice reconciliation and provided to customer to support payments.

●Involved in writing various macros, creating pivot tables, customized charts and graphs for different reports in MS Excel and SSRS.

●Created weekly & monthly quality reports for different user groups and depicted Network, Quality and Performance issues in the form of graphs and charts.

●Ran existing and new reports according to the users demand.

●Involved in setting up MS SQL Database Server and link to other databases in Network.

●Created and modified Data transformation packages (DTS).

●Imported/Exported data and wrote complex queries in Query Analyzer for fetching data in MS SQL server 2000.

●Strong Experience in Business Objects Data Integration.

●Involved in the creation of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis of the database using Business Objects 6.0.

●Involved in Database Optimization and Tuning the universe and SQL.

●Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Up/Down, Cross Tab, Master Detail, and Formulae’s and TSQL etc. Also created reports in Microsoft Access and Microsoft Excel.

●Customized the Business Objects features by using VBA in Macros.

●Tested the reports for query performance and optimization to increase performance.

●Exported the universes to the Repository to making resources available to the users.

●Strong knowledge of Data Warehousing Environment including requirement specification, data modeling, data base designing, Data Mart, Data Cleansing, Data Integration, AD-HOC Reports.

Environment: Business Objects 6.5 X, SAP, Web Intelligence, Info view, VBA, TSQL, SQL Enterprise Manager, DTS Package, SSRS, Oracle, Sybase, HTML, DHTML, COM, C, Visual basic, Query Analyzer, MS Access, MS PowerPoint, MS Project, MS Excel including Pivot tables, Macros, Charts & Graphs.

Virtual Soft System Limited, India June 2003 – February 2005

System Executive

Responsibilities:

●Developed Software Requirement Specification document by interacting users.

●Took part in designing and developing databases using SQL Server.

●Did coding, implementing and testing of whole software.

●Conducted meetings for any other requirements and modification of projects.

●Handled Data Entry Team for Creating Databases.

Environment: Windows NT/2000, Visual Basic 6.0, SQL Server, Oracle, HTML, DHTML, COM, ActiveX, Crystal Reports.

National Fertilizer Limited, India January 2003 – June 2003

Software Developer

Responsibilities:

●Designed, coded, implemented and tested whole software.

●Developed new modules in this project.

●Conducted meetings for any other requirements and modification of projects.

●Handled bug solving for this project.

Environment: Windows NT/2000, Visual Basic 6.0, SQL Server, Oracle, HTML, DHTML, COM, ActiveX, Crystal Reports.

REFERENCES:

Available on request.

Contact this candidate