SUMMARY:

• Data analyst with 5 years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical figures.
• Knowledge in all phase of SDLC like Requirement Analysis, Implementation and Maintenance and Good experience with Agile and Waterfall.
• Good knowledge in a Python - based environment, along with data analytics, data wrangling and Excel data extracts and Familiar with Pandas, NumPy, matplotlib and SciPy.
• Good in developing different Statistical, Text Analytics, Data Mining solutions to various business generating and problems data visualizations using Python, R and Tableau.
• Understanding of Data Warehousing principles like Fact Tables, Dimensional Tables, Dimensional Data Modelling - Star Schema and Snow Flake Schema.
• Knowledge in writing, testing, and implementation of the triggers, procedures, functions at database level and form level using PL/SQL.
• Extensive experience in ETL Design - Informatica Power Center, SSIS for Extraction, Transformation & Loading.
• Analyzing web traffic by performing data mining and web-analytics and predicting the behavior of customer with the help of Google Analytics.
• Knowledge on maintaining and managing Tableau and Power BI driven reports and dashboards.
• Having good Knowledge with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLAP.
• Created Drill down Reports, Parameterized Reports, Linked Reports and Sub Reports apart from generating Ad-hoc Reports . using SSRS .
• Experience with different Relational databases like Oracle, MySQL and SQL Server.
• Used ERWIN to design Logical and Physical Data Models, to forward and reverse engineering data models and publishing data model to acrobat PDF files.
• Expertise in Excel, Pivot Tables, VLookup and other advanced functions.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Hands-on experience with MS Visio to create use case diagrams, data flow/process flow diagrams such as flowcharts, activity charts, sequence diagrams as per UML.
• Considerable Experience in working on different operating Systems like Windows and Linux.
• Good Leadership, Technical, Communication, Analytical and Problem-Solving skills and ability to get on well with people including cross-cultural backgrounds.

SKILL:

SDLC, Agile, Waterfall, Python, R, Tableau, MSBI, NumPy, pandas, SciPy, SAS, MySQL, Oracle, Erwin, Pivot tables, VLOOKUP, MS SQL Server, ETL, SSIS, Informatica, SSRS OLAP, PL/SQL, T-SQL, Excel, Google Analytics, MS Visio, Windows, Linux

EXPERIENCE:

Confidential, NY

Data Analyst

Responsibilities:

• Worked in Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings and profiling result.
• Produced operational reports in SSRS i.e. drill-down, drill-through, dashboard and matrix reports.
• Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Generating various capacity planning reports (graphical) using Python packages like NumPy, matplotlib, SciPy.
• Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server and Oracle.
• Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics and statistical analyses.
• Designed and implemented end-to-end systems for Data Analytics and Automation, integrating custom visualization tools using R, Tableau, and Power BI.
• Worked with business team to test the reports developed in OLAP.
• Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and Pivot Charts using Power Pivot skill.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment .

Confidential, NJ

Data Analyst

Responsibilities:

• Collaborate with Development team to support release planning, estimation and delivery processes using Agile methodologies.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• Worked in using collections in Python for manipulating and looping through different user defined objects.
• Delivered data solutions in report/presentation format according to customer specifications and timelines.
• Data Analysis, logical, physical and Data Modeling for OLAP systems.
• Performed backend testing by writing SQL Queries to verify data Integrity.
• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union and Execute SQL Task to load into database.
• Created remote SAS sessions to run the jobs in parallel mode to cut off the extraction time as the datasets were generated simultaneously.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Produced variance reports, Excel graphs, charts, presentations in PowerPoint.
• Creating test cases for ETL mappings and design documents for production support.
• Used Microsoft Visio model business processes using UML to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.

Confidential

Data Analyst

Responsibilities:

• Involved in requirements gathering, Analysis, Design, Development, testing production of application using Waterfall model.
• Involved in the entire data science project life cycle and actively involved in all the phases including data cleaning, data extraction and data visualization with large data sets of structured and unstructured data, created ER diagrams and schema.

• Data Warehousing principles like Fact Tables, Dimensional Tables, Dimensional Data Modelling - Star Schema and Snow Flake Schema.
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Created reports using formulas such as VLookup and pivot tables.
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Monitored company’s website UX and traffic using Google Analytics to improve inefficiencies and identify trends.
• Used Microsoft Visio model business processes using UML to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.
• Maintained data dictionary by revising and entering definitions.
• Responsible for Power BI Data Quality and Worked on data mining and data profiling.
• Used statistical analysis techniques to analyze data and prepared Dashboards in Excel.