SUMMARY

• 7+ years of administration, design and development experience in SQL server 2008/2005/2000 system in OLTP and OLAP environment.
• 5 years of experience in SSIS, SSAS and SSRS of MS SQL Server.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Highly expert in translating Business System Design document into technical design document
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Excellent knowledge of using variables and expressions in SSIS packages.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using TSQL.
• Experience in writing complex TSQL queries using Inner, Left, Right, Outer and Cross Joins.
• Good knowledge in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SSRS based on Relational and OLAP databases.
• Expert in dimensional data modeling, and cube development, partition, aggregation and optimization using SSAS.
• Excellent command in deploying analysis projects using SSAS services.
• Successfully performed SCD transformation and deployed SSIS package with security.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts with star schema and snowflake schema design and implementation.
• Experience in performance tuning of TSQL, SSIS Packages, SSRS Reports and SSAS cubes.
• Excellent communication skills, exceptional versatility and adaptability, a strong team player with an ability to take new roles, hardworking and fast learner.
• Good skills with computer science concepts, analytical skills and programming.

TECHNICAL SKILLS

• MS-SQL Server 2008/2005/2000
• MS Access
• T- SQL
• PL/SQL
• SQL server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• DTS
• SQL Server BI Development Studio (BIDS)
• Erwin 7.2/4.5/4.0
• MS Visio 2003/2007
• Autosys
• Windows 98/2000/2003/ XP/NT/Vista
• Windows 2000Advanced Server
• MS Office 2007/2003
• C
• C++
• C#
• HTML
• XML
• Java
• ASP .NET
• VB6 .NET
• MS Visual Studio 2008/2005.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL Server Developer/SSIS

Environment: MS SQL Server 2008, MS SQL Server Integration services 2008(SSIS), XML, T-SQL, MS Visio, Windows XP.

Responsibilities:

• Developed ETL packages using SQL SSIS to migrate data from various sources into SQL Server 2008 database.
• Created SSIS packages using advanced tools (pivot transformation, derived columns, conditional splits, term extractions, multicasting)
• Used SQL profiler for troubleshooting, monitoring and optimizing of SQL Server
• Loaded Excel files into stage tables by using Bulk Copy Program BCP and SSIS packages.
• Successfully deployed SSIS packages with defined security.
• Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Created stored procedures for the business logic using T-SQL.
• Involved in performance tuning of SSIS Packages .

Confidential, MA

MS SQL Server Developer/SSIS/SSRS

Environment: MS SQL Server 2008/2005, MS SQL Server 2008 Reporting Service2008, Business Intelligence and Development System 2008, T-SQL, Erwin, MS-Office, MS Visio, Windows XP.

Responsibilities:

• Participated in meetings and interactions with users, team lead, DBAs and technical managers to fully understand the requirements of new system.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Worked on SSIS to import the data from different format.
• Responsible for creation of new database objects like stored procedures, tables, view, triggers, function according business logics.
• Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and SSIS packages. Scheduled database jobs for automation of DBA tasks.
• Partitioned large tables1.2 million rows tables using range partition.
• Performed data extraction from OLTP to DW for decision making using SSIS.
• Defined report layouts and wrote queries for drill down reports and identified and included report parameters using SSRS.
• Developed complex reports and provided to business people for further analysis.
• Developing various simple to complex reports using SSRS.
• Identified various data sources and established connections between source and the target using SSIS based on the required reports.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Provided support to the application developers on the application databases.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.

Confidential, Nashville, TN

MS SQL Server Developer/SSAS/SSIS

Environment: MS SQL Server 2008/2005, SSAS 2008,SSIS 2008,T-SQL, VB.

Responsibilities:

• Designed a complex SSIS package for importing data from 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 2008.
• 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, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.
• 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 2008.
• Created Batch files to run the script in development, production environment.
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• 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.
• Tuned SQL queries using execution plans for better performance.
• Created Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures.

Confidential, South Brunswick,NJ

MS SQL Server Developer / SSIS

Environment: MS SQL Server 2008, SSIS 2008, T-SQL

Responsibilities:

• Carried out a Developer’s role on SQL (using SSIS, T-SQL, Stored Procedures and Views).
• Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical and physical database development.
• Imposed Referential Integrity of data by creating different constraints.
• Migration of the data from text files to Oracle database and SSIS packages for the processing of different policies.
• Managed all indexing, debugging, optimization and performance tuning
• Created stored procedures,triggers and functions for the business logic using PL/SQL.
• Performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Designed and developed Data Transformation Process.
• Successfully performed SSIS packages and scheduled them.
• Used advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner.
• Effectively used views to prevent unauthorized access in Oracle.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
• Built and performed user acceptance testing on new and modified reports.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Confidential, NY

MS SQL Server Developer/SSAS/SSIS

Environment: MS SQL Server 2005, SSAS 2005, SSIS 2005,T-SQL, VB.

Responsibilities:

• Designed a complex SSIS package for importing data from 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 2008.
• 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, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.
• 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 2008.
• Created Batch files to run the script in development, production environment.
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• 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.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures.

Confidential

MS SQL Server and BI Developer

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

Responsibilities:

• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
• Involved in deploying SSIS packages for various environments.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.
• Implemented logical and physical database modeling using Erwin tool.
• Designed and implemented complex SSIS package and scheduled it for OLAP to satisfy BI requirements using SSAS.
• Successfully implemented SCD transformation in SSIS and performed security.
• Archived and restored data warehouse database.
• Provided technical guidance and support to end-users by developing documentations required.
• Involved in the complete data warehouse development life cycle. .
• Modified existing reports and successfully implemented.
• Added already created reports to Publish on web service.
• Designed, developed, and tested complex queries for Reports distribution.