SUMMARY

• Highly motivated SQL server Developer having IT experience more than 10 years in Database and Business Intelligence Technologies with experience on ETL process using SQL Server 2012/2008R2/2008/2005, SSIS and developing reports using Report builder 3.0
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/ 2008/2005/2000.
• Experience in various Relational Database Management systems like SQL Server, Oracle, DB2 and MS Access
• Experience working in Financial Industry and knowledge of business terminology and process.
• Strong in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, Triggers, User Defined Functions, Views, DDL/DML, TSQL Scripts and Batches.
• Proficient with SQL Query Analyzer and SQL Profiler.
• Knowledge in High Level Design of SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split,Bulk Insert
• Experience in Data Warehousing Concepts and Data Modeling Techniques like Star and Snow - Flake Modeling.
• Experience in TSQL Script programming and batches.
• Experience in Microsoft Visual C# in script component of SSIS.
• Experience in developing Tabular, matrix reports using Report Builder 3.0 and good knowledge in SSRS.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Marveled in Query Optimization, Performance tuning using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experience in QA Testing & Documentation- Requirement Specs, Source-To-Target Mappings, and Test Plans, etc.
• Working experience in domains HealthCare, Pharmacy, Finance, Insurance services.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Operating System: Windows Vista Business / XP Pro. / 2003 / NT / 9.X, Unix, Oracle

Databases: MS SQL SERVER 2000/ /2008 R2/2012, MS Access 2003/2007, Oracle, DB2, MS Excel 97-2003/2007

Programming Languages: C, C++, C#, .Net, ASP, PL/SQL, .NET 2.0, Visual Basic 6.0, Visual FoxPro 5.0.

ETL Tools: SQL Server Integration services (SSIS) 2005 and 2008, Data Transformation Services (DTS),VBA, Data Junction

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Import and Export Data wizard, SQL Server Business Development studio (BIDS).

Development Tools: SQL, SQL Analyzer, Query Analyzer, SQL Server’s Execution Plan

Reporting Tools: SQL Server Reporting Services

Scripting languages: UNIX Shell Scripting, VBA

Scheduler Tools: ActiveBatch, SQL Server Agent, VSS

Models/Framework: OLAP, ROLAP, MOLAP, Star Schema, Snow Flake Schema

.Net Frameworks: .Net Frameworks 1.0/2.0/3.0/3.5

Other Tools and Utilities: Microsoft Office, Adobe Acrobat (Reader, Photoshop, Paint Shop, writer) MS Power Point, Ms Visio

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Responsibilities:

• Actively participated in Investors Data related meetings with users, team lead and technical manager to fully understand the requirements of the system.
• Wrote Stored Procedures, User Defined Functions, Views, TSQL Scrips for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in business requirement gathering and created functional/technical specification documents and Publishing to SharePoint.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created logins, users and configuring permissions and assigning roles to users.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Team member of JPMC Account Number Increase Project in which Modified all the SSIS packages, Stored Procedures, UDF’s to support 17 digit A/C numbers which were 10 digits before.
• Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
• DevelopedSSISTemplates which can be used to developSSISPackages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in Deployment and Administration of SSISpackages with Business Intelligence development studio.
• Created Code Review Approval form & Implementation Plan Approval form templets to regulate deployment of the completed development work in Stage and Production environments.
• Created Test-Plan & Proof of Test documents to support UAT’s
• Implemented automated jobs for Database Backup on a Daily, weekly and monthly basis, based on the volatile nature of database tables and indexes.

Environment: SSIS/SQL 2005/2008, SFTP, BIDS, Visual Studio2010, Visual Studio2013, TFS 2013.

Confidential, Milwaukee, WI

Sr SQL Server/SSIS/SSRS Developer

Responsibilities:

• Reconstructed stored procedures form SQL 2005 to SQL 2012 and increased performance by 20 percent
• Migrated DTS ETL process to SSIS 2012.
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Migrated existing reports to SSRS 2012 and 2014 as per the new DW dimensions.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• For ease of debugging used Event Handlers and logging in my SSIS Packages.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
• Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
• Developed various operational Drill-through, Drill-down and linked reports using SSRS 2012.
• Created Standard and Data Driven both kind of subscription for delivery of those reports.
• Developed stored procedures to use in SSRS report using dynamic SQL and T-SQL.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS 2012.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created various reports for daily claims and deployed to server for higher end users

Environment: SSIS/SQL 2005/2008 R2/2012, ActiveBatch v9, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, TFS 2010, Visual Studio2010, MS Visio.

Confidential, NYC, NY

Sr SQL Server/SSIS Developer

Responsibilities:

• Involved Interaction with Project Managers and Business Teams for requirement gathering.
• Designed Dimension and Fact tables based on the requirements and specifications.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and loaded data into data warehouse.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts fortuningandscheduling.
• Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
• Involved in Deployment and Administration of SSISpackages with Business Intelligence development studio.
• Generated reports usingreport Builder3.0that could be used to send information to diverse group of users, clients, and managers.
• Extensive experience in ActiveBatch V9 scheduler. Installed the tool and moved all the scheduled jobs from Prism to ActiveBatch.
• Scheduled and maintained routine jobs, tasks, and alerts using ActiveBatch. For instance an alert would be sent to the entire Investor team, if any mismatch in the pricing entry by the trading.

Environment: SSIS/SQL 2005/2008 R2, ActiveBatch v9, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, Visual Studio2010.

Confidential, NYC NY

MS SQL Server Database Developer/SSIS Developer

Responsibilities:

• Using SSIS, Along with the LightSpeed server for the Recovery and the Backup of the Customer Data.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Implement migration SQL Server databases, DTS packages from one server to another.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Identified data issues and provided recommendations for resolution to ensure optimal performance
• Performance Tuning and optimization of the store procedure.
• Responsible for the Creation of the Adhoc queries as per the Business requirement.
• Intensively involved in the setup and installation of the Development Server
• Involved in the migration and restoration of the TB data from the staging folder into the development server
• Rectified and fixes various bugs in the stored procedure as well as various suggestion of the outsourcing team is incorporated.
• Resolved various JIRA as per the business requirement.
• Monitored and provided front-line support of daily processes as well as in production server.

Environment: SQL Server 2008R2/2008/2005, SQL, Windows Server 2003, Internet Information Server (IIS) 6.0/7.0, My SQL, MS-Access, LightSpeed.

Confidential, Boston, MA

SQL Server SSIS Developer

Responsibilities:

• Involved in the Installation and Configuration of SQL SERVER 2008 with latest service packs.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Used various Data Flow Transformations, like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension(Task Factory Tool)
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
• Handled the database components (Code migration, Change control) for application releases.
• Creates technical specifications, test plans and test data to support ETL processes. Creating and Fixing the Bugs and change requests.
• Involved in performing data conversions from flat files into a normalized database structure.
• Created a Configuration file, for successful execution of package on any machine and on the server.
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Created Reports on the Performance of the Packages level and deployed the report into SharePoint using SharePoint Destination.
• Identify and map fields to ensure proper data flow to the tables.
• Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s
• Created technical specifications, test plans and test data to support ETL processes.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Maintained data integrity by performing validation checks.

Environment: T-SQL, PL/SQL, MS SQL Server 2008 R2/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS),Team foundation server (TFS)2010, Windows XP, Erwin and Visio, Microsoft Office SharePoint Server.

Confidential, Atlanta, GA

SQL Server SSIS Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into ODS.
• Extract, Transform and Load (ETL) process framework.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Developed SSIS packages using different types of Error Handling for various events.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2, Text files and Excel files) to SQL Server.
• Developed complex queries using joins and sub-queries.
• Experience with ER and Dimensional modeling.
• Performance tuning and Query Optimization.
• Created multiple views and queries for complex SSRS reports.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Created Clustered index and Non-clustered for increasing performance.
• User interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh (dimensions and measures).
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008R2, SQL BI Suite (SSIS, SSAS, SSRS), MS Visual Studio 2005/2008, T-SQL, SQL Profiler, Management Studio.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements from users and business analysts and created requirement documents.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Expert in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
• Created stored procedures to use as the datasets for the Report Design.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports
• Extensively worked on Report coding to behave according to the front end CRM Application.
• Configured Subscriptions and Security for all critical reports.
• Handled the database components (Code migration, Change control) for application releases.
• Creates technical specifications, test plans and test data to support ETL processes
• Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers

Environment: MS SQL Server 2000/2005, SQL Server 2005 Analysis Services (SSAS), Reporting Services (SSRS 2000/2005, Microsoft Visual Studio 2005, BIDS, Visual SourceSafe, MSOffice, HTML, VBScript, Erwin and Visio.