Data Analyst

Smriti Dewangan

Frisco, TX, United States Phone: 469-***-**** Email:*************@*****.***

PROFESSIONAL Summary:

7+ years of Database and Business Intelligence Report Developer experience in Data Analysis, Design, Implementation, and Support using SQL Server and Oracle databases with various business domains like Financial, Automotive, Media, Telecom, and Retail

Expertise in generating reports using SQL Server Reporting Services (SSRS), Power BI, Tableau, Business Objects, EXCEL services.

Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing, and Implementation of client-server-based applications.

Experience with educating and training others and/or helping stakeholders with using data and reporting to solve problems

Expert in all areas of SQL Server development including T-SQL Queries, Stored Procedures, User-defined Functions, Views, Case expressions, Cursors, T-SQL relational database models, and data integrity

Created Drill through, Drill down, Matrix and Subreports, added report mapping functionality to the reports using MS SQL Reporting Services

Good knowledge of various types of charts and visual reports using Stacked Column, Clustered Bar, Map, Card, Ribbon, Gauges, Tables, matrix, Pie Charts, Bar Charts, TreeMaps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Power BI to provide better data visualization, and implemented Slicer into the report page to filter the data, Calculated Columns, and Measures in Power BI Desktop to show good data analysis techniques

Developed complex calculated measures using Data Analytics Expression (DAX).

Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.

Experience creating Tableau reports using multiple data sources (.tds) like Microsoft Excel, CSV, Google Sheets, and Google Analytics for generating workbooks using Export/Live connection methodologies

Applied various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations, and Maps, etc

Developed SQL queries with the use of joins clauses (inner, left, right) in Tableau Desktop to validate data

Applied various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations, and Maps, etc

Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Heat maps, and Highlight tables and Dashboards

Experience in creating database Tables, Views, Cursors, Constraints, Joins, Stored Procedures, User Defined Functions, Temp Table consumed at various stages of migration/cleaning process, report, or data validations.

Worked on Extract, Transform, and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

Good knowledge of Data Marts, Data warehousing, OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling, Fact, and Dimensions Tables using Analysis Services.

Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills

Technical Skills:

Databases Tools

Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service and SQL Server Management Studio, SQL Developer, Toad

ETL Tools

DTS Data Transformation Services Export/Import and SQL Server Integration Service (SSIS)

Reporting Tools

Power BI, SQL Server Reporting Service (SSRS), Crystal Report, SAP Business Objects (WEBI/DESKI), Tableau

Database

SQL Server 2012 R2/2008 R2/2008/2005/2000, MS Access, ORACLE 10g/11g, and My SQL

Web Technologies

HTML, DHTML, XML, XSL, Java Script, Python, CSS, VC++ 6.0, VB 6.0 (VBA Macro)

Operating Systems

Windows Server 2008/2003/2000/XP and UNIX/Linux.

MS Office

MS WORD, MS EXCEL, MS VISIO, and MS PowerPoint

Business Analysis

JIRA, Agile Methodology BRD/FRD, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design Functional, and Technical specifications

Data Modeling

Database Design, Physical and Logical Diagrams, Star-Schema Modeling, Snowflakes Modeling Data Quality, Data Analysis, Pattern and Trend identification, Visualization of Data Insights

Digital Marketing

Google Analytics, CRM (Infusionsoft), VWO (A/B or Split Test), Wicked Report, TruConversion, Maropost, Google Sheets

Professional Project Profile:

Utest.com, Dallas, TX July’2019- Jan’2020

Role: IT QA Analyst

Responsibilities:

•Testing web applications on a wide range of Mobile handsets of different vendors which includes iPhone, Samsung Galaxy, and Apple iPad.

•Supported Monitoring and tracking high Priority defects and Production Issues on a day-to-day basis

•Tested the application under different networks and Internet speeds including while on 3G, 4G, LTE, & Wi-Fi.

•Performed compatibility testing with various mobile handsets to ensure that functionality works fine.

•Perform impact analysis (of defect fixes, feature additions & feature enhancements).

•Performing functional, GUI, and regression testing for the web-based application.

Harv Eker International, Bellingham, WA Jun’2018- Jun’2019

Role: Data Analyst

Responsibilities:

•Developed and maintained KPI and benchmark that support the business goals through the digital channels

•Tracked key metrics of website performance: unique visitors, page views, time spent, and conversion metrics

•Developed visualization/reports, dashboards and monitor key metrics daily, weekly, and monthly to communicate trends with the appropriate teams

•Well-versed with digital media concepts/technicalities i.e. website tagging, building dashboards/customer segmentation, designing/analyzing digital marketing campaigns using Google Analytics

•Proficient in configuring Google Analytics features such as Profiles and Filters, E-commerce, Site Search, and Goal Tracking with Funnels, Custom Dashboards, Advanced Segments, Custom Reports, and Content Experiments

•Proven Power BI development experience with desktop and Pro versions. Familiarity with Direct Query functionality within Power BI

•Scheduled Automatic refresh in Power BI Service.

•Created Calculated Columns and Measures in Power BI Desktop to show good data analysis techniques.

•Created visual Reports using different Charts (Stacked Column, Clustered Bar, Map, Card, Ribbon) Gauges, Tables, matrix, etc.

•Implemented Slicer into the report page to filter data for business requirements.

•Created Parameterized Report, Dashboard Report, Linked report, and Sub Report by Year, Quarter, Month, and Week.

•Created Drill Down Reports, Drill Through Report by Region.

•Developed complex calculated measures using Data Analytics Expression (DAX).

•Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, Power View, SQL Server Reporting Services)

•Analysis of visitor behavior generating heatmaps, funnels, recordings to track and analyze conversion

•Product/content analysis, user behavior analysis (path/site navigation), A/B testing, multivariate testing analysis

•Advanced Excel working knowledge including VLOOKUP, pivot tables, INDEX/MATCH, and other formulas

•Used Excel VBA/Macros, MS Access, and T-SQL queries to make reports in different styles as per client requirements

•Wrote T-SQL queries for data validation through the front end to back end and good knowledge of RDBMS concepts

•Followed JIRA Scrum/Agile methodology, met the challenges, and produced a value-added reports

Environment: MS SQL Server, SQL Server Management Studio, SSIS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Excel, SQL Server Query Analyzer, Erwin, Power BI, Google Analytics

Accenture, Mumbai, IN May’2011- Mar’2012

Role: Senior Software Engineer

Responsibilities:

•Worked with business/functional analysts to determine reports and analytical requirements.

•Expert in developing T-SQL DDL, DML statements, data integrity constraints and worked on validation issues.

•Strong experience in developing parameterized, drill down, drill through, chart, matrix, Ad-Hoc, sub-reports using SSRS.

•Worked on Tableau Server, Tableau Public, Tableau Reader, and Tableau Online

•Designed and developed various reports and dashboards utilizing Tableau visualizations like Dual Axis, Bar Graph, Scatter Plots, Pie Charts, HeatMap, Bubble Charts, TreeMaps, Funnel Charts, Box Plots, Geographic visualizations, and other making use of Dashboard Actions, Data Source, and Context Filters according to the end-user requirements

•Created complex data views manually using multiple measures also used sort, filter, group, create set functionality

•Published reports, workbooks, and data sources to the server and export the reports in different formats

•Good experience in using URL’s, Hyperlinks, Filters for developing complex dashboards

•Worked creating Aggregations, Calculated Fields, Table Calculations, Totals, Percentage using Key Performance Measures

•Followed JIRA Scrum/Agile methodology, met the challenges, and produced a value-added Tableau reports

•Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables

Environment: MS SQL Server 2012/2008/R2, SQL Server Management Studio, SSIS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Excel, SQL Server Query Analyzer, Erwin, Tableau Desktop 6.1.10

Antwerp diamond bank, Mumbai, IN Sep’2008 - May’2011

Role: IT Manager

Responsibilities:

•Involved in SDLC of the project to gather requirements from Business users and perform technical design, development, and testing.

•Provided transactional reports based on Flexcube - Retail (FCR) schema trace the deposits, loans, accounting, and bills on a daily/monthly basis and providing analytical reports based on Flexcube - Corporate (FCC) schema.

•Designed the Data warehouse and done the mappings from Source to the Target tables.

•Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to the data warehouse.

•Generated Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS for different department Head by Monthly and Quarterly Report

•Expertise in scheduling reports to end-users and give access to the report server

•Created SQL Scripts, using Microsoft SSMS, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses

•Performed data analysis using T-SQL, MS Access, Excel, and Visual Basic scripts

•Cleaned, maintained, and updated database for accuracy of all reports using SSMS and T-SQL

Environment: SQL Server 2008, Visual Studio 2003, SSMS/ DTS/SSIS, SSRS, T-SQL, Unix, Shell scripts.

Oracle FinancialServices, Mumbai, IN May’2007 - Aug’2008

Role: Associate Consultant

Responsibilities:

•Involved in the development and production support of the business application Flexcube (FCUB)

•Analyzed extracted data using (SQL, stored procedures, and queries) and provided reports to the commercial team (Excel, VBA Macro, and SAP Business Object, WEBI/DESKI, CMS)

•Developed complex reports by using various techniques like Context, Break, Sections, setting Alerter, Sorting, Combined Queries, Slice and Dice, Drill Up/Down, Master-Detail, Ranking, Prompts, Input Filters, LOV, and incorporating sound business logic.

•Expertise in using various data providers like Universes, Personal Data Files, and Freehand SQL to generate reports.

•Involved in checking the cardinalities, resolving loops, and traps by creating Alias and Context.

•Extensive experience in building and managing Universes, creating Complex, Ad-hoc Reports, Charts using SAP Business Objects.

•Assured and checked the quality and the integrity of the data using SQL-Queries and stored-procedures

•Wrote and analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team using Excel, SQL-Queries, and Crystal Reports.

Environment: SAP Business Objects XI R2, Crystal Reports XI, Oracle 9i, VC++ 6.0, VB 6.0, Java Script, XML SDK 4.0.

CMC Limited, Mumbai, IN Aug’2005 - Feb’2007

Role: Trainee – System Integration

Responsibilities:

Developed routines using SQL Scripts

Created database objects like Tables, Stored Procedures, Functions, Triggers.

Worked on Data migration using SQL Loader utility

Upgraded and converted existing Excel data Format into Database

Interacted with clients for understanding new requirements and changes.

Analysis and estimation of changes/new requirements.

Prepared FS (Functional specifications), DS (Design specifications), Unit Test Plans (UTPs)

Prepared checklists for design, code, and UTP reviews.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader

Education:

2001-2004 Bachelor of Engineering: Information Technology, Pandit Ravishankar Shukla University, Raipur, India

Certification:

OCA Oracle Certified Associate

Contact this candidate