Data Management

Vaishnavi P. Sattigeri

***** ******** ******* *****: 832-***-****

Westland MI 48185 Email:******************@*****.***

Summary:

Master’s degree in Engineering Management.

Data scientist Analyst at GDIA (Global Data Insight and Analytics) Ford Motor Company Ltd.

Proficient working with data in Microsoft Excel, pivot tables, charting, VLOOKUP.

Hands on experience on Qlikview, Qlikview NPrinting

Excellent knowledge of Alteryx 10.6.8/Alteryx 10.6.9

Worked on Iterative and batch Macros in Alteryx.

Experience on SQL management studio 2012 and SQL management studio 2014.

Overall 4+years of IT experience with solid understanding of Business requirement gathering, documentation, Business process flow and Business process modeling.

Strong knowledge of System Development Life Cycle (SDLC) methodology and project life cycle specifically Agile and Waterfall.

Business Process Documentation skills: Project Implementation skills include AS-IS and TO-BE documentation, Process Mapping, requirement definition, process design.

Expertise in preparing Business Process Master List (BPML), Business Process Procedures (BPP). Reviewing Business Requirement Documents (BRD).

Proficient in schedule development, progress monitoring, report and forecasting, resource allocation, critical path analysis using MS Project

Experience in analyzing and implementing SharePoint 2010/2016 solutions.

Proficient in data analysis and extractions using MS Access, SQL

Excellent communication skills, problem solving analysis, people management and leadership skills and an effective team player.

Work Experience :(On contract through TEK System)

Ford Motors Company Ltd. (Data Scientist Analyst) Aug 2016-Aug 2017

Build Workflows on Alteryx tool 10.6.9 for data blending and advanced data analytics.

Lead and developed timekeeping dashboards, cycle check planning dashboard using Qlikview NPrinting and Qlikview.

Worked on SQL server Management Studio 2012 and 2014.

Worked with financial analysts to provide and analyzed financial reports.

Analyzed weekly performance for departments (actuals, targets, headcount) with Microsoft Excel, pivot tables, charting, VLOOKUP’s.

Hands on data sourcing, analyze the data for quality, harmonize the data and work with sources to finalize requirements, develop feeds, document business rule transformations and work with development team to implement. Perform detailed reconciliations between data sets.

SQL querying experience - Writing queries, database queries, and stored procedures.

Build and execute SQL queries to generate reports.

Work closely with global plants and technical teams for launching Daily cost package.

Worked with business clients to understand their requirement, data and implementing test plans and strategies.

Provide Production Support for already launched plants (Region: NA and SA).

Manage the business requirements, and process improvements for the Plants.

Worked on stabilization projects for AP and SA region.

Analyze and Create reports on the departments performance, Cost data, headcounts and timekeeping reports. Experience developing reports and dashboards.

Experience in analyzing and implementing SharePoint 2010/2016 solutions.

Created SharePoint pages and page layouts for customers.

Worked on security implementation in Qlikview for dashboards.

Expertise in all quality related documentation (Test planning, Test cases, Test data and status reports).

Tata Communications Ltd. (Associate Engineer) Aug 2012 - Dec2014

Manage the department's system enhancements, performance of the existing applications and the implementation of new applications.

Work closely with the project and technical teams to aid in system upgrades through creating requirement documents and implementing test plans and strategies in an Agile Methodology.

Manage the business requirements, and process improvements for the department.

Analyze and Create reports on the departments performance, SLA and Quality scoring for the department.

Expertise in all quality related documentation (Test planning, Test cases, Test data and status reports).

Perform GUI and User acceptance testing and arrange Demo meetings with client for deployment.

Skills Used: Selenium, SQL writing, Fitnesse, DBFit, HP Quality Center, Rally, communication skills (written and verbal) with user community, technical staff and management

Provide SME support to IT transition teams in adopting processes, procedures and tools configurations.

Drive continual improvement to meet service level agreements and KPI targets.

Establish knowledge articles on strategy and design for successful service planning and deployments.

Sky techno-labs, Pune (Intern) Aug 2011 - May 2012

Identified potential business customers and analyzed their requirement.

Process large amount Text data and classify it according to nature of the document like Technology, science Historical Document using complex SQL queries and Build Reports.

Experience in a data analyst, data mining, and/or statistical analysis.

Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.

Used data quality and data explorer to improve the quality of data on an ongoing basis and to make easier to access by the business users

Added Active Directory Users and Groups to SharePoint.

Created SharePoint pages and page layouts.

Administered user permissions and accounts.

Deployed SharePoint packages to server farm.

Additional Skills:

Reporting Tools: Qlikview/QlikSense,SQL management studio, Qlikview NPrinting, SSRS, SSIS, Tableau, Business Objects, Crystal Reports

C,C++,C#,SAP NetWeaver Business Warehouse: Data Warehousing Workbench, BEx Analyzer and Query Designer

Alteryx 10.6.8/Alteryx 10.6.9

Databases: SQL Server, R2, Oracle 9i/10g/11g, MySQL, DataMart, MS access, VBA

Additional Experience:

Academic Project: Predictive analysis using Tableau Jan 2015 - Aug 2015

Analyzed and processed raw students data collected by department of Engineering management and applied data mining techniques including Logistic Regression, Decision Trees. Patterns were identified and used to predict the number of student with GPA greater than 3.5, 3.0 and less than 3.0.

Developed, Designed and supported interactive Tableau Dashboard/workbooks/Reports for university department student forecasting.

Performed and documented data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses.

Utilized Tableau to develop executive dashboards and operational scorecards.

Converted requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing

Delivered reports to team on timely manner.

Qlikview Data warehouse Project Aug 2015 - Dec 2015

Determined the best predictive model by comparing actual revenue value to the forecasted value.

Designed QlikView reports, dashboards, semantic/data models for adhoc reports, QVD generation using QlikView.

Good experience in development of highly rich dashboards using different types of QlikView Sheet objects including various charts types, Trends, KPI’s and custom requests for Excel Export

Good experience in QVD and tuning queries for QVD generation

Knowledge of data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.

Performance testing on Qlikview, DataZen, Qliksense, Power BI, Tableau and Hadoop.

Tune data QVD and QlikView application for efficient performance

Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.

Education:

Master in Engineering Management, Lamar University, Texas January 2015 – May 2016

Bachelor in Electronics and telecommunication engineering, Pune May 2008 – May 2012

Contact this candidate