Summary:

• 7 years of IT experience as a MS SQL Server Developer 2008/2005/2000 in various Industry verticals like Finance, Health Care and Insurance.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005/2008 including database consistency checks and index defragmentation.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience in SQL Server 2000/2005/2008 Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands
• Extensive experience in MS SQL Server 2008/2005/2000, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Extensive experience with Data Modeling, Logical and Physical Database Design.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Excellent experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS.
• Expert in creating and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong knowledge working with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

Technical Skill Set:

TECHNICAL SKILLS

• RDBMS: MS SQL Server 7.0/2000/2005/2008,Access,Oracle9.0,Sybase,Excel
• Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, SSAS, Upgrade Wizard, Replication, Crystal Reports 9.0/10, ERwin Data Modeler 4.2/4.1/4.0,BIDS 2008/2005, Data Integrator (ETL) 11.0.
• Programming languages: SQL, T-SQL, PL/SQL, VB.NET, XML, C++, Java, VB 6.0.
• Scripts: JavaScript, CSS, VBScript, HTML and XML.
• Applications: Microsoft Office, Visio, and Visual SourceSafe.
• Operating systems: Windows 9x/NT/2000/XP/2003.
• Reporting Tools: SSRS, Crystal Reports 11/10/9/8, Business Objects XI.

Professional Experience:

Confidential, Chesapeake, VA May '10 - Present
MS SQL Server BI Developer

Confidential is the leading US provider of speaker meeting logistics, commercial compliance management and sales force productivity tools for the health care industry. Fully integrated suite of hosted products and sales support services are custom designed for the needs of the clients, leveraging the vast industry experience to meet current and future needs.

Environment:MS SQL Server 2008/2005/2000,SSRS,SSAS,SSIS,T-SQL, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, ERwin 7.2, C#.Net 2005.

Responsibilities:

• Involved in installation and configuration of MS SQL Server 2008.
• Implemented Change Tracking a new feature of SQL Server 2008 as per business requirements.
• Defined Check Constraints, functions, indexes and views.
• Created and modified complex TSQL batches/stored procedures.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Developed SSIS packages to export data in Flat Files and Excel Sheets to Clients.
• Involved in migrating data from MS SQL server 2005 database to MS SQL server 2008 database.
• Developed unit test plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Created reports to retrieve data using stored procedures that accept parameters.
• Fine tuned SQL queries for maximum efficiency and performance.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Provided documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.

Confidential, Chicago, IL Apr '09 - May '10
MS SQL Server SSIS/SSRS/SSAS Developer

Confidential serves the risk management needs of customers around the globe. They provide the widest range of benchmark futures and options products available on any exchange, covering all major asset classes, including interest rates, equities, FX, commodities. Confidential vision is one of ongoing global growth, innovative product development, continually enhanced technology and the highest level of service available on any exchange.

Environment:MS SQL Server 2008/2005/2000,SSRS,SSAS,SSIS,T-SQL, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, ERwin 7.2, C#.Net 2005.

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Defined Check Constraints, functions, indexes, synonyms and views.
• Created and modified complex TSQL batches/stored procedures.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Developed unit test plans for SSIS packages.
• Designed and implemented the logical and physical data models using Erwin.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Created MDX queries to extract data from the data mart.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using stored procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard.
• Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server.
• Configured the report viewing security for various users at various levels using report manager.
• Fine tuned SQL queries for maximum efficiency and performance.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Provided documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.

Confidential, Phoenix, AZ June '08 - Mar '09
MS SQL Server Developer/SSIS/SSAS/SSRS Developer

Confidential is a company that improves the cost-effective of health care. As the business behind health care, Confidential helps pharmacies, hospitals and ambulatory care sites focus on patient care while reducing costs, improving efficiency and quality and increasing profitability.

Environment: MS SQL Server 2008/2005/2000 SSRS, SSIS, SSAS,SSMS ,Visual Studio 2005, MS SQL Profiler, SQL Query Analyzer, MS Visio 2007/2003,MS SQL Server Index Tuning Wizard, T-SQL, VBScript, ERwin 4.2/4.1/4.0.

Responsibilities:

• Transformed data from MS SQL server 2000 to MS SQL server 2005 using OLE DB connection by creating various SSIS packages.
• Used the execute DTS package task to execute DTS packages.
• Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Expert in developing SSIS 2008 Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.
• Designed a new schema for the data mart databases.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Created MDX queries to extract data from the data mart.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Generated dynamic reports from cubes (SSAS) using SSRS 2008.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Generated various reports like cascade type reports, tabular reports, and drill down reports.
• Created stored procedures, functions and triggers for retrieval and update of data in the database.
• Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
• Created simple data entry applications using C#.Net 2005 and SQL 2005 server.
• Used HTML code to make report manager more functional and customizable.
• Used Index tuning wizard, SQL profiler and SQL query analyzer for performance tuning.

Confidential, Cincinnati, OH Sep '07 - May '08
MS SQL Server Developer

Confidential engages in commercial and retail banking, electronic payment processing services and investment advisory services in the United States. In addition to the traditional lending and depository offering, their product and services include cash management, foreign exchange and international trade finance, derivatives and capital markets services, asset-based lending real estate finance, public finance, commercial leasing and syndicated finance.

Environment: MS SQL Server 2005/2000, SSAS, SSMS, T-SQL, ERwin 4.2/4.1/4.0, MS Visio 2003, DTS, Enterprise Manger, Query Analyzer.

Responsibilities:

• Designed staging database using ERwin and SSAS wizard.
• Designed a new schema for the OLAP database.
• Generated cubes to perform analysis and created fact and dimension tables.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Defined granularity within a measure group and drill through actions using SSAS.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Created Key Performance Indicator (KPI) objects in SSAS and created calculate member in MOLAP cube using MDX in SSAS.
• Created various parameterized reports, drill through reports using SSRS.
• Generated ad hoc reports using MS reporting services and crystal reports.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Scheduled jobs and alerts using SQL server agent.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.

Confidential, Iselin, NJ Apr '06 - Aug '07
MS SQL Server Developer

Confidential is an independent international provider of effective financing solutions for business-to-business customers. Leveraging the global footprint they finance infrastructure, equipment and working capital and act as an expert manager of financial risks within the Siemens Group.

Environment: MS SQL Server 2000, Windows NT/2000/XP, Enterprise Manager, UNIX, SQL Query Analyzer, SQL Profiler, MS Access, MS Excel.

Responsibilities:

• Involved in planning and monitoring Log Shipping.
• Created new Databases and maintained existing User / System Databases.
• Involved in Logical/Physical design of database and maintenance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Involved in the migration of MS Access databases to MS SQL Server 2000.

Confidential, Bloomington, FL Aug '05 - Mar '06
MS Sql Server Developer

Confidential is an insurance company to help people manage the risks of everyday life, recover from the unexpected, and realize their dreams. The project is to maintain the Production, Test and Development and Cluster Server Environments and support for developers in developing SQL queries. Worked as a team member with other DBAs to ensure 24x7 support of all database.

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created the database for the reporting team.
• Migrated the data from various sources using DTS and created backup and restore operations.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL queries and solved various T-SQL issues using Query analyzer.
• Created database triggers to implement business requirements.
• Created complex stored procedures and functions to support the front-end application.
• Optimized SQL queries for improved performance and availability.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Ensured data recovery, maintenance, and data integrity and space requirements for physical database.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Optimized long running stored procedures and queries for effective data retrieval.

Confidential, Alexandria, VA Oct '04 - July '05
MS SQL Server Developer

Confidential is a non-profit organization, founded in 1964, with goals of improving cancer care and prevention and ensuring that all patients with cancer receive care of the highest quality.

Environment: MS SQL Server 2000/7.0, Windows NT 4.0 Server, Windows NT, T-SQL, ERwin 4.0

Responsibilities:

• Carried out a developer’s role on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, Stored procedures and Views).
• Worked on Logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Involved in generating reports using third party tools.
• Worked on MS SQL server tasks such as data loading, batch jobs, BCP, DTS and indexes.
• Created and automated regular jobs such as daily/weekly report generations.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the systems.
• Managed the security of the servers,as a part of administration duties.
• Developed complex T-SQL code for the application.
• Designed and implemented the stored procedures and triggers for automating tasks.

Confidential, Mumbai, India. Nov '03 - Aug '04
MS SQL Server Developer

Confidential is one of the leading engineering services/solutions provider’s in INDIA with a broad services portfolio catering to most complex engineering problems.

Environment: SQL Server 7.0/2000, MS Access, MS EXCEL, T-SQL, Windows 2000 server.

Responsibilities:

• Installed and Configured SQL Server 2000.
• Transformed data from various data sources such as Excel and text files.
• Developed queries and macros for reporting purposes.
• Developed modules to export the data to excel for creating Charts and Graphs.
• Expert in all aspects of MS Access (tables, queries, forms, reports, modules, macros, security) including database design, developing, testing and documentation.
• Strong reporting experience using Excel, Access & Crystal reports.
• Experienced in evaluating and modifying tables, queries, and reports as per requirement.
• Extensive experience in analyzing data of relational database designs.

Education:

Bachelor of Technology in Computer Science Engineering.