SUMMARY

Over * years of extensive experience as a SQl Server Developer as well as BI Developer (SSIS/SSRS/QlikView) with exposure to Database Administratoin.

Experience in creating Store Procedures/TSQL Coding, Performance and Tuning, User Defined Functions and Physical and Logical Database Design.

Expert in MS SQL Server Suite of Products i.e. SSIS (Integration Services), SSRS (Reporting Services) on various business domains like Insurance, Financial, Health Care and Pharmacy.

Excellent knowledge of entire Software Development Life Cycle(SDLC) methodologies like Waterfall model and Agile SCRUM, starting from business requirement gathering and analysis to testing and deployment.

Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.

Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000.

Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.

Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.

Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.

Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.

Experience in OLTP/OLAP environment and Data Warehouse.

Utilized Power BI to design and deploy analytical reports/dashboards from tabular models, assisting with KPI analyses.

Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.

Designed and developed matrix and tabular reports with drill down, drill through using SSRS.

Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and CSV and XML files using SSIS.

Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.

Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and HTML.

Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.

Experience in tuning the reports that includes modifying, Testing the required T-SQL and MDX queries using DMV's and creating the necessary environment for Deployment.

Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web based applications

Experience in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.

Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front-end, web and reporting applications.

Excellent experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.

Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Proficient in using SQL Profiler, Execution Plan and Performance Monitor

Over 3 years of hands on experience with QNXT application databases.

Extensive experience in using various tasks, containers, sources, transformations and destination in SSIS tool while transferring the data from various sources systems into the destination

Used Task Factory components and tasks like Upsert Destination,Update batch transformation, Surrogate key transformation and many based on the requirement.

Extensively used SSIS Import/Export Wizard for performing the ETL operations.

Proficient in creating different Package Configurations such as SQL Sever, XML configuration and Parent package variable.

Implemented different Logging in SSIS packages to log events during the run time

Experience in using BI xPress tool for applying auditing framework,deploy and manage SSIS packages

Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like SQL Server, Oracle, QVD files, Access, text files, excel documents etc. as per the user requirement.

Strong understanding of Dimensional Modeling technique, Multi Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.

Proficiency in creating different types of reports such as List, Cross-Tab, Conditional, Drill-down, Master-detail, Chart, Summary, Form and formatting them by using QlikView reporting tool.

Performed different types of loads Incremental Load, Optimized Load & Binary Load.

Experience in implementing various levels of File/Document and Data level Security.

Proficient in creatingAd-Hoc reports and complex dashboards in Tableau.

Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.

Excel under pressure in deadline driven environment with superior interpersonal communication and technical documentation skills.

TECHNICAL SKILLSET

Programming Languages

C, C++,SQL, TSQL, PL/SQL

RDBMS

MS-SQL Server 2000/2005/2008,2012, Oracle 9i/10g, Microsoft Access, DB2

ETL Tools

SQL Server Integration Services (SSIS) 2005/2008/2012, DTS

Reporting Tools

SQL Server Reporting Services (SSRS) 2000/2005/2008,QlikView 11,Tableau

Database Tools

SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Operating Systems

Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate.

EDUCATION

Bachelor’s in Engineering, Computer Science, JNTU - K University, INDIA

PROFESSIONAL EXPERIENCE

State of Indiana, Department of Health Oct 2016 - Present

Senior SQL Server/SSIS/SSRS Developer

Family and Social Services Administration (FSSA) which determines eligibility and provides benefits for programs like Temporary Assistance for needy family (TANF), Supplement Nutrition Assistance Program (SNAP) and Medicaid etc. for the people in state of Indiana. Project focuses on helping agencies improve how they determine eligibility, manage cases and deliver health and human services programs to customers in need.

Responsibilities

Document technical and business requirement documents spanning all phases of system life cycle

Develop custom scripts and stored procedures for data import and manipulation

Developed SSIS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2008 Integration Services (SSIS)

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Create SQL server Reports using SSRS 2008. Identify the data source and defined them to build the data source views.

Work on querying data and create on-demand reports using Report Builder in SSRS reports and send the reports via email.

Design and develop matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Create Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Use SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.

Develop, monitor and deploy SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.

Create SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Maintain Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Create ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformation as Lookup, Fuzzy lookup and Slowly Changing Dimension SCD.

Work on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.

Troubleshoot ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.

Write DTSX Packages to get the data from various heterogeneous databases as Oracle, Teradata to SQL Server 2008.

Conduct data migration processes in the SQL Server environment using SQL Server Integration Services.

Build a company specific DataMart for the Claims related data using SSIS and SSAS.

Experienced in uploading Claims data for various healthcare plans into HSP MediTrac system.

Develop complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, Triggers, CTE's, Views, Constraints with best execution plan in SSMS to implement the business logic for loading Claims to HSP MediTrac system.

Develop SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)

Schedule and execute SSIS Packages, using SQL Server Agent.

Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2005 to the SQL Server 2008.

Develop complex Stored procedures, User Defined Function and Triggers in SQL Server.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.

Create copies of operational Databases using the Import/Export Wizard.

Performance tuning, and optimization of procedures and queries.

Involved various levels of testing (Unit, Functional and Integration).

Use VB.Net and C# in Script task of SSIS 2015 Packages.

Write T-SQL programming to implement Stored Procedures and Functions for different tasks and create Triggers to enforce data and referential integrity.

Optimize the performance of complex source queries and stored procs with the help of execution plan and Database Engine Tuning Advisor to fetch data fast from source systems.

Implement Error Handling in Stored Procedures using Try and Catch.

Testing Packages and fixing bugs using SQL 2005 Business Intelligence Development Studio.

Have deployed packages on different servers by configuring it.

Write SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes using LINQ and SQL Server.

Develop member trouble shoot reports from QNXT applicatiom database by using SSRS reporting tool.

Interact with the business users to gather information to design reports on Claims data for various healthcare plans.

Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

ETL process was documented for future references.

Environment: MS SQL Server 2016/2014, Windows Server 2012, Transact SQL, PL/SQL, SSIS, SSRS, SSAS, ETL, Informatica 8.1, MS Visual Studio 2012/2015, Proclarity, C#, .NET, OLAP, Erwin, Foglight, Business Objects, Query Analyzer, SQL profiler, SQL Query Manager, MS Visual Source safe and Source Offsite, Performance Monitor, Query Optimizer, Cognos Framework Manager

Walmart - Bentonville, AR Oct 2014 – Oct 2016

SQL BI/SSRS/SSIS/SSAS Developer

Project scope was to develop a data mart based on an existing data warehouse to store data for CHNA reports. In addition to this, there was a requirement to build an SSAS cube and generate various reports using SSRS for decision making.

Responsibilities

Drafted functional/non-functional requirement documents from JAD meetings.

Involved in the analysis of Report design requirements and actively participated and interacted with Project Lead, Technical Manager, and Lead Business Analyst to understand the Business requirements.

Migrated DTS packages from SQL Server as SSIS packages.

Worked on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).

Wrote complex stored procedures, views, triggers, and user-defined functions to implement business logic structures.

Added error handling techniques to SQL code to identify run time issues.

Made use of CTEs and other temp objects to achieve performance.

Enhanced stored procedure performance and rectified parameter sniffing issues with SQL profiler and DTA.

Defined correct business logic by implementing control flow constructs.

Implemented ER-Win data modeler to design dimensional models of data mart with star schema.

Designed data mappings from source to target tables on the OLAP data mart design.

Developed SSIS packages for the ETL process; loaded and transformed data from multiple sources into the data mart.

Utilized SSIS transformations for data scrubbing and validation checks prior to loading into the data mart.

Implemented transactions at package and task levels to follow ACID properties.

Created a SSISDB catalog with SQL Server 2012 to support SSIS package deployments.

Adapted advanced SSIS features such as event handlers, loggings, breakpoints, and data viewers.

Implemented parameters in the project deployment model, making packages dynamic.

Built SSAS MDX and Tabular cubes to handle different departmental data.

Created Calculations, KPI's and named sets utilizing multi-dimensional expressions (MDX).

Customized hierarchies, calculated measures utilizing data analysis expressions (DAX).

Secured SSAS MDX and Tabular cubes at cell and row levels respectively.

Designed multiple reports with SSRS report designer for business analyses.

Utilized Power BI to design and deploy analytical reports/dashboards from tabular models, assisting with KPI analyses.

Created apps to share dashboards across organizational user groups in Power BI Server.

Deployed Power BI dashboards and reports to Power BI servers.

Provided report access security at server, report, and report item levels.

Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS.

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining, and Architecture.

Created multiple reports with drop down menu option having complex groupings within the report.

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Worked with the new concept of Tablix Data Regions in the Report Layout, created a stack of stepped reports using the Tablix.

Developed reports and deployed them on the server using SQL Server Reporting Services (SSRS).

Scheduled and delivered reports with standard and data-driven subscriptions.

Configured virtual machines, virtual networks on MS Azure.

Modified data on Azure SQL database through SQL Server Management studio.

Implemented TFS for version control and change management of BI solution for cross-functional communications.

Environment: MS SQL Server 2012, SSIS, SSAS, SSRS, DTS, T-SQL, SQL Profiler, OLAP, OLTP, ER-Win, Flat Files, Excel with Power Pivot, Power View, TFS, SharePoint, Power BI, MS Azure

Progressive Insurance – Mayfield, OH (Offshore) Oct 2013 – Sep 2014

MS BI Developer

Progressive is a leading auto insurance company based in the Cleveland suburb of Mayfield Village, Ohio. In addition to auto insurance, Progressive offers the following types of insurance to customers throughout the country for boat/personal watercraft insurance, commercial auto insurance, homeowners insurance, motorcycle insurance and RV insurance. The project dealt with managing login and user management, database creation, tuning, backup planning, and generating reports using Power BI for the data containing information about the personal insurance policies of the customers.

Responsibilities

Participated in Business Processes with the Business Analyst/Client delivery to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.

Optimized Stored Procedures and long running queries using query-optimization techniques.

Participated in Design/Discussions of ETL flow from different source systems into Datawarehouse(DWH) model(Start Schema).

Created Source to Target(STT) mapping document for DWH ETL process.

Involved in installing and maintaining MS SQL Server 2008 R2/2012.

Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012 as SSIS packages.

Developed various objects such as Functions, Tables, Views, Triggers, Indexes and Constraints.

Created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.

Developed User Defined Functions for giving Scores and views for the application.

Reviewed and fine-tuned stored procedures and triggers before production migration.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.

Created SSIS packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, multicast and derived column.

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS

Worked on the reports to pull up the finances data of the company by using the Business intelligence SQL server Reporting Services (SSRS).

Optimized queries by looking at Execution Plan for better tuning of the database.

Created Clustered and Non-Clustered Indexes for Query Optimization and also involved in Database Tuning.

Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.

Involved in DBA activities such as backups, restores, replication etc. Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.

Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.

Maintained Batch logging, Error logging tables and handled errors using Event handlers.

Create SSIS package to export and import data from SQL Server to Access, Text and Excel files and configured database mail agent for sending automatic mails.

Involved in generating Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.

Involved in deploying, configuring and managing reports using Report Manager and Report Builder.

Environment: MS SQL Server 2008, Visual Studio 2008, windows server 2008, T-SQL, QlikView 11/10,Tableau, MS Excel, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), TFS.

LA Health care plan – Los Angeles, CA(Offshore) Jun 2012 – Oct 2013

Senior SQL Server/SSIS Developer

L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. They are the nation’s largest publicly operated health plan. The proect deals with migration of Data from different sources and optimizing the performances of the queries. It also deals with developing SSIS packages to load the incremental load data

.Responsibilities

Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.

Responsible for performance tuning and optimization of SQL queries and indexes.

Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations.

Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.

Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.

Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.

Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.

Developed, deployed and monitored SSIS Packages.

Created and managed database schema objects such as tables, views, indexes, and stored procedures and maintaining referential integrity for the lookup tables.

Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.

Created Stored Procedures in T-SQL to fill Datasets from MNS Database and generating Media Rates Reports in Excel.

Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC commands.

Perform daily database backup & restoration and monitor the performance of Database Server.

Debugged Stored Procedures and improved Query Performance while Retrieving Millions of Records by creating Indexes.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Configured and maintained Report Manager and Report Server for SSRS

Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.

Worked extensively on the database to create stored procedures, Views on oracle 10g.

Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.

Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.

Involved in Migration of SSRS 2005 to SSRS 2008.

Involved in extracting the data using SSIS from OLTP to OLAP.

Involved in creating Tables, Stored procedures, functions, and triggers at the back-end by using SQLSERVER.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Environment: SQL Server 2000/2005, Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform,Oracle,VB.NET,ASP.NET.

CATAX Solutions - Hyderabad, India May 2010 – Jun 2012

SQL server Developer (Intern) Client has the largest pharmacy chain in India with over 250 outlets and six regional distribution centers across India. Project objectives are to standardize Pharmacy outlet operations across the country, automate and stock transfer processes, consolidate reporting at national level, centralize master data maintenance and procurement process management

Responsibilities

Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and

Primary and Foreign Keys

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.

Configured SQL Server 2000 Environment.

Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.

Design and Creation of logical storage (Table spaces, Segments etc.).

Designed E-R Diagrams, logical and physical data modeling

Implemented business logic using the ETL packages, to perform necessary transformations on the data before it is loaded into its final destination table.

Interacting with business users in getting the reporting requirements.

Performed installations of Oracle 8i and SQL server databases.

Backup and Recovery of Oracle database using Recovery Manager (RMAN).

Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.

Used FTP and SCP for keeping important files safe and secure.

Optimization of the SQL queries to meet the performance requirements.

Worked with database export & import scripts to backup database

Created tables, indexes, stored procedures and functions.

Modified existing ETL packages to support additional/new features based on the customers’ requirements.

Developed and integrated code for enhancement of the application.

Responsible for optimizing the queries and application tuning.

Scheduling Jobs and Alerting using SQL Server Agent

Developed custom reports using Microsoft reporting Services.

Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.

Optimization of the SQL queries to meet the performance requirements.

Worked with database export & import scripts to backup database

Environment: Windows, SQL server, Oracle 8.1.7.0.1/ 9.2.0.1.0, T-SQL, Query Analyzer, Data Transformation

Contact this candidate