SUMMARY

• Over 8 years of experience in IT industry, with a wide range of experience in SQL Server Database Development, Business Intelligence tools (SSIS SSRS SSAS) and Administration.
• Extensive experience in all phases of Software Development Life Cycle ( Analysis, Architecture, Design, Unit & Integration Testing, Migration, Deployment, Production Support)
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP Environments
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mining, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in developing Database Objects like Schemas, Tables, Views in SQL Server Database
• Expertise in Data-Integrity by implementing suitable constraints on Database Objects
• Expertise in using DDL and DML commands for developing T-SQL Statements, Stored Procedures, User Defined Functions, Triggers, Common Table Expressions (CTE’s), Cursors
• Proficient in strategically implementing the Clustered and Non-Clustered Indexes on data structures.
• Excellent knowledge in Query Optimization & Performance Tuning.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in migrating data between homogenous &heterogeneous systems and loading data coming from Oracle, Sybase, DB2, My-SQL Databases using ETL Tools by Microsoft Corporation
• Experience in using Data Transform task, VBScript task, SQL task and Send Email task to migrate data using SQL Server Integration Services SSIS Packages
• Experienced in Scheduling, deploying and creating Config files for the packages in SSIS
• Experience in creating Data Flow Diagrams (DFD) for SSIS packages using Microsoft Visio.
• Experienced in creating a Log Database/ file to capture the SSIS events and used it to Perform Debugging of packages using SQL Server Integration Services 2005
• Experienced in writing scripts by using Script task in SSIS to update the database and generate scripts for the current database and do the aggregation for the new system.
• Expert in Generating Reports using SQL Server Reporting Services SSRS and Crystal Reports
• Experience in building different kinds of Report Layouts based on Business requirements.
• Expert in Parameterized, Drilldown, Drill-through, Sub-Reports, Chart and Ad Hoc reports
• Generated reports using Analysis Services Database Cubes by using MDX Queries
• Experienced in Full life cycle development of Data Warehouse for SQL Server Analysis Services.
• Experience in working with OLAP environment and Reporting developments using SSAS.
• Had experience in creating Cubes, Data Modeling (Star Schema/Dimensional Modeling), Data marts
• Experience in implementing Data Mining Project Life cycle in different phases.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Deployment of SSIS Packages and SSAS Cubes using command line utilities.
• Excellent command over managing Alerts, Operators and Jobs through SQL Server Agent.
• Experienced in Database backup and Recovery Procedures.
• Managed the security of the servers and created new logins and users and changing roles of users.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks, can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000/7.0/6.5, MS Access 2003/2007, Oracle 9i, 10g
Languages: C, C++, VB.Net, C#.Net, SQL, T-SQL, PL/SQL, HTML, VB Scripts, XML
Operating Systems: Windows 2003/2000 Server, Windows 95/98/2000/XP, Windows NT, UNIX
ETL Tools: SQL Server Integration Services SSIS 2008/2005, Data Transformation Services DTS 2000
Reporting Tools: SQL Server reporting services SSRS 2008/2005/2000, Crystal Reports
Environment: SQL Server Management Studio SSMS 2005, Enterprise Manager & Query Analyzer 2000, Microsoft Visual Studio 2005, SQL Server Analysis Services SSAS 2008/2005
Testing Tools: Test Director, Win Runner, Load Runner, QTP
MS Office Tools: Word, Excel, Power Point, Visio
Data Mining Tool: Erwin v 4.0
Web Servers: Internet Information Services IIS 6.0/5.1/5.0, MS Performance Point server

PROFESSIONAL EXPERIENCE

Confidential,Jacksonville FL May 2008 – Till Date
Role: SQL & SSIS, SSRS Developer

Confidential, is a leading provider of technology and services to the financial industry. With a history deeply rooted in the financial services industry, FIS reaches well beyond geographic and cultural borders in countries throughout the world. Our work and vision continue to expand, along with that reach, with a strategy that has given FIS the most comprehensive product breadth of any provider. FIS supports the success of more than 14,000 financial institutions in more than 90 countries, making it one of the largest and most successful technology companies in the world.

Responsibilities:

• Used DDL Commands for generating Tables, Views, Stored Procedures and User Defined Functions and to alter existing database objects and maintained Data integrity
• Created control flow statements, user defined Functions, Indexes to speed up the queries
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Extensively used T-SQL to create and update triggers and stored procedures used by the enhancements modules to update the SQL Server database to meet Business requirements
• Used datasets, data readers and data adapters in data access layer.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, FTP, XML etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Created Data Flow Diagrams (DFD) to migrate data from legacy databases MS-Access, Oracle to the SQL Server Database and load into appropriate tables using SSIS Packages
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Used several control flow items and data flow transformations to design the SSIS packages to meet the Business Requirements for data integration
• Generated Config files, logging and created breakpoints for SSIS packages and deployed to Development, QA and Production environments
• Redesigned the SSIS packages for optimizing the time in production environment.
• Created an Access Control List (ACL) to restrict access to the location or folder where you store the files, and give access only to users or accounts that are permitted to run packages
• Tested SSIS packages for Unit and Integration types to meet the business and technical requirements that guided its design and development.
• Deployed all the reports and SSIS packages on to the Microsoft Performance Point Server.
• Managed scorecards, dashboards, management reporting, analytics, planning, budgeting, forecasting, and consolidation using Microsoft Performance point Server
• Worked on SSRS 2005 and have experience in creating different types of Reports.
• Created SSRS reports by using components like grouping, sorting, filters, and Expression Builder.
• Designed layouts and Created Template in reports for Business using Report Builder
• 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

Environment: SQL Server Management Studio, SQL Server Integration Services (SSIS), DTS 2000, SQL Server reporting services (SSRS), MS – Access, Load Runner, Microsoft Visio, Performance point Server

Confidential,Evansville, IN June 2007 – May 2008
Role: SQL Server & SSAS, SSRS Developer

Confidential, Source is a subsidiary of Confidential,Corporation, an energy and applied technology holding company. Vectren\'s subsidiaries serve more than one million energy customers in the Midwest and Southeast. Vectren Source is a non-regulated subsidiary of Confidential,State public utility commissions do not regulate prices for products and services of Confidential,Natural gas purchased from Confidential, Source will continue to be delivered to home or small business by the local utility that you currently have. In the "more-than-you-ever-wanted-to-know" department, Confidential,is located in Evansville. We know the energy business can bring that knowledge to bear in servicing your home or business.

Responsibilities:

• Designed physical database model on SQL Server 2005 RDBMS and created database objects using DDL commands and implementing Constraints to maintain Data Integrity for database development.
• Created and updated existing MicrosoftSQLServer based data models and meta data repository
• Worked extensively on creating Complex T-SQL Queries, Stored Procedures, User Defined functions and implementing Error Handling using Try & Catch Block
• Using Database Engine Tuning Advisor constructed, Rebuilt and Reorganized (Single and Multi)column Indexes and also created Included-Columns in Indexes and increased Performance of Query
• Created DDL & DML Triggers according to Business flow requirements
• Worked in Optimizing code and improving efficiency in databases including re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks Worked in Full Life Cycle Development of Data-warehouse for OLAP environment
• Created Reporting databases and necessary tables required for Reporting.
• Designed, created, and managed Cubes and data-mining models from data warehouses and to provide client access to OLAP data and data mining data.
• Defined Data Source and Data-Source views based on views in Data Source and set logical Primary key on tables to support relationship between Fact and Dimensional tables in Snow flex schema
• Created Data Mining Objects like measures, dimensions, hierarchies, attributes, and measure groups for Cubes and worked extensively on Calculations, Key Performance Indicators (KPIs), Actions, Perspectives in the Analysis Services project
• Developed Cell Level Security in SSAS project by defining Security Roles within a cube
• Designed and build new data aggregations for ongoing data analysis and reporting
• Extensively used SQL Server Reporting Services, Crystal Reports and Report Builder Model to generate custom reports.
• Created Form/Layout, Summary, Mail, Drill down types of reports using Crystal Reports for data in

MS-Access Database

• Generated Parameterized, Drill down and Ad-Hoc Reports using SSRS 2005
• Retrieved Data out of Cubes using MDX and generated reports out of it by using SSRS
• Created Reporting Services user Roles to control access to Report Server Operations
• Developed Data-driven Subscriptions to query data from an external data source at runtime
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery

Environment: SQL Server Management Studio 2005, SQL Server Analysis Services SSAS 2005, SQL Server Reporting Services SSRS 2005, Load Runner, ADO.Net, ODBC, MS-Office.

Confidential,Grand Rapids, MI March 2006 – June 2007
Role: Database & SSIS, SSRS, SSAS Developer

Confidential, was founded by people with a strong commitment to integrity and doing the right thing for their customers, employees, business partners, associates and neighbors. Steelcase provides you environment and tools to do it better, faster and more effectively that you need to accomplish. Business is to study how people work, to fully understand the ever-changing needs of individuals, teams and organizations all around the world.

Responsibilities:

• Maintained records in Excel Spread and exporting data into SQL Server Database using SSIS
• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Extensively used DDL/DML commands in T-SQL to define Database, Tables and Views
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Designed and Developed extract transform and load (ETL) code and staging tables for Packages to load data into appropriate tables using SQL Server Integration Services 2005
• Worked on various Data Transformation Tools like Conditional Split, Fuzzy Lookup, Fuzzy Grouping, Merge Join, Derived Columns to transform data to meet Business Requirements
• Designed SSIS packages to pull data from Snapshots of production server to development server.
• Created a Log Database/ file to capture the SSIS events and used it to Perform Debugging of packages.
• Performed Data integration testing, tested database, Stored Procedures and tracked defects
• Scheduled Jobs, managed Alerts, Operators and Jobs through SQL Server Agent.
• Installed and Configured Report Server for deploying Reports built using SSRS 2005
• Developed reports using SSRS 2005, used table control, matrix control for cross tab reports.
• Retrieved XML data for a Reporting Service report using the XML data processing extension
• Utilized Data analysis techniques and queries to provide Ad-hoc reports, Bar graphs, Pie charts analysis, and datasets based on business needs.
• Created System-level & Item-level role assignments to enable users to view & publish reports on report server in SQL Server reporting services
• Designed OLAP/reporting development using SSAS & MDX Scripts to generate reports
• Strong experience in data modeling (Star Schema/dimensional modeling), data marts

Environment: Visual Studio 2005, SQL Server Management Studio 2005, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services(SSAS), MS-Office.

Confidential,Portland, OR May 2005 – February 2006
Role: SQL Developer/DBA

Confidential,provides life insurance products, annuities, and mutual funds, and offers a variety of investment products and services to individuals, businesses, and pension plans. The project was to generate reports using SQL server reporting services.

Responsibilities:

• Actively participated in gathering business requirements and system specifications from users.
• Involved in Database architecture design and data modeling and created new database.
• Involved in Upgrade of Database from SQL Server 2000 to SQL Server 2005
• Created Views on multiple tables to prevent unauthorized access of users on database tables
• Extensively used Stored Procedures and Functions, wrote new stored procedures and modified existing ones and tuned them such that they perform well.
• Made proper use of Indexes to enhance the performance of queries and enhance the stored procedures.
• Moved all DTS packages to SSIS for transferring data between different databases.
• Generated Reports of transactions and services provided using SQL Server Reporting Services.
• Deployed all the Reports and SSIS packages on to the SharePoint Portal.
• Worked extensively with all the BI tool set in Visual studio 2005.
• Used Analysis services to build Cubes over dimensional model and MDX to extract data out of Cubes
• Daily backups of transaction logs and scheduling jobs to perform this task.
• Tuned SQL queries using Execution plan for better performance.
• Managed evolution of Architecture, Analysis, Design Documents, Planning and Monitoring all systems
• Developed System Standards, System Architecture Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.

Environment: Windows 2000 Advanced Server, SQL Server 2005/2000, Query Analyzer, T-SQL, MS-Reporting Services, MS Office Components, SQL profiler, DTS / SSIS, SSRS, SSAS, MS-Share Point

Confidential,South Pembroke, FL January 2004 – May 2005
Role: SQL Developer, SSIS and SSRS Developer

Bank Atlantic provides a full range of commercial and individual banking products and services. The project is to create client solutions that automate business process by sharing data with the different systems in the bank.

Responsibilities:

• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created customer management database and objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Wrote stored procedures to generate account statements for different types of accounts.
• Maintained Data Consistencies and scalability using DBCC commands.
• Performed Query optimizations using Query Analyzer and Index tuning wizards.
• Wrote DTS packages to transfer data from heterogeneous databases & different files formats (Text File, Spread Sheet) to SQL Server.
• Designed new dynamic DTS Packages to transfer data between servers, load data into database
• Designed and Developed all extract transform and load (ETL) code and staging tables.
• Experienced in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Designed DTS package, DTS import/export for transferring data between different databases.
• Tuned SQL queries for better performance.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Worked on improving Stored Procedures and Trigger performance.
• Generated Reports using SQL Server Reporting Services.

Environment:MS SQL Server 2000/7.0, Microsoft Visual Basic 6, MS Access, MS-Reporting Services, DTS.

Confidential,India September 2001 – December 2003
Role: SQL Developer

Confidential,in India is part of Royal Philips Electronics. Philips stands as a source of reliable and innovative products that enhance the quality of consumer’s professional and personal lives. The project is to process sales orders. The quantity of product is sold to the Customer according to the Invoice prepared.

Responsibilities:

• Created Triggers and Stored Procedures for incorporating new company policies.
• Analyzed the database and backend objects requirements.
• Involved in front-end development using HTML.
• Performed Query Optimizations using query analyzer and index tuning wizards
• Solved the problems by re-configuring parameters, creating/rebuilding indexes,
• Designed Database Schema using third party tools like Erwin.
• Created stored procedures for the business logic using T-SQL.
• Performed coding of several database triggers, stored procedures and maintained Referential Integrity.
• Participated in design of Logical and Physical databases and applied knowledge of Database design standards.

Environment: SQL Server 2000/7.0, Windows NT 4.0, ERWIN and HTML

EDUCATION

BS in Electronics & Communication Engineering