PROFESSIONAL SUMMARY:

• Over 8+ years of IT industry experience in using Microsoft SQL Server 2000/2005/2008/2008 R2/2012 for data design, Data migration, Business Intelligence, Database Development, and Administration.
• Domain expertise in Banking, Financial, Airlines, Insurance, Scouting, Gas Trading, and Healthcare Solutions.
• Strong analytical and problem - solving skills along with inter-personnel communication skills as well as ability to acquaint to fast changing environments.
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Experienced in writing T-SQL queries with DDL and DML commands, complex stored procedures, indexes, triggers and views.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Worked extensively on system analysis, design, development and implementation of projects in Software Development Life Cycle (SDLC).
• Experienced in developing, deploying and monitoring ETL tasks using SQL Server Integration Services (SSIS) packages, DTS Import/Export Utility and DTS packages.
• Followed the Microsoft recommended best strategies in the design, development, and implementation and testing of the ETL using SSIS.
• 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 2008/2005 to achieve the efficiency of SQL Server Analysis Server (SSAS).
• Worked 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 handling different Data warehousing methodologies such as Bill Inmon (Top Down design) and Ralph Kimball (Bottom-up design).
• Experience in Online Analysis Processing (OLAP), created cubes, dimensions for schemas.
• Experience in developing various types of reports like Drill Down, Drill Through, Matrix, and Parameterized using SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS:

RDBMS: Microsoft SQL Server 2000/2005/2008/2008 R2/2012, MS Access

LANGUAGES/SCRIPTS: C, C++, T-SQL, PL-SQL, VB Script

MICROSOFT TECHNOLOGIES: MS Office, Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, Visual Studio

OPERATING SYSTEMS: Win 98/NT/2000/XP/Vista/7, MS-DOS, UNIX, Windows Server 2003 Enterprise, MAC OSX

TOOLS: AND UTILITIES: Crystal Reports, DTS, SSRS, SSIS, SSAS, Team Foundation Server(TFS),Agile development environment, Performance point Server, Erwin, SQL Profiler, Database Engine Tuning Advisor, Index Tuning Wizard, dynaTrace, Autosys, SQL Agent, Maintenance Plans, Security, Replication, HP Quality Center, Microsoft dynamic CRM

WORK EXPERIENCE:

Confidential, Charlotte, NC

System Analyst/ BI Developer

Responsibilities:

• Worked on Onboarding Data Export using SSIS to create different flat files for internal application.
• Created Delta Process for Export process. The different nature of data is checked based on Business logic (New, Update, Delete) using different database objects (Stored procedures, views, functions, CTEs) and generate files and archive after further processing.
• Worked on Upgrading SSIS 2008 packages to SSIS 2012 with custom logging/Error handling.
• Worked on Data Validation Process with different Delta Source files (text file, excel file).
• Worked on Performance tuning the different database objects using dynaTrace, SQL profiler, and Execution plans.
• Worked on NDM process to transfer the files.
• Created/Scheduled Autosys and batch jobs using UNIX script based on the Business requirements.
• Worked on TFS for create/update the scripts, packages and for local deployment project.
• Worked on issue/ bug tracking with HP Quality Center, TFS, and Microsoft dynamic CRM.

Environment: SQL Server 2008 R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, T-SQL/PL-SQL, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio 2010, Team Foundation Server (TFS),OLTP, XML, dynatrace, SQL Profiler.

Confidential, Kannapolis, NC

MS SQL Server/ BI Developer

Responsibilities:

• Migration of Data from current system to dimension and fact tables into Kimball modeled data warehouse using Extract, Transform and Load (ETL).
• Developed multiple Stored Procedure to support business logic for extracting data from source as well as Data Validation.
• Worked on various Transformations like OLEDB Command, Conditional Split, Derived Columns, and Merge Joins during Data Migration.
• Worked on Data validation process in order to match source to target data.
• Worked on Entity-relationship (ER) Model and created Source to Target mapping document to support.
• Worked with different Configurations in order to change the package properties dynamically.
• Worked intensively on Data Validation while migrating data to Data Warehouse.
• Fine-tuned DML, DDL scripts with lock hints for performance boost.
• Worked with DBAs for schema maintenance as well as performance tuning for long running SQL scripts.
• Worked with SQL Server Agent to create the job and monitor closely for job run.
• Troubleshoot the ETL packages as well as issues occurred during daily job load.
• Supported SSRS Report writer with the data issues and clarifying the business logic on extracting the data for the report.
• Created SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema.
• Worked with QA’s on writing test cases and tested based on business requirement documents (BRD’s).
• Worked with QA’s on writing test cases and tested based on business requirement documents (BRD’s).

Environment: SQL Server 2008 R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, T-SQL/PL-SQL, Business Intelligence Development Studio (SSIS, SSRS,SSAS), MS-Visual Studio 2010, Team Foundation Server (TFS),OLTP, XML.

Confidential, Irving, TX

MS SQL Server/ BI Developer

Responsibilities:

• Developed Archive Process to relieve the transactional system of data storage based on the business logic that helped to reduce about 65% of the transactional data storage. By implementing this process, the performance was a great .
• Developed a Bi-directional Synchronization Process from Oracle environment to SQL Server Environment using ETL/SSIS.
• Developed a procedure that helped the Application where the customer reside whether in Transactional data Storage (OLTP) or had stored in the Historical Data Storage based on the business logic customers are needed to pullback in the Transactional data storage for the business.
• Worked on Change Data Capture (CDC) for delta process.
• Run scripts, execute PL/SQL Procedures, DML operations using SQL *Plus.
• Worked Extensively with ETL (Export, Transform, and Load)/SSIS on loading data from different sources using linked servers.
• Created different reports based on business needs using SQL Server Reporting Services (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Cross Tab and Sub-Reports using Report Designer and Report Builder based on the business requirements.

Environment: SQL Server 2008 R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server (TFS), SQL * Plus, MS-Visual Studio, OLTP, XML.

Confidential, Marshalltown, IA

MS SQL BI Developer

Responsibilities:

• Developed technical specifications and analyzed business needs with managers and development Teams.
• Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
• Worked with DBAs for maintenance schemas as well as different database objects.
• Developed Triggers and Stored Procedures to in corporate the business logic and process.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in tuning of Stored Procedures and query optimization for the improvement of deadlock situations and hang-ups on server.
• Experienced in developing, deploying and monitoring ETL tasks using SSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Used Data Manipulations to optimize the performance, which includes modification of T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing table, establishing Joins and creating clustered/non-clustered indexes where necessary.
• Worked on formatting the SSRS report using Global variables and expressions.
• Developed query for generating drill down reports using Reporting Services.

Environment: MS SQL Server 2008, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), and MS-Visual Studio.

Confidential, Atlanta, GA

MS SQL Server/ BI Developer

Responsibilities:

• Analyzed the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Created Master SSIS packages to execute set of packages that load data from various sources onto the Data Warehouse on timely manner.
• Used Script Task to establish connection with FTP server and locate the files within the server.
• Scheduling and Monitoring SQL Server Agent Jobs to run various ETL Processes.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine.

Environment: SQL Server 2005/2008 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio, OLTP, OLAP, XML.

Confidential, Township, IL

SQL/ BI Developer

Responsibilities:

• Involved in gathering business requirements, definitions and design of the data sourcing and data flows, data quality analysis, working in conjunction with data warehouse architect on the development of logical data models.
• Interacted with Development management Teams to analyze business necessity and creating new technical specifications.
• Created SSIS packages to generate underlying data for reports from excel, text file, MS Access and CSV files to Data Warehouse.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user-defined functions (UDF's).
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas driven, summarized and conditional formatting) using SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Involved in development and modification of existing Financial Reports and Marketing reports which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Used ETL from heterogeneous sources system. Assisted DBA in using the repository manager to give permission to users to create new users and repositories.

Environment: MS SQL Server 2005/2000,SQL Server Management Studio (SSMS) 2005,SSIS-2005, DTS-2000, SSAS, VB 6, OLAP, OLTP, Load Runner, SSRS-2005, SQL Server Profiler, Visual studio 2005, SQL Analyzer, and SQL Server Agent.

Confidential, Rose Land, NJ

MS SQL Server Developer

Responsibilities:

• Responsible for gathering and refining requirements from the customer for developing reports.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Executed batch files using SQL Agent and developed Stored Procedures for schedules, reports and other client interfaces.
• Used Data Transformation Services (DTS) to populate data from various data sources using the concept of OLEDB.
• Worked DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Identified the Data Source and defining them to build the Data Source Views.
• Responsible for report generation using SQL Server Reporting Services (SSRS) Reports based on business requirements.
• Developed query for generating drill down reports using Reporting Services.
• Responsible for scheduling the subscription reports with the subscription report wizard.

Environment: SQL Server 2005, T-SQL, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SSRS, DTS, Crystal Reports, XML.

Confidential

Junior MS SQL Server Developer

Responsibilities:

• Developed scripts for restoring backup for SQL Server as needed.
• Upgraded to latest version of SQL 2005 from SQL server 2000.
• Performed replication of data using Transactional method.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Managed and coordinated with remote user for change request and optimization of application.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Created and managed users, roles and groups and handled database security.

Environment: Windows XP, SQL Server, SSIS

Confidential

Junior MS SQL Server Developer

Responsibilities:

• Created new database objects like Stored Procedures, User Defined Functions, triggers, Indexes and Views using T-SQL.
• Worked on DTS Package, DTS Import/Export for transferring data from different Databases to SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Used joins, database links, and developed reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Created stored procedure to transform the Data and worked extensively in T-SQL for various needs of the transformation while loading the data.

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