SUMMARY

• Over 7 years of in - depth experience in database design, development, administration and maintenance of SQL Server / 2000 large scale databases.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, SSIS with MS SQL 2008/2005
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Excellent Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2005.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Performed DBA tasks using Enterprise Manager and Query Analyzer.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• Data Stage
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Rational Rose
• Oracle 9i
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• JavaScript
• ODBC
• MS Visio 2008.
• Erwin.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

MS SQL Server /SSRS/SSIS/SSAS/ C#.NET Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Made Master Child package using variables and Execute package task in SSIS.
• Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Maintained report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL server 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plana and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Environment: Windows Server 2003, SQL Server 2008R2, SQL Profiler, SSIS, SSRS,VB.Net.

Confidential, NYC

MS SQL Server SSIS / SSRS Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, MS Office, Erwin, Windows Server 2003.

Confidential, Southfield, MI

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.
• Used Package configurations, Variables and Expressions while creating the SSIS packages.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Used SQL server agent to automate the SSIS package execution.
• Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Implemented caching of reports and managed the report history in the Report Manager.
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Created stylish reports and implemented conditional formatting using SSRS 2008.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.

Confidential, New York, NY

MS SQL Server Developer (SSRS,SSIS,SSAS)

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Extensively worked on SCD transformation in SSIS package.
• Successfully deployed SSIS packages with defined security.
• Developed logical database and converted into physical database using Erwin.
• Proficiently created Reports based on the requirements using SSRS 2005.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Defined parameters for parameterized Reports using SSRS.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2005.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using chart experts for BI needs.
• Successfully worked with Report Server and configured into SQL Server 2005.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Wrote Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.

Confidential, Northbrook, IL

MS SQL Server Developer

Responsibilities:

• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Configured linked servers in SQL Server 2000 and modified them to work in SQL server 2005.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes, implementation of necessary batch processes for periodic updates.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Environment: Windows XP Professional (SP 2), SQL Server 2005, SQL Profiler, SSIS, SSRS.

Confidential

MS SQL Server Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications
• Planned the Complete Backup of Database and Restored the Database from Disaster Recovery.
• Managed Transactional Replication and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Created different user level groups, and assigned appropriate permission level to the database.
• Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on.
• Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: SQL Server 2000, DTS, SQL Profiler, Enterprise Manager, Query AnalyzerWindows XP