PROFESSIONAL SUMMARY:

• Over 7+ years of professional experience in SQL Server database development, extensively worked in OLTP, OLAP environment & development databases as a Developer/ DBA in different domains including HealthCare, Retail, Insurance and Financial services.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
• Well versed in Normalization/ Denormalization techniques for optimum performance in relational and dimensional database environments.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Cross-Tab, Drill-down, Drill-through, Tablix, and Sub-Report using RDL.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) 2012/ 2008R 2/ 2008/2005/2000.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Strong Experience in Report Development, Modeling (Relational, DMR) and Dash Board Report in Performance Point, Targit.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R 2/2008/2005/2000, Reporting Services (SSRS) 2012/2008R 2/2008/2005/2000, Integration Services (SSIS) 2012/2008R 2/2008/2005/2000
• Analysis Services (SSAS) 2012/2008R 2/2008/2005/2000, Power Pivot, Performance Point, Crystal Reports 8.0/8.5/9/10/Xi, Crystal Enterprise Xi, Business Object Xi r2, DTS, T-SQL, PL/SQL, Business Intelligence Development Studio (BIDS),Database Engine Tuning Wizard, Visual
• Studio, MS Visio, Erwin 3.x/4.x/7.x, ER-Designer, TOAD, Oracle 9i/10g, C, C++, .Net Framework, ASP.Net, VBA, HTML, XML, CSS, PVCS, Visual Source Safe, Data stage, Remote Desktop, Microsoft Office Suite, Windows 95/NT/XP/Vista.

PROFESSIONAL EXPERIENCE:

Confidential, Nyc,NY

MS SQL Server Developer / SSRS/SSIS Developer

Environment: SQL Server 2012, SSIS 2012,SSRS 2012, T-SQL, Visual studio 2010, Data Analyzer, MS Access, Excel, SQL Profiler, MS Access, TOAD Data Modeler, Windows Server 2008R2.

Responsibilities:

• Expertise in creating physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.
• Created several tables, views and stored procedures using SQL Server.
• Developed several SSIS packages and data flow tasks by using SSIS.
• Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Strong experience Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Created different data points and pulling those using SSIS package.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2012, Excel 2010.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created all the SSRS report using Cube as data source.
• Success several Ad-hoc reports by using MS Excel and automate some of these Ad-hoc reports based upon business demand.
• Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.
• Analyzed the error output and error log of an automated process in case of failure of the process.
• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.

Confidential, Jersey City, NJ

MS SQL Server Developer / SSRS/SSIS Developer

Environment: SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, Oracle 9i/10g,Team Foundation Server(TFS), T-SQL, Visual studio 2007, Data Analyzer, MS Access, Excel, SQL Profiler, MS Access, Erwin v7.2, Windows 2008 Server

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in SQL Server 2008R2 with the use of the SQL Profiler, Execution Plan, and Database Engine Tuning Wizard.
• Established backup and recovery of SQL server 2008R2 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Confidential, Cincinnati, OH

MS SQL Server Developer/ SSIS/ SSRS developer

Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, Optimization, Calculated members and actions, Data warehousing, Parent child dimensions, Attribute Hierarchies.

Responsibilities:

• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Involved created Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Designed SSIS packages to import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension Wizard.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created data driven subscriptions for different users using Report Manager.

Confidential, Pittsburgh, PA

MS SQL Server /SSRS/SSIS Developer

Environment: MS SQL Server 2005, Business Intelligence Development Studio (SSRS & SSIS) 2005, TFS, MS Office Access 2003, Excel, Erwin4.0 and Visio, Windows server 2003R2.

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the new system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential, Dublin, OH

SQL Server Developer/SSIS/SSRS Developer

Environment: MS SQL Server 2005, Windows 2003 Server, T-SQL, SSIS 2005, SSRS 2005, ASP .Net, VB.net

Responsibilities:

• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers. Worked to tune the SQL queries using SQL Profiler.
• Highly responsible for scheduling and delivery of jobs using SQL server Agent. Performed T-SQL tuning by using Database engine tuning adviser and execution plans.
• Migrated data from SAS environment to SQL Server 2005 with SSIS 2005.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Reviewed ETL jobs developed by other teams and made sure they followed the standards.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Generated test data and tested database to meetthefunctionalities deliverables intheproject documentation and specifications.

MS SQL Server / SSIS/SSRS Developer

Environment: SQL Server 2005, Enterprise Manager, Query Analyzer, VB Script, Windows Server 2003 Platform, MS Office 2000,VB.net, Report net, ERWIN

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Involved in the complete data warehouse development life cycle.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handle the Migration process from Development, Test and Production Environments.
• Developed and maintained data cubes using ODBC to access heterogeneous data sources and defined Data Source Name.
• Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and Crystal reports.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data)
• Provided technical guidance and support to end-users by developing documentations required.