SUMMARY

• Skilled software professional with 7+ years of industry experience in design, development and implementation of business requirements with Microsoft SQL Server 2000/2005/2008 database system in client/server environment.
• Domain expertise in Healthcare, Banking, Financial and Communications.
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Expert in writing T - SQL queries with DDL and DML commands, complex stored procedures, user defined functions, indexes, triggers and views.
• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development LifeCycle (SDLC).
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility, BCP and DTS packages.
• Followed the Microsoft recommended best strategies in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS).
• Expert in providing logging, error handling by using event handler and break points for SSIS packages.
• Migrated organization orders, adjustments, objectives and data in various formats like text based files; excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.
• Experienced in monitoring and scheduling ETL processes using DTS EXEC utilities and batch files.
• Migrated and recreated existing dimensions and cubes using star schema on SQL Server to achieve the efficiency of SQL Server Analysis Server (SSAS).
• Worked extensively on the Data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Experience in Online Analysis Processing (OLAP) created cubes, dimensions for schemas.
• Experience in developing reports using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Parameterized, Ad hoc and Cascaded Parameterized.
• Excellent hands on experience in scheduling SQL Server Agent Jobs for database Backups, Restoration and Disaster Recovery Procedures and implementing Backup strategies.
• Highly committed, motivated and a natural team player with strong analytical ability.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 7/Vista/XP/2000/95/98/NT, MAC OSX, Linux, Unix

RDBMS: MS SQL Server 2008/2005/2000, MS ACCESS 97/2000,Oracle

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Share Point Server, Visual Studio

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import/Export Data

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Languages: PLSQL, TSQL, C++, VB Script, MDX

Web Technologies: HTML, JavaScript, CSS, PHP5.0

PROFESSIONAL EXPERIENCE

Confidential, VA

Senior-BI Developer

Responsibilities:

• Experience in working with SSIS for Data integration services. Expert in extracting and transforming data using SSIS Import/Export, DTS Import Export Data, DTS Packages, Bulk Insert and BCP.
• Managed the production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Highly capable in developing and monitoring DTS and SSIS packages for using it in regularly scheduled jobs to extract, modify, or transform data for a variety of purposes.
• Experienced in developing User reports and management reports using SQL Server Reporting Services (SSRS).
• Efficient in creating reports with complex formulas and to query the database for Business Intelligence.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages
• Experience in generating on-demand and scheduled reports for business analysis or management decision using Crystal Reports and SQL Server Reporting Services.
• Demonstrated ability to write testable SSIS maps in the SQL Server 2008 environment or greater.
• Ability to communicate fluently with stakeholders when asked to present the completed work.
• Demonstrated experience with organizing techniques when dealing with a large library of SSIS scripts.
• Collaborated with test teams who ran the SSIS maps during test and validation phases of a project.
• Expert in developing ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SSIS transformation for Data cleansing to remove unnecessary columns, eliminated redundant and inconsistence data.
• Designed SSIS packages using control flow task, Data Flow Task, For Each Loop container, Execute SQL Task. Also, actively involved in deploying and scheduling packages
• Extensively participated in database design and creating E-R diagrams for participant and client databases.
• Involved in writing the stored procedures, checking the code for efficiency using T-SQL.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated and deployed interactive and non-interactive complicated reports from various database and cubes. Built the mockup reports using SSRS and Excel for prototype.
• Used Integration services for the purpose of Transforming data from the cubes and storing it in to SQL SERVER tables.
• Tested the performance of Stored Procedures and execution plan by using SQL Profiler.
• Worked on Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), .Net Framework 3.0/3.5, SQL Profiler, TFS.

Confidential, OH

Senior BI Developer

Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
• Research and investigate key business problems through quantitative analyses of utilization and healthcare and costs data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), .Net Framework 3.0/3.5, SQL Profiler, TFS.

Confidential, AZ

Senior BI Developer

Responsibilities:

• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Created Views to facilitate easy user interface on database tables, and created Triggers to facilitate consistent data entry into the database tables.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Performance Tuning of T-SQL Statements implemented effectively with SQL Profiler and Database Tuning Advisor.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages and VBScript.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Implemented Transactions is SSIS packages using Sequence containers and Execute SQL tasks.
• Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary queries and sorting to use optimized queries.
• Designed and created Report templates with Constant Header information like Company logo, Department Name etc. for Weekly, Monthly reports.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.
• Involved in Trouble shooting and Performance improvement of SSRS Reports.
• Integrating SSRS reports into various Web applications using Web Service and Report Viewer Control in .NET framework 2.0.
• Deployed various reports onto Report Server and Report Manager in SSRS 2008.
• Worked on Visual source safe (VSS) to maintain code repository of the T-SQL and SSIS developments.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, .NET Framework 2.0, VSS

Confidential, NY

SQL Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Strong performance, diagnostic, and query tuning skills.
• Involve in creating ER Diagram, Data Architecture design, Data modeling.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Designing SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Optimized indexes, SQL queries, stored procedures to improve the quality of software.
• Design, review, and create primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc reports for the clients as per their requirements using SSRS.
• Variance reports using Reporting Services (SSRS).
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Responsible for taking data objects across different databases: Development -Test - Production.
• Created trace in SQL Profiler and used Data-base engine tuning advisor for Performance tuning on stored procedures and script.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, .NET Framework 2.0, VSS

Confidential, Atlanta - GA

SQL Developer

Responsibilities:

• Involved in designing of Conceptual Logical Modeling and Physical Modeling of the database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 using SSIS Packages.
• Designed dynamic SSIS Packages to transfer data across different platforms, validate data during transferring, and archived data files.
• Created SQL Server Reports and stylish report layouts using SSRS 2005.
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports. Writing queries to generate reports for analysis of data using SQL Server Reporting Services.
• Identified the Data Source and defined report layouts for formatting the report design as per the need and built Ad-hoc reports using SSRS2005.
• Converted very complex RPTs of Crystal Reports into RDLs of SSRS manually
• Identified and worked with XML Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Involved in Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS Packages.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Developed, monitored and deployed SSIS packages.
• Created SSIS packages to retrieve data from Legacy sources.
• Strong experience with SQL Server Analysis Services 2005(SSAS) and OLAP cubes, Dimension table, Dimension, and Fact table.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Implemented different types of constraints on tables to maintain Data Integrity.
• Responsible of developing SQL objects like store procedures, views and user defined functions
• Normalized (3NF) and De-Normalized the existing tables in the database for optimizing the performance.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, .NET Framework 2.0,VSS

Confidential

Junior SQL developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Involved in Implementation of Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2000, Windows 2000, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.