Team Lead

SHRUTIKA GOYAL

Mobile No: +91-989*******, 966-***-****

adfd1l@r.postjobfree.com

EXPERIENCE SUMMARY

‘Master of computer applications’ degree holder with scoring 80% from well-known university UPTU.

Total 7 years of relevant experience in database technologies.

Good experience in writing T-SQL, Teradata queries and designing database objects.

Experience in building the BI solutions for Foster collaborative growth by sharing comprehensive analytical reports on sales with other departments such as operations, product and marketing.

Good experience in designing the Power BI different reports to analyze sales rep’s activities, provide forecasts to management to ensure service levels are met & KPI's are on track.

Good experience in developing Tableau reports that provide clear visualizations of various industry-specific KPIs.

Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed tracking and improving customer units KPI.

Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS.

Experience in developing various type of BI reporting solutions and dashboards in Power BI and SSRS.

Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS).

Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.

Good experience as a Training coordinator in providing the training and establish the training content and assessment.

Experience in gathering the requirements, resolving the data issues and working with clients.

Experience in automation using BI technologies to populate the data from various source systems feeds like Veeva CRM, Salesforce, Teradata and others.

TECHNICAL SKILLS

Languages : T-SQL, MDX writing Language

Databases : MS SQL Server, SSIS, SSRS, DTS, Teradata, SSAS

Reporting Tools : Advance Excel, SSRS, Power BI, Tableau, Alteryx

Others : Veeva, Vault, Cloud computing, Data visualization, Data Analytics, Business Intelligence, Alteryx

PROFESSIONAL EXPERIENCE

Currently working with ‘WNS Global Services Private Limited' and supporting GSK as ‘Team Lead' since May, 2018 to till date.

Responsibilities:

Responsible for leading and performing range of functions in the areas of gathering requirements, technical design/review, development, testing, deployment and integration of Data Warehouse & Business Intelligence solutions.

Extract, filter and aggregate data using MS SQL Server and Teradata.

Authored complex stored procedures, views, functions and scripts to support development team and leadership data analytics needs.

Performed various calculations using complex expressions in the reports and created report models.

Consolidated standard reports, eliminated duplicate functionality and reduced the number of standard reports.

Develop different reports and dashboards in Power BI like sales, profit and other reports for gaining the sales insights.

Providing expertise in data storage structures, data mining, and data cleansing.

Prepared the different reports to analyze sales rep’s activities, provide forecasts to management to ensure service levels are met & KPI's are on track in Power BI and Tableau.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Restricted data for particular users using Row level security and User filters.

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Developed Tableau workbooks from multiple data sources using Data Blending.

Imported data from SQL Server DB, Teradata to Power BI to generate reports and dashboards.

Publish Power BI reports in GSK and make Power BI Dashboards available in Web clients and mobile apps of GSK.

Work with program work stream leads where needed – work streams include: Global Business Process, Change Management, Testing and Validation, Region/Country Deployment.

Comparative analysis to compare brands, performance across regions and countries.

Synthesize data, generating meaningful insight and presenting inform of effective presentation, creating project management tools and SOPs.

Performed in-depth data validation on data from various suppliers across the world.

Served as the primary contact for client service teams for several different projects.

Researched and resolved data discrepancies with troubleshooting teams.

Merged data with existing data sets, careful to keep old data sets and documentation.

Worked with 'Wells Fargo' as 'Technology Specialist' since January 2018 to May 2018.

Responsibilities:

Involving in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Creating stored procedures, Triggers, User-defined Functions, Views.

Involving in batch file creation using windows scripting language and Autosys job for scheduling the execution of SSIS packages.

Responsible for generating different types of daily and weekly Reports based on requirements using SQL Server Reporting Services (SSRS) and MS Excel.

Collaborating with business users, understood and delivered their reporting needs.

Involved in end to end testing and writing the test cases.

Preparing LLD documents after the implementation and testing.

Worked as ‘Operations Processing Analyst’ with “NTT DATA” Formerly ‘DELL International Services’ worked as ‘IT Enabled Ops Proc Team Lead’ since May, 2015 to 10th Jan 2018.

Responsibilities

Designed ETL packages dealing with different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created stored procedures, Triggers, User-defined Functions, Views, etc in T-SQL

Worked on Teradata queries and ETL in Teradata.

Involved in writing MDX query to fetch data from cubes.

Created Cross-Tab, Drill-down, Drill-through, Sub-Report, Parameterized, linked reports an Ad Hoc reports using SQL server 2008 R2 / 2012 Reporting Services.

Responsible for generating different types of daily and weekly Reports based on requirements using SQL Server Reporting Services (SSRS) and MS Excel.

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs using Power BI platform.

Collaborated with business users, understood and delivered their reporting needs.

Responsible for resolving the data issues and attend all the data calls with clients for updates and requirement gathering.

Worked as Software Developer at “VQMS Pvt Ltd (A Management Consulting Company)” since Feb, 2013 to May, 2015.

Responsibilities:

Understand data requirements from the business analyze source data and derive required datasets.

Develop test and tune database code and information.

Created various types of reports like Tables, Matrix using reporting services.

Design and maintain SQL scripts.

Provide technical support and guidance to staff and clients.

Extracted and collected data to create needed reports.

Validated accuracy of data to ensure database integrity

Responsible for automation in excel and created various types of daily or weekly reports in MS Excel.

CERTIFICATION

Microsoft certified in “Analyzing and Visualizing Data with Power BI” in April’20.

Certified in “Fundamentals of Visualization with Tableau” course authorized by University of California, Davis and offered through Coursera in June’20.

Certified in “Data Visualization using Tableau” course authorized by Great Learning Academy in May’20.

Certified in “ Alteryx: Self-Service Analytics In Your Hands” course authorized by Udemy in July’20.

Certified in “ Alteryx- Data Processing, Data Manipulation and Analytics” course authorized by Udemy in Aug’20.

Certified in “Data structure using C” from “INFORMATICS Computer Institute” in 2011.

Certified in “Managing table design” from “DELL INTERNATIONAL SERVICES” in 2016.

Certified in “Multiple Tables and Advanced Queries” from “DELL INTERNATIONAL SERVICES” in 2016.

ACHIEVEMENTS AND EXTRA CURRICULUM

Received ‘Bronze’ and ‘On the Spot’ Awards for outstanding performance and being a valuable team member.

Received Service innovation award in last 3 quarters for my outstanding performance and creativity in the current process enhancement.

Received ‘On the Spot’ Award for outstanding performance and being a valuable team member in DELL International Services.

Present the Presentation in the “Paper Presentation and Software Presentation” in college Festival AGAAZ-2011.

Participated in the Crack code/debugging in the college Festival AGAAZ-2012.

STRENGTHS

Analytical Skills

Created and analyzed a series of regional performance metrics that allowed linking the KPI’s of multi-channel dataset of retail enterprise into a single efficient unity

Creativity

Found a new way to present quarter financial data that eventually became a company-wide standard for quarter performance presentation and retrospectives sessions.

Presentation Skills

Gathered and effectively presented data from various sources to business stakeholders in the form of manageable visual reports as was specified in business requirements

INTERPERSONAL SKILL

Ability to rapidly build relationship and set up trust.

Confident and Determined.

Ability to cope up with different situations.

PERSONAL DETAILS

Date of Birth: March 1, 1991

Current Location: Noida

Language Known: Hindi, English

LinkedIn Profile: https://www.linkedin.com/in/shrutika-goyal-a48719186/

DECLARATION

I do hereby declare that the above information is true to the best of my knowledge.

Reference: As Required

Date: SHRUTIKA GOYAL

(Signature)

Contact this candidate