Candidates About

 

Arjuman Afreen

_________________________________________________________________________________________

PROFESSIONAL SUMMARY

·         Dedicated technology centric Microsoft Business Intelligence Developer with over 7.5 years of experience in implementation of Database systems in Finance, Banking, Health care and Retail Domain.

·         Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in Microsoft Product SQL Server 2008/2008R2/2012/2014 with expertise on data normalization, denormalization and understanding of SDLC lifecycle and methodologies like Agile, Scrum, Waterfall.

·         Extensive experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau and good knowledge on SQL Server Analysis Services (SSAS).

·         Expertise in Creating, Populating and maintaining Data marts. In depth knowledge of Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

·         Expertise in Data Warehousing Concepts like Ralph Kimball

·         Proficient in creating database objects using Complex SQL queries like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

·         Expertise in writing complex T-SQL queries using advanced features of Microsoft SQL Server like CTE, Merge, Multiple Joins and Sub queries.

·         Experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

·         Proficient in Data Scrubbing, Data Cleansing, data validation checks during Staging, before loading the data into the Data warehouse. Used ETL packages to apply control flow tasks (For loop, For each loop, Execute SQL task) and data flow tasks using various transformations (Conditional Split, Data Conversion, Look up, Derived Column, Merge, Union all).

·         Experience in design and development of interactive data visualizations, graphical dashboards and reports using tools like Tableau, SSRS, Power BI

·         Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server to build customized and interactive dashboards

·         Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.

·         Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.

·         Extensively worked on different types of tests such as Unit testing, System testing/Integration testing, Regression and Acceptance Testing.

·          Knowledge on Big data/Hadoop concepts

·         Good exposure in implementing object oriented programming(OOPS) like C++, C#, Java, Python, R, design patterns, cloud services such as AWS

·         Quick learner, Excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

 

EDUCATIONAL QUALIFICATION

Masters in Computer Science & Engineering

 

TECHNICAL SKILLS

Databases	SQL Server, Teradata 12, Microsoft Access
ETL Tools	SSIS, DTS, BIDS
Reporting Tools	SSRS, Tableau 9.x, Power BI
Data warehousing Tools	Master Data Services (MDS), Data Quality Services (DQS), SSAS, ERWIN, Visio
Coding Languages	C++, C#, SQL, T-SQL, Python, R, JAVA
Methodologies	Agile, Waterfall, Scrum
Operation Systems	Windows, UNIX.

 

 

PROFESSIONAL EXPERIENCE

CareSource, Dayton, OH                                                                                                    05/17-Present

Sr. MSBI Developer

Project: CareSource provides public health care programs including Medicaid and Medicare. The main goal of this project is to provide the Data Integration for various Line of Business using SSIS.  Develop regulatory reports for Indiana, Georgia LOB using SSRS.

·         Collected business requirements from users and translated them as technical specs and design docs for development.

·         Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

·         Extensively used SSIS to move data from text files to SQL Server.

·         Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.

·         Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)

·         Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

·         Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

·         Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

·         Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel, Oracle.

·         Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

·         Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and dashboards involved in analyzing multi-dimensional reports in SSRS.

·         Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.

·         Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

·         Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

·         Involved in implementation of entire Testing life cycle. Followed the Agile/Scrum process. 

·         Experience in using Automated Deployment tools like Teamcity and Octopus

·         Ensured HIPPA and regulatory compliance rules are addressed for all data movement

·         Good knowledge of HIPAA security and privacy guidelines.

Environment: MS SQL Server 2014, Excel, SQL, T-SQL, SQL BI Suite (SSIS) MS Office, Microsoft Visual Studio 2014, Microsoft Visio, TeamCity, Octopus, Agile/Scrum

 

PNC Bank, Centerville, OH                                                                                               05/15-Present

MS SQL BI (SSIS, SSAS, SSRS)/Tableau Developer

Project: PNC is a Multinational banking and financial services in America. The goal of the project is to create, maintain and administer ETL and reporting jobs using Tableau to generate reports for risk management department. To analyze key business metrics such as customer growth, assets management, loan loss, so on using tableau reporting.

Responsibilities:

·         Collected business requirements from users and translated them as technical specs and design docs for development.

·         Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

·         Extensively used SSIS to move data from text files to SQL Server.

·         Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.

·         Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)

·         Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

·         Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

·         Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

·         Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel, Oracle.

·         Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

·         Created Source Target mappings for migrating on-Premise DataMart to SQL Azure.

·         Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.

·         Created Tableau reports for different processes on Home Loans Servicing

·         Designed & developed various departmental Tableau reports by using SAS, Netteza and Teradata Sources

·         Involved in implementation of entire Testing life cycle. Followed the Agile/Scrum process. 

·         Designed Cubes with Star Schema using SQL Server Analysis Services 2014(SSAS).

Environment: MS SQL Server 2014, Excel, SQL, T-SQL, SQL BI Suite (SSIS, SSAS, SSRS), MS Office, Microsoft Visual Studio 2010, Microsoft Visio, Tableau Desktop/Server, Agile/Scrum

 

 

Progressive Insurance, Pittsburgh, PA                                                                                01/14-04/15

BI (SSIS, SSAS, SSRS)/Tableau Developer

Project: Implementation of ETL workflows for integration of data using SSIS and various analytical engines, Claim Management System (IMS). Primary technologies included SQL Server 2012 SSMS, SSRS, SSIS and Tableau Desktop.

Responsibilities:

·         Actively participated in interaction with Users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.

·         Transformed business requirements to data flow diagrams and process flow by extensively using Microsoft Visio.

·         Created and maintained the database for all the data, Implemented Data Warehousing Concepts using Ralph Kimball Techniques

·         Worked on complex SQL queries like stored procedures, triggers and also on large number of business analytical functions.

·         Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Hands-on training in the use, maintenance, and development of databases using MS SQL Server.

·         Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

·         Created SSIS Packages using SSIS Designer for export heterogeneous data from Excel Spreadsheet to SQL Server using Visual Studio.

·         Worked with Inbuilt Transformations in ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.

·         Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.

·         Extensively used Excel for in-built data functions for data analysis and reporting

·         Deploying, Testing and Scheduling SSIS packages using SQL Agent.

·         Designed and developed a business intelligence dashboards using Tableau Desktop, allowing executive management to view past, current and forecast sales data.

·         Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

·         Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

·         Extensive experience in creating dashboards using calculations, parameters in Tableau.

·         Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.

·         Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.

Environment: MS SQL Server 2012, Excel, T-SQL, PL-SQL, SQL BI Suite (SSIS, SSRS, SSAS), MS Office, Visual Studio 2010, Tableau Desktop/Server, Agile/Scrum

 

Paypal, Santa Clara, CA                                                                                                           05/12-11/13

MS SQL BI Developer (SSIS, SSAS, SSRS)

Project: The scope of this project is to provide the integration of data through BI Suite and develop reports and dashboards using SSRS

Responsibilities:

·         Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements. 

·         Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations

·         Developed SQL Scripts for data validation, manipulation and reporting services

·         Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages using Visual studio.

·         Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.

·         Created checkpoints and configuration files in SSIS packages

·         Experienced in slowly changing dimension in SSIS packages.

·         Deploying, Testing and Scheduling SSIS packages using SQL Agent.

·         Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.

·         Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and dashboards involved in analyzing multi-dimensional reports in SSRS.

·         Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.

·         Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

·         Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

·         Tested all ETL packages, various types of testing like Unit, Regression and System.

Environment: MS SQL Server 2012, SSRS, Teradata SQL Assistant, SQL, T-SQL, UNIX, Microsoft office Suite (Word, Excel, PowerPoint), Agile/Scrum

 

Macy’s, New York, NY                                                                                                                11/10-03/12

BI Developer (SSIS, SSAS, SSRS)

Project: The Project mainly involved Designing, creating, and maintaining database. It also includes developing and maintaining SSIS packages and creating reports using SSRS.

Responsibilities:

·         Responsible for gathering requirements for the database designing for the middle office with the Data Architect.

·         Developed SQL Scripts for data validation, manipulation and reporting services

·         Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults. Used multiple join statements to retrieve data from multiple tables using complex SQL queries

·         Developed SSIS ETL Packages using multiple data sources (SQL Server, Flat Files, Excel Source files, etc.) and then loaded the data into destination tables by performing different kinds of transformations.

·         Extensive experience in usage of SSIS Control Flow items (For Loop, for each loop, execute package/SQL tasks, Script task, and send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

·         Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, Transaction, and package configurations and Logging for Complex SSIS Packages.

·         Created reports using SQL Server Reporting Services (SSRS) as per user requirements.

·         Designed various reports like charts, drilldown, drill through and matrix reports based on the user requirements using SQL Server Reporting Services (SSRS).

·         Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2, Teradata, SQL, T-SQL, UNIX, Microsoft office Suite (Word, Excel, PowerPoint).

 

IBM India, Hyderabad                                                                                                            06/08-07/10                                                                                       

MS SQL BI Developer

Project: Data is extracted from the transaction systems, put into the Data Warehouse, and it is then accessed and analyzed using SSIS and generate input data for various Systems. Responsibilities:

·         Involved in gathering and analyzing of Business Requirements by interacting with end users.

·         Developed SQL Scripts for data validation, manipulation and reporting services

·         Worked as a SQL developer to write complex SQL queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

·         Involved in creating of T-SQL Stored Procedures, Triggers, Views.

·         Create joins and sub-queries for complex SQL queries involving multiple tables.

·         Used DDL and DML for writing triggers, stored procedures, and data manipulation.

·         Performance tuning and testing on stored procedures, indexes and triggers.

·         Expert in creating multiple kinds of Reports and Dashboards using SSRS.

·         Involved in writing MDX queries for cubes and Performance optimization of MDX queries.

·         Designed & created OLAP Cubes with Star schema using SSAS.

·         Used Execution Plan, SQL Profiler, tuning SQL queries and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

·         Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Environment: MS SQL Server 2008, T-SQL, SSIS, SSAS, Excel, Agile