SUMMARY

• 5 years of experience in understanding data requirement, creating data model, analyzing data integration, creating reports and dashboard, KPI generation in multiple domain.
• Around 4 years of Data Analyst experience in Analyzing, Designing, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions
• Data - driven and Analytical minded with proven ability in providing solutions to challenging data problems.
• Currently working on data modeling, dashboard implementation using Power BI and SQL, Analysis of ERP- Microsoft Dynamic Nav data, process flow.
• Experience inAd-hocreports, data driven subscription reports by usingReport Builder.
• Expertise in Python programming to create end to end Data pipeline (data cleansing / wrangling / manipulation / output generation), integration with MongoDB, third party web API, Data processing from various file type.
• Implemented Machine Learning Algorithms in python: Linear (Multiple)/Logistic Regression, Neural network, Support Vector Machine, Multilayer Perceptron (MLP), Decision Tree, NLP, Naive bayes, K means, KNN using libraries (Pandas, NumPy, SkLearn, spaCy, Matplotlib).
• Developed a Web Crawler using R Programming Language (RCurl, XML, stringr, httr).
• Developed Java code for Hadoop/YARN systems and hosting Hadoop using Oozie Workflow XML
• Experience in big data technologies like Hadoop, Map reduce, Oozie, Yarn, Hive, Pig, Hbase, Spark, and HDFS.
• Experience in AWS services: Lambda function for format conversion, transformation, enrichment,S3 for storage, Redshift for data warehousing
• Expertise in data modelling, predictive modelling using Rapid Miner and JMP SAS.
• Developed United Nation - Crisis Response Unit dashboard using Tableau, SQL and python.
• Hands on experience in database design and advance SQL (Functions, Triggers, Stored Procedures and Views).
• Expertise inPower BI, Power BI Pro
• Proficient in using sql new features likeRanking Functions, PIVOT/UNPIVOT, XML PATH,Physical, logical database designand Performance tuning.
• Knowledge of SAP Sales and Distribution, Material Management and Business Data warehousing module.
• Good understanding of ETL, data warehousing, Corporate Finance concept.
• Good understanding of high-performance computing architectures, parallel applications, grid/cloud computing.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) usingWaterfallandAgile methodologies.

TECHNICAL SKILLS

Tools: Power BI, AWS, Tableau, SAP (SD, MM, BW), SAS JMP, OLAP, Axure RP, Test Link, Bugzilla, ALM, Rapid Miner, Advance Excel (Pivot, H-Lookup, V-Lookup, Power query etc.), Google-docs, slides and sheets, Google Analytics, Jet Reports

Languages: Python, SQL, R Programming, JAVA Script.

Data Management: MS SQL Server, Big Data-Hadoop, Map Reduce, Spark, Hbase, Yarn, Oozie, Pig, Hive, MongoDB

Machine Learning: Linear Regression, Neural Networks, SVM, Decision Tree, Naive Bayes, KNN, K means, NLP.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Analyst

Responsibilities:

• Working with Finance, Sales, Inventory and Operations department head to define business reporting and forecasting needs.
• Developed Micro-ETL scripts to perform ad-hoc datasets analysis using Python.
• Developed python package using Sci-kit Learn,Sci-py, matplotlib, seaborne libraries for forecasting & prediction of customer sales information, inventory storage pattern, company cash flow, analysis of third party sales call information, web scrapping.
• Implemented Custom data extraction using SQL script, SQL stored procedures.
• Developed Power BI Data reporting model for Finance, Sales, and Purchasing and Operation departments.
• Implemented dashboard, reports using Power BI Features Natural Language Q&A, DAX Programming, M query, Power Pivot, Row level security, advance slicer sync.
• Developed Python programs to process web api hosted by third party marketing solution to generate and massage data for sales metric, usage metric, campaign metric etc.
• Create and maintain data pipeline architecture using Python program, MongoDB collection to generate dashboard and KPI.
• Implemented data pipeline using SSIS and python to integrate third party data /tools.
• Developed complex measures using DAX functions inPower BI and Power Pivot.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service
• Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
• Developed excel tool to identify margin and pricing impact.
• Developed daily, weekly, monthly and Adhoc interactive reports using Dynamic Nav BI solution Jet reports.

Environment: Windows OS, ERP- Microsoft Nav Vision, SQL Server, SSIS, Power BI PRO, Python, Jet Reports, MS Office tools ( Word, Excel, PowerPoint, Access)

Confidential, NY

Data Analyst

Responsibilities:

• Used Tableau software to design and develop a customized dashboard prototype to strengthen analytical and visualization needs of UNDP country offices and headquarters
• Proactively identified additional data sources, managed data flows to support crisis risk analysis, performed data modeling and database query development using excel power query and advance SQL
• Innovated and improved upon Crisis Response Dashboards by improving dashboard interface and data visualization
• Utilized SQL server reporting services and SQL Server Integration Services to develop and maintain reports
• Data Migration/integration, analysis and reporting functions using SSIS, SSAS and SSRS.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ER Studio
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Implemented python function to process .csv file to analyze data distribution and categorization in survey data sets.

Environment: Windows OS, Tableau, SQL Server, Python, MS Office tools (Word, Excel, PowerPoint)

Confidential

Data Analyst

Responsibilities:

• Worked with various stakeholder to understand requirement.
• Created analysis document, data mapping document, data flow document.
• Define business processes for development of android application.
• Developed logical and physical data models for schemas
• Developed Create Table Script, Bulk Insert data script, Grant script
• Cleansed, modeled and analyzed the structured and unstructured customer provided data.
• Generated custom reports to analyze app transactions, availability and adaptability using Excel and Tableau.
• Developed SQL function stored procedure to generate Adhoc report
• Developed Power BI dynamic interactive Dashboard.
• Integrated data from multiple source flat file, excel, CSV, XML, Json.
• Designed, created and reviewed primary objects such asviews,indexesbased on logical design models, user requirements and physical constraints

Environment: Windows OS, Waterfall, MS Office tools (Word, Excel, PowerPoint, Access), Python, Tableau, SQL Server, Bugzilla

Confidential

Business / Quality Analyst

Responsibilities:

• Analyzed business requirements, completed end-to-end software testing to understand VNS health application process,
• Identified gaps, continuously addressed and refined the existing process to improve upon application quality
• Analyzed existing application data to identify the root cause of critical functional issues
• Create Queries to extract and understand data pattern.

Environment: Agile-SCRUM, Microsoft Tools, ALM, SQL Server, MS Office tools (Word, Excel, PowerPoint)

Confidential

Business /Quality Analyst

Responsibilities:

• Created AWS EC2 instance, verified and validated backup data on cloud
• Created and executed SQL queries for data verification, comparison, and report generation.
• Used UNIX commands to perform various product initiation function.
• Performed Installation and configuration of “Centos” Linux operating system.
• Applied analytical, documentation skills to documented Business Requirement, System Analysis, System feasibility, software testing process and user manual.
• Created SQL queries to extract and understand data pattern
• Created SQL Function, procedure as per the requirement.

Environment: Bugzilla, Agile-Scrum, UNIX, AWS, SQL server, MS Office tools (Word, Excel, PowerPoint, Access)