SUMMARY:

• Around Eight years of experience in IT industry performing Database/Data Warehouse/ETL Analysis, Design, Development and Support using SQL Server 2000/ 2005/2008/2012 in multiple environments Dev/UAT/Production .
• Experienced in Installation, Configuration, Migration and Maintenance of SQL Server 2000/20 .
• Experienced in working with Windows server 2000/2003/2008.
• Worked on SQL Server 2000 tools Query Analyzer, Enterprise manager, Profiler and Index Tuning Wizard and SQL Server 2005/2008/2012 tools Management Studio, Business Intelligence management Studio, Data Tools, DTA, SSIS, SSRS and SSAS.
• Worked on Data Modeling (Logical and Physical Design of Databases), Normalization and Building Referential Integrity Constraints using Erwin and MS Visio.
• Worked extensively with T - SQL for developing complex stored procedures, triggers, views, tables, user profiles, user defined data types, functions, relational database models and data integrity, SQL joins and query writing.
• Experience in design and implementation of Data Warehouse techniques using Star Schema and Snowflake Schema Dimensional model.
• Worked on creation of SQL jobs, Alerts and scheduling DTS Packages and SSIS Packages.
• Worked with Clustering, Online recovery, Replication, Database mirroring, Log Shipping and indexing features.
• Worked on design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Designed and developed OLAP Cubes with Star schema and Dimensions using SSAS. Performed Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle, DB2 to MS SQL Server by using BCP utility and DTS/SSIS services.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with DTS/SSIS and stored Procedures.
• Have experience in Performance Tuning, T-SQL Query Optimization and solving blocking issues using Execution Plan, Profiler and DTA.
• Worked performing administrative tasks: database files management, backup/restore, Disaster Recovery procedures, security management, data integration and synchronization.
• Strong understanding and knowledge of Relational Database Management Systems RDBMS .
• Strong Knowledge of Web development technologies such as HTML, XML, DHTML, ADO.NET, ASP.NET, IIS and Visual Studio.
• Strong Knowledge of entire phases of Software Development Life Cycle starting from gathering business requirements and analysis to testing, development and support.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, Windows Server 2000/2003/2007 , Windows 98/NT 4.0/XP, UNIX

DB Design and modelling Tools: ERWIN 4.x, MS Visio 2000/2003/2007 , Rational Rose 2000

RDBMS/Databases: MS Access, MS SQL Server 2000/20, DB2,Oracle,FoxPro

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, DTA, Performance MonitorProgramming Languages: T-SQL,PLSQL, C, HTML, XML, C++, C#

Version Control Tools: VSS,SVN

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008

ETL Tools: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard.

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, PA

Responsibilities:

• Created design documentation and implementation strategies for multiple risk finance applications by functional requirement analysis based on the business requirements, admin source systems and also by interacting with multiple business users.
• Performed installation and configuration SQL SERVER 2008/2008R2/2012.
• Created a data warehouse using star schema from scratch to a complete solution for FMDB data which is used for market data analysis.
• Based on business requirements created complex Transact-SQL (T-SQL) queries, stored procedures, triggers, user defined functions (UDF), views, indexes, and user defined data types strictly following the data integrity using constraints, rules and default.
• Designed data model for various reporting based datamart’s using Erwin.
• Worked on the development, enhancement, and maintenance of multiple Analysis Services OLAP cubes including Type 1 and Type2 dimension creation, attributes relationship creation, time intelligence calculations, and complex user security model using SSAS.
• Created MDX script for representing cube calculation using SSAS.
• Implemented process improvements for various actuarial functions.
• Involved in configuration, maintenance, monitoring, backup and disaster recovery procedure and replication.
• CreatedETL packagesusing different data sources(SQL/Oracle, Flat Files, Excel, XML, FoxPro etc.) and loaded the data into required destinations by performing different kinds of transformations usingSSIS packages.
• Createdcomplex SSISpackages using proper control and data flow elements with error handling and logging.
• Involved in automating SSIS Packages using SQL Server agent jobs and windows scheduler.
• Worked on performance tuning, query optimization, database maintenance plans. Resolved the blocking issues.
• Created various ad hoc reports, drill down reports, sub reports, linked reports, charts, drill through reports for administrative needs and also user needs using SSRS.
• Designed reports using table filters, single value parameters, multi value parameters, dependent parameters and cascading parameters. Worked on the performance enhancements of reports and data driven subscriptions for reports.
• Worked on creating, structuring, formatting using report designer and report builder.
• Worked on unit testing and supporting the QA team with testing efforts.
• Provided 24*7 on call production support for hedging applications.

ENVIRONMENT: MS SQL Server 2005/2008 R2/2012, SSIS, SSAS, SSRS, Erwin, XML, MS Access, Excel, C#, Windows Server 2007, Share point Server

Confidential, Jersey City, NJ

Responsibilities:

• Interacted with Customers, Business Analyst, Project manager and gathered and Peer Reviewed the Business Requirements.
• Analyzed Requirements, Performed Design (HLD’s, LLD’s), and Development, Testing, Maintenance and documentation for the FA data warehouse.
• Performed installation and configuration of SQL SERVER 2008R2.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL Queries as per the business requirements.
• Involved in Migration of Source control tool from VSS to Tortoise SVN for multiple projects.
• Reengineered the SSISpackages to obtain source data from Live Tables of Loan Processing Database instead of getting from static daily files.
• Involved in creating E-R diagrams, Logical & Dimensional Modeling, Development and Implementation of the Loan Analysis system.
• Worked on error handling and troubleshooting the scripts in failure to load the data into database for SSIS and TSQL.
• Implemented Type I, II, III changes in Slowing Changing Dimension (SCD) Tables.
• Used PIVOT/UNPIVOT operations to turn rows into columns and vice versa to normalize table structure of the database which doesn’t meet the desired reporting format.
• SSIS Execution Configurations from hardcoding to table driven with environment variable process.
• Configured product meta-data tables to support client data reporting needs.
• Used SSRS to create customized Reports, on-demand reports, ad-hoc reports, multi-dimensional reports, Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Sub-reports and Linked reports using SSRS and integrated into the web front end
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS). Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Snapshot Replication was been used to synchronize the data between their Different Stores. Involved in SQL Server Mirroring and Database optimization.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
• Designed dimensional modeling with star and schema flakes Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Used SQL Profiler to estimate the Slow Running queries for Performance Tuning.
• Responsible for daily and monthly Data Warehouse enhancements, maintenance and documentation.

ENVIRONMENT: MS SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, MDX, Share point 2010, Oracle 10g, ASP.NET, XMLVSS

Confidential, Bloomington, IL

Responsibilities:

• Designed and developed database backend for the grid modeling engine.
• Installed and configured servers and clients using SQL Server 2005/2008. Created and upgraded SQL databases.
• Created logical and physical data models using Erwin for new requirements after discussion with Business users and Team as per agile methodology.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created an archival process to move data from operational database into a reporting environment.
• Improved Query performance by monitoring the system utilization using the query optimizer and analyzing the Execution Plan.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created notifications, alerts to let support team know in case there are any failures.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and refreshing Database on weekly basis.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis.
• Involved in configuring and maintain Snapshots, Subscriptions and Transactions using Replication services.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs usingSQL ServerAnalysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created cubes with calculated fields which greatly helped us in improving the performance of the reports (SSAS).
• CreatedETL packageswith different data sources(SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations usingSSIS packages to data warehouse.
• Worked on SSIS scripttask, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Created audit events for master and child packages to track the status of the package execution.
• Utilize C# script tasks within SSIS to enhance functionality not available from the GUI, such as dynamic data loading and transformations.
• Created parallelized process for data warehouse extraction, transformation and loading (ETL) using SQL Service Broker.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Involved in migration and Conversion of Reports from SSRS .
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.--> ALL CONFIGURATION
• Used Report Catalog in order to store the security, configuration and caching information for the operation of the Report server (SSRS).
• Developed detail and summary reports line, trend analysis reports and sub-reports according to business requirements using SSRS.
• Created in setting report parameter properties. Determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time.
• Developed reports with flexibility using Report Parameters Drop-Down Parameters Multi-Valued Parameters in order to meet the changing business needs (SSRS).
• Improved the appearance and help the business users reuse the reports for presentation by using Charts and Gauges (SSRS).
• Created Reports with Dynamic Grouping and Sorting (SSRS).
• Created Reports using Report builder which helped the business users to build the reports on the fly (SSRS).
• Creating Role Based security in SSRS .Converted Crystal Reports in to different SSRS reports.
• Developing List Reports, Charts, Master-Detail Reports, Parent-Child Reports and reports using Report Studio and Query Studio.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked on production support to resolve the data quality issues, troubleshooting of failed processes and ad-hoc client requests
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

ENVIRONMENT: MS SQL SERVER 2000/2005/2008 , T-SQL, Windows 2005/2007, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS Visio, DTS, XML, Oracle 11g.

Confidential, East Greenbush, NY

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Worked extensively in writing and debugging complex stored procedures, cursors, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS and also migrated DTS packages to SSIS Packages
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to Access etc
• Migrated objects from SQL server 2000 to SQL Server 2005.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Created dimensional cubes using SQL Server Analysis Services (SSAS) and queried the data using MDX script.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Ad-Hoc reports using Report Builder. Deployed reports in to Report Manager.
• Designed the User Interface (UI) web interface of the application using prototyping.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Worked on uploading the SSRS reports to Web portal developed using Share point 2007.

ENVIRONMENT: MS SQL SERVER 2000/2005, T-SQL, Windows 2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Erwin, DTS, XML, MDX, VSS.

Confidential

Responsibilities:

• Created Tables, Views, Triggers, Functions and Indexes as per the design specifications.
• Developed Stored Procedures for implementing application functionality and logging.
• Created customized reports, on-demand reports and parameterized reports and published as PDF, Excel, and CSV using SSRS.
• Developed DTS packages to migrate data from flat-files, spreadsheets to other databases.
• Used ActivexScript for adding additional dynamic functionality for DTS packages.
• Interfaced with the client as part of the requirements engineering team to finalize the project scope.
• Designed the User Interface (UI) web interface of the application using ASP.net
• Created, maintained and developed web services using WCF.
• Worked on performance tuning and optimization of procedures and queries.
• Created jobs and alerts to run DTS packages periodically.

ENVIRONMENT: MS SQL SERVER 2000/2005, T-SQL, Windows 2003 Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS,VB Script, ASP .NET, WCF.