Summary:

• Over 8 years of IT experience as a MS SQL Server Developer 2000/2005/2008 in various verticals such as Health Care, Telecommunication, Finance, Insurance and Retail
• Extensive experience working with MS SQL Server 2000/2005/2008, Business Intelligence Development Studio, MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services
• Expert in Developing SSIS Packages Extracting, Transforming and Loading ETL /DTS data into the Data warehouse from databases such as Oracle, DB2, Sybase and MS Access
• Extensive experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services SSIS
• Experienced in designing and developing more than 100 enterprise reports SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources
• Successfully performed testing in recent projects by writing different test cases based on different testing strategies decided in the design review meetings
• Expert in creating MOLAP Warehouse utilizing SQL 2005 Server Analysis Services and created multiple cubes with dimensions, facts and hierarchies
• Experienced in functional, integration, system and unit testing by writing different scripts in SQL.
• Experienced in implementing Key Performance Indicator KPI , calculated members, aggregations and partitions in SSAS 2005
• Expert in creating and deploying SSRS Reports on the portal for ease of access
• Experienced with parameterized queries for generating tabular reports, formatting report layout, sub reports using global variables, sorting, defining data source and subtotals for the reports using SSRS 2005/2008
• Experienced at Logical and Physical Database design and development, Normalization and data modeling using ERwin and the use of SQL Server Enterprise Manager
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, SQL query analyzer and database engine tuning advisor
• Well versed in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, SQL joins
• Hands on experience in working with UML documentation like class diagrams, use cases, sequence diagrams and ERDs
• Involved in all phases of SDLC and successfully completed
• Vast experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database
• Knowledge of Autosys for defining, scheduling and monitoring jobs
• Exposed to Microsoft Visual Studio .Net Win Forms in developing simple data entry applications
• Able to maintain positive communications and working relationships at all business levels
• Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles.

Skill set:

MS SQL Server 2008/2005/2000/7.0, MS SQL Server Integration Service SSIS , MS SQL Server Analysis Services SSAS , MS SQL Reporting Services SSRS , Team Foundation Server, T-SQL, MS SQL Profiler, SQL Query Analyzer, MS Office 2000/2003/2007, Microsoft Access 2000/2003/2007, Microsoft Excel 2007/2010, Microsoft Outlook, Microsoft Visio 2003/2007, Data Transformation Services DTS , ERwin Data Modeler 4.1/4.2, ER Diagrams, Microsoft Visual Source Safe, Crystal Reports 9/10/11.0, MS FrontPage, Data Integrator ETL 11.0, HTML, XML, ASP.Net, JavaScript, Professional Presentations.

Projects Summary

Confidential

TSQL/SSIS/SSRS Developer

Responsibilities:

• Created a data model based on multiple discussions with architects and the clients to facilitate the calculation of risk scoring for the members, the data for which was provided by multiple clients
• Created all the tables, keys, indexes with the relevant attributes that the major clients needed. Some of the clients were Aetna, Scott And White and MVP
• Designed several SSIS packages for loading the data from different Tiers to the Tier that was used for reporting and suspecting
• The entire project was broken down in to 3 different levels/tiers i.e. Tier 1, Tier 2, and Tier 3. All of the Tiers had claims that were submitted to CMS
• As a part of Tier 2 and Tier 3 environment what all claims were loaded in to Tier 1, we had designed several packages to move that data over to the next tiers
• All the objects were checked in and deployed to the servers using TFS Team Foundation Server
• The reporting was totally based out of the objects and data in Tier 3. Several reports were created to identify the claims that cannot be used for risk scoring, distribution of HCC's for different members etc.
• Company had its own portal where the reports were deployed and available to be used by the clients
• All the connections, user accesses for the report were stored in a reporting database and those values were passed to the portal to make sure the reports were running fine
• Most of the reports were drilldown reports based on the requirements provided by the client. The main advantages of drilldown reports was that they were easier to read, because the report was broken down by different groups
• SSIS packages were developed following the templates that were at place. The templates had all necessary logging, inclusion of audit columns and package configurations that were stored in a Config table
• Was involved in solving production issues related to reports, tables and data quality issues that the clients were facing
• All this being a new project and brand new development, there was a lot of documentation build on each piece, so the future developers or members in the team won't face issues with understanding the project

Environment: MS SQL Server 2008, Team Foundation Server TFS , T-SQL, SSRS, SSIS

Confidential

MS SQL Developer/SSRS Specialist/BA

Responsibilities:

• In the first project, the task was to convert all the old legacy reports sitting on the old ASP system to SSRS 2008. The code was converted in to stored procedures and the reports were developed depending on whether they were multi-valued parameter reports, drill-through reports or cascaded parameterized reports
• Development and the production deployment of all the reports to the report server and granting permissions, setting subscriptions, caching reports, setting timeouts were some of the things that were done
• Worked on an SSIS package to get a file which had no delimiters and no sequencing. The entire file was loaded in to one column of a staging table and the data had to be parsed to get the file records loaded to the main table
• Worked on a CRM project that was designed to facilitate customer care employees to give welcome calls to the customers who were new to NTelos. Several SSIS packages and stored procedures were developed to grab all the new postpaid and prepaid activations and reports were created to give an overview of all the records
• Was responsible for converting around 25 reports from SSRS 2005 that were hosted by our marketing team on to DW side and necessary data driven/event subscriptions had to be set up
• Worked with clients/business users directly to grab their requirements and develop solutions that could fulfill their needs. Examples were some prepaid reports that told us how many people were active, churned, inactive, ported outs and had returns
• Worked directly on production support to handle trouble tickets and troubleshooting jobs, packages and queries that existed
• Handled partitions for huge tables whenever there were load failures related to those tables. Deleted data from some partitions and reloaded it by running the package manually from the machine
• Was given the responsibility to tune up the performances of some of the already existing code, majority of the time was spent in reading execution plans, profilers and did indexing, partitioning and keys setup if it was needed
• As a production support person, every week during the patching, I had to disable the jobs, stop all the feeds to data warehouse and ran some of the jobs manually by co-coordinating with different teams on which we were dependent
• Deployed SSIS packages by connecting to integration services and then importing the packages there by setting necessary security permissions
• Created summary tables in the events when it was determined that running the just the stored procedure for a report would take a lot of time. So, plan of action was to load a summary table daily using the code and then running the report from the table and not from the stored procedure which had a lot of different joins
• During the meetings with the users all the new features in DW, for reporting, share point, and some website related information was demonstrated by our team so they are up to date with latest technology
• Deployed all the production as well as testing related objects to subversion using Tortoise SVN which works like Visual Source Safe. All the rdl, dtsx .sql and .job files had to be deployed here.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSIS, Tortoise SVN

Confidential

MS SQL Developer/Testing Specialist/QA

Responsibilities:

• Worked extensively on updating T-SQL queries for getting the desired results using batch updating in a loop and tuned up those queries so that result retrieving was faster than it was before
• Extensively worked in the Testing environment to make sure the developers did everything according to the FRT's and the BRD's, testing process required particular test cases to be followed
• Wrote queries to see the data and match it with what was required according to business requirements and upon approval make sure that data was same in all the environments
• Ran packages created by developers, scheduled jobs for them and assured data matched in Development and Testing environment
• Coordinated with developers, team lead, project managers for design implementation for my testing plans and several test cases
• Corrected packages and modified various transformations within that package so that data was imported the same way the company wanted
• Created and updated several stored procedures and tweaked them up to improve overall quality of result retrieving
• Cleaned up unnecessary databases, logs, packages and stored procedures that company was no longer using by running my own dependency scripts and using the inbuilt functionalities in SQL

Environment: MS SQL Server 2008 Management Studio, SSIS, Visual Source Safe, SharedPoint

Confidential

MS SQL Server Developer

Responsibilities:

• Worked extensively on stored procedures for extracting different columns from different tables to extract datasets based on the requirements
• Extensively worked on performance tuning of the stored procedures, by creating staging tables that had proper indexes set and had proper joins
• Used SSIS to migrate the excel files that were already in the system to a SQL server destination table by working on variables and for each loop container
• Worked mostly on ad-hoc reports, sub reports, cascading reports, drill-through and drill-down reports to report the results to my manager
• Worked as a DBA to restore the databases, monitor the activities on the server and suggest ways of tuning up the performance of queries to developers
• Extensively used stored procedures to create the reports with cascading parameters and improved the performance of my reports by eliminating extraneous data fields and setting up time-out values for them
• Migrated several DTS packages to SSIS 2008 and executed the DTS 2000 packages. Also, migrated some of the databases from Oracle to SQL

Environment: MS SQL Server 2008 Management Studio, SSIS, SSRS

Confidential

QA/MS SQL Server Developer

Responsibilities:

• Involved with the testing team to generate test cases, testing scripts, scheduling jobs and packages and doing a statistical analysis of their run time
• Coordinated with developers to see what was their criteria of testing, if any, so that there were no redundant operations
• Migrated MS SQL Server 2000 databases to MS SQL Server 2008 using Detach/Attach, Backup and Recovery and by Replication
• While working in a team, learned about Autosys for scheduling and monitoring jobs for different programs
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures through SQL Server Agent
• Used ETL processes to implement the Slowly Changing Dimension, to maintain historical data in data warehouse. Worked with all types of SCD's
• Created a number of reports with dynamic parameters accommodating the changing reporting needs of various business users. Also proficient in working with static parameters
• Extensively worked with crystal reports and MS SQL Server Reporting Services 2005 and 2008 and deployed successfully
• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS
• Created Ad-hoc reports for managers using SSRS to immediately have them get access to the reports on the fly and generated reports using SSRS to send information to different Primary Vendors, Clients, and Managers
• Designed and implemented Stored Procedures and Triggers for automating tasks, also proficient in using cursors for row by row fetching of data
• Built SSIS packages for processing cubes and dimensions and performed documentation for all kinds of reports, DTS packages and SSIS packages
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes, Triggers, Cursors and Stored Procedures
• Created Views to reduce database complexities for end users and save the query results in a temporary table that will be available immediately as per the requirements of the business user
• Created use case diagrams and class diagrams using Microsoft Visio 2007 to give a clear picture of how the database will look like. Also designed entity relationship diagrams

Environment: MS SQL Server 2008, ERwin, T-SQL, SSRS, SSIS, SSAS, ASP.NET, XML, Web Service, DTS

Confidential

MS SQL Server Developer/QA

Responsibilities:

• Designed and normalized the databases and created different objects like tables, views, stored procedures and indexes on MS SQL Server
• Used tools like Beyond and Compare for comparison of files and wrote different test cases for functional, integration, system and unit testing
• Involved in installing and migrating legacy databases to SQL Server 2008 using attach or detach and backup and restore
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Multi-cast task, XML-Merge task, Conditional Split task, OLE DB Command and Derived Column
• Transformed data from various heterogeneous data sources using OLE DB connection by creating various SSIS packages
• Created several SSIS packages to import Flat files CSV into data tables. These packages were scheduled in regular time interval using SQL Server Agent in SQL Server Management Studio
• Extracted data using SSIS from OLTP to OLAP and extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Created SQL Server Reports using SSRS 2008 and exported them to Excel format for managers and Quality Assurance team for easy validation
• Created schemas, views, stored procedures, triggers and functions for Data Migration and created back-ups for the database created
• Built complex multi-sectional reports with charts and drill-down capabilities so that it is easier for the business users and the end user to browse through the reports
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• Created Ad-hoc reports for manager using SSRS to find all the work items open for Developers
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, Crystal Reports 9.0, Business Intelligence Development Studio, DTS, SQL Profiler, Microsoft Visio, Erwin, MS Office 2003/2007, Excel 2003, ODBC, OLEDB

Confidential

MS SQL Server Developer/ SSRS/SSIS Developer

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB connection by creating various SSIS packages
• Designed, Developed and Deployed various kinds of reports like ad-hoc reports, drilldown reports, drill through reports and parameterized reports using SSRS-2005
• Implemented SSAS Cubes, Facts and Dimension tables used to perform analysis and used various services like KPI's, Partitions, Calculated Members and actions
• Created OLAP Cubes from the integrated data from the packages that were built in SSIS and generated reports on those cubes
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases
• Configured packages using SSIS configuration utility. Tested Packages against wrong data
• Designed a new schema for the Data Mart databases
• Migrated reports from Crystal Reports 9 to SSRS 2005
• Used the Execute DTS 2000 package task to execute DTS packages
• Developed report specifications, created and modified reports using SSRS 2005
• Generated Assessment Reports to analyze the Scope and Complexity of the migration projects

Environment: MS SQL Server 2005, Crystal Report 9.0, SSMS, C , ASP.NET, Windows 2000/2003, SSRS, SSIS and SSAS