SUMMARY

• Overall 8 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2014/2012/2008 / R2/2005. Experience in various industries includes Financial Services, HealthCare, Retail and pharmaceutical.
• Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL.
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation and Testing.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP.
• 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.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experience in designing and optimization of OLTP, OLAP configuration in SSAS by creating cubes with normal and MDX query.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Expert in using generating Visual Studio 2008/2005/2000 Client Side Report, Tabular Reports, Matrix Reports, Drill down Reports, Parameterized Reports, Ad-hoc Reports, and Stylish Reports usingSQL ServerReporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in Logical and Physical Database design & development, Normalization and Data modeling in star and snow flake schema using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R2/2008/2005
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL server analysis services(SSAS)
• Business Intelligence Development Studio (BIDS)
• BCP
• SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.2/7.2
• Microsoft Visio 2010
• T-SQL
• VB/C# Script
• Visual source safe 2005
• MS office 2007/2010
• Windows 2000/2003
• SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).
• Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Used try-catch block to handle the errors and to store all the errors in a table to handle them later and to continue the flow of execution.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).
• Created and modified various complex Stored Procedures used in the application using T-SQL.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions for SSRS with Conditional Formatting.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Tuned SQL query for better performance using SQL Profiler. Documented all work, so user can easily understand the flow of process.

Tools: & Technologies:Microsoft SQL Server 2014, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, BIDS 2012/2014, Windows Server, MS Visio, Oracle 9i, MS Excel

Confidential, Philadelphia, PA

MS SQL SERVER/SSIS Developer

Responsibilities:

• Installing and configuring, upgrading theSQLServer Databases, Monitoring and Performances.
• Develops automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Ran and tested required queries and reports before publishing.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Wrote various functions including scalar functions, Inline table-valued functions, Multi-statement table-valued functions.
• Maintained database environments, backup and recovery, database security, tuning, administration and also involvement in the design and development of new databases.
• Installing and maintaining theSQLServer Databases, monitoringSQLagent jobs, assisting development teams with data cleansing, migration with reviewing, building, testing and maintaining database structures and SQLscripts.
• Published the reports and scheduled the reports in different formats (Email, Public Folder).
• Created trace in SQL Profiler and used Database engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

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

Confidential, Providence, RI

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2005/2008.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2005/2008 R2.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008 R2.
• Involved in setting up and implementation of the 2005/2008 reporting server.
• Created complex reports using SSRS 2005/2008 R2 from the OLAP cubes for end user analysis.
• Migrated reports from MS SQL Server Reporting Services R2.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2005/2008 R2 using data from a variety of sources.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Scheduled the reports on capacity levels of different servers to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Scheduled tasks to run every day to update changes in the base tables.
• Added/modified Users, Groups, folders and rights.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.

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

Confidential, New York, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Stored Procedures, Functions and Triggers using TSQL to migrate the data.
• Created SSIS packages to clean the incoming data including address and to find out if the address is valid or not.
• Performed data analysis and designed source to destination mapping.
• Involved in migration of data from main frame server to SQL Server database using Target Adapter.
• Designed and developed Matrix and Tabular reports with Drill Down, Drill Through, Parameterized, Sub Reports and Drop down menu option using SSRS 2005.
• Developed reports with Charts and Multiple Datasets using Reporting Services (SSRS).
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
• Created a stored procedure to automate the execution of all the stored procedures and to schedule the jobs.
• Installed SQL Server, applied service packs and hot fixes.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load.
• Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically
• Performed tasks like Backup, Restore, Data Profiling using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler and SQL Server agent.
• Created .Net windows application to display all the data from different tables in grid view based on the search.
• Used Merge Join extensively to load the data from production database to operational database and to perform basic de duplication.
• Involved in writing functional specification document that has all the details of the work done to migrate the data

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

Confidential

MS SQL Server Developer

Responsibilities:

• Worked with Sr. Developers to convert verbal requirements into technical format.
• Modified code and provide extremely complex logic to the code for best results and better performance.
• Used SQL Profiler to monitor the performance of SQL Server.
• Scheduled replication on the databases.
• Actively participated for the meetings to decide the backup policies for the database and perform back up operations on databases.
• Performed Join operations using on large scale database tables.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
• Created Indexes on database tables to perform the Read operations of the database.
• Wrote extremely complex Stored Procedures with the use of Cursors, Triggers, and UDFs to provide best performance of the application.

Tools: & Technologies:MS SQL Server 2005, T-SQL, ER-Win v4.0, Windows 2000, BI studio 2005, MS SQL Server 2005, Windows Server, Windows NT