PROFESSIONAL SUMMARY:

• Over 6 years of experience in the IT industry, includes Software Analysis, Design, Development, Customization and Implementation of various business applications.
• Extensive experience in SQL Server, T - SQL, Oracle, MYSQL and MS Access.
• Experience in the complete life cycle of databases which includes the design a database, populating lookup data, creating Stored Procedures as per front end developer’s requirement and commercial transitions, writing Triggers, creating user defined functions and created views to simplify the complexity of the data structure.
• Experience on T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Excellent experience in creating, managing and deploying various types of reports using SQL Server Reporting Services and Report Manager.
• Extensive experience in developing reports using SQL Server Reporting Services (SSRS), Crystal Reports, Oracle Reports and MS Access reports.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
• Experience in database administration and maintenance activities such as Backup and Recovery, monitoring SQL Server.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Experience in Capacity planning and Disaster Recovery Planning.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Monitored and tuned application using the performance Diagnostic tools such as SQL Profiler.
• Experience in maintaining security on multiple servers and multiple databases with Windows authentication and SQL Authentication.
• Experienced in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Knowledge of data warehouse fundamentals,
• Good knowledge of parallel processing used it for faster query processing and loading data.
• Based on the business requirements,worked onFACT’s and DIMENSIONS.
• Good experience with database designing, creating logical and physical data models using Erwin.
• Knowledge on platform like Unix/Linux

TECHNICAL SKILLS:

Databases: Oracle 10g/9i/8i/8.0, Access, MS-SQL Server.

Tools: /Utility:: Enterprise Manager, SQL Server Management Studio(SSMS),SSIS, Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Query Builder, Informatica, Erwin.

Languages: C, C++, SQL, PL/SQL, UNIX Shell Programming, HTML, Visual Basic, Java, XML.

Web Applications: Active Server Pages 2.0.

Testing Tools: Win Runner 7.0, Test Director 8.0

GUI Tools: Forms 5.0/6i/9i, Reports 3.0/6i/9i

Other: MS Word, Excel, PowerPoint, Visio

PROFESSIONAL EXPERIENCE:

Confidential, OH

SQL Server/BI Developer

Responsibilities:

• Create SSIS package to clean and load data to data warehouse.
• Designed and developed SSIS packages to extract data from various data source such as Access Database, Excel spreadsheet and flat files into SQL server 2008 for further Data analysis and reporting By using multiple transformations provide by SSIS such as Data conversion, conditional split, Bulk Insert, merge and union all.
• Create package to transfer data between OLTP and OLAP databases.
• Create SSIS and used the task to import and export files.
• Excellent skills in implementing ETL packages using DTS and SSIS 2008.
• Create, modify, schedule, test and or trouble shoot SQL Server Integration Services.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in T-SQL programming.
• (SSIS) packages, stored procedures, Tables and Views.
• Experiences in designing, Creating and processing of Cubes using SSAS.
• Scheduling cubes processing from staging Database Tables using SQL Server Agent.
• Aggregated the cubes with 40% Performance for better performance.
• Processed cubes to perform incremental updates.
• Create Reports by extracting data from cube.
• SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Involved in Unit Testing and System Testing of the application.
• Analysis and trouble shooting of defects.
• Involved in implementing of coding and Designing with ASP.net
• Front End-ASP.net and code behind C#.net.

Environment: T - SQL, SQL Server 2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS,C#.net,Asp.net.

Confidential, NJ

SQL BI Developer

Responsibilities:

• Writing of Stored Procedures and Functions using SQL Server 2008 and T-SQL.
• Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Created SSIS packages for Data Importing, Cleansing and parsing.
• Created SSIS packages using Pivot Transformation, Derived Column and Conditional Split.
• Created SSIS packages to clean and load data to data warehouse.
• Experience in writing VB script in script Component Task.
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedules SSIS packages.
• Extensive experience in database tuning, server logins and database permissions.
• Experiences in Xml scripts.
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports.
• Created reports by extracting data from cube.
• Experience in configuration of report server and report manager scheduling give permission to different Level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and schedule reports for business analysis or management decision using SQL Server Reporting Services
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Analysis and trouble-shooting of defects.
• Involved in Unit testing and System Testing for the application.
• Create database backups, restore, data replication, and database security.
• Developed Open Connect Robots to resolve different edit.
• Worked extensively in HIQK,HEHK (EEC),HRBK modules of NASCO claims processing system.
• Designed and developed dot net interface to consume HIPAA5010 to be used in OFP robots.
• Responsible for implementation and testing of ICD10 changes in the existing Open Connect Robots.
• Worked with business and development teams to develop system, End-to-End and Regression Test scenarios, Plans and Scripts

Environment: Microsoft SQL Server 2008, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin, Open Connect.

Confidential, New York, NY

SQL BI Developer

Responsibilities:

• Analyzed the business requirements from the given specifications.
• Writing of Stored Procedures and Functions using SQL Server 2008 and T-SQL.
• Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous system using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
• Created SSIS package using Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned Data for the reports and to export cleaned data from Excel spreadsheet, Text file and MS Access to data warehouse.
• Created SSIS package to import data from MS Access, Excel to SQL Server 2008.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Created complex ETL packages using SSIS to extract data from staging tables to partitioned tables with the incremental load.
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports.
• Created reports by extracting data from cube.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Analysis and trouble-shooting of defects.
• Involved in Unit testing and System Testing for the application.
• Did requirement gathering time estimation and design for the project following Agile Development Methodology.
• Extensive use of ADO.Net features like Data Table, Data Views, Datasets and Data Reader to Display and update the data.
• Create database backups, restore, data replication, and database security.

Environment: Microsoft SQL Server 2008, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Gather and analyze business requirements
• Create data models to describe data and relationships between the data
• Create data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.)
• Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server 2000/2005
• Create SSIS & DTS packages to import/export data to/from data-sources such as flat file, Oracle, DB2, Excel, Access, and XML.
• Experience working with transformations provided by SSIS such as Data Conversion, Conditional Split, Merge, Union all, Lookup and Script transformation.
• Created complex ETL packages using SSIS to extract data from staging tables to partitioned Tables with incremental load.
• Created SSIS package to automate maintenance, database backup, update statistics, re-build indexes as well as create error log for event during data load.
• Scheduled packages and different maintenance tasks using MS Jobs.
• Used Notification services mainly to manage package on success, completion and failure of deployment and other Tasks
• Involved in production support.
• Code Stored Procedures to validate, process data needed to create and update Retail warehouse
• Construct reports using SSRS from OLTP & OLAP Databases
• Validate change requests, prepare effort estimates and make appropriate recommendations
• Database planning in relation to physical and logical data architecture
• Develop and implement database and coding standards, improve performance and maintainability of SQL Server databases
• Provide back-end support for functional testing and performance testing.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, SSIS, SSRS, SSAS, DTS, VBA-Excel,Oracle 8i/9i, VB.Net, VSS, Windows 2000/XP/2003, OS/390, AIX, Linux

Confidential

SQL Developer/SSRS Developer

Responsibilities:

• Involved in Analysis, Design, and Development and Testing phases.
• Analyzed the business requirements from the given specifications.
• Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.
• Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2005.
• Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment
• Used the maintenance Plan for SQL Serve databases to recreate indexes and statistics for the performance.
• Design and implementation of Security Model, policies and procedures.
• Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
• Designed and developed complex SSRS reports.
• Create ad hoc complex management reports as required.
• Design and develop reports using SQL server reporting services
• Configuration of linked servers for user to be used for data exchange.
• Created and scheduled jobs and alerts
• Involved in version management of source code using VSS.
• Analysis and trouble-shooting of defects.
• Involved in designing of reports using SSRS.
• Involved in Unit testing and System Testing for the application.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, Microsoft SQL Server Reporting Services.

Confidential

SQL Developer

Responsibilities:

• Involved in designing of conceptual logical model and physical model
• Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2000
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Wrote transact SQL utilities to generate table insert and update statements
• 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.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• 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/2005, MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio.