PROFESSIONAL SUMMARY:

• Over 8 years of IT Professional experience in Development, Data Warehouse, Client Analysis, Database Design, and Presentation using SQL Server 2012/ 2008/2005/2000 . Experience in various industries includes Retail, Financial, Health care and Media.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2012/2008r2/2008/2005).
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Real time Experience in Modify SSIS Package & Create SSIS Package by using different sources like XML, SSAS cube, Web - service.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Strong experience in Stored Procedure, User Defined Function, T-SQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Responsible for writing parameterized queries for generating tabular report,Subreports, using global variables expressions and functions, sorting the data, defining the data, defining the data sources and subtotal for the reports using SSRS 2012/2008 R 2/2008/2005.
• Strong knowledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
• Extensive experience in SSRS (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them.
• Experience in finding the various versions of SQL using power shell & manipulating the data.
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, and Star schema for OLTP/OLAP systems.
• Development & maintain Tools like C#, C++ related work tool.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

• MS SQL Server 2008/2005/2000
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• BCP
• Power shell 1.0
• SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.2/7.2
• MS SQL Server 2005/2008 Analysis Services
• Microsoft Visio 2010
• C#
• C++
• T-SQL
• Visual source safe 2005
• MS office 2007/2010
• Windows 2000/2003
• SQL Developer
• Squirrel SQL Client 3.2
• IBM Rational Clear Quest
• CLR assembly (VB.NET)
• JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Englewood, NJ

MS SQL/ SSIS Database Developer

Responsibilities:

• Responsible for scheduling the subscription reports with the subscription report wizard.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Created AD HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse(DW) and Report-Data mart.
• Used power shell to extract, configure & manipulate the data & also to know the various versions of the SQL.
• Generated SSIS Package for ETL Process and develop source to Client data mappings using SSIS various tasks such as Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Developed and tested storage strategies and disaster-recovery plan form operational database, delivering solution that guaranteed recovery performance using power shell.
• Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Interacting with onsite people, Taking clarifications regarding applications and Formulating SQL queries and stored procedures on assigned modules.
• Responsible for estimations of the new requirements or enhancements in existing projects.
• Responsible for requirement gathering and creating requirement and technical document.
• Wrote stored Procedures, Functions and Triggers as per the requirements.
• Designed and implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2008 and wrote the SQL queries, Stored Procedures and views.
• Built data connection to the database using MS SQL Server and Have worked with Database testing and SQL queries.

Tools: & Technologies: Visual Studio 2012, Microsoft SQL Server 2008/2012, SSIS 2012, SSRS 2012, SSAS 2012, JIRA, Team foundation server, SQL Developer, MS SQL Profiler, Power shell 1.0, SQL Server Database Engine Tuning Wizard, Windows Server 2008R2, MS Office 2010, MS Access, MS Visio.

Confidential, Marengo, IL

MS SQL Server/BI Developer

Responsibilities:

• Gathering Requirements from Client and understand current Database and system environment and then integrate it with business logic and made documentation on it.
• Based on documentation generated different data model for the Data Warehouse and worked on Data mapping/Data Profiling & create hierarchy as per business requirements.
• Start working on specification and transformation meanwhile start working to create new structure of DW and other objects like ETL Store Procedure,
• Required Sys tables, lookup tables and also link server to fetch data from different servers.
• Hand on experience to create complex store procedure and ETL SSIS Packages to load records into DW tables, also need to maintain referential integrity between DW tables.
• Generated SSIS Package for ETL Process and develop source to Client data mappings using SSIS various tasks such as Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Created Views and Synonym to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Developed and tested storage strategies and disaster-recovery plan form operational database, delivering solution that guaranteed recovery performance using power shell.
• Created Cluster and Non Cluster Index to optimize performance of TSQL queries.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and parameterized reports using SSRS.

Tools: & Technologies: MS SQL Server 2012,2008 R2, T-SQL, SSIS 2008, SSRS 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v7.1, Windows XP, Power shell 1.0, MS Office 2010, MS Access, IBM Rational Clear Quest.

Confidential, Stamford, CT

MS SQL Server/ETL/BI Developer

Responsibilities:

• Responsible for migrating data from staging area to enterprise-wide data warehouse to store reliable data for decision support systems using Data Stage.
• Transform data in ODS databases and load in the Enterprise data warehouse using SQL Server Integration Services.
• Used several stages like Transformer, Sequential flat file, Aggregator, Remove Duplicates, Merge, sort, and Lookup during the development process of the Data Stage jobs.
• Working to design Dimension model for Business Process during project.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Gathering and analyzing the requirements from both external and internal users.
• Created reports using SQL Server Reporting Services based on the requirements.
• Responsible for transferring the data using SSIS packages.
• Involved in creating web portal for External clients using Microsoft SharePoint 2010.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• SSIS Package Deployment to Production Server as well as Job Scheduling for Package In Daily bases.
• Generate Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard on custom built .NET reporting websites.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Create Complex SSIS Package from POS/XML Source.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work in Interface and for all process

Tools: & Technologies: Microsoft SQL Server 2008, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, VB .Net, Windows Server, MS Visio, Oracle 9i, MS Excel

Confidential, Chicago, IL

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Used the SSIS script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times (using Foreach Loop )
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star schema using dimensional Modeling principles in SSAS.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Designed relationships between the dimensions and measures. Resolved complex many to many relationships and referenced relationships between the dimensions and the measures.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Setup Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2008 Partition functions and schemes.
• Involved in Unit testing integrated testing and System testing.

Tools: & Technologies: Microsoft SQL Server 2005, T-SQL, SQL SSIS, SSRS, Windows server 2003, Visual Source Safe, Visual Studio 2008, Erwin v7.2.

Confidential

Jr. Database Developer

Responsibilities:

• Worked with non-technical colleagues and provide them SQL 2005 queries and store procedures to make their task easy and less time consuming.
• Created complex SQL join queries, views, and store procedures.
• Write Stored Procedures, ad hoc queries, join operations, dynamic SQL to extract the data in smoother and quicker manner out of Database.
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Worked on data cleansing techniques using look-ups, conditional split, and fuzzy lookup.
• Provided efficient error handling to SSIS packages.
• Prepared the reports using SSRS 2005 from scratch.
• Created parameterized, drill down reports and Changed old reports as per requirements using SSRS 2005.
• Create report model to give flexibility to users to create their own reports in SSRS.

Tools: & Technologies: MS SQL Server 2005, SSIS 2005, SSRS 2005, MS Office 2003/2007, MS Access, MS Excel.