SUMMARY

• Professional qualified Data Analyst with around 6+ years of experience in Data Analytics including Data Mining,Deep Learning/Machine Learning, and Statistical Analysis.
• Strong experience in gathering business requirements from business/user, source to target mapping, creating source to target mapping document, creating process flows, and DFD.
• Expertise in designing and creating various analytical reports and dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in using various packages in R and python - like ggplot2, NumPy, Pandas, Matplotlib, SciPy for Data Analysis, and Model Building.
• Good experience in creating visualizations, interactive dashboards, reports, and data stories using Tableau, Power BI.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing, and Performance Tuning using QlikView.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS
• Expertise in using Linear&Logistic Regression and Classification Modeling, Decision-trees, Principal Component Analysis (PCA), Cluster and Segmentation analyses, and have authored and co-authored several scholarly articles applying these techniques.
• Extensive experience in Text Analytics, developing different Statistical Machine Learning, Data mining solutions to various business problems, and generating data visualizations using R, Python, and Tableau.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Informatica Power Center and Data Stage.
• Worked with heterogeneous relational databases such as Teradata, Oracle, MS Access, and SQL Server.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1, and Visio 10.0.
• Experienced in using the IDQ tool for applying rules and develop mappings to move data from source to target systems.
• Expertise in a broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy, Data Warehouse, Data Modeling,and Design
• Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts, and Project Manager.
• Well-versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\SQL Scripts.
• Excellent communication, documentation, and presentation skills with a clear understanding of business process flow.

TECHNICAL SKILLS

Programming Language: R, SQL (PostgreSQL, MySQL, Oracle), Python (pandas, NumPy, Matplotlib, Scikit-learn), HTML, CSS, JavaScript, D3.

DataModeling Tools: Erwin, Visio, IBM Infosphere, Data Architect, IBM Rational Rose, Power Designer, and ER Studio

BI & Reporting tools: Business Objects, Cognos, SSRS, Crystal Reports

MS-Office Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

Visualization: Tableau, PowerBI, Qlik Sense, AWS Quicksight, Adobe Analytics

Databases: MySQL, SQL Server, Oracle RDBMS, MongoDB, Teradata, Cassandra, NoSQL, PostgreSQL, SSIS

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Big Data: Apache Spark, HDFS, MapReduce, PySpark.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Data Analyst

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Participated in all phases of data preparation; data collection, data cleaning, validation, visualization, and performed Gap Analysis.
• Consumed a large volume of complex datasets stored in different databases and Infocubes in BW to create visualizations.
• Designed self-service reports using Power BI Desktop highlighting key performance indicators providing business insights.
• Utilized DAX functions to create calculated tables, columns, and measures and published the report for decision making.
• Interaction with Business Analyst,SMEs, and other executive stakeholders to understand Business needs and functionality for various project solutions
• Implemented end-to-end systems for Data Analytics, Data Automation, and integrated with custom visualization tools using Tableau.
• Recommended analytic solutions for Extra care Card program, that enable a comprehensive understanding of customer behavior within or across segments, markets or other defined logical groupings.
• Produced customized customer-centric reporting by pulling data from Teradata database. Assessed the request for information and developed there porting to provide the data.
• By means of complex SQL queries, performed ETL on large datasets, apply data hygiene, reconciled matched tables, performing data auditing and validation.
• As a part of Customer Research & Marketing Analytics team, evaluated business needs, derived actionable insights from customer POS & E-commerce data to help business teams take informed decisions.
• Worked collaboratively with multiple internal teams like Sales & Operations, Retail and Marketing, to identify critical business requirements for reporting and conducted regular ad-hoc data analysis.
• Analyzed program performance trends to identify opportunities for operational or measurement enhancements.
• Created XML schema definitions (XSDs) with the XMLSpy tool and converted them into Informatica metadata.
• Created Data Stage jobs to extract, transform, and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files, etc.

Environment: Informatica Power center, ERWIN, PL/SQL, ETL Data Validation, Cube Testing, Report testing, OLTP, SDLC, Pandas, NumPy, Seaborn, Data Marts, MicroStrategy, UAT, Python.

Confidential, California

Data Analyst

Responsibilities:

• Involved in the entire data Migration process from analyzing the existing data, cleansing, validating, translating tables, converting, and subsequent upload into the new platform.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Implemented Forward engineering to create tables, views and SQL scripts, and mapping documents.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user's understanding of the data warehouse objects
• Worked with BAs in an open season project using FACETS MEET.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analysts to design weekly reports using a combination of Crystal Reports.
• Identified existing data models and documented suspected designs affecting the performance of the system.
• Extracted data from databases like Oracle, SQL Server, and DB2 using Informatica to load it into a single repository for data analysis.
• Involved in the development and implementation of SSIS, SSRS, and SSAS application solutions for various business units across the organization.

Environment: Oracle SQL Developer, Oracle Data Modeler, Teradata, SSIS, Business Objects, Teradata, Oracle 10g, SQL server 2012, SQL Assistant, data stage 8.1, DB2, Informatica Power Center.

Confidential - Lisle, IL.

Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record required to define the asset data for financing
• Performed Data Analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Developed normalized Logical and Physical database models for designing an OLTP application.
• Developed new scripts for gathering network and storage inventory data and make Splunk ingest data.
• Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company
• Created tables in Hive and loaded the structured (resulted from Map Reduce jobs) data
• Using HiveQL developed many queries and extracted the required information.
• Exported the data required information to RDBMS using Sqoop to make the data available to the claims processing team to assist in processing a claim based on the data.
• Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Extracted data from the database using SAS/Access, SAS SQL procedures, and create SAS data sets.
• Created Teradata SQL scripts using OLAP functions like RANK () to improve the query performance while pulling the data from large tables.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design, etc.
• Designed and implemented reports for Healthcare Accreditation, NCQA (National Committee for Quality Assurance)
• Performed Data analysis using Python Pandas.
• Good experience in Agile Methodologies, Scrum stories, and sprints experience in a Python-based environment, along with data analytics and Excel data extracts.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Hive, HDFS, Flume, Sqoop, R connector, Python, R, Tableau 9.2.

Confidential - Rochester, MN.

Data Analyst

Responsibilities:

• Performed exploratory data analysis using NumPy, matplotlib, and pandas
• Expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand trends and insights.
• Experience analyzing data with the help of Python libraries including Pandas, NumPy, SciPy, and Matplotlib.
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts and Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts) as well as gathered analytical data to develop functional requirements using data modeling and ETL tools.
• Read data from different sources like CSV file, Excel, HTML page, and SQL and performed data analysis and written to any data source like CSV file, Excel, or database.
• Used the Lambda functions like filter (), map (), and reduce () with pandas Data Frame and perform various operations.
• Used Pandas API for analyzing time series. Creating a regression test framework for new code.
• Extensive knowledge in loading data into charts using python code.
• Using High charts, passed data and created interactive JavaScript charts for the web application
• Extensive knowledge in using python libraries like OS, Pickle, NumPy, and SciPy.

Environment: Python, PyQuery, HTML5, CSS3, Apache Spark, Django, SQL, UNIX, Linux, Windows, Oracle, NoSQL, PostgreSQL, Python, PySpark, NumPy.

Confidential

Data Analyst

Responsibilities:

• Used Waterfall methodology throughout the project, Involved in weekly and daily basis release management.
• Worked on CSV files while trying to get input from the MySQL database.
• Generating various capacity planning reports (graphical) using Python packages like NumPy, matplotlib.
• Implemented Data exploration to analyze patterns and to select features using Python SciPy.
• Validated the system End-to-End Testing to meet the Approved Functional Requirements.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database, and providing exacted data as an input to Tableau.
• Responsible for making growth model for the organization by segmenting advisor using quadrant analysis in Tableau.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access and Oracle.
• Planned monthly and quarterly business monitoring reports by creating Excel Pivot summary reports to include System Calendars.

Environment: Agile, Python, Jupyter notebook, Spyder, EC2, NumPy, Matplotlib, MS Excel, OLTP, MySQL, JIRA, Git.