SUMMARY

• Over 7 years of in - depth experience in database design, development, administration and maintenance of SQL Server / 2000 large scale databases.
• Expert in Stored Procedure/TSQL coding, Performance Tuning, Physical and Logical Database Design.
• Strong experience in MS SQL Server 2005 with Business Intelligence in SQL Server Reporting Services(SSRS),SQL Server Integration Services(SSIS) and SQL Server Analysis Services(SSAS).
• Actively lead or participate in resolving key issues that impact the performance of the team.
• Proficient in creating and designing the report layout, sorting the data, defining subtotals and generated Reports like parameterized reports, drill down reports using SSRS 2005.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experienced in all the stages of SDLC life cycle and involved in the migration and up gradation of databases.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool.
• Expertise in Data Warehousing methodologies and concepts, including star schemas, snowflake schemas, dimensional modeling and reporting tools.
• Expert in using Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
• Strong in ETL, Data warehousing, data marts and OLAP technologies.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and SQL Server Integration Services (SSIS).
• Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user functions, relational database models and data integrity, SQL joins and query writing.
• Skilled in creating multidimensional cubes using the SQL Server Analysis Services 2005.
• Experienced in creating Calculated Measures and Dimension members using multi dimensional expression (MDX) and including mathematical formula.
• Expert in developing Stored Procedures and Triggers in SQL-Server.
• Experienced in logical and physical database design & development, normalization and data modeling using Erwin and SQL Server Enterprise manager.
• Performed dynamic calculations, developed, reviewed, and optimized SQL queries in SQL Server.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2000/2005
• MS SQL Server Reporting Service
• MS SQL Server Analysis Services
• MS SQL Server Integration Services
• MS Access
• C
• ERWIN
• HTML
• XML
• MS Visio 2003
• Oracle 9i/10g
• T-SQL
• PL/SQL
• Java Script
• Windows NT/2000 Server/XP

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

MS SQL Server Developer

Responsibilities:

• Analyzed and designed software and database solutions.
• Found database objects which directly communicate between the two databases.
• Traced all entities being used in either of the databases and find specific entities which are used both by the front end application and the databases.
• Co-related the database objects and entities used with the common front-end application for both the databases and use only the common ones.
• Created Drop scripts and Create Table scripts for existing database objects in order to replace them with tables in both the databases.
• Created SSIS packages for uploading data into the empty tables for the first time in both databases.
• Built efficient SSIS packages for daily updates to keep the databases up to date in both databases, using the SQL Server Agent which would manage insertions of new data, delete data as well as make updates.
• Created subscriptions using the Report Manager for reports generated by the legacy reporting tool on various schedules.
• Built SSIS packages for generating fixed format reports to replace the legacy reporting tool.
• Scripted C# code for enabling cell comments and formatting the excel sheets from the database, such as freezing header rows, Bold, Italicize and Underline Text when rendering reports in MS Excel.
• Documented the separation of the two databases for the applications release.
• Communicate with the development and production teams to introduce the new changes in the system for release.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSIS, Visual Studio 2008, Win NT /2000/ 2003,MS Office Suite 2007

Confidential, Philadelphia, PA

MS SQL Server Developer

Responsibilities:

• Fixed the bugs present in already existing reports.
• Developed many Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports and created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing. Modified existing reports according to requirements of the end users and communicated with Business Analysts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created the structure of the model and cube in MS Analysis Services (2008).
• Reviewed Cube with End user and changing the cube and documentation according to their requirements. Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Created trace in SQL Profiler and used Data base engine tuning advisor (DTA) for Performance tuning on stored procedures and Scripts.
• Defined relationships between Measure groups and Dimensions.
• Generated automatically grouping attribute members. Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse. Created reports to generate them through Email for the administrative using MDX Queries.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, Win NT /2000/ 2003,MS Office Suite 2007/2003,Microsoft Office Share Point - 2007

Confidential, Plano, TX

MS SQL Server Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, DevelopmentandCustomization of the Application.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Enhanced the legacy systems to the current system.
• Developed the logical design of the databases using Entity Relationship Diagrams, Database Diagrams, and Table Structures.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on SQL Server 2008.
• Extracted the data from Oracle, Access, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008/2005) and BCP.
• Defined and created facts, metrics, attributes, filters and prompts in OLAP data warehouse.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2005.
• Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations using C#/VB.NET.
• Handled slowly changing dimensions (up to Type-2) to maintain the history of the data.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc request/reports for the clients as per their requirements using SSRS.Created views and used them for generating Reports in SSRS 2008.
• Involved in Scheduling Jobs and Alerting using SQL Server Agent.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Involved in User Acceptance Testing, N-UNIT Testing for debugging of the system and taking data objects across different data stages namely Development, Test and Production.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: MS Office Suite, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Oracle 10g, Visual Studio .NET 2005/2008, .NET Framework 2.0/3.5, Windows NT 2003, UNIX.

Confidential, Baskin Ridge, NJ

MS SQL Server Developer/ SSIS /SSRS/SSAS

Responsibilities:

• Involved in gathering, understanding and validating the technical specifications.
• Interacted with the business users for verification of the development needs.
• Gauged the effectiveness and efficiency of existing packages.
• Developed and implemented strategies for improving and further leveraging these packages in order to better performance.
• Designed packages in SSIS 2005 with various complex transformations.
• The tasks in the complex packages included initial and final row counts, referential integrity, preload and load of the tables using tasks such as Sequence Container, Foreach Loop Container, Execute SQL Task and Script Task.
• Modified precedence constraints in different modes according to the execution results in various executables.
• Created various lookups for the package with different kind of outputs..
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Developed complex cubes which handled large databases with various dimensions. Developed KPI’s according to the requirements of the end user.
• Defined Attribute Hierarchy for the dimensions of the cubes.
• Designed, developed and deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2005.
• Developed parameterized reports with drill down capabilities and drop down lists.

Environment: MS SQL Server 2005, MS SQL Integration Services 2005, MS SQL Analysis Services 2005, T-SQL, Windows Server 2003, MS SQL Server Reporting Service 2005.

Confidential, Sunnyvale, CA

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Created SQL Server Reports using SSRS 2005 as needed.
• Identified the Data Source and defining them to build the Data Source Views for easy access.
• Developed query for generating drill down reports in SSRS 2005.
• Interacted with end users to define, implement, and maintain their reporting requirements
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Deployed the generated reports directly on the client’s workstation. Responsible for transferring the data using SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Implemented different types of constraints on tables for consistency. Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance and integrity maximum efficiency using SQL Profiler.
• Generated Sales Ranking reports using Sql Server Reporting Services for different subjects
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, Windows 2003 server.

Confidential

MS SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Managed Windows NT Server logins, folder permissions, and share permissions. Supported front-end development team to resolve SQL related issues in Active Server Pages during server migration.
• Performed layout and installation of new computer systems and modifications of existing workstations and Windows 2000 Server.

Environment: MS SQL Server 2000, T-SQL, ER-Win v4.0, Windows 2000, Crystal Report.