SUMMARY

• Around 6+ years of experience in IT, Financial and Healthcare environments with primary skill on SQL Server database development with SQL Server 2008/2005/2000
• Experience with stored procedures, user defined functions, triggers, designing tables, views, indexes, relational database models, data dictionaries, data diagram and data integrity.
• Expertise in SSIS (Integration services), SSRS (Reporting service).
• Extensive experience in data migration between homogenous and heterogeneous system using various tools.
• Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Expertise in performing administrative tasks such as database files management, backup/restore, security management, data integration and synchronization.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.
• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Extensively worked on SSIS packages to transfer data from heterogeneous databases & different files format (Text File, Spread Sheet, and XML) to SQL Server 2005.
• Building reports using SSRS
• Developing custom ETL using DTS.
• Thorough knowledge and extensive experience in create SQL Server objects, such as stored procedures and triggers.
• Designed and mapped using various SSIS Transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.
• Experience working with SQL server 2008R2/ 2008/ 2005 and oracle 9i
• Experience in providing high quality application support on data integration and data management projects.
• Worked on complex data loading from FTP sites (implemented the batch data cleansing and data loading).
• Expertise on ETL skills, Data modeling, Database Normalization, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.
• Experience in Data Profilers

TECHNICAL SKILLS

Database: SQL Server 2008/ 2005/ 2000 , Oracle 10i, MS Access

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series

Operating Systems: HP UNIX, Windows XP/2000/2003.

Programming Languages: T - SQL, PL/SQL, C#

B.I Tools: DTS, SSAS, SSRS, Informatica 7.1.3/6.2.

Database Tools: DBArtisan, SQL Litespeed

Miscellanies: Visual Source, Safe, SVN, TFS, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Participated in the entire life cycle including database design, Development, Testing, Optimizing, deploying onto Test, UAT and production servers.
• Developed several SSIS packages to improve performance by reducing runtime using different partitioning techniques.
• Wrote stored procedures and scripts to move content for staging database to actual database in all environments.
• Developed reports using table control, matrix control for cross tab reports.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like EXCEL, CSV, flat file, Text format, SQL and Oracle.
• Used SSIS Scheduler for validating, executing, scheduling and monitoring jobs.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS)
• Designed and created Report templates, bar graphs and pie charts
• Generated Reports and designed packages using global variables, Expression and functions.
• Written and reviewed functional specifications, performed unit and system tests, troubleshoot and implement logged bug fixes.
• Designed and Developed Technical specifications for the packages created, for future reference as per the client’s request.

Environment: SQL Server, SSRS, SSIS, Visual studio 2008 Oracle 9i

Confidential, Phoenix, AZ

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in complete life cycle of SDLC and also responsible for designing of logical as well as physical database.
• Created indexes for better performance.
• Created packages to migrate data from different data sources to data warehouse.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Extracted required mapping fields from different sources (schema, CDW) to data Warehouse for Staging Table.
• Tested the data with complex queries, joins, sub queries and temp tables.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Scheduled report and exported in PDF format.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.
• Documented all old and migrated Store Procedures and scripts for future references.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked on linked servers to run distributed queries between SQL servers.

Environment: SQL Server, SSRS, SSIS, T-SQL, Visual studio 2008 Oracle 8i, 9i

Confidential, Kansas City

MS SQL Server Developer/DTS/ BI Developer

Responsibility:

• Design/Build Extract Transform Load procedures in SQL Server 2008 using SSIS packages and import/export data feeds to/from data warehouse and loan systems.
• Created new database objects like Sequences, Procedures, Functions, Package, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Worked with Client/Business Analysts to define data requirements for reporting Warehouse and loan systems to import data feeds.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Configured product meta-data tables to support client data reporting needs.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2008 that stored and maintained the bank’s financial data.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Created data extraction and data loading scripts for different databases and schemas.
• Created stored procedures for SSRS Reports.
• Develop Stored Procedures, Functions (UDF), Views, Joins and Sub queries to enforce the business rules.
• Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.
• Created Triggers to implement business control.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Wrote an Adhoc queires for Business analysts to extract required daily data.
• Received .txt and Excel files to update the tables in DB.
• Extracted data from database and export to Excel files for DA to categories the data.
• Uploaded files in Database through weekly run packages in SSIS.
• Created Packages in SSIS to push the data from one DB to Other DB while working on Performance Point Project.
• Created Custom Logging in SSIS packages.
• Updated the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and Stored Procedures.

Environment:, SQL Server 2005/2008, BIDS 2005 T-SQL, UNIX, Sun Solaris, ODBC, Power Point, Excel, SOAP UI, Test link, JHIRA, Data warehouse

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2000.
• Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP.
• Assisted in designing and creating website utilizing ASP and .Net technologies for the system using ADO.Net, HTML, XML in designing form, validating inputs and connecting to backend database
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard
• Performed rigorous Performance Tuning of queries written in middle layer and backend to gain huge performance gain of webpage loading.
• Involved in testing and debugging business logic in Store Procedures with Application Development Team.
• Prepared scripts to upgrade the software from one version to another and make sure the client’s production data has been correctly populated after the up gradation.
• Data migration (import & export - BCP) from Text to SQL Server.
• Used Crystal Reports to generate ad-hoc reports Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Wrote complex stored procedures to process driver’s record and balanced the processing load between front end and back end.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Developed windows based applications in C#.Net for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.

Environment: MS SQL server 2000, DTS, Oracle, ASP, Windows2000/NT, Crystal Reports