SUMMARY:

• Over 7 years of professional experience in IT as MS SQLServer Developer R2/2012/2008/2005 in various industry verticals like health care, finance and retail.
• Strong knowledge in working with all phase of Software Development Life Cycle (SDLC) involving systems analysis, design, development and implementation by identifying the business requirements.
• Experience in MS SQL Server 2012/2008/2005 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Database activities like data modeling, database design, performance monitoring.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Expertise in creating complex Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.
• Experience in monitoring and tuning the SQL server database performance using tools like SQL Profiler, Index tuning wizard and database engine tuning advisor.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Package migration Wizard and knowledge on Storage Management.
• Excellent work experience on creating packages to handle Incremental loads and slowly changing dimensions to update data in data warehouse using SSIS.
• Experience in logging, Error Handling, Check Points, and Package Configuration to provide the dynamic flow off data to load data warehouse.
• Expertise in designing Ad-hoc, Drill-Down, Drill-Through, Matrix, Pivot and Tabular reports to match the needs of the end users by interacting directly with Business Analysts.
• Developed various kinds of graphical reports and scorecards/Dashboards to provide the daily/ weekly and monthly reports to provide a better decision making for the current and future years.
• Proficient in deploying reports and creating subscriptions on the report manager and SharePoint site to provide the access to the specific reports to the business users.
• An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS:

Operating Systems: All Windows client and server platforms.

Languages: C#.Net, VB.Net, XML, HTML, T-SQL, PL/SQL

Databases: MS SQL Server 2005/08/12, Oracle 9i/10g, MS Access, DB2, SAS

ETL Tools: DTS, SSIS (SQL Server Integration Services), SSDT

Tools: Enterprise Manager, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, SQL Profiler, ER win, Microsoft Office, MS Visio 2003/2007/2010, MS Project.

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008, Actuate Report

PROFESSIONAL EXPERIENCE:

Confidential, Parsipanny, NJ

Responsibilities:

• Designed and implemented complex business requirement in backend using efficient stored procedures and flexible functions.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Migrated data from different sources (text based files, Excel spreadsheets, Sybase, Oracle) to SQLServer databases using SQL Server Integration Services (SSIS).
• Scheduling and deployment of SSIS packages using SQL server agent for incremental load of datawarehouse.
• Used various tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed Data Models for various kind of databases as per the requirement Visio design.
• Created automated reports using SSRS (SQL Server Reporting Services)
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts.
• Created ad-hoc reports using SQL server 2008 R2 Reporting Services (SSRS).
• Worked closely with Business Analysts and Application Developers to produce all required documentation.

Environment: MS SQL Server 2012/2008R2, SSIS-2012/2008, SSRS-2012/2008, MS Visual Studio 2012, MS Office 2010/2013, VISIO 2010, SQL Query Analyzer, VSS, SSMS, ASP.NET, MS Excel, T-SQL.

Confidential, NJ

Responsibilities:

• Migrated data from SQL Server 2008 to SQL Server 2012 environment.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Developed and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained referential integrity.
• Develop ETL packages using SSIS to load fact and dimension tables for EDW.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Created SSIS packages using complex data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and For-Each loop container in SSIS
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Deployed 2008 R2 Reporting Services (SSRS) RDL files to Reports server and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services ( SSRS ).
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).

Environment: MS SQL Server 2012/2008R2, SSIS-2012, SSRS, Visual Studio 2012, Red Gate, Agent Ransack, VS 2008, PowerShell Scripting.

Confidential, Philadelphia, PA

MS SQL Server SSIS/SSAS/SSRS Developer

Responsibilities:

• Transformed data from MS SQL server2000 to MS SQL server2005 using OLE DB connection by creating various SSIS packages.
• Worked on the Supply and Distribution module of the ChemSMART project as a developer on MS SQL Server 2000 (using DTS, T-SQL, scripts, stored procedures and views).
• Used the execute DTS package task to execute DTS packages.
• Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Generated daily, weekly and monthly Ad-hoc reports in SQL Server Reporting Service (SSRS) on the products, cash inflow and the meetings held by the end users.
• Expert in developing SSIS2008 packages to Extract, Transform and Load (ETL)/DTS data into the Data Warehouse from heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Used SSIS to create ETL packages to validate, extract, transform and load data-to-data warehouse and data mart databases.
• Designed a new schema for the data mart databases.
• Implemented SSAScubes, facts and dimension tables to perform analysis.
• Created MDX queries to extract data from the data mart.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Generated dynamic reports from cubes (SSAS) using SSRS2008.
• Designed, developed and deployed reports in MS SQL server environment using SSRS2008.
• Generated various reports like cascade type reports, tabular reports and drill down reports.
• Created stored procedures, functions and triggers for retrieval and update of data in the database.
• Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
• Created simple data entry applications using C#.Net 2005 and SQL 2005 server.
• Used Index tuning wizard and SQL query analyzer for performance tuning. Worked using SQL server Profiler to apply traces on the stored procedures and queries and rebuild them to improve the performance.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Designed and deployed various complex reports using MS Reporting Services.
• Prepared Documents of each process involved, developed complex stored procedures using T-SQL to generate reports using SSRS 2005/2008.
• Worked on developing cubes and KPI based on Sales, Distributions, PO’s etc.
• Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.
• Analyzed reports and fixed bugs in stored procedures.

Environment: MS SQL Server 2005/2000 SSRS, SSIS, SSAS, SSMS, Visual Studio 2005, MS SQL ProfilerSQL Query Analyzer, MS Visio 2007/2003, MS SQL Server Index Tuning Wizard, T-SQL, VBScriptErwin4.2/4.1/4.0

Confidential

MS SQL Server SSIS/SSAS/SSRS Developer

Responsibilities:

• Created Stored Procedures, User Defined Functions (UFD), Triggers, Indexes, Views, SQL joins to implement business rules.
• Developed and implemented SSRS reports and SSIS packages.
• Actively participated in the development and deployment of new applications and enhancements to existing applications for projects.
• Developed software solutions by identifying needs based on conferring with users, studying system flow, following design documentation, and requirements documentation.
• Prepared Documents of each process involved, developed complex stored procedures using T-SQL to generate reports using SSRS 2005/2008.
• Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.
• Analyzed reports and fixed bugs in stored procedures.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Implemented a defined architecture and participated in code reviews.
• Consulted as needed on technical issues regarding data systems related to data management systems.
• Mentor other developers and provide leadership
• Work closely with others in a team environment on a variety of projects.

Environment: MS SQL Server 2005/2008/R2, Windows XP, Windows Server 2008, SSIS, SSRS, SSASEnterprise Manager, Query Analyzer, XML, MS Excel, Visual Studio Team Foundation Server, Enterprise Architect 8, MS-Visio, MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in logical & physical design, development and testing of the system.
• Developed complex T-SQL code for the application and Implemented constraints on tables.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Generated reports using MS Reporting services.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Worked on backup, recovery and security of the servers (Logins and users).

Environment: MS SQL Server 2005, MSDE, MS Access, DTS, Query Analyzer, MS reporting services, BCP, SQL Profiler, Erwin, Import & Export Data, Windows 2003 Server.