SUMMARY

• Highly motivated SQL Server Developer with 6 + years of IT Experience in Database and Business Intelligence Technologies, Reporting Services, Stored Procedure/TSQL coding, Performance and Tuning, Physical and logical Database Design
• Proficient in MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2005/2008/2012
• Expertise in report generation (automating, managing and security of reports) using SQL Server Reporting Services (SSRS). Created, designed and deployed Tabular, Matrix, Chart, Drill - down and Ad-Hoc reports on report server.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005/2012 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
• Good Hands on experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
• Experience in writing Complex Stored Procedures, Indexed Views, DDL/DML Triggers and User defined Functions for data consistency and manipulation.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas
• Experienced in formatting the SQL Server Reports and in creating configuration files, error handling, and logging in SSIS and in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity. Good interpersonal Skills result oriented, hardworking with quest and zeal to learn new technologies.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member

TECHNICAL SKILLS

• MS SQL Server 2000/ 2005/2008/2012
• MS SQL Server Reporting Service 2005/2008/2012
• MS SQL Server Analysis Services 2005/2008
• MS SQL Server Integration Services 2005/2008/2012
• DTS
• MS Visio 2003
• MS Access
• C
• FrontPage
• Visual Basic 6.0
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• HTML
• XML
• VBScript
• Crystal Report
• SQL Server Agent
• Visual Studio 2012
• .NET
• C#
• Oracle 11g
• Beyond and Compare
• HP Quality Centre

.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Application Developer/SSRS Developer

Responsibilities:

• Develop SSRS Reports based on data being migrated to Eagle Performance Data Mart
• Design Reports Using SQL Server Reporting Services (SSRS) and identify the database tables for defining the queries and datasets for report generation
• Writing complex PL SQL and SQL queries used by SSRS Reports
• Creating ad-hoc, matrix, drill through, drilldown and sub- reports based on the requirements
• Gathering requirements from the Business Analysts and End Users for SSRS Reports
• Created Data Quality Audit Reports to assist the Performance Team with their daily workflow. Participating in daily meeting and providing status on the reports and SharePoint deployment. Fixing defects raised by testing team and discuss the scope of the report
• Designing the layouts of the new SSRS reports and discussing it in the meetings with Technical Lead and other team members
• Created outbound Performance Attribution date interface from Eagle Performance Data Mart for Narrative Science to support their ability to create commentary for 36 Nuveen Funds.
• Created Performance Attribution Extracts for a selected group of funds in specific format based on Star Schema Data warehouse for client Narrative Science.
• Involved in developing logical and physical model of database using Erwin.
• Creating and managing schema objects such as tables, views and indexes and Maintaining Referential Integrity
• Developing SSIS Packages to extract data from Eagle Performance Data Mart and Flat Files and load to BI Platform
• Writing Views on top of Star Schema Tables in order to meet End User Requirements.
• Creating SSIS Packages to fetch data from BI Platform and to create zip folders of the data files according to each unique Portfolio Id.
• Setting up the connection for Production Servers and UAT Servers on SharePoint 2013 in order to deploy all reports on the landing page.

Confidential, Charlotte, NC

Database Analyst/SSRS Developer

Responsibilities:

• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS). Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS
• Wrote complex SQL Queries used by SSRS Reports
• Implemented Query Optimization techniques in performance tuning. Created various weekly and monthly reports using Table, Matrix and List controls in SQL report Services. Created technical documentation to future reference
• Gathered requirements from the Business Users for SSRS Reports
• Scheduled work sessions to help non-technical team members to understand the SQL queries used to create SSRS Reports and to run various SSIS Packages used by team
• Fixed defects raised by testing team and discuss the scope of the report
• Developed stored procedures, functions and database triggers. Maintained referential integrity and implemented complex business logic.
• Developed and deployed SSIS packages to bring data from Oracle to SQL Server.
• Performance tuning of the existing packages
• Scheduled package run with help of SQL Server Agent tool.
• Changed the packages according to the new requirements so that they can fetch data from new tables under new databases
• Managed the daily, weekly and monthly packages for the team
• Worked on complex stored procedures and performance tuning the procedures which are slow
• Creating documents that helps business team to understand various SSIS Packages which they use and creating worksheets that they can use for running the packages on monthly basis

Confidential, Chicago, IL

BI Developer/ SSRS Developer

Responsibilities:

• Converted Crystal Reports to SSRS 2008 format.
• Fixed the bugs in already existing reports.
• Developed Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS)
• Generated Reports using Global Variables, Expressions and Functions for the reports Deployed the generated reports on the Production Server.
• Created Cross-Tab, Drill-down and Sub-Report for the loan policies using SSRS
• Wrote Requirement Documents for the newly created reports and existing crystal reports.
• Gathered requirements from Business Users in order to convert pre-existing Crystal Reports.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2008 SSRS Generated reports from existing SQL Stored Procedures.
• Interacted with QA Team for the converted reports.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008
• Involved in training the other team members for Reporting Services.
• Produced, maintained, and monitored corporate dashboard reports which gather data from multiple servers for executives and external parties throughout the organization for multiple departments.

Confidential, Chicago, IL

BI Lead/QA Analyst (Back End Testing)

Responsibilities:

• Wrote Test Cases in SQL/Oracle to test the migration of data from Legacy data warehouse to Payment Net 4 Oracle database.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005 Facilitated implementation of automated scripts.
• Participated in cross functional discussions to review the impact of application changes from both internal and external interfaces on the quality of their applications.
• Troubleshoot and resolved the issues occurred in the new datawarehouse feeds.
• Tested data using Beyond Compare tool. Checked for discrepancies in data migrated to PaymentNet4.
• Worked with Offshore team to help them with better understanding of functional requirement document and execution of Test Cases.
• Executed Test cases and was involved in analyzing, retesting and logging the defects on HP Quality Centre.
• Created Test Sets on Quality Centre and Wrote description of each Test Case in order to make them easy to understand for other team members.
• Supported monthly releases as QA Lead. Assigned work to Onshore and Offshore Team and supported team for test execution.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers

Confidential, Scranton, PA

BI Developer

Responsibilities:

• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS.Created new and converted several Crystal reports into detailed SSRS reports. Debugged reports for the business end users.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Involved in documentation for all kinds of reports, DTS and SSIS packages.
• Developed trend indicating reports which monitor changes in different categories and record historical analysis and displays them in a single dashboard.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.

Confidential

MS SQL Developer (Intern)

Responsibilities:

• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.