SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server Developer in Banking, Insurance, Health Care Domains
• Excellent experience in MS SQL Server 2005/2008 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)
• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC)
• Skilled in writing and reviewing T - SQL code and maintaining coding standards
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Cursors, Views and User Defined Functions to implement business logic
• Expertise in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using import export wizard, DTS, SSIS, and bulk insert utilities
• Strong knowledge and experience with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging
• Well-versed in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Slow Changing Dimension (Type 1, Type 2 and Type 3), Pivot)
• Generated reports that can handle dynamic grouping and dynamic sorting
• Skilled in defining measures and dimensions using multi-dimensional expressions (MDX), mathematical formulae and user-defined functions to in corporate business rules
• Extensively worked on tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance
• Designed and Implemented Physical and logical models for databases and data warehouses
• Expert in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2000/ MS SQL Server 2005 and MS SQL Server 2008 respectively
• Proficiency in Error and Event Handling: Check Points, Logging in SSIS
• Expert in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication
• Prepared Test Plans and Test Strategies, Executed and reviewed the Test Cases
• Strong team player with ability to prioritize workload
• Expert in analytical research and business requirement analysis, communication skills, troubleshooter and problem solver
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies

TECHNICAL SKILLS

Industries: Banking, Health care, Insurance.

Database: MS SQL Server 2008/2005/2000 , Oracle 9i, MS Access 2000, SQL*PLUS.

Database Tools: SQL Server Enterprise Manager, T-SQL, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, SQL Server 2005 Reporting Services (SSRS). SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services.

Operating Systems: Windows 2003/2000/XP/NT, MS-DOS, UNIX

Computer Languages: SQL, PL/SQL, C, C++, JAVA

Version control Tools: Microsoft Visual SourceSafe, Tortoise SVN.

PROFESSIONAL EXPERIENCE

Sr. Business Intelligence Developer

Confidential, Deerfield, IL

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS and SSRS to develop a solution
• Created Stored Procedures for complex business, SQL Agent jobs, and designed tables by following RDMS rules
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations
• Developed 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 cleaned data from Excel Spreadsheets, Text file, MS Access
• Implemented and customized Slowly Changing Dimensions (SCD Type 1, Type 2 and Type 3) and Lookup transformation on Data Warehousing Project
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks
• Working with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio
• Analyze, design, develop, unit test, document, and implement reporting applications using SQL Server Reporting Services (SSRS) and other related technologies
• Worked with Report Manager to configure Web URLs, E-mail for reports

Environment: MS SQL Server 2008, SSIS, Web Services, SSRS, Crystal Reports 10, HTML, JavaScript, XML, Visual Studio 2008, Visio 2010, Visual Source Safe, ASP, C#

Business Intelligence Developer

Confidential, Kansas city, MO

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS and SSRS to develop a solution
• Performance tuning of Stored Procedures and T-SQL Queries
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS)
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

Environment: SQL Server 2008/2005, SSIS, SSRS, SQL Server OLAP 2000, Reporting Services 2008/2005, T-SQL, MS Access, Windows XP/2003 Server, Visual Studio 2008

SQL Developer

Confidential, Jacksonville, FL

Responsibilities:

• Involved in gathering user requirements, analysis, designing and maintaining documentation
• Interacting with business user groups in selling ideas for improving the user interface and business processes all through the system development
• Developed complex stored procedures and triggers in T-SQL
• Assisted the front end application developers with their queries
• Tested the reports and fixed bugs in Stored Procedures, Tables and Triggers
• Schedules and performed data transfers using DTS including filtering appropriate to the data mart for data analysis
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes
• Compressed data files by removing empty database pages and updating index statistics
• Configured snapshot replication for reporting, user acceptance test and development servers
• Designed and implemented user log in and security
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries
• Planned the complete back-up of databases for disaster recovery scenarios

Environment: MS SQL Server 2005 Enterprise Edition, MS Access, T-SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, ASP .Net, Crystal Reports 9.0.

MS SQL Server Developer

Confidential

Responsibilities:

• Participated in Business Requirement Gathering and Development of BRDs for new and upgrade implementations
• Developed and maintained data, procedures and performed Data Impact Analysis
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules
• Coordinated and assisted with the Front-End Developers in handling & solving bugs

Environment: SQL Server 2005 Enterprise Edition, Enterprise manager, Windows NT, XML, SQL Reporting services, Tortoise Hg.