SUMMARY:

• Over 8 years of IT experience which include analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Servers 2008/2005/2000) in production environments
• Worked through all phases of System Development Life Cycle (SDLC): requirements gathering, analysis, design, development, testing, UAT, production and post-production support
• Extensive experience in designing, developing, and testing of Business/Commercial Applications using Visual Studio .NET 2003/2005/2008, Visual C#, VB.NET, ASP.NET 1.1/2.0/3.5, ADO.NET, WCF, WPF and Microsoft Enterprise Application Block
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SSAS (analysis services) and MDX for data warehouse and data mart solutions.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to Access etc
• Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user-defined functions.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Installed, configured and maintained SSRS server.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
• Extensively used Informatica PowerCenter, SIEBEL for Data Warehousing, Data governance, Data replication and Synchronization, Service-Oriented architecture and more.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Experience in migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SQL Server DTS.
• Experience in designing the logical data model and physical data model.
• Experience in supporting large databases up to a size of four terabytes.
• Experience in installing and configuring SQL Server database and Windows Cluster Servers (Active/Passive).
• Delivered 24/7 support including scheduled and emergency night and weekend work.
• Excellent communication skills both verbal and written.

TECHNICAL SKILLS:

C, C++, C#, VB6, VB.NET

Operating Systems:

Windows 2000 / 2003 / 2008 Server, Windows NT/95/98/XP/Vista.

Database Tools:

SQL Server Profiler, DTS, Enterprise Manager, Query Analyzer, SSRS, SSIS,SSAS, BCP, Crystal Reports, Management/Business Intelligence Studio.

Databases:

SQL Server 2008/2005/2000/7.0, MS Access, Oracle 9i/10g, IBM DB2

GUI Tools:

Visual Studio 2003/2005/2008

Web Technologies:

ASP.NET, ASP, HTML, DHTML, CSS, AJAX, WSDL, XML, XSL, XSD, XSLT, JavaScript, VBScript, ADO.NET, COM, SOAP

Web Server:

Internet Information Server 5.0/6.0

Version Control:

Microsoft Visual Source Safe, Perforce, Team Foundation Server 2008, SVN

Professional Experience:

Confidential,Tallahassee, FL March 12 – till date
Position: SQL Server Developer/SSIS/SSRS

• Extensively worked on Billing Center, Policy Center and Claims Center.
• Worked with business analysts and data analysts to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI and applications
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data in and from GuideWire OLTP Data Warehouse and Data Mart.
• Debugging of SSIS packages, Stored Procedures and Functions and rewriting / adding necessary business logic to the scripts
• Frequent teleconferencing and e-mail communication with Guidewire team to understand business rules and data structures
• Configured product meta-data tables to support client data reporting needs.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve slow running queries.
• Wrote complex SQL statements using CTE’s, joins, sub queries and correlated sub queries.
• Migration: copied production SQL Server databases to test server running Windows 2008 Server and SQL Server 2008
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Packages and SQL server environments across entire system.

Environment: SQL Server 2008 R2, SSIS, Guidewire, IBM DB2, Excel, T-SQL, Excel, Perforce, AQT, Windows Server 2008

Confidential,Atlanta, GA Nov 11 – Mar 12
Position: SQL Server Developer/SSIS/SSRS

• Installed and configured SQL Server 2008 R2 in Test/Development environments with latest service packs and migrated databases and configured the Report Manager
• Created database objects like Tables, User Defined Functions, Triggers, Procedures, Functions, Indexes and Views, SQL joins and statements as per the team’s request through team tracks
• Performed T-SQL tuning and optimizing queries which take longer time in execution
• Developed, deployed, and monitored SSIS Packages including upgrading DTS to SSIS
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Developed Reusable SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, flat files, Teradata and DB2 Systems into SQL server 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 etc
• Created complex Stored Procedures, Triggers, Cursors, Tables and Joins by using T-SQL in SQL Server 2008.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users
• Transformed DTS packages into SSIS packages and improved the performance by analyzing database design, database modeling, query plans, database settings and deployed them on to production server.
• Created complicated reports like parameter based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts
• Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS 2007)
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.

Environment: SQL Server 2008 R2, TeraData, DB2, Excel, T-SQL, Excel, Visual Source Safe, Microsoft Access.

Confidential,Atlanta, GA October 10 – October 11
Position: SQL Server Developer/SSIS/SSRS

• Upgraded databases from SQL Server 2000/2005 to SQL Server 2008.
• Designed and developed Databases, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Developed T-SQL programs and Involved in optimizing stored procedures and queries for faster retrieval and Server efficiency.
• Transformed DTS packages into SSIS packages and improved the performance by analyzing database design, database modeling, query plans, database settings and deployed them on to production server
• Created SSIS packages to extract historical information from the Excel Spreadsheets, CSV Files, SIEBEL and load them onto the SQL Server Databases
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Performance tuning of SQL queries and stored procedures using SQL Server Profiler and Database Engine Tuning Advisor.
• Involved in creating report models and applying row level security filters for report model.
• Designed and developed SSIS Packages (.dtsx files) to import and export data from Oracle 10g, SIEBEL, MS Excel, SQL Server 2008 and Flat files.
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Identified and worked with parameters for parameterized reports in SSRS 2008.
• Designed and developed various complex reports such as Drill down, Drill Through, Sub Reports, and Cross Tabbed using MS Reporting Services.
• Responsible for design layout like Pie charts, Graphs and Linked Reports.
• Created and managed users, roles and groups and handled database security.

Environment: SQL Server 2008, SIEBEL, Excel, MS Visio, T-SQL, Excel, Advanced Windows 2003 Server, IIS, Visual Source Safe, Microsoft Access.

Confidential,Atlanta, GA April 10 – October-10
Position: SQL Server Developer/SSIS/SSRS/.NET Developer

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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
• Performed both logical and physical modeling of databases using ERWIN data modeling tool.
• Designed and developed Databases, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Developed the T-SQL programs and Involved in optimization of stored procedures and queries for faster retrieval and Server efficiency.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Analyzed and resolved complex technical problems, including performance tuning, and application design and debugging.
• Involved in mock testing and Unit Testing and Integration testing and used Defect tracking tool.
• Supported EDW/CDWs 24x7 operation by being on-call as needed for data related issues.
• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, configuring optimizations and securing the web application.
• Automate tasks using ActiveX script (similar to VB script). Be able to implement failure alerts using email.
• Created and monitored database maintenance plans for checking database integrity.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created and Configured OLAP Cubes using SQL Server Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Designed and developed various complex reports such as Drill down, Drill Through, Sub Reports, and Cross Tabbed using MS Reporting Services (SSRS).
• Based on Windows Script Host manipulated the files using VB Script.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Created and managed Server level logins, users, roles and groups and handled database security.

Environment: .Net Framework 3.5, Visual Studio 2008, ASP.NET, ADO.NET, Ajax, VB.NET, XML, UML, SQL Server 2008, Microsoft IIS 6.0, Active Directory, WCF, JavaScript, SSRS, SSIS, M.S. Access 2003, Microsoft Visual Source Safe

Confidential,Atlanta, GA Dec 09 – March-10
Position: SQL Server Developer/SSIS/SSRS/.NET Developer

Confidential,is designed to enable the authorized users to carry out Historical and Monthly Reconciliation process. The system enables users to carry out various steps of reconciliation - select the clients for reconciliation, check the status of the clients to be reconciled, create reports for manual data analysis, create summary totals to be send to the NOMAD database and set the recon status to appropriate value.

• Interacted with Customers, Business Analyst, Project manager and gathered and Peer Reviewed the Business Requirements, Software Requirement, Design, Developing, Testing and Maintenance.
• Performed Server installation and configuration using SQL Server 2008.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Coordinated integration of data cleansing scripts with ETL and scheduling tools.
• Worked with different Loop containers and Tasks in Control flow tab.
• Worked with different dataflow source, Transformations and Destinations in Data flow tab.
• Involved in complete SSIS life cycle. Creating SSIS packages, building, Deploying and Executing the packages in both environment(Development and Production)
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using VB.NET, ADO.NET. The middle tier contained all the business logic.
• Designed and developed GUI using ASP.NET and VB.NET
• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, configuring optimizations and securing the web application.
• Developed module which deals with validating user, changing passwords and searching of information depending upon priority of user in site.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to Oracle data sources.
• Extensively used Third Party tools like TIDAL for initiating the SSIS packages through ASP.NET.
• Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel within existing web pages
• Used Microsoft Visual Source Safe (VSS) for the purpose of version Control and source code maintenance needs.
• Experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements using SQL SERVER 2008
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS 2008.
• Very strong experience in ad-hoc reports, Tabular and Charts reports in SSRS.
• Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SQL Server 2008 Reporting Services.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Actively involved in migration of DTS packages to SSIS packages
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Wrote Stored Procedures in designing various SSIS packages.
• Designed SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
• Implement NUnit Testing, Integration Testing and Regression Testing.
• Participated in creating a build deployed strategy that would take care of deploying the Entire App to various Web, App and Batch servers automatically using the NANT Build and deployment solution.

Environment: .Net Framework 3.5, Visual Studio 2008, ASP.NET, ADO.NET, Ajax, VB.NET, XML, UML, SQL Server 2008, Microsoft IIS 6.0, Active Directory, WCF, JavaScript, SSRS, SSIS, M.S. Access 2003, Microsoft Visual Source Safe

Confidential,Florida Feb 09 till Nov 09
SQL Server Developer, DBA SSIS/SSRS Developer /.NET developer

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Interacted with the client as part of the requirements engineering team to finalize the project scope.
• Worked extensively in writing and debugging complex stored procedures, cursors, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Implemented SQL Server SSIS packages for ETL methodologies
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB to M.S. Access and various other destinations
• Migrated Data from SQL server 2005 to SQL Server 2008 using SSIS.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• Designed the User Interface (UI) web interface of the application using prototyping.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Experience with the Share point 2007 to upload the SSRS reports to Web portal.
• Participated in full development life-cycle using Object Oriented Programming concepts and Agile Methodologies (Scrum).
• Designed and Developed Web Forms with various controls to incorporate the User Interface in ASP.NET 3.5
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET 3.5
• Extensively used Informatica PowerCenter ETL tool apart from SSIS to work on the Data Warehouse.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Worked on large number of business analytical functions.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries
• Working with Different methods of taking Database Backup and Recovery procedures.
• Generated database SQL scripts and deployed databases including installation and configuration
• Supported front-end applications under .NET framework.
• Design and development of classes using C#.Net, ADO.NET, XML for database connectivity.
• Provide 24 X 7 supports to all production, development, staging and clustered servers

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 2007,Oracle 10g,DB2, Sybase, Active X, Informatica, M.S. Access, ASP.NET, C#.NET, XML, Microsoft Source safe, Clear Quest, Autosys, Unix, Windows 2003

Confidential,Silver Spring, MD Nov 07 – Jan 09
SQL Server Developer, DBA SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Migrated objects from SQL Server 2000 to SQL Server 2005
• Involved in designing of Conceptual Logical Model and Physical Model
• Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems
• Working on ASP.Net Gridview and various other controls for editing data
• Involved in requirement gathering and complete development of new features and enhanced the application using VB.NET and ASP.NET
• Worked on Stored Procedures and Database Triggers.
• Wrote various T-SQL stored procedures and Triggers, Inner Joins, Outer Joins to carry out tasks.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to M.S. Access and other Destination Sources.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Involved in capturing requirements, preparing business blocks UML, Use Cases, Collaboration Sequence, and Activity diagrams.
• Created databases and specified automatic growth options.
• Design and development of classes using C#.NET, ADO.NET, XML for database connectivity.
• Assigned Reports to Web Application using C#.
• Responsible for data transfer and replication over internet between the offshore development site and onsite implementation site.
• Maintained and developed applications using C# and ASP.NET
• Used ADO.NET data objects such as Dataset, Data Adapter, Data Table, Data Reader and XML Document for consistent access to SQL data sources.
• Created named backup devices to backup the server regularly.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Designing and building data load procedures, using MS SQL Server
• Generated database SQL scripts and deployed databases including installation and configuration
• Created Packages using Integration Services.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Configured two Active/Passive clustering setups for failover on production servers. This included installing windows cluster service and SQL Server 2000 on Windows 2003 Enterprise Edition.
• Used Microsoft Source Safe for version control and configuration management.
• Provided 24/7 support to all production, development, staging and clustered servers.

Environment: SQL Server 2000/2005, SQL Server Integration Services (SSIS), SSRS, SSAS, DTS, T-SQL, Share point 2007, Oracle 9i,Active X, C#.NET, ADO.NET, XML, UNIX, M.S. Access, Teradata V2R5/V2R6, Autosys, Clear Quest, Windows 2003
Confidential,Duluth, GA May 06 – Apr 07
SQL Server 2005 Developer, DBA,SSIS/SSRS Developer

• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Governed and maintained performance and analysis portfolio of SQL Server Reporting Services report.
• Defined parameters to SSRS in C#.NET to run dynamically at runtime.
• Assigned reports using C#.NET to the web application to the end users.
• Developed, prepared unit test documents for all SSRS reports.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Maintained applications in VB.NET
• Involved in system analysis & source system data profiling
• Conducted gap analysis on de-normalizes star schema data model for data warehouse.
• Implemented SQL Server SSIS packages for ETL methodologies.

Environment: MS SQL Server 2005, Server Integration Services (SSIS), SSRS, SSAS, T-SQL, VB.NET, ASP.NET, .NET Framework, C#.NET, Oracle 9i, Microsoft Excel, M.S. Access, QTP & win runner, Microsoft Power Point Erwin 4.0