Arpita Kadre

addglu@r.postjobfree.com

© 832-***-****

CAREER GOAL

To be a part of a growing organization as an ETL developer and aid in accomplishment of organizational objectives by utilizing my knowledge in ETL processes, C#, HTML scripting, SQL and PL/ SQL.

TECHNICAL SUMMARY

Master’s Degree in Computer Science with 5+ years of IT work experience in application development and data warehousing team.

Expertise in MS SQL Server suite of products SSIS, SSRS and SSAS.

Remarkable experience in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Extensive experience in creating SSAS OLAP Cubes by constructing fact and dimension tables

Strong ETL experience from different sources like Oracle/Access/Excel/SQL server using SSIS/DTS

Experience in design and implement processes for deploying and extracting data for reporting and creating several types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL access using SSRS and Crystal report

Working experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Migrated Organization, Building Data Integration, Objectives and data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints to develop ETL mechanisms.

Worked in working on a Scrum Team or Agile environment

Experience for using share point for creating workflows.

Working knowledge in developing N-tier web applications within ASP.NET web forms, C#.NET, ADO.NET, WCF, HTML/CSS/jQuery/Bootstrap, Visual studio 2017/2019, SSDT.

Experience using Team foundation server (TFS) for Source Control.

Technical Skill & Expertise

RDBMS: SQL SERVER 2008/2012/2016/2019, Oracle 11g.

Database Tools: SQL Query Analyzer, SQL Developer including PL/SQL, SQL server Management Studio

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).

Software Languages: HTML, CSS, JavaScript-SQL, PL/SQL, C#, .NET

Web Technologies: ASP.NET, HTML, WCF

Tools: Visual Studio 2015/2013, TFS online (VSTS)

BI Tools: Power BI

Education Qualifications

Master of Computer Application, India

Bachelor of Commerce from G. H. College, India

Diploma of Computers Application G. G. Polytechnic, India

EXPERIENCE

Client: Commonwealth of PA, Office of Administration

Location: Harrisburg, PA

Position: SQL/BI Developer (ETL, Data Warehouse Developer)

Tools: Microsoft SQL Server Business Intelligence Development Studio (SSIS, SSRS & SSAS), Visual Studio 2015, SQL Server Management Studio 2016, Power BI

Technology: ASP.NET

Duration: March 2019- Aug 2019

Project Information: Microsoft Governance Project for Secretary of PA

Responsibility:

Involved in all the phases of the project automation of the processes for Agency delivery center from scratch and performed different roles in the different phases of the project.

Identified the dimensions, & Fact tables to design data mart.

Designed and developed the ETL solution using SSIS packages to implement slowly changing dimensions of Type 2 to populate current and historical data into Dimensions. ETL solution validated incoming data and sent notifications on job completion.

Designed and documented the error-handling strategy in the ETL load process. Prepared the complete ETL specification document for all the ETL flows.

Created Stored Procedures, User Defined Functions, Views. Created database triggers to check the referential integrity of the database.

The Customer data thus loaded in to data warehouse is utilized to generate reports using the SSRS reporting functionality.

Developed monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.

Created test data and unit test cases to ensure successful data loading process.

Worked on Azure dev ops in Repos and branches, Azure data factory and on SharePoint and deployment of package on On prem and on Azur.

Worked on Sql server 2019, database tables, stored procedures, relation model, dimensional model.

Performed major role in understanding the business requirements and designing, loading and extract the data into data warehouse from source using SSIS like exporting varbinary file from database to folder using SSIS export column transformation.

Using SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and Visual Basic scripts.

Developed various Power BI Dashboards.

Client: Commonwealth of PA, Department of Correction

Location: Mechanicsburg, PA

Position: ETL Developer (ETL, Data Warehouse Developer)

Environment: Microsoft SQL Server Business Intelligence Development Studio (SSIS, & SSRS), Visual Studio 2015, SQL Server Management Studio 2014, Power BI

Duration: March 2018 - Feb 2019

Project Information: Planning Research And Statistics (PRS)

Responsibilities:

Responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs.

Consolidate and optimize available data warehouse infrastructure.

Proactively gathers business requirements.

Works with architects and business partners to fashion out the technical vision for applications in Customer Data Warehouses employing SSIS, SSRS, and SQL Server.

Worked with high volume datasets from various sources like Oracle, Text files, flat file Relational Tables and xml targets. Responsible for mandatory checks, date field checks and number field checks in ETL packages.

Developed Power Bi dashboards.

Worked with Business Analyst and users to clarify requirements and documented to technical specification document for ETL processes and databases

Created new mappings and updating old mappings using VISIO.

Designed and developed database packages, procedures, functions and triggers on SQL Server database.

Used SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and Visual Basic scripts.

Developed Drill-through, Drill-down, sub Reports, Charts, Matrix reports, Linked reports using SSRS. Following Software development life cycle (Development, System Integration Testing, User Acceptance Testing and Production).

Client: Commonwealth of PA, Pennsylvania Municipal Retirement System

Location: Harrisburg, PA

Position: Application Developer III

Environment: Microsoft SQL Server Business Intelligence Development Studio (SSIS, & SSRS), Visual Studio 2015, SQL Server Management Studio 2012, Oracle 11g, SharePoint, Crystal Reports

Duration: April 2016 - Feb 2018

Project Information: Involved in various projects simultaneously

Responsibilities:

Understood the business logics and requirements and gained the knowledge of backend for CPAS software the client’s business tool for handling pension and retirement database.

Enrollment of new municipality with 150 members via adding their employer contribution and salary, Completed extraction of their salary history provided by the municipality, extract it from txt to excel file and conversion into CSV format to stored into CPAS database using control files. Made changes in control file according to data requirements. Did successfully accomplished the task.

Development for cost-of-living adjustment (COLA) database for pension administration system. In this process extract data from excel sheet and extract into of oracle data and from there transformation and successfully loaded into Production database using SQL Server 2012.

oUsed SSIS to export the data to flat files (CSV) from Oracle

oImport data into staging area of MS SQL Server based on new column name convention

oWorked on ETL process for using SSIS

oCompleted aggregation for cost for monthly summary using SSIS Aggregate transformation

oComplete COLA adjustment using MS Access form connected to SQL server back end

oCreate reports on SSRS and Power Bi presentation.

Worked on scrambled the data for CPAS new version build. In this process production data needs to scrambled and send to CPAS as the data has PI like SSN.

Worked with the Database Administrator to maintain the database to perform maintenance tasks before backing up the databases space issues and data backups..

Worked on Database backup and recovery, Data refresh for SANDBOX and ITSANDBOX environment for testing from production via running the script against database on Oracle 11g, Sql developer or on Toad. In this process, we use script to delete the old database from test environment and then add current production data into test environment.

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using Crystal reports and SSRS.

Experienced in creating many complex SSIS packages with complicated transformations.

Developed various access databases using macros, VBA code, and created user interface as per the client’s requirements.

Worked on designing of intranet page for client using Bootstrap and CSS.

For CAFR development (Yearly book edition of client): worked on arranging financial data plans and graph images. Worked on adobe in design for graphs, images, and picture resizing to fit into pages.

Worked on creating new database for Minimum Municipal Obligation (MMO) for Cash balance and Defined benefit via figuring out to use the control file appropriately given by CPAS system. did changes in bunch of Crystal reports, and did enhancement to the report related to the MMO-DB and MMO-DC. Did successful implementation of the work with the approval from top authorities.

Worked on to create multiple Access database like Actuary and 1099 database for IRS.

Analysis and development on GASB financial Data by plan database and GASB 68 Data Reconciliation to CAFR. Did via developing new database using linking of tables and did enhancement of forms and macros. Made new report and did some changes in old reports.

Made changes of Crystal Report for Accounting and Member Service departments and try to implement new logic using formula, commands and stored procedures as per the requirement from client to make it more user friendly and easy to use. Merging of reports with linking of their parameter.

Worked on benefit estimate reports, script for perc changes for municipalities like added new field to the existing report with all the calculations related to the field without affecting any previous calculation.

Worked on year-end tracking and reporting process, and made the changes into ranking form as per the client requirements.

Worked on quarterly database made batches to divide the work process so the four users can work simultaneously for larger municipality groups.

Worked on the CADS tool (an accounting tool for doing calculation out of the CPAS system) to do changes in Annual statement reports for individual person and for municipality.

Worked on Share point to create business workflows and tracking.

Client: The Unica Group

Location: Mechanicsburg, PA

Position: Intern for multiple projects.

Environment: Dot net, Sql server,Crystal report, Sql server reporting services(SSRS)

Duration: July 2015-March 2016

Project Information:

Project 1 Description: Food blog web site for a confidential client with HTML5 and asp.net technology

As responsive web design with team of 4 developer

Responsibilities:

Database modeling for food blog web site

Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.

Form based authentication and authorization for user

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created SQL Joins, sub-queries and other SQL code to implement business rule.

Used data access layer and WCF web services

Continue to test styles/methods to optimize all aspects of the website

Used Pagination in SQL server .

Created Stored Procedures in SQL Management Server.

Developed in-line queries and stored procedures to retrieve the information from the database.

Project 1 Description: Update the current company web site (http://www.unicagroup.com ) with new responsive design template (http://www.templatemonster.com/website-templates/39609.html) with HTML5 and asp.net technology

Created Pennyslvania Downtown Center web site using INSPINIA Template.

Responsibilities:

Database modeling for company web site

Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.

Form based authentication and authorization for user.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created SQL Joins, sub-queries and other SQL code to implement business rule.

Continue to test styles/methods to optimize all aspects of the website.

Used Pagination in SQL server

Created Stored Procedures in SQL Management Server.

Developed in-line queries and stored procedures to retrieve the information from the database.

Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.

Used data access layer and WCF web services

Client: PSA Infotech

Location: Bhopal, India

Position: Software developer/ Report Developer

Environment: Dot net, Sql server,Crystal report, Sql server reporting services(SSRS)

Duration: March 2008-January 2010

Project 1 Description: Front Office Management (FOM) and Point Of Sales (POS) System for a renowned hotel.

Responsibilities:

System Analysis, Database Designing and Coding and implementation.

Developed Reports for faster printing of orders and bills.

The FOM System maintains the basic information of the guests.

Walk in and their transactions Like Room Service, Sundry and generates bill at the time of Check out.

The POS System maintains the information about all the items (dishes) which are sold from different Point Of Sales like Restaurant, Fast food, Room Service, Management etc.

Created Stored Procedures in SQL Management Server.

Project 2 Description: Payroll System and Employee Information System for M.P.State Co-Operative Bank.

Responsibilities:

•Application maintains the information and payroll of all the employees of Co-Operative Bank.

•Payroll systems include general HR functions, business intelligence and recruitment features, offering a complete human resource tool.

•Employee information regarding history, performance, compensation and benefits is stored in a database where all HR resources can be easily accessed by managers and team members.

References: Will be provided on request

Contact this candidate