SUMMARY

• About 6+ years of experience in IT, as MS SQL Server 2012, 2008/2005Database Developer in Windows environment.
• Extensive experience knowledge in ETL using SQL Server Integration Services (SSIS).
• Experience inBanking,HealthCare domains with expertise in MS SQL Server 2012/2008/2005/2000 suite of products like SSIS, SSRS.
• Experience in Designing and Implementation of Business Intelligence applications using SQL Server 2005 and 2008 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Expert in Creating stored procedures, Views, Indexes and effective User Defined functions and appropriate Triggers to facilitate data manipulation using T - SQL.
• Experience with Data Transformation Services (DTS) an Extract Transform Load (ETL) tool of SQL Server to populate data from various data sources by creating packages for different data loading operations for each application.
• Implemented SSIS data updating using tools such as SSIS Slowly Changing Dimension Task controls.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, Netezza, MS SQL, Excel and MS Access.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2008/2005
• Experienced in designing and developing large number of enterprise reports (SSRS) using the data from ETL loads and various heterogeneous data sources.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Expert level skills in Data Modeling,Normalization,Optimization and Performance Tuning.
• Experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and Tuning MS SQL Server Performance
• Experience in different team projects with extensive project implementation, team skills,troubleshooting, presentation abilities and issue resolution capabilities.
• Involved in Agile Methodologies to produce high quality results.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts. Experienced in working effectively under pressure in order to meet deadlines in a rapidly changing environment.
• Ability to learn new languages and tools quickly and efficiently with the ability to work under high pressure distinguishes me from my peers.

TECHNICAL SKILLS

Databases: SQL Server /2005, MS Access, Excel.

Database Utilities: Enterprise Manager, DTS, SSIS,SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Jobs, SSAS.

ReportingTools: SQL Reporting Services (SSRS), Crystal Reports, Business Object.

Languages: C/C++, SQL, T-SQL, VB.6, C#.

Operating Systems: Win 2003, Win 2000, Win NT, XP, Mainframes.

Application Packages: MS-Office / 2008

Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.

Other Tools: Microsoft Visual Studio 2008/2005/2003

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

SQL BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions
• Created SSIS Packages to import and export from Excel Spreadsheets, Text files and CSV files through FTP.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Worked on building several new SSIS packages and updating existing packages and created related scheduled jobs.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS. Back end experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers.
• Responsible for creating the reports basing on the requirements using SSRS .Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Used Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Created jobs maintenance plans for rebuilding of indexes and updating statistics.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: SQL Server 2012/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment .Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, and Teradata

Confidential, Louisiana

SQL BI Developer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Involved in full Software development life-cycle (SDLC) followed by Agile methodologies to produce high quality software model.
• Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
• Strong experience in working withBCP,SSIS(DTS,DTSX)packages forData Integration Services.
• Extensive knowledge of usingSystem Variablesand creatingUser-Defined VariablesforSSISPackages.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• 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)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Extracted data from various sources like SQL Server 2012/2008, .CSV, DB2, Excel and Text file from Client servers and through FTP.
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008R2/2005 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, SSAS, ProClarity, OLAP, XML, SharePoint, Agile, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP.

Confidential, Atlanta,GA

SQL Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Created SSIS packages to extract data from OLTP to Data warehouse and scheduled jobs to call the packages.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Created Stored procedure, Views and user defined function. Extensively used Joins also Cross join on the tables for extracting desired data.
• Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loadeddata using different transformations such asDerived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Wrote and modified numerous stored procedures and Functions and created and modified existing SSRS reports and uploaded them on Repositories.
• Created complex Drill Down reports, Custom Code functions,Chart Reports, Parameterized and Matrix SSRS reports.
• Involved in analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Worked on various ADHOC reports request and generated results on Excel and CSV file Reports.
• Provided support by troubleshooting and solving the issues.
• Actively participated in review team meetings with Manager to ensure that the development of projects meet business and system requirements also Received appreciation for dedication to service and overall excellent management of assigned duties.

Environment: MS SQL Server 2005,2008,SSMS 2005,2008, Visual Source Safe, EXCEL, Access, Mainframes,Windows 2003 Server, Windows XP Professional, Visual Studio 2005,2008.

Confidential, Renton WA

SQL Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loadeddata using different transformations such asDerived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created Stored procedure, Views, Cursors and functions to support application
• Extensively created SSRS reports (Executive Summary report for Annual and Quarterly)and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Actively supported Business users for change requests and provide support to team members.
• Provided support by troubleshooting and solving the issues.

Environment: MS SQL Server 2008 R2,SSMS 2008, Neteeza,DB2, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010, Star Team.

Confidential

SQL Developer

Responsibilities:

• Involved in Creation of database, tables and procedures to update and clean the old data.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule
• Created Indexes and Triggers to maintain data referential integrity using T-SQL.
• Created various parameterized, linked sub reports using MS Reporting Services (SSRS).
• Implemented ETL by creating the SSIS packages to migrate and load the data
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered reports using ‘pulled’ and ‘pushed’ methodologies and formatted them using Global variables and expressions.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2005 (SSIS, SQL Profiler), T-SQL,MS SQL Reporting Services 2005(SSRS), MS Access 2003, MS Excel, Window 2003.