SUMMARY

• 8+ years of strong IT experience with MS SQL Server 2012/2008/2008 R2/2005 as SQL Server developer and ETL Developer.
• Proficient in requirement gathering, analysis, design, development and user training.
• Expertise in the installation of SQL Server and SQL Server Enterprise manger tools using SQL Server Setup Program
• Strong understanding of designing Database Models using MS Visio and ER - win.
• Proficient in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong knowledge of Enterprise Data Warehousing and Data Mart in OLTP/OLAP environment.
• Extensive experience of working with Transact-SQL and PL/SQL (DDL and DML).
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts
• Expert in Tuning SQL queries and improving the query performance using Database Engine Tuning Advisor.
• Experienced in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Highly proficient in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access
• Strong experience of creating jobs and alerts on linked servers for MS SQL Server/Oracle/ Sybase databases.
• Extensive experience of working with SQL Mail Agent and schedule DTS and SSIS packages.
• Highly proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SQL Server Integration Services.
• Expert in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports and Business Intelligence Development Studio.
• Expert in creating Reports, sub-reports, parameterized reports and dashboards using Performance Point server.
• Expert in publishing reports on Report Server, SharePoint Server and other portal for users.
• Good experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Worked on OS like Windows, Linux, Unix.

TECHNICAL SKILLS

• MS SQL Server 2012/ 2008/ 2008 R2/ 2005
• DTS
• SSIS 2012/ 2008/ 2005
• SSAS 2012/2008/2005
• SSRS 2012/2008/2005
• Windows Server 2008 R2/2005
• Performance Point Server 2007
• Report Builder 3.0
• T-SQL
• PL/SQL
• MS Visual Studio 2010/2008/2005
• Microsoft Project 2003
• MS Visio 2007
• MS SQL Profiler
• SQL Query Analyzer
• Erwin 8.0 Data modeler
• Crystal Reports11/10/9/8.5
• M.S. Access java java script
• Jquery
• VB.net
• Windows
• Linux
• Unix.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. MS SQL Developer/Engineer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin 8.0 on business requirement and provided documentation.
• Developed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Created and modified complex stored procedures, complex views and indexes based upon Detail design and Business requirements diagram.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Developed DDL and DML triggers and CTE.
• Designed queries using merge statements, joins and functions.
• Performed performance tuning of stored procedures and queries using execution plan, SQL profiler and database engine tuning advisor.
• Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column Using SSIS.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures.
• Used C# to create script tasks for migrating data and creating simple webforms.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Performed performance tuning of SSIS packages.
• Designed, Developed and Deployed tabular and matrix reports in MS SQL Server environment using SSRS.
• Created parameterized and drill down reports for better visualization of reports.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Created SQL agent jobs for smooth and timely running of the SQL projects.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Involved in creating web forms using C#. Worked on front end screens and DALs.
• Involved in backing up stored procedures, views and packages on version manager tools like TFS.

Environment: Microsoft SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visio 2007, Microsoft Project 2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Windows2000 Advanced Server, Unix, Linux.

Confidential, SanJose, CA

Sr. MS SQL Developer/Engineer

Responsibilities:

• Involved in creating requirement according to business logic.
• Involved in creating stored procedures, complex views and UDF’s on SQL server 2012 for integrity checks of transferred data.
• Experience in creating SSIS packages in SSIS 2012 and performing unit and system test on them.
• Experience of deploying Integration project in system, UAT and Stress environments creating environment variables.
• Experience of working with TFS and Serena business viewer for Versioning and source code management.
• Experience of working in Agile environment and involved in Agile meetings for better planning and smooth processing of the project.
• Involved in creating Test Data for Unit Testing and Integration Testing.
• Performed Unit, UAT and stress test and SQL performance tuning.

Environment: Microsoft SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visio 2007, Microsoft Project 2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Windows2000 Advanced Server, Unix, Linux.

Confidential, NY, NY

MS SQL/ SSIS/SSRS DEVELOPER

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and developed SSIS packages to move data from staging environment to EDW environments within the organization.
• Developed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to DW with the help of SSIS.
• Extensively used SSIS for transferring data by utilizing various control flow and data flow elements.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Experience of working with .net developers in creating approval dashboard for UI using ASP.NET, HTML, and CSS for styling the Web pages.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL (SSIS) processes used to populate the Data Warehouse.

Environment: Microsoft SQL Server 2008R2 Enterprise Edition, Windows Server 2008, Visual Studio Team System 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Builder 3.0,Performance point server 2007,Microsoft SharePoint 2010, Visual Source Safe 2005, SQL Profiler, ASP.net 2.0

Confidential

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Implemented SSIS Package (ETL) to Extract and Transform data from Oracle RDBMS, Flat File or CSV, SQL Server 2005 instances and to Load into Staging Database. The main purpose to load data into staging database is to use key tat populated in fact table. And then to Data Warehouse for further Data Analysis by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained every mid-night and weekly load data by creating corresponding job task by SQL Server Agent in SSMS.
• Used Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Developed Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Involved in Designing and deploying cubes in SSAS environment using Star.
• Designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Created Reports using MDX queries and creating MDX Base Report Definition.
• Created and run Sub-reports, Drill-down reports, Matrix or Crosstab reports and Summary reports in SSRS.
• Designed subscriptions to generate reports on daily and weekly basis via FTP.
• Managed Report Security by using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Involved in Creating Scorecard Reports using Performance Point Server for the managers.
• Used SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the development work.

Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS),Performance Point Server 2007, Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio 2005, IIS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and user training.
• Participated in the installation of SQL Server and Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Migrated Access objects to SQL Server 2000.
• Created Tables, Indexes and Constraints.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and Monitored database application.
• Designed and implemented several complex Reports and Administration modules.
• Defined Stored Procedures for module integrity and application.
• Wrote database Triggers in T-SQL to check the referential integrity of the database.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in Performance tuning of the database and T-SQL queries.
• Developed reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Preparation of test plans for assembly testing & System Integration testing.
• Troubleshooting and solving complex problems working with SQL Server support.
• Participate in review meetings with Sr. Business Analyst and Manager.
• Prepared Project Documentation.

Environment: SQL Server 2000 Enterprise Manager, Windows 2000, DTS, T-SQL, Visual Basic, Crystal Reports 8.0