SUMMARY:

• Around 8 years of MS SQL Server Development experience in Finance, Production & Marketing, Telecommunications and Health Insurance domains with expertise in MS SQL Server 2000/ 2005/2008/2008 R2 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in the development of SSIS packages.
• Identified and resolved problems encountered during development and release of the SSIS code.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experience in Deploying the created SSIS packages in Development and Testing environments.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated the Reports with all the subcategory Information to Business users.
• Developed and Deployed different types of Reports like Ad Hoc, List, Drill Down, Drill Through, Matrix, Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2008R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe,SQL Query Editor

Languages: T-SQL, HTML, XML,SQL,C, VB.Net, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. SQL Server Developer/Data Modeler

Responsibilities:

• Actively involved in gathering requirements from the business/end users.
• Lead a team of 4 individuals from offshore and assigned the tasks and was involved in the project estimates.
• Provided mapping documents for the source and target systems and involved in Data Conversion and Data Cleansing by loading data to staging tables.
• Ensured business requirements and system requirements are complete and translate them into unit tests, test cases, and other technical artifacts.
• Worked actively with the client to define the source data extraction strategy and file Structure.
• Defined validation rules for raw data validation and integrity validation of the source data.
• Designed the data cleansing techniques to improve the quality of the source data.
• Created programs in PETL for all above projects which involved in using generic packages for file loads and complex stored procedures to meet the business requirements for different clients.
• Assisted in production deployments and provided support if there are any issues and was available on call during the deployment.
• Developed process to extract the data from Tibco ADB tables and created campaigns for different types of letters for Europe.
• Implemented new enrollment process by extracting data from different sources (Tibco and Microsoft CRM) for Europe Clients.
• Loaded data to GreenPlum which is one of our Data Warehouse environments from SQL Server 2008 reporting environment.
• Provided Adhoc queries for data validation and involved in error handling through stored procedures and in SSIS.
• Developed Parameterized, Drill down reports for claims and enrollments using reporting services (SSRS).
• Created Data marts for Claims and Enrollments for analysis of past trends and experiences.
• Modified existing and created new reports in SSRS to meet the requirements as per Client Services and published them to the SharePoint server.
• Configured user accounts and their privileges using Sharepoint and created different directories which hold the documentation for all the projects.
• Part of the team which built the dashboards using .NET technologies for development (PETL), and using PHP for operations (ETLOC). ETLOC also interacts with change management to schedule the releases for ETL Operations/DBA/CM. Sends updates via Email to different groups involved in the deployment and there by eliminates the manual involvement of people.
• ETLOC which is also the primary UI for operations to track the status of each job.
• Developed custom packages to load the data from Postgres server to SQL server and there by loading the facts and dimension tables.
• Created facts and dimension tables using STAR schema and involved in data modeling for AMA project and created a cube and generated reports using SSAS from the cube.
• Proficient in MDX scripting and building ADHOC reports for End Users using SSAS.
• Provided daily files for activation process to Sprint by updating the claims in the target system which involves closing the claims and shipment of claims.
• Ensured to work with end users to do the validation by providing Adhoc queries.
• Worked closely with Project Managers, BAs and Integration Testing Team to ensure delivery of high quality solutions that meet functional and business requirements.

Environment: SQL Server 2005/2008/2008 R2, SSIS, SSRS, Windows NT 4.0/2003, Sharepoint 2010, Tibco, Microsoft Dynamics CRM, Microsoft Dynamics (DAX), GreenPlum.

Confidential, Eden Prairie, MN

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server 2008 R2 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• Designed and developed SQL Server 2008 R2 databases, including tables, stored procedures and functions.
• Created, Implemented and Executed T-Sql statements including Triggers
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Stored Procedure development, Enhancements, Performance tuning.
• Provided technical support to internal developers and external clients.
• Created Packages that dealt with text files containing dynamic number of columns.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Reports migrations from Actuate to SharePoint/SSRS technology.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL and Promoted RDLs to Reporting Service Server (SSRS).
• Had involved in Start to end of enhancements projects like creating Business Required Document (BRD), Developing, Testing, creating UAT test scripts, opening remedy tickets.
• Involved in organizing meetings with Production Management and Architecture Approval teams and involved in Production Deployment support.

Environment: MS SQL Server Management Studio 2005/2008R2, MS project, MS SQL Server Integration services(SSIS),SQL Server Reporting Services(SSRS),Microsoft Visual studio 2005/2008R2,Borland Starteam, Microsoft Visual Source Safe, VB.Net, MS Excel, Window XP.

Confidential, Hartford, CT

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Designed SSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Responded to AD-HOC requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Environment: MS SQL Server Management Studio 2008, Query Analyzer,, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential, Richmond, VA

SQL Developer/SSIS/SSRS /SSAS

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005.
• Actively supported business users for change requests.
• Created several databases in various Development and Test server by using SQL Server 2005.
• Created several tables, views using SQL Server 2005 Management Studio as well as in Oracle 10g and Oracle 9.0 / 8.6 using Toad. These tables, views are created based upon the function spec.
• Generated scripts and schemes by using reverse engineering through Toad Data Modeler.
• Responsible for making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
• Responsible for installation, configuration, security, maintenance and restoration of SSRS on Windows Server 2003.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Imported and exported data in the tables using Toad for Oracle and SSMS for SQL.
• Performed Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS in SQL Server 2005.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Performed report testing and Verification as per internal reporting system requirements.
• Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2005 as assigned.

Environment: MS SQL Server 2000, MS SQL Server Reporting Services 2005, SSIS, SSAS,Oracle 8i / 9i / 10g, Toad, Toad Data Modeler, MS Office, Windows XP/NT.

Confidential

SQL Server Developer

Responsibilities:

• Coordinating with the Production monitoring Team, which monitors daily data loads from R/3 systems, SEM-BPS, APO, CRM and flat files.
• Scheduled and modified the Process chains as per client and market requirements.
• Delivered daily, weekly and monthly SSIS reports of ten process modules on-time to the users with in SLA’s, and detailing data discrepancies.
• Analyzed problems related to data loading performance - Ticket Resolution.
• Analysis of Performance of the system (Checking for Deadlocks and Lock waits).
• Monitored and analyzed the Data loads to identify reasons for frequent failures and resolving the errors.
• Communicated with the key users and quality review board for validation of tickets before applying for production.
• Created documents to track work flow, deliverables, and operating procedures required for project delivery.

Environment: MS SQL Server Management Studio 2008, Query Analyzer, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2000.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth. .
• Generated Reports for the day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition views Using T-SQL.

Environment: Microsoft SQL Server 2005 Enterprise Edition Microsoft Share Point 2007Enterprise manager, Query analyzer, DTS, SQL profiler, SVN.