SUMMARY

• 8+ years of IT experience in Database Design, Data Modeling, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/20 .
• Strong experience in Business Intelligence (BI) using Visual Studio 2010/2008/2005.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005 databases and scheduled them according to requirements.
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Experience in working with Reporting tools like MS SQL Server Reporting service (SSRS).
• Experience in working with Data Warehousing and business intelligence tools for developing various reports.
• Experience in developing and monitoring ETL Packages using SQL Server Integration Services (SSIS), creating cubes for analysis using SQL Server Analysis Services (SSAS), developing reporting solutions using SQL Reporting Services (SSRS).
• Monitoring Production environments by our DBA group for scheduled releases and ad - hoc issue resolution.
• Extensive experience in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2012/2008/2005 .
• Experience in Logical Modeling using Dimensional Modeling techniques such as Star Schema and Snow flake Schema. Created Multidimensional cubes using SQL Server Analysis Services (SSAS).
• Proficient in SSAS functions like Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security roles within a cube.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, partitions, facts, dimension tables using MS Analysis Services.
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on report server.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance.
• Experience in executing complex T-SQL queries using stored procedures, Triggers, Cursors and User Defined Functions
• Created database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL
• Created recursive queries using Common Table Expression (CTE).
• Performed database consistency checks at regular intervals.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, VB.Net, C, C++, Phython

Services: Database Engine, DTS, SSIS, SSRS (Visual Studio 2012, 2008, 2005)

RDBMS: MS SQL Server 2012, 2008, 2005, 2000, 7.0, MS Access

Reporting Tools: BIDS/SSDT, Report Builder 2.0, Crystal Reports

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5.

Other Tools: DTA, SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Litespeed, RedGates

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. SQL / SSIS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in Preparation/Author of ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML, OLE DB Source (Flexnet, PMC) to SQL Server 2008 R2.
• Responsible for creating the reports basing on the requirements using SSRS 2012.
• Data migration (import & export - BCP) from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Environment: SQL Server 2012/2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential, Alabama, GA

SQL Server / SSIS Developer

Responsibilities:

• Migrating data from Legacy system to SQL Server using SQL Server Integration Services 2012.
• Used C# scripts to map records.
• Involved in SSIS Package creation from package design documents, build package and also perform Unit testing of the SSIS extract by building validation packages to check the accuracy of the data migrated.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created Test packages to validate the SSIS packages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server,Flat files and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2012 reporting Services.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Expertise in generating reports using MS Reporting Services 2012.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Created high-level architecture and full solution design both hardware and software in Windows Azure.
• Developing and executing on the plan for expand the ecosystem of ExpressRoute connectivity partners and System Integrators to accelerate adoption and growth of Azure & ExpressRoute customers
• Excellent command on subscriptions, report snapshot and report cache.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Worked on database configurations and Accessibility.

Environment: MS SQL Server 2012, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2012, Microsoft Office, XML, Team Foundation Server (TFS), SharePoint, CloudBerry, AZCopy, Azure.

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

• Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
• Played major role on production support (operations) running and scheduling jobs, backups, cube refresh and so on.
• Handled day to day Service Requests (SR) coming from end users/customers.
• Used C# scripts to map records between CRM and Legacy database.
• Involved in SSIS Package creation from package design documents to package build.
• Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with front end developer to put in the business rules. Wrote stored procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed the project using iterative approach.
• Created new SSIS packages according the business rules.
• Participated in creating reports using SSRS.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2008/2005, SQL Server 2008 Integration Services (SSIS), SQL Server 2008 Reporting Services (SSRS),SQL Server 2005 DTS, MS Access 2003, MS Excel 2003, VB.Net, OLEDB, Visio 2003, Microsoft Outlook 2003, XML, Windows 2003 Server/XP.

Confidential, Wayne, NJ

SSIS Developer

Responsibilities:

• DesignedSSIS packages to Extract data from different sources like SQL server 2008R2, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developing reports on SSRS on SQL Server (2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing with off short team
• Created and modified Stored Procedures, Functions, and Indexes
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.

Environment: MS SQL Server 2008 R2, Oracle 11g, XML, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2005, Erwin, and SQL Profiler, Actuate Report.

Confidential, New York

SQL Server Developer

Responsibilities:

• Participated in joint application development session (JAD) to gather information about clients need and to get familiar with vendorsproduct.
• Migrated databases from Sybase to sql server DBAs.
• Frequently requested the promotion of the Development team’s database software objects to our QA, UAT and Production environments by our DBA group for scheduled releases and ad-hoc issue resolution.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBCPto move in or out data from different sources.
• UsedBulk Inserttocopy large amount of data into database.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Backing upmaster & system databases andrestoring.
• Design and automation of disaster recovery procedures.
• DevelopedMerchandise Business Analysis reportfor Top management and Category Buyers using reporting services(SSRS)and deployed to reportserver.
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Maintained and createdReplication:Merge,Transaction and Snapshotand also implemented data transformation to the published articles.
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by usingPerformance Monitor,Profiler, andIndex tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQLServer2005, VB 6.0, XML, VB.Net, SSRS, SSIS.