Prabhakar

SQL Developer

Phone: 614-***-****

Email: ac4lbu@r.postjobfree.com

Professional Summary

Around 4 years of IT industry experience with Microsoft SQL Server 2005/2008/2008R2/2014, SSIS/SSRS and OLAP as SQL Developer.

Extensive experience in using Microsoft BI studio products like SSIS,SSRS for implementation of ETL methodology in data extraction, transformation and loading.

Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Expert in Developing reports on SSRS on SQL Server (2005/2008/2008R2).

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.

Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis,design, creation of mapping documents, specification writing, development, testing, and implementation.

Experience in Data Modelling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MS SQL 2005/2008/2008R2/2012 for Business Intelligence applications.

Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

Expertise in writing Complex T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.

Expertise in creating indexed tables with Primary, Foreign key constraints to maintain referential integrity.

Good understanding in implementing different types of Replication Models such as Transactional, Snapshot and Merge.

Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’S, OLAP charts and SSRS Reports with PPS.

Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.

Involved in Develop, analyze and execute system test plans and worked closely with QA group.

• Created logs 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.

• Implemented Error handling and Roll Back process in ETL load.

• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos.

Technical Skills

Operating Systems

Microsoft Windows 95/98/2000/2002/Vista/Windows 7/Windows 8/Mac OS X

Databases

MS-SQL Server 2000/2005/2008/2008R2/2014, Oracle 9i/10g/11g, DB2, MS Access

SQL Server Tools

SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), BIDS, DBCC, BCP, SQL Server Profiler, Microsoft Performance Point Server.

Data Modeling Tools

Erwin, Microsoft Visio 2000/2003 Microsoft Project/Office 2003,2007, 2010, 2013

ETL Tools

Experienced working with BIDS - DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS), Informatica.

Reporting Tool

SQL Server Reporting Services (SSRS)

Languages

T-SQL, SQL, C, C++, HTML, JQuery, Javascript, XML/XSLT/.Net/C#,Core Java

Professional Experience

GVAInfotech, Ashburn, VA Jan ’16 - Present

Role: MS SQL / SSIS Developer and QA tester

Responsibilities:

Actively involved in business rule analysis; gathered user requirements.

Created ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.

Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from Flat files, excel files and SQL server database.

Developed multiple test plans and test case documents working with Product Owners and Developers.

Worked on data migration from Oracle sources to SQL server 2014.

Responsible for transferring the data using SSIS packages from excel/flat file sources to database.

Responsible for creating, scheduling Jobs in Talend and SSIS.

Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.

Published migrated data using SSIS (SQL Server Integration Services) through data flow tasks, look up transformations and script tasks.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.

Involved in Backend, Regression, Integration, Functional, Smoke, End to End Testing

Interacted with Business Analysts for UAT (User Acceptance Testing), and tested the possibilities of system failure with UAT.

Extensively used JIRA for automation scripts execution

Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and Linked reports using SSRS and deploying them on the server.

Build different types of chart reports using SSRS like column chart and Pie charts.

Worked on VB.Net (Windows App) and C#.Net (Web Application) for developing the utilities such as Server Manager, Patient Merger, Visit Re open, Open Door and Hide Visit.

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple Transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all and Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Developed Reports out of the Consolidated Data Warehouse for the Business Users using MS SQL Server BIDS 2008 (SSRS).

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server and scheduled the monthly/weekly/daily reports to run automatically and send the reports via email.

Worked on troubleshooting, supporting, monitoring, production and test environments.

Designed SSIS packages to load data from source to Data Warehouse.

Environment: MS SQL Server 2008/2008R2/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Talend, SharePoint, MS DOS Batch scripting and COBOL.

Anira Solutions, Hyderabad, INDIA Feb’14-Nov’15

Role: MS SQL Server Developer

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).

Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.

Created Configurations to make package portable and created Event handlers for handling package error.

Worked on Report Creation from TFS using SQL Server Reporting Services, Excel Reporting From Work Item Query and SharePoint Dashboard.

Managing Build process for which solution includes dependency on Microsoft Framework .Net Version (1.0, 2.0, 3.0, and 4.0) and external dependencies.

Configuring Clustering, Log shipping and Merge Replication at SQL Server level and monitoring.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Used Performance Point Server to create reports, scorecards and dashboards.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.

Developed MDX Queries against cubes to generate reports using BIDS.

Managed AMO (Analysis Management objects) using BIDS.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes.

Created and modified various Stored Procedures used in the application using T-SQL.

Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

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

Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.

Developed yearly and quarterly company expense reports.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Tuning SQL query for better performance using SQL Profiler.

Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables and monitoring of both T-SQL and PL/SQL blocks.

Actively supported business users for change requests.

Environment: SQL Server 2008/2005, Enterprise Edition, SSRS, SSIS, Spotlight, MS SharePoint, Oracle 9i, Microsoft Excel Power Pivot, MS Access 2000 & Windows 2003/2000 platform, VB.NET,ASP.NET.

Academic Qualifications:

Master Degree in Information and Computer Sciences from Sacred Heart University, CT, USA 2016

Courses taken: DBMS, Networking I, Advanced software Engineering, DBMS II, Networking II, OOAD, Web development I, Web Development II, Security in Computing.

Bachelor of Technology in Electronics and Communication Engineering from JNTU, Hyderabad, India 2015.

Contact this candidate