SUMMARY

• 7 years of experience in IT, as MS SQL Server Database Developer in Windows environment, current experience with SQL 2008 R2/2008/2005 and BI tools (SSIS, SSRS).
• Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count.
• Experience in creating and deploying packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, and OLDB and migrating DTS packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraint
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• I have a strong grip in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self - motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

Operating System: WINDOWS XP, WINDOWS 7, WINDOWS 8, WINDOWS 2003

Programming Languages: T-SQL,PL/SQL,C,C++,C#, ASP .NET, HTML, XML, JS, VB Script

Databases: MS SQL Server(2000,2005,2008,2008R2,2012),ORACLE

DWH/BI Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Visual Studio, Tableau, Informatica, SQL Server Analysis Services(SSAS)

Packages: MS Visio, MS Project, MS Office

Tools: /Utilities SQL Server Management Studio, SQL Server Enterprise Manager, Crystal Reports, Excel Power Pivot, Erwin 4.0, AutoSys, Visual Source Safe, SVN,TFS

PROFESSIONAL EXPERIENCE

Sr SQL Server BI (SSIS/SSRS) Developer

Confidential, Herndon, VA

Responsibilities:

• Created number of stored procedures, views, triggers, T-SQL Scripts for multiple applications.
• Extensively worked on extraction of data from file systems, ODBC to SQL Server 2008 R2/ 2012.
• Developed T-SQL scripts for Execute SQL task, Execute Package tasks and appropriate transformations using SSIS for the sake of automation of end-to-end ETL process and inputs to downstream systems.
• Written extensive T-SQL Programming, MS SQL Server Scripts, ETL (SSIS) packages, SSRS reports and SAP BOBJ reports, deployment feasibility, cost and time requirements, compatibility with current technologies and system capabilities to integrate new business functionalities.
• Generating various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports in customer level, manger level, vendor level using Microsoft and SAP technologies.
• Written documentation describing end to end business flow, data flow among different applications, program modification and automation processes for maintenance and to support business users.
• Worked on SSIS Package names in a folder to admin tables using Bulk load processing, T-SQL Scripting, query optimization, indexing using SQL server 2008 R2.
• Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases (VLDB) in terabytes.

Environment: Microsoft SQL Server 2012/2008 R2, Visual Studio 2010/2008, Microsoft Data tools, Business Intelligence Development Studio (BIDS), Remedy, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SAP Business Objects (BO/BOBJ), and SAP BI/BW 7.3, Windows Server 2008.

MS SQL Server Developer/ SSIS Developer

Confidential, Clayton, Missouri.

Responsibilities:

• Developed SSIS packages and used Aggregate, Conditional split, Multicast, Derived column, Lookup and Fuzzy Lookup transformations.
• Migrated data from different sources like Text files, Excel spreadsheets to SQL Server databases using SSIS.
• Involved in planning, defining and designing data and provided documentations.
• Created SSIS Packages for Data Migration and Transformation.
• Configured and deployed SSIS packages.
• Worked on various database maintenance tasks in SSIS.
• Used ETL to implement slowly changing Dimension to maintain historical data in Data Warehouse.
• Developed reports using complex queries and filters as per client requirements.
• Created various database objects such as Stored Procedures, Functions, Triggers, Tables, and Views using T-SQL queries to retrieve data from various tables.
• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: Microsoft SQL Server 2008, Windows 2003, T-SQL, PL/SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), SVN, C#, .NET, SSMS

Sr.SQL Server SSIS/SSRS Developer / DBA

Confidential, Dallas, TX

Responsibilities:

• Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
• Installed and Configured Microsoft SQL Server 2008 R2 on different domain servers like dev, QA, UAT and production on Windows operating system.
• Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.
• Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.
• Processed data from flat files, excel files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
• Managed, operated and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.
• Continued to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates
• Developed data importing processes and designed processes/applications to help increase automation, efficiency, flexibility and extensibility by creating T-SQL Scripts, Stored procedures, functions Etc.
• Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis.
• Technical support to users for various purposes like Access change, performance issues and storage space.
• Work in cooperation with other teams and business analysts for of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.
• Running various DBCC commands for administration of database objects and system performance.
• 24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.
• To ensure all scheduled administrative jobs are running or completed for Microsoft SQL Servers.

Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2008/2005/2000 , T-SQL, Visual Studio2010/2008, LINQ, WCF, Team Foundation Server(TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, Red gate, SQL Profiler, Auto sys, DTS, Microsoft Office.

SQL SSIS/SSRS Developer

Confidential, West Des Moines, IA

Responsibilities:

• Created a SSIS package and also windows services to monitor FTP.
• Created complex Stored Procedures, Triggers, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Used joins and sub queries to simplify complex queries involving multiple tables .
• Provided technical support to move databases from development to test and production for multiple applications.
• Experienced in slowly changing dimension in SSIS packages.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with SQL server profiler to generate traces.
• Integration of SSRS Reports using various web parts into Share point and various delivery mechanisms.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Studied the existing OLTP system(s) and involved in creating facts, dimensions and star schema representation for the data mart.
• Worked with Star and snow flake schema designs for the financial data mart.
• Creating SSIS packages to clean and load data to data warehouse.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).

Environment: MS SQL Server 2008/2012, SSIS/SSRS, T-SQL, Visual Studio 2008, Oracle11g, SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), ETL, Microsoft Office SharePoint Server

Jr. SQL Server Developer

Confidential

Responsibilities:

• Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
• Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning.
• Responsible for Developing GUI Screens.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Responsible for creating COM Components using ActiveX DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed various management reports using Crystal reports 8.0.
• Maintain the application as per the user requirement.
• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Developed database objects like tables, views, stored procedures, indexes etc.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.

Environment: SQL Server 2000/2005, ASP .Net, VB Script, Crystal Reports, Access, Crystal Reports, MS Office and windows 2003, C#.NET, T-SQL

SQL Developer

Confidential

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Developed database objects like tables, views, stored procedures, indexes etc. Fine-tuned the logic in
• Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.

Environment: SQL Server 2005, Crystal Reports, MS Office and windows 2003, C#.NET, T-SQL