SUMMARY

• 3+ years of IT experience in the field of Data analysis , ETL Development, Data Modeling, and Project Management.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins. Experience in working with both Agile and Waterfall methodologies .
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Experience in developing different Statistical Machine Learning Models, Text Analytics and Data Mining solutions to various businesses and generating data visualizations using Python, R and Tableau .
• Design & Implementation of Data Extraction, Transformation & Loading (using SQL Loader, Informatica & other ETL tools ), Analysed Oracle & SQL Server Data & Migration of the same.
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization, data extraction, data cleansing , data manipulation.
• Proficiency in multiple databases like , MySQL, ORACLE and MS SQL Server .
• Expertise in creating complex SSRS reports against OLTP, OLAP databases.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, etc. involving multiple tables and exception handlers. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables along with Performance Tuning and Query Optimization.
• Experience in Tableau (Desktop, Server, Reader, Mobile) as a Developer and Analyst .

TECHNICAL SKILLS

Languages: SQL, R, Python, C++, Matlab

Web Technologies: HTML5, CSS3, Javascript

Cloud Technologies: AWS Dynamo DB, AWS S3, AWS RDS, AWS VPC

Databases: SQL Server, MySQL, Teradata

Reporting Tools: Tableau, Power BI, SSRS

ETL Tools: SSIS, SSAS, Informatica

Tools: MS Office, PowerPoint, MS Visio, GitHub, TFS, Pivot Tables

Python Libraries: Scikit, pandas, NumPy, NLTK, SciPy, matplotlib

Methodologies: SDLC, Agile, Scrum, Waterfall, RUP

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, FL

Data Analyst

Responsibilities:

• Involved in every phase of the SDLC process starting from Inception to Transition.
• Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Involved in the below phases of Analytics using R, Python and Jupiter notebook .
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used SSIS for data population from different sources and create SSIS packages for data conversions and load data from flat files and vice versa.
• Built multifunction readmission reports using python pandas and Django frame work.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharing, replication, schema design, etc. Performed analysis on implementing Spark using Scala and wrote spark sample programs using PySpark .
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh. Worked extensively with Advance Analysis using Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies and sets to create detail summary report and Dashboard using KPI's.
• Worked on Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation.
• Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality . Worked on Cloud automation using AWS Cloud Formation templates.
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Worked on Design and deploying rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau .

Confidential

Data Analyst

Responsibilities:

• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Defined the key identifiers for each mapping/interface.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Extensively used SQL for accessing and manipulating database systems.
• Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created ad-hoc reports using SQL server Reporting Services (SSRS).
• Used Erwin and Visio design to create Data Models for various kind of databases as per the requirement.
• Used different Python libraries for data analysis and visualization of decision-making.
• Responsibilities included roadmap, development and implementation of real-time risk and pricing models, maintenance and development of analytical calculation framework. Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.
• Created and managed scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.