SUMMARY

• Over 7 years of Professional Experience in Development, Testing and Support of Microsoft SQL Server 2012/2008 R 2/ 2008/2005/2000 on various business domains.
• Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
• Experienced in the migration and implementation from other databases to MS SQL Server
• Expertise in establishing and managing all standards, processes, artifacts, relative to the practice of Configuration Management.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle, Teradata to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expert in MS SQL Server BI suite of products like SSRS, SSAS, SSIS on MS SQL Server 2008, 2005.
• Experience in Extraction & Migration of data from heterogeneous data sources like Excel, MS Access, Oracle to MS SQL Server by using import/export Wizard, SSIS, BCP and Bulk Insert utilities
• Expertise in Creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
• Experience in working with SSRS, designing different types of reports like Parameterized Reports, Cascading Parameterized Reports, Drill down Reports, Drill through Reports, Tabular Reports, Matrix Reports, Sub Reports, and Ad-hoc Reports
• Experience in creating the FACT and Dimension Tables.
• Experience in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, MDX Scripts and formulas, Refresh Strategy and Planning.
• Worked on Fine Tuning SQL scripts, Indexes, Stored procedures and Views to reduce execution time. Monitored the query processing Using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics.
• Experience in regular maintenance activities like Index Rebuild, Query tuning, Stats Update, Log file Monitoring, Temp DB monitoring, Deadlock resolutions, and Blocking contention issues.
• Implemented the new SQL Server 2008 concepts like Data Partitioning, Snap shot isolation, Database mirroring, Database snapshot, DDL triggers, Try-Cache blocks, online indexing.
• Extensively worked on Active-Active and Active-Passive Clustering, Troubleshooting production issues and making high availability, meeting Service level agreements.
• Experience in using DMV and Dynamic Management Functions (DMF) for finding out Long Running queries.
• Worked closely with developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Experience in analysis, development and deploying of windows application, web services and window services in Microsoft Visual Studio .Net IDE using C#.Net 1.1, C# .Net 2.0, VB.Net, ASP.NET, ADO.NET and SQL Server.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), ERWin, ETL, Analysis Manager DTS Import/Export Wizard

Databases: MS SQL Server 2012/2008R 2/ 2008/2005/2000, Oracle 8i,9i/10g, MS Access 97/2000, DB2

Languages: T-SQL, C#, ASP.NET, VB.Net

Operating Systems: Windows NT/ 95/98/2000/2003/ XP

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

Sr. SSIS and SQL Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Used different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, Merge join as required using SQL Server Integration Services (SSIS).
• Used FTP task to pull the XML files from FTP Server. Scheduled the SQL Server Agent Jobs for SSIS packages.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Studied the existing OLTP system(s) and involved in creating facts, dimensions and star schema representation for the data mart.
• Worked with Star and snow - flake schema designs for the financial data mart.
• Creating SSIS packages to clean and load data to data warehouse.
• Worked with SQL server profiler to generate traces.
• Created SSRS Reports over Data marts for Business Customers.
• Created Parameterized Reports, Cascading Parameterized Reports using Complex Stored Procedures and deployed on Report Server.
• Worked on issuing Subscriptions on Reports for different Business Users.
• Integration of SSRS Reports using various web parts into Share point and various delivery mechanisms.
• Had excellent report creation skills using Microsoft Reporting Services (SSRS).

Environment: MS SQL Server 2008R2/2012, SSIS/SSRS, T-SQL, Visual Studio 2008, Oracle11g, SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), ETL, Microsoft Office SharePoint Server

Confidential, Ridgefield, NJ

Sr. SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed and created Tables in SQL server 2008R2.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Rules, Defaults and complex SQL statements.
• Monitored index fragmentation and performed index rebuild at regular intervals.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of databases.
• Designed the ETL Packages using SSIS for data replication from various sources to SQL Server 2008R2.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and performed different kinds of transformations using script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, Derived columns, Aggregate, Execute SQL Task, merge and union all and many more before loading the data into the destination using SQL Server Integration Services (SSIS).
• Created SSIS packages to automate the Import and Export of data to and from SQL Server 2008R2 using SSIS tools like Import and Export Wizard, Package Installation and Business Intelligence Development Studio (BIDS).
• Created package configurations like XML, SQL Server Configurations and also logging using text, XML and Windows event log.
• Created SQL Server Maintenance jobs, SQL Mail, Alerts and scheduled SSIS Packages using SQL Server Agent.
• Created and scheduled Data loading Jobs using Autosys.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS) and assigned permissions to the valid users for executing the reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Automated DBA activities like monitoring Database backup, SQL Maintenance jobs status, database files space and file system space usage, index fragmentation, CPU utilization, Instances running in Cluster environment using SSIS packages and also generated reports for the same using SSRS which were run sequentially by SQL agent jobs.

Environment: SQL Server 2008R2, SQL Server Integration/Reporting/Analysis Services 2008R2, Visual Studio 2010, Windows 2005/2008 Server.

Confidential, Milwaukee WI

SQL Server Developer/DBA/SSIS/SSRS Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in the SSIS packages.
• Deployed SSIS package involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created various Dimensional Hierarchies, KPI’s as part of cube design.
• Created Effective Partitions and used Proactive caching options as part of OLAP cube design.
• Designed aggregations using aggregation wizard.
• Used Processing Options: Process Full, Process update, Process Incremental, Process Data, Process Index.
• Designed STAR, SNOW FLAKE Schemas.
• Worked on database modeling, logical and physical database design using Erwin.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Worked with Managers and Management to design customized Reports to view OLAP cube Data.
• Created custom and Ad hoc reports using SSRS.
• Generated several drill down and drill through reports using SSRS.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Wrote T- SQL queries for data retrieval.
• Took part in the normalization and de-normalization of database.

Environment: SQL Server 2008/2005/2000, Reporting Services (SSRS), Integration Services (SSIS), DTS, Oracle 9i/8i, C#, Erwin, ASP.NET, Visual Studio 2005, Windows NT, MS Office, Team Foundation Server.

Confidential, Omaha, NE

SQL Developer

Responsibilities:

• Participated in designing, coding, testing and implementing user interfaces, procedures and functions for new and existing software application requirements
• Responsible in writing the stored procedures, triggers and functions based on the business requirement
• Integrated Crystal Reports with SQL Server 2000 and Access databases
• Responsible for creating datasets using T-SQL queries and Stored Procedures
• Fine tuning the stored procedures and SQL queries for optimal performance by viewing execution plans, database tuning advisor and 3rd party tools
• Involved in database normalization and de-normalization for creating Data ware house
• Used SQL server agent for scheduling jobs and alerts
• Developed DTS packages to extract and transform data
• Created DTS package to get data from different data sources, consolidate and merge into one single source
• Used performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Responsible for creating and implementing logins and user permission to databases
• Created technical design document for the project
• Imported and exported flat files using Bulk Copy Program (BCP) extensively to/from SQL Server

Environment: MS SQL Server 2000, T-SQL, DTS, ASP.NET, Access 2000 & Windows 2K platform, MS Excel, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Installed and Configured SQL Server 2005 successfully
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Involved in database design process and data modeling process using Microsoft Visio 2003.
• Developed stored procedures, complex queries, triggers and functions by using T-SQL.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Performed data transformation services and bulk inserts for large amounts of data
• Generated Reports using Data Source Views and OLAP Cubes.
• Built MDX (Multi Dimensional Expressions) and Data Mining Extensions.
• (DMX) queries for Analysis Services and Reporting Services.
• Involved in creating reports using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MS SQL Server 2005 Enterprise Edition, MS Access, SSIS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server.

Confidential

Jr. SQL Developer

Responsibilities:

• Requirement gathering - Solution design.
• Install and Configured SQL Server 2000 on development server for designing and testing.
• Involved in the migration from SQL server 7.0 to 2000.
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Environment: MS SQL Server 2000, Windows 2000 Advanced Server, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.