PROFESSIONAL SUMMARY:

• Over 7 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 / 2005 / 2000.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Software Analysis, Design, Development, Testing, Implementation and Production, support of Client/Server and Web based applications.
• Experienced in RDBMS concepts, Creating Databases, DDL/DML Triggers, constructing normalized and de-normalized tables, user defined functions, complex and dynamic stored procedures, views, synonyms, cursors and Indexes.
• Expertise working on Online TransactionProcessing (OLTP), Data Warehousing and Online Analytical Processing (OLAP) environments.
• Hands on experience with loading large volumes of data in Very Large Database environment.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Experience in MS SQL Server Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Running Database consistency checks, SQL Profiler and Database Tuning Advisor.
• Experience in Optimizing the Database by creating various Clustered and Non-Clustered Indexes.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Good Knowledge on Error handling, Performing Incremental Loads and Logging Operations using SSIS.
• Extensively worked on Data extraction using the Microsoft DTS/SQL Server Integration Services.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. (Table, chart and matrix reports).
• Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2008/2005.
• Profound knowledge on Data Mining Concepts like Building Cubes and Dimensions with different Architectures and Data Sources using SSAS.
• Experience in creating various Measures Groups, Scorecards and Key Performance Indicator (KPI) as well as defining Actions, translations and perspectives.
• Highly motivated and adaptive with the ability to grasp things quickly and posess excellent interpersonal, technical and communicational skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

EDUCATION:

Bachelors in Mechanical Engineering.

TECHNICAL SKILLS:

RDBMS: SQL Server 2008/2005/2000, Oracle 8i, MS Access.
LANGUAGES: C, C++, T-SQL, PL/SQL, Visual Basic 6.0, HTML.
OPERATING SYSTEMS: Windows Server 2003/2000/98/95, Windows XP/XP-Pro,
Windows NT, UNIX, MS Dos 6.0.
DATABASES: SQL Server 2008/2005/2000, Oracle 8i.
TOOLS: BIDS (SSIS, SSRS, SSAS), BIMS, Query Analyzer, DTS, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Client: Confidential,Bellevue, WA July 2011 Till Date
Role: SQL BI Developer
Confidential, is the hub for introducing new tools and technologies in SQL server all over
World. The Project is mainly based on cloud computing which is an emerging
Methodology used in highly developed IT companies. The Project involved in migrating
Data from multiple sources to respective databases. Performed Staging and wrote T-SQL
Functions. Created SSIS packages and hands on building cubes. Done back end work to
Support MSRA to make it compatible for this project. Generated various ad-hoc reports
With the help of MSRA.

Responsibilities:

• Well Interacted with the team members for developing Business rules for the DATA

VAULT methodology.

• Clear understanding of properties and relationship between LNK, HUB and SAT Tables.
• Developed Extract Functions for extracting the data using T-SQL coding involving

LNK-SAT and HUB-SAT relationship from the Data Model.

• Involved in deriving and inserting Metadata into the Extract Functions by carefully observing their relationship as per the Business Rules.
• Hands on experience with Suspect Processing and Watch-Dog Process.
• Wrote complex Store Procedures about Notification Email, Event logging etc., involved in the Watch-Dog Process.
• Worked on developing Metrics to support the UI for Business Needs.
• Created complex views to build Metrics for respective areas of the Business which are also base for generating reports in MSRA.
• Created SQL Server Integration Service (SSIS) packages to populate data from various data sources (CSV files, Flat files, Excel, Oracle, SQL Server) for many applications.
• Deployed a wide number of SSIS packages in order to handle a large volume of Data using Multiple Transformationsto support Delta-Processing and Full Loads.
• Implemented logging and event handling for all packages.
• Used Configurations to make packages dynamic.
• Involved in Building Cubes with help of SSAS.
• Responsible for doing back end work to support UI and Relational Database.
• Performed Integrated Testing, Fine Tuning of views which support MSRA in generating Reports.
• Hands on resolving UAT Issues corresponding to changes in the Business Rules as per the Customer Needs.
• Generated numerous ad-hoc reports with the help of MSRA to verify the successful loading of data.
• Used TFS for check-in and checkout packages, reports, and database code (version control)

Environment: SQL Server 2008/2005, T-SQL, SSIS, MSRA, MS-Excel, Visual Studio 2008.

Client: Confidential,Minneapolis, MN Sep 2010 June 2011
Role: SQL Developer/BI Developer
Confidential, is one of the Nation’s largest brokerage company handling over 35 largest
Metropolitan areas. The Project mainly involved in creating new Databases, Performance
Tuning, T-SQL coding,Migration of data, Performing Back-up. Also it included Extract,
Transform and Loading (ETL) of data from Flat file, Excel sources etc. by using
SSIS Packages. Creating, Deploying and SchedulingReports.Generated various
Operational,Drill-Through and Dynamic Reports using SSRS.

Responsibilities:

• Involved in developing E-R diagrams, logical and dimensional modeling, development and implementation of the system.
• Created complex stored procedures, user defined functions to meet the business rules.
• Converted the data mart from logical design to physical design, defined data types, constraints, and generated schema in the Database.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Worked on importing data from MS-Access Database and XML to SQLServer Database. Worked with development teams in the design of physical databases and in modification.
• Created, loaded, and modified a new package or an existing package and configure components, made changes to object by using Control Flow Tools and Data Flow Tools and then verify it.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Developed High Level Design of ETL DTS Packages & SSIS Packages for integrating data and knowledge on multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Created SSIS packages for file transfer from one location to the other using FTP task.
• Migration of data from SSIS 2005 packages to SSIS 2008 packages.
• Designed SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Designed high level ETL architecture for overall data transfer using SSIS from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, column mapping, data dictionary and Metadata.
• Defined various facts and dimensions in the data mart including Fact less Facts and designed the Data Mart defining entities, attributes and relationships between them.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Responsible for creating the reports using the SQL server reporting services and maintained them. Used various parameter passing techniques to create input for reporting parameters.
• Experience in creating multiple reports (SSRS) in Drill mode using financial tables, cross tabs and charts.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2008/2005 using Team Foundation Server (TFS).
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008/2005,
Windows Server 2003 Enterprise Edition, HTML, MS Access.

Client: Confidential,Erie, PA Oct 2009 Aug 2010
Role: SQL Server Developer/SSIS/SSRS
Confidential, is one of the largest insurance providers in the United States and around the world
Providing different types of insurance for automobiles, home owners, personal and
Liability, property, business and life insurance.CAIS (Customer Automobile Insurance
System) project was designed to convert current manual processing into efficient
Automated system to gain huge corporate savings and support growing customers. The
CAIS was responsible for taking drivers and their vehicles information, processing each
Driver’s/vehicle’s record for approval and providing quotation to the customer. It also
Supported future modification in client’s policy.
Responsibilities:

• Actively involved in gathering Business Requirement and building up a solution to implement in CAIS.
• Filtered, purged and cleansed bad data from legacy system using complex T-SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Created scripts to verify and reconcile the migrated data from legacy system to CAIS.
• Developed interface store procedure to upload customers driving record from DMV in XML format to CAIS.
• Implemented batch processing for approval process by creating a wrapper driver which used ISQL conducting various BCP, select out and select into commands.
• Wrote complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.
• Identified, tested, and resolved database performance issues using performance monitor and SQL profiler and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created roles to bound security limited to specific tasks and assigned users to these roles.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Assisted in designing and creating user Interface using Microsoft Visual Basic 6.0.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Administered interface to organize reports and data sources, schedule report execution & delivery and track reporting history using SSRS.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2005, SSIS, SSRS, MS Visual Basic 6.0, Query Analyzer,
XML, MS Excel, MS Access.

Client: Confidential,Westchester, IL Nov 2008 Sep 2009
Role: SQL Developer/BI Developer
Confidential,s is Nation’s leading seller of repairable, recovered-theft, fleet
Lease and rental vehicles. The Project is to develop new Databases, Performance
Monitoring and Tuning. It also involved in writing Complex T-SQL codes for the
Packages that are migrated from DTS to SSIS.

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in monitoring database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Migrated DTS packages from SQL Server 2000 to 2005 on Windows 2000 Advanced server and scheduled their execution time.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Enhanced existing Cube with new functionality and features in SSAS.
• Optimized cubes by Partitioning Cubes and Designing Aggregations.
• Implemented Attribute Relationships and Hierarchies to design more aggregations in order to improve summarization performance of queries
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Performed system administrative tasks in SQL environment, including definition of user roles, setup and security.
• Ensured data integrity across databases using DBCC commands.
• Planning, implementing and troubleshooting Replication.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.

Environment:SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008/2005.