Senior System Analyst Resume

SUMMARY:

Highly accomplished Business Intelligence Architect and technology leader with a 7+ years of career that spans data warehousing, business intelligence, and data management architecture, design, development, and solution implementation for Fortune 500 organizations.
Expertise in BI strategy, consulting, and project management for various business domains such as Financial, Banking, Insurance, T&L and Manufacturing & Logistics.
Proficiently performed Project Manager activities for Software Life Cycle Development Methodology (Water Fall), Agile (Scrum and Kanban) methodology.
Extensive Experience of Designing Logical, Physical Data Models as well as Dimensional Modelling for Data Marts.
Extensive experience in all the phases of the Data warehouse life cycle involving Design, Development, Analysis and testing in the various areas of Data warehousing, including Data Quality checks.

EXPERIENCE:

Data Analyst

Confidential

Responsibilities:

Managing Project activities for Data Profiling, Data Quality and Metadata Management.
Lead ETL design for migration of data from MySQL to AWS Redshift.
Gather and document business document
Deliver data - driven solutions and provide support for customers and identify the gaps for management using intuitive dashboards built in Tableau.
Derive insights from consumer data analysis and lead the team on data driven approach for problem solving.
Develop data model for new business use cases in an agile environment.
Creation of reports and dashboards for key performance indicators.
Developed data stories for whitespace analysis for customer presentations.
Implement complex business rules by employing in-process ETL consolidation.
Working on Customer’s finance data and implementing a financial data mart for regulatory purpose.
Developing metrics and BI reports for the top management on a daily and monthly basis.

Research Assistant - Big Data Analytics

Confidential

Responsibilities:

Performing exploratory data analysis on data from PPMI and PDBP database for Parkinson’s disease by setting up a Hadoop Cluster.
Datacleaningandanalysis,manipulation,fusionandaggregation,classification and clustering to perform diagnosticforecasting to predict Parkinson’s disease.
Creating an interactive visualization platform to understand the correlation of various attributes causing Parkinson’s.

Manager Daimler

Confidential,

Responsibilities:

Implemented Interactive Real Time Dashboard to track key business metrics.
Consolidate dimensions and measures from heterogeneous sources (ie. DWHs and flat files) using SSIS.
Designed & Implemented Extract, Transform, and Load process with SQL Server Integration Services in Microsoft SQL Server 2014 from various source systems like Text files, Excel Spreadsheets & RDBMS.
Involved in Development, Review and testing of the new system by implementing business rules and transformations

Senior System Analyst

Confidential,

Responsibilities:

Migrated from legacy system to Teradata using Informatica for MES (Manufacturing Execution Systems) and created the Business Object reports for the Production plants.
Tune the SQL queries for pulling data from database to provide optimal unload performance.
Executive - Integrated Supply Chain Management Kennametal, India
Successfully migrated 60000 Material Master from SAP4.6C to SAP ECC for endmill shop floor.
Developed reports in SAP BO for Sales and Operations Planning.
Gathering Business requirement and creating source to target mapping documents.

TECHNICAL SKILLS:

Programming Languages: Python (Proficient in Numpy, Pandas and Scikit-Learning)

ETL: SSIS, Informatica

Visualization: Tableau, AWS Quicksight,D3.Js and Matplotlib (Python), ggplot2 (R)

Statistical Package and Data Mining: R, Weka

Database Systems: Relational Databases -MySQL, Oracle, Teradata, NoSQL - MongoDB,Neo4J, Cloud - AWS