Resume

Sign in

ETL Developer/BI Developer

Location:
Mechanicsburg, Pennsylvania, United States
Posted:
February 20, 2019

Contact this candidate

Resume:

Arpita Kadre

Email: ac8jwr@r.postjobfree.com Mobile: 832-***-****

Executive Summary

5+ Years of work experience in years of experience in the IT industry as a MS SQL Server/Business Intelligence Developer SQL Server 2000/2005/2008/2012/2016

Expert in MS SQL Server suite of products like SQL Server Reporting Services(SSRS), SQL Services Analysis Services(SSAS) and SQL Server Integration Services(SSIS).

Cascading prompts, matrix dynamics reports and other features of reporting service.

Experienced in SQL Server Analysis Services(SSAS) OLAP Cubes by constructing fact and dimension tables

Experience in Export, Transformation and loading (ETL) of data from different sources like Oracle/Access/Excel/Sql server etc. using SSIS/DTS utility.

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 SQL Reporting Services (SSRS) and Crystal report

Experience in using global variables, expressions and functions for the reports with experience in handling sub reports in SSRS and Crystal Report.

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

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

Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Experience in report writing using SQL Server Reporting Services (SSRS) and

Experience in creating database objects such as Tables, View, writing stored procedure and Functions.

Experience in designing and developing the Sql Server Integration Services-SSIS packages with different control flow tasks and data flow transformation, Securing package and deploying packages.

Expert communicator of complex technological concepts to professional and non-professional audiences.

Experience using Crystal Report with Oracle, SQL Server and Access database.

Experience for using share point for creating workflows.

Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.

Experience in developing N-tier web applications with in ASP.NET web forms, C#.NET, ADO.NET,WCF, HTML/CSS/jQuery/Bootstrap

Experience in VBA.

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

Education Qualifications

Bachelor of Commerce(1999),Guru harkishan,(Jhansi,U.P.),India

Diploma of Computers Application (2001),Govt.Girls Polytechnic,(Allahabad, U.P.), India

Master of Computer Application (2005), AAI-DU, (Allahabad, U.P.), India

Technical Skills & Expertise

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

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL *PLUS, SQL Developer including PL/SQL basic knowledge, server Management Studio

ETL Tools: MS SQL Server Integration Services (SSIS).

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)

Current Experience:

Client: Pennsylvania Department of correction,

Location: Mechanicsburg PA

Duration: March2018-Till date

Project Description: Worked on several projects in support of Pennsylvania Department of correction.

As ETL developer with having good experience on Sql server 2012,2014,2016.

Responsibilities:

Work closely with Operations and Automation teams in defining operational procedures.

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

Responsible for designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems.

Consolidate and optimize available data warehouse infrastructure.

Proactively gathers business requirements and creating architectural designs.

Participating in providing support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems.

Performed major role in designing, loading and extract the data into data warehouse from source using SSIS.

Actively part of the team to review, analyze, modify, and create ETLs, utilizing SSIS, testing, debugging, integration and implementation processes.

Responsibility includes documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

Ensure all data warehouse architecture codes are maintained in a version control system.

Prepared Power BI visualization displaying reports and analysis.

Work with Business Analyst and users to clarify requirements and translate the requirement into technical specifications.

Created new mappings and time to time updating old mappings according to changes in Business logic.

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

Created Reports for various projects using client side reporting services. (RDLC).

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

Involved in defining the source to target data mappings, business rules and data definitions. And incorporate gathered business data loading details in to SSIS package for final execution.

Actively took part in defining the functional requirement documents for each source to target interface.

Involved in the documentation of complete process flow to describe SSIS package development, logic, testing and implementation.

Responsible for analyzing and assuring quality/integrity of data collected in stores(DTS Package, T-SQL, jobs, stored procedures and queries) and provided reports to respective teams.

Worked on daily basis with data warehouse team to evaluate impact of current implementation and redesign of all ETL logic if needed.

Involved in supporting any reporting requirements through SQL Server Reporting Services (SSRS).

Following Software development life cycle(Development, System Integration Testing, User Acceptance Testing and Production).

Worked with Database team on data needs and to process for requirement.

Gather data needed to develop a database and also design and implement new database.

Works with architects and business partners to fashion out the technical vision for applications in Customer Data Warehouses employing SSIS, SSRS, and SQL server to re-structure hierarchy of systems.

Actively part of the team to review, analyze, modify, and create ETLs, utilizing SSIS, testing, debugging, integration and implementation processes.

Responsibility includes documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

Worked on SQL server for creating procedure and function creation and execution, validation of Invalid Objects and day to day data validation.

Worked on creating RDLC and RDL reports.

Worked as active team person.

Works on TFS for maintaining Code Quality and also, versioning each code changes/checkins are critical as per the process. Only approved Checkins will be retrieved and deployed for all the environments.

Perform Unit testing and integration testing of code.

Coordinated application releases and planning for execution for cross dependencies.

Involved in the documentation of complete process flow to describe SSIS package development, logic, testing and implementation.

Documentation for step by step instruction to carry out the deployment for Lower environments and responsibility for Knowledge Base documents on the process, troubleshooting guide and Infrastructure documentation.

Work with systems analysts, programmers and others to design system and to obtain information on project limitations and capabilities, performance requirements and interfaces.

Store, retrieve, and manipulate data for analysis of system capabilities and requirements.

Work on Power BI tool to connect with database and for enhancing the result to end user .

Client: Pennsylvania Municipal Retirement System

Location: Harrisburg, PA

Duration: April 2016 -February 2018

Project Description: Handling Pension and Retirement Database using Sql server/Oracle 11g/Crystal report/SSRS/SSIS/SSAS/MS access/Excel/SharePoint/.

as Application Developer/BI Developer

Responsibilities:

Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups.

Expertise to create Dashboards and Interactive Dashboards using Power BI tools.

Experienced in creating many complex SSIS packages with complicated transformations.

Generated reports using SQL Server Reporting Services(SSRS) integrated and deploying them using web applications onto the web servers

Expert 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.

Generated reports using SSRS that could be used to send information to diverse group of users.

Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.

Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL.

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, Did 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.

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

Interacting with Business Analyst to identifying the requirements, designing, and implementing the Database Schema.

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.

Worked on Visual Basic 2015.

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

oWorked on stored procedure for the report

oCreated Oracle view for accounting reports

Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

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 how 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.

Made Access database for Actuary

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.

Merging of reports with linking of their parameter.

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.

Worked on benefit estimate reports for making new

ochange into report

oAdded new field to the existing report with all the calculations related to the field without affecting any previous calculation.

Worked on script for perc changes for municipalities.

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 some of the queries for 1099 database for IRS

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: Unica

Location: Mechanicsburg, PA

Duration: July 2015 – March 2016

Project 1

Project 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

Environment: SSRS,SSIS,SAS, Asp.net web forms, HTMl5, SQL Server Express 2014 WCF web services, VS2015 community edition

Project 2

Project 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

Environment: SSRS,SSIS,SAS, Asp.net web forms, HTMl5, SQL Server Express 2014 WCF web services, VS2015 community edition

Client: PSA Infotech,

Location: Bhopal, India

Duration: March 2009 –January 2011

Project 1

Project Description: Front Office Management (FOM) and Point Of Sales (POS) System for Hotel Ranjit as Software developer.

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.

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

Project 2

Project 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.

Environment: ASP.net, HTML, C#, Sql server, Sql server reporting services(SSRS)

References

Will be provided on request



Contact this candidate