SUMMARY

• Over 6 years of IT experience as SQL developer in design, development, test, and Production support using MS SQL Server 2012, 2008/R2 and 2005 of various applications for Sales, Transportation, Insurance and Healthcare.
• Proficient in writing SQL queries, stored procedures, database triggers, exception handlers,SSISExport& Import.
• Experience in working with SSIS (SQL Server Integration Services)as an ETL tool for Data integration servicesand business applications .Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Experience in migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.
• Extensive experience in creating multiple various types of reports using SQL Server Reporting Services (SSRS) like parameterized reports, detail, in linked and Drill mode using tables, financial tables, crosses tabs and charts.
• Skilled in writing Transact - SQL in SQL Server Management Studio and Query Analyzer to handle database objects.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.Writing, debugging, and optimizing various complex stored procedures, Views, Triggers, Functions, Data Modelling for the mission critical application development and Monitored, Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Performance optimization.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Strong Experience in data warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications, design of Star and Snowflake Schema and cubes using SQL Server Analysis Services (SSAS) for Business Intelligence applications.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging and Extensive knowledge of Software Development Life Cycle (SDLC).
• Extensive Knowledge in working with MDX for OLAP and OLTP systems, data analysis and architecture skills.
• Knowledge on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades.
• Self-motivated and also worked in a technically challenging environment.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS

Languages: SQL, TSQL, PLSQL, XML, Java, HTML, C, C++.

Applications: Microsoft SQL Server 2005/2008/2012 , SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS), Oracle 8i/9i/10g/11g, MySQL, MS-Office, Visual Studio 2005/2008, MS Visio, SQL Developer, XML Spy.

Operating Systems: Windows 95/98/XP/ 2000/2003/2008 Server, Fedora, Red Hat.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

MS SQL Server Developer/ SSRS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• As a Team Player, involved in gathering the Business Requirements for Extraction of Data from different sources.
• Responsible for database design and creation of tables, views and functions.
• Developed custom reports using SSRS/SQL Server BI studio.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminateBlocking& deadlocks /user counts and connections/locks etc.
• Provide database coding support to application development team.
• Extract Transform Load (ETL) development using SQL 2012/2008 Integration Services (SSIS).
• Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Used system stored procedures and DBCC commands.
• Wrote some complicated stored procedures in order to meet the requirements.
• Successfully migrated the data from various sources such as Oracle, Flat files, Excel filesandMS Access.
• Created new SSIS packages for Extracting data using Sequence Container, For Each loop Container, Execute SQL Task, Merge Transformationetc,.
• Modified the Existing SSIS Packages to improve the performance of Data Load.
• Generated Quarterly, Semi-Annual and Annual reports through Tabular and Matrix reports using SSRS Reporting tool.

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Reporting Services 2005/2008/2012 , T-SQL, Oracle 11g.

Confidential, Joplin, MO

SQL Server/ETL Developer

Responsibilities:

• Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Design and develop data transformation processes.
• Design and develop SSIS packages for data transformations and importing into new database.
• Created different kinds of financial reports,cachedreports,linked reports etc in drill mode, using tables,charts,cross tabs
• Design T-SQL code blocks.
• Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.

Confidential, Smithfield,RI

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Scheduling Jobs and Alerting using SQL Server Agent
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Developed various reports for managing various securities and assets to meet specified investment goals.
• Worked Extensively with Business System Analysts who has drafted the requirements for me and helped me in testing the report results.
• Extensively involved in high level design of OLTP and OLAP based Databases.
• Used Extensively MS SQL Server Reporting Services 2008 to develop various kinds of reports and test them with users and finally deploy them.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Formatted the report layout for the requirement of the end users and deploy the developed Linked, history and sub reports on to the server for the end users.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL.

Confidential, Bloomfield, CT

SQL Server Developer

Responsibilities:

• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages.
• Worked with cubes in analysis services to analyse input data for data mining operations.
• Migrated data from flat files to SQL Server.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.
• Managed indexes and optimized queries using execution plan.
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created users and logins and granted the permissions at server and DB level.
• Managing SQL servers, databases, and storage management.
• Implemented VB.Net script and performed testing.
• Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations

Environment: MS SQL Server (2008, 2008R2), Visual Studio (2008, 2010), VB 6.0,SSIS, SSRS, Query Analyzer, Windows Server 2003, SSAS, T-SQL, C#, UNIX

Confidential

SQL Server Developer

Responsibilities:

• Created and modified procedures, triggers and functions
• Used MDX to work with OLAP and OLTP database systems.
• Worked with SQL Server Analysis Services to provide a rich set of data mining algorithms to enable business users to mine their data looking for specific patterns and trends. These data mining algorithms can be used to analyze data through a UDM or directly from a physical data store.
• Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Modified store procedure for performance tuning
• Used DTS packages to do file operation, to apply business rules.
• Extensively used Ultra-Edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency
• Transformed data from text file to SQL server using OLE Automation Objects
• Deployed database objects from development/testing environment to production environment
• Created DTS package to export and import data from SQL Server to text files and data files.
• Worked with Application Developers to support Development activities and achieve optimal efficiency.
• Monitored and scheduled existing/new jobs on production environment.
• Created all administration tasks of SQL Server.
• Used system stored procedures and DBCC commands.
• Keep trace of version of store procedure in Visual SourceSafe
• Responsible for keeping system and databases up-to-date by making necessary changes.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL,BIDS.