SUMMARY

• Around 8 years experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2008 R2 in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through And Cascading reports using SSRS.
• Experience in creating reports by using ProClarity Views and Dashboards strategy.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000/7.0 , Oracle 8i & 9i, MS Access.

BI /Data model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS, Erwin And Visio.

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages: T-SQL, PL/SQL, C, Visual Basic 6.0, VB Script, SQL * Plus, VB .NET, ASP .NET

Application Packages: MS Office, MS Outlook.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE

SQL Server/ SSIS/ SSRS/ BI Developer

Responsibilities:

• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Created and managed the scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Using Dynamic SQL statements constructed and executed dynamically during run time, based on supplied users.
• Created the SSIS packages for extracting data from OLTP to OLAP.
• Created and scheduled SQL jobs to run SSIS packages into the data warehouse on a daily basis.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Implemented free text parser for FTP and web data feed inC# .Net
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Understanding the OLAP processing for changing and maintaining the Warehouse Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services 2005/2008 (SSAS).
• Experience in writing complex MDX queries for calculated members and measure groups.
• Generated reports using Crystal Reports that could be used to send information to different Primary Vendors, Clients, and managers.
• Created reports from data warehouse using SSRS i.e. Parameterization, Drill Down, Drill Through, Sub Reports, Charts, Table.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also sent email to analysts to review in Excel Sheet.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

Environment: Microsoft Business Intelligence Studio, SQL Server 2005/2008, SSAS, SSIS, SSRS, ERWin 4.0, MS Outlook, FTP, TSQL, Windows 2003.

Confidential, Berkeley Heights, NJ

SQL Server /SSIS /SSAS/ SSRS Developer

Responsibilities:

• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Worked on performance monitor counters for monitoring SQL Server environments.
• Managed index, statistics and optimizing queries by using execution plan.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created SSIS packages using various transformation techniques and also created jobs that are scheduled to run daily night and thus load the Data Warehouse.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and Facts.
• Defined attribute properties in a Parent Child Dimensions.
• Responsible for hiding and disabling attributes hierarchies.
• Sorted attributes members based on a secondary attribute.
• Defined relationships between Dimensions and Measure groups.
• Identified and Defined Key Performance Indicators based on End user requirment.
• Specified the Calculated members and named sets for calculations.
• Deployed and Processed Cubes on to the Server.
• Wrote the queries for the drill down, drill trough and cascading reports.
• Identified and worked with Parameters for parameterized reports.
• Deployed the generated reports directly on the client’s workstation.

Environment: MS SQL Server 2005, MS SQL Server Integration / Analysis Services 2005, OLTP, MS Access

Confidential, Phoenix, AZ

SQL Server/SSRS /SSIS/ Server Developer

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Involved in creating Indexes for faster retrieval of data.
• Maintained data integrity by performing validation checks.
• Involved in running the SQL Profiler for better execution Plans.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Scheduled Automated jobs using SQL Server Agent.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of users.
• Added Script and lookup components using C#.
• Used SSIS in importing data from XML files.
• Monitored the performance and optimized SQL queries for maximum efficiency.
• Developed SSIS solution for developing a fully fledged data warehouse solution
• Monitored and deployed SSIS packages and involved in notification services, error handling.
• Identified the database tables for defining the queries for the reports.
• Assisted in migrating de-normalized report DB into a Star Schema design
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Deployed the generated reports on to the server.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: SQL Server 20005, DBA, ERWin 4.0, MS Outlook, FTP, TSQL, Windows 2003

Confidential, NY

SQL Server / SSIS /SSRS Developer

Responsibilities:

• Involved with Installation, Upgrade and Troubleshooting of MS SQL Server 2005.
• Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL JOIN techniques.
• Designed, Developed and maintained Relational databases.
• Extensively involved with Database Space Management, Performance.
• Involved with tracing activities using SQL Profiler.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Responsible for SSIS activities to move data from text files to SQL Server.
• Scheduled SSIS Packages daily and weekly Basis.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: Windows 2000 Advanced Server, SQL Server 2000, 2005, MS Outlook, FTP, TSQL

Confidential, Somerset, NJ

SQL Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2000, ER-Win, T-SQL, Excel, Access and Windows NT.

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program and tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Maintaining the database consistency with DBCC at regular intervals.

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