SUMMARY:

• 5 Years of experience as a Data analyst with a Double Master’s Degree in Information systems and strong knowledge in SQL programming
• Extensive experience in developing various real - time dashboards and reports using different Data visualization tools like Qlik Sense, Tableau, Power BI and Power pivot etc.
• Good working experience with different ETL tools like Alteryx, Talend, SSIS, Apache Nifi and Informatica and have ability to manage multiple projects in parallel during time critical solutions and never missed a deadline
• Proficient in various BI tools like Qlik sense (Trained), Tableau, Power BI and Power pivot
• Proficient with different database methodologies

TECHNICAL-SKILLS:

Expertise: Experienced Data Analyst with a demonstrated history of working in the information technology and services industry. Skilled in SQL, PowerPivot, Alteryx, Talend, SSIS, Qlik Sense, KPI metric development, Power BI and SAP business objects dashboard development.

Software Development Model: Agile (Scrum), Waterfall, Other

Software: Microsoft SQL server, Microsoft Visual studio (SSIS, SSAS), Microsoft SSDT, Ubuntu Server, MS Visio.

Databases: SQL, MYSQL, PostgreSQL, Oracle SQL developer (Linux/ windows), MongoDB, Vertica (Linux)

Data (ETL) & BI tools: Qlik Sense, Alteryx, SSIS, Talend, Apache Nifi, Tableau, power BI and power pivot

Other: JIRA Client/ Web, MS project management, Business development skills

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville

Responsibilities:

• SQL Data analysis for report building and gap analysis
• Performing and documenting data analysis, data validation using SQL, and data mapping/design.
• Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.
• Communicating requirements to Users and allotting them within the project.
• Rebuilding and developing ETL processes from SQL to SSIS for productive environment
• Reviewing and improving existing systems and collaborating with teams to integrate new systems.
• Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.
• Creating tools to store data within the organization.

Confidential, Tampa

Responsibilities:

• Design, build and maintain all components of data warehouse which includes numerous numbers if ETL processes, stored procedures, reporting environments, dashboards, scorecards, ad hoc requests on regular basis- monthly, quarterly and daily utilizing SQL as a language to communicate
• Develop huge number of ETL processes for error handling, data manipulation, data preparation using SSIS, Qlik Sense and Alteryx using SQL server management console/ database
• Rebuilding and developing ETL processes from SSIS to Alteryx for productive environment
• Utilizing SAP business objects in designing and building the reporting environment
• Developing executive summary, departmental and provider independent dashboards using SAP business objects and later migrating it into Qlik Sense
• Hands-on professional with thorough knowledge of ETL, Data modeling scripting and SQL
• Translating business requirements into Qlik based solutions and Tableau solutions into SSIS solutions
• Understanding of healthcare procedures and management, knowledge of enterprise Data warehouse (EDW) and data management systems
• Carried out modifications of various KPI metrics depending upon the requirements and definitions requested
• Handled various Healthcare research and reporting projects utilizing required tools

Confidential, MA

Responsibilities:

• Carried a research program on comparing different (ETL tools) Data loaders - Talend, Apache Nifi
• Integrated datasets from Oracle and Vertica into Vertica database
• Generated Task scheduling reports and to collect, organize, analyze, and disseminate significant amounts of information
• Created dashboards, reports, visualizations and analytics using Qlik Sense followed by ETL to integrate different data subsets from 4 different databases SQL server, MySQL, Postgres and Oracle
• Carried Data visualization and analysis on Data sources provided using Qlik Sense and accessed reports generated through Qlik sense cloud
• Automated the manual data loading procedure using Apache Nifi / Talend
• Produced reports and created dashboards using Tableau, Qlik sense and Ad hoc
• Developed Dimensional data modelling, familiar with snow, star, dimensions and facts, Qlik sense analysis
• Developed meaning insights using Tableau, Qlik view and power BI
• Created ETL scripts under Vertica and Oracle database platform, cleared dataset anomalies using SSIS and SSAS
• Carried Data integration tasks on Qlik Sense management console

Confidential, Dublin, IR

Responsibilities:

• Performing data analysis, data collection systems and other strategies that optimize statistical efficiency and quality
• Acquiring data from primary or secondary data sources and maintaining databases where I got to perform analytical research on three different teams and their productivity
• Using Business analyst tools like JIRA and Microsoft program manager sheets to keep a track on the performance of the teams in order to calculate the productivity
• Final stage involved developing Dashboards using Power BI based off of the analysis performed on the teams and updating the Data with in the private cloud and later on hybrid cloud using Company’s credentials

Confidential, Dublin, IR

Responsibilities:

• Carried a research program on comparing different ETL tools for further development on hybrid cloud data
• Integrated different installation packages on one operating system to observe the processing time
• Developed visualizations and analytics using Tableau and power pivot to figure out the memory limits of private cloud

Confidential

Responsibilities:

• Develop dashboards using power BI and Excel power pivot
• Login the data generated by an automated report into the system
• Schedule the reports developed and tweak the reports using SSIS scheduler when they do not run properly
• Migrated 15 scheduled jobs which were reports running through Webi business objects and have been scheduled daily using Alteryx for Data integration and Qlik sense for the dashboards.
• Delivered Data to one of the finance department using Qlik Sense dashboards
• Had to cut and alter data from an unfamiliar source and had to come up with a good presentation for future dashboard requirements
• Developed numerous numbers of reports during the project transition and migration process
• Successfully came up with a logic that changed our departments scenario on scheduled appointments - made it available for all the physicians and executives interested.

Confidential

Data analyst

Responsibilities:

• Implemented exploratory data analysis, feature engineering, feature transformations, feature extraction, missing value imputations, cross-validation and model ensembles for better accuracy using Tableau.
• Applied different predictive models like Logistic regression and Random Forest to predict survivors from Titanic shipwreck.
• Obtained target data through integration from source databases such as SQL, MySQL, PostgreSQL and Oracle through Talend and SSDT (SQL server Data tools), accessing source data given in different formats and create a target database
• Provided required data by running different Queries in all the databases and displayed the results set by generating reports through Microsoft Power BI, Qlik sense cloud/ Qlik sense Desktop, Tableau and Power pivot
• Created dimensional data models for the different data subsets of a school database, created OLAP (SSAS) cube for each data model, created meaningful queries for each of the module on all the databases, applied KPIs in business analysis, developed dashboards and performed Data visualization through Microsoft Power BI, Qlik sense cloud/ Qlik sense Desktop, Tableau and Power pivot, generated DDL script based on the model in Toad