SUMMARY

• Proficient working with data in Microsoft Excel, pivot tables, charting, VLOOKUP.
• Hands on experience on Confidential, Confidential 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.
• Hands on experience of handling Big data. Worked on Hadoop ( Confidential, Confidential, Confidential ).
• 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.

TECHNICAL SKILLS

Reporting Tools: Confidential /QlikSense,SQL management studio, Confidential 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

PROFESSIONAL EXPERIENCE

Confidential

Data Scientist Analyst

Responsibilities:

• 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 Confidential NPrinting and Confidential .
• 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.
• Worked with global plants to track parts inventory.
• 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.
• Assisted with troubleshooted incidents arise with reporting system.
• 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.
• Hands on experience of handling Big data. Worked on Hadoop ( Confidential, Confidential, Confidential ).
• Created SharePoint pages and page layouts for customers.
• Worked on security implementation in Confidential for dashboards.
• Expertise in all quality related documentation (Test planning, Test cases, Test data and status reports).

Confidential

Associate Engineer

Responsibilities:

• 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.

Confidential

Intern

Responsibilities:

• 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.

Confidential

Data warehouse Project

Responsibilities:

• Determined the best predictive model by comparing actual revenue value to the forecasted value.
• Designed Confidential reports, dashboards, semantic/data models for adhoc reports, QVD generation using Confidential .
• Good experience in development of highly rich dashboards using different types of Confidential 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 dat hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Performance testing on Confidential, DataZen, Qliksense, Power BI, Tableau and Hadoop.
• Tune data QVD and Confidential 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.