PROFESSIONAL SUMMARY:

• Around 8 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL 2008/2008R 2/2014/2012.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Creating parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services.
• Expertise in developing Parameterized, Chart, Graph, Dashboard, Matrix Report using SSRS.
• Worked on different Data sources shared and embedded data sources for developing the various reports.
• Involved in Design and Development for both OLTP and Data warehousing environments.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the database from SQL Server 2012/2014, MS Excel and Flat files.
• Experience in creating reports built across multiple Data sources and dynamic Dashboard creations.
• Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.
• Hands on Experience SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server.
• Strong Experience in creating parameterized reports, Matrix reports using SQL SSRS 2012/2008 R2.
• Performed data analysis and data profiling using complex SQL on various sources.
• Excellent experience in analysis huge volumes of data in industries such as Finance, Healthcare.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Exceptional skills in Agile Development and Test Driven Development.
• Involved in the Daily Scrum calls and attending Agile calls.
• Extensively used SSIS transformations such as Derived column, Data conversion, Aggregate, Conditional split, SQL task etc.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Created, implemented and maintained a reporting suite of over standard reports while also customizing many reports to meet individual client needs.
• Scheduled 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).
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the pharmacy data.
• Excellent experience in developing Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the health data from various source systems.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2008/2008 R2/2014/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

SQL Server Tools: SSMS 2014/2012/2008 R2, 2008 Visual Studio

Data Warehouse Tools: SSMS 2013/1014/1012, Business Intelligent Studio, ETL, SSIS,SSRS, Data Modeler, Query Analyzer, Profiler, Power View, Power Pivot, Power BI, Performance Monitor, Database Tuning Wizard, MS Visual

Databases: MS SQL Server 2014, 2012, 2008 R2, Microsoft Office 2007/2003.

Languages: CSS, HTML, XML, T-SQL, MYSQL

Operating Systems: Windows XP2003/2007 Servers

Reporting Tools: Excel, SSRS 2008/2012/2013, SSIS 2008/2012 and SSIS 2012.

Other Tools: MS Office 2007/2003, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential - Columbus, OH

SSRS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Developed parameterized reports which were used for making current and future business decisions.
• Extensively used SSIS transformations such as for each loop container, Execute SQL task, derived column, Data conversion, Aggregate, Bulk Task, SQL task etc. using different sources like OLE DB source and Excel source.
• Worked with different teams in an Agile model.
• Created packages to export the data from flat file to SQL server.
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations).
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like MS access and flat files.
• Worked on different type of reports by using rebate data and claim level data and Generic product identifier (GPI) and master data drug base, different types of transaction control numbers (TCN).
• Developed Reports to generate daily, weekly dashboards, monthly, quarterly, yearly Reports.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Advanced extensible reporting skills using SQL Server 2013 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the med span, Medicare and Medicaid different type of pharmacy data.
• Developed various types of complex reports like pie charts, bar charts Involved in scheduling, and subscriptions for the reports using SSRS 2013.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experienced in writing complex SQL Queries, Stored Procedures, Joins and User Defined Functions.
• Scheduled and managed daily/weekly/monthly rebate reports and operational reports based on the business requirements.
• Develop new reports and perform maintenance of existing reports.
• All reports are stored procedure driven by SQL Server 2008 with output of reports in Microsoft Visual Studio.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Developed different kind of reports such a Matrix reports, Tables and bar charts and pie charts.
• Develop reports using complex formulas and to query the database to generate different types of reports using SSRS.

Environment: SQL Server 2014/2012 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSRS 2013, SSIS 2012), T-SQL, XML.

Confidential - Jessup, PA

ETL Developer

Responsibilities:

• Migrated SSIS packages from SQL server 2008 to SQL server 2012.
• Executed Stored Procedures, Triggers, Views and Functions from the development team for the Application on the production servers.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012/2014, MS Excel and Flat files.
• Developed stored procedures by using existing SSIS packages of 2008 and 2012.
• Managed records in Excel Spread Sheet and exported data into SQL Server Database using SSIS.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Managed month to month change reporting in order to properly update the claims processing system.
• Created SSIS packages to load monthly timesheets and loaded the timesheets into a new table.
• Generated missing project reports using SSIS and created tasks to load the report into table.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as for each loop container, Execute SQL task, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task etc. using different sources like ADO.NET, OLE DB source and Excel source.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Text format data) to SQL Server.
• Performed User acceptance testing ( UAT) for assigned change requests, incidents and SSIS packages.
• Worked on change requests, incidents tickets and defects.

Environment: SQL Server 2012/2008/2008 R2, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential - Dover, NH

SQL BI DEVELOPER

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Created various Types of report types like tables, matrix, sub reports etc.
• Advanced extensible reporting skills using SQL Server 2008 R2/2012/2014 Reporting Services (SSRS).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2013.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Extensively used SSIS transformations such as Derived column, Data conversion, Conditional split, SQL task, Script task etc.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2014/2012/2008 /2008 R2 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSRS,SSIS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential - Northbrook, IL

SQL BI DEVELOPER

Responsibilities:

• 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.
• Generated Reports using Expressions and Functions for the reports using SSRS 2012.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services 2012(SSRS).
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL DB, flat files and loaded database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server 2008 R 2/2012/2014.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQLServer 2014/2012/2008 R2 Enterprise Edition, SSRS 2008/2012/2013, .NET Framework, T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2013.

Confidential

Junior SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL .
• Involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor and Windows performance monitor.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Written and executed T-SQL queries using SQL Server 2008 R 2/2012/2014.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2008, T-SQL, SSMS, MS-Office, MS-Excel, Visual studio 2013