Ankur Patel

Lansing, MI - ***** 614-***-**** adh9pg@r.postjobfree.com Visa status – H1B visa

PROFESSIONAL SUMMARY

Result oriented and highly skilled data analyst with years of industry experience in collecting, organizing, interpreting, and disseminating various types of data. Analytical and process-oriented data analyst with in-depth knowledge of database types; furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth. Strong experience in ETL design and implementation involving the extraction and loading of data from/to variety of legacy systems, integration, and cleansing data. AREAS OF EXPERTISE

Programming – SQL, R, Python, Core Java

Data Management tools – Informatica PowerCenter, Talend Data Integration, Collibra Data Catalog Database –SQL Databases, Hadoop, MySQL, PostgreSQL Software/Applications - Oracle BI, R studio 1.1, PowerBI, Tableau, Oracle BI, Hadoop Impala, Microsoft Visio 2016, Microsoft Project, SQL Server Management Studio 18, MS SQL Server 2016 Data Analysis - Machine Learning (Clustering, Classification, Regression), Categorical and Time series data analysis Data Modeling: Erwin DM Standard Edition, Conceptual, Logical and Physical modeling WORK EXPERIENCE

CHAIN-SYS CORPORATION LANSING, MI

Data Analyst March 2018 - Present

• Working closely for implementation of Product Profitability and developing BI reports on top of Data Warehouse in PowerBI and Oracle BI for a well-known equipment and services provider of datacenters.

• Building Data Warehouse, organization was able to scrap and obsolete 7 old ERP systems and databases that saved about 23% of total cost of subscriptions, maintenance and workforce that used to be spend annually.

• Implemented Collibra’s Data Catalog solution that helps the organization to maintain unified view of their Data assets which can be trusted for data analysis and can be focused on delivering business insights.

• Worked on maintaining repository, manage processes of application server in Informatica Data Analyzer

• Collaborated with SMEs, Business Analyst and developers on the data mapping document from source-to-target and the data quality assessments for the Master data.

• Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.

• Developed ETL procedures in PowerCenter to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures for VLDB.

• In Impala, documented logical, physical, relational, dimensional data models and designed the data marts in dimensional data modeling using star and snowflake schemas.

• Developed, documented and validated complex business rules vital for data transformation. GANNON UNIVERSITY ERIE, PA

System Analyst May 2016 – December 2017

• Lead the design and testing of MS Access Database (to replace MSQ V8.0)

• Developed website maintenance training materials and trained IT Support staff and involved with Terminal Services testing, training, and implementation.

• Facilitate optimal internal communications by serving as liaison between services organization and product development, product management, and technical teams.

• Assisted development team's Lead Business Systems analyst with determining agile workflows and assisting getting the JIRA tool to match their development cycle.

• Documented system occurrences for reference and maintenance of the constantly changing environment daily.

• Participated for SDLC testing in clients meeting, reviewed functional and business documents to develop test plan and managed testing efforts for project's testing phases. SHREEJI FINANCIAL SERVICES GUJARAT, INDIA

Business Analyst June 2014 – December 2015

• Completed first project of a real estate company in 90 days in an industry that averages 6 months to completion.

• Interviewed business clients to analyze their business requirements and recommend and design technological improvements to their business processes and operational procedures.

• Created functional requirements in use cases. Coordinate requirements walk-through and signoffs, verifying with user representatives/stakeholders that use cases and process models accurately portray specific business needs.

• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.

• Planned, facilitated, and reported on quality assurance testing efforts.

• Analyzed quantitative and qualitative business data to develop a solution design capable of fulfilling the customer's requirements using Tableau.

• Created presentations in concise & well-researched manner on new product feature ideas & opportunities by collaborating with product owners.

SKILL LOGICA PVT. LTD. GUJARAT, INDIA

Java Programmer Intern June 2013 – December 2013

• Involved in Scrum methodology for new business requirements.

• Developed and maintained code using JSP, Servlets and JDBC.

• Assisted in maintaining and updating existing applications and modules.

• Evaluated and solved trouble tickets by coordinating with DBAs, Help Desk, and senior development team. EDUCATION

GANNON UNIVERSITY ERIE, PA

Master of Science, Computer and Information Science December 2017 Major: Information Analytics

GUJARAT TECHNOLIGICAL UNIVERSITY AHMEDABAD, INDIA

Bachelor of Engineering in Information Technology May 2014 Major: Business Analytics

PROJECTS

Title: Product Profitability and Sales Reporting (in progress) – Chain-Sys Corporation

• Development of Sales reports and views every month that consists of Sales revenue, cost, adjustments from Data Lake and perform Reconciliation with existing reports from 18 different ERP Systems.

• Improving Sales transaction traceability by developing new automated integrations in Data Lake.

• Implementing one universal GPH structure across Organization which will be managed by Data Governance board on Collibra platform.

• Streamlined and simplified Market vertical structure that leverages Customer hierarchies. Title: Enterprise Data Warehouse – Chain-Sys Corporation

• Data Management activities including planning, coordinated analysis, and maintaining data from multiple source systems into the Hadoop data warehouse while ensuring data integrity.

• Translated business requirements into technical design specifications using Visio to design ERD schema.

• Performed data transformations using custom mappings. Processed and validated data as per business rules to load data to Hadoop.

• Managed assignments/workload for the team of 6 offshore developers working in different regions to meet project milestone and delivery goals.

• Support the data reporting tool environment and processes, data extract, transform and load (ETL) design and processes, reporting toolset configuration, implementation, and maintenance in Informatica Data Analyzer tool. Title: ERP Data Migration – Chain-Sys Corporation

• Managed end-to-end complex data migration, conversion and data modeling from multiple source systems within the established project budgets and advised Project Manager of potential deviation.

• Worked with Program Managers and Business users for formulating a comprehensive data migration plan with different conversion strategies, detailed objects and field mappings including its transformations and business rules from legacy systems like SAP, EBS, MS Dynamics into a centralized Oracle Fusion cloud application.

• Liaised with business analyst colleagues and SMEs during the build and test cycles and own the resolution of defects pertaining to requirements and designs.

• Lead the delivery of business and functional analysis and artefacts working alongside the Business SMEs and offering advice and feedback on the potential functional and technical solutions and approach.

• Validated, tested, and maintained all developed data conversion models to ensure successful loading of data from different sources to Oracle Fusion.

Title: Enterprise Reporting and Analytics – Chain-Sys Corporation

• Rebuilt, expanded and improved all legacy reports on new reporting platform using Hadoop and Microsoft PowerBI.

• Provided technical financial reporting expertise to assigned business units/leaders to ensure all financial and operational data (including planning, budgets and forecasts) are available to support business decisions

• Prepared strategic trend reports to measure KPI, Increased leadership focus on key performance indicators

• Directly supported Finance, Projects, Budgeting, Sales and Planning departments on custom reporting needs as well educated them use of various reports.

Title: Data Analysis for Consumer Complaint Data - Gannon University

• Predicted type of products that will receive more complaints and analyzed the type of responses of companies from year 2011 to 2017.

• Implemented steps like Data Cleaning, Data Clustering, Data Classification, and Data Visualization using several algorithms in R programming language and Tableau on more than 700,000 data with more than 90% accuracy. Title: Research and Development Expenditure Analysis Model - Gannon University

• Predicted of inclination or declination of funds based on designed analytic model.

• Demonstrated accountability of the money invested by the spot sponsors. Title: Financial Tracking System – Shreeji Financial Services

• Reduced time of CA and PM for recording and maintaining budget and finances by 35%.

• Gathered requirements, modeled system using Microsoft Visio, Microsoft Project, and Gantt chart.

Contact this candidate