PROFESSIONAL SUMMARY

• Over Nine (9) years of IT experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2008/2005/2000) in production environments.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Expertise with continuous integration and nightly deployments using TFS with a Test Driven Design approach
• Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SSAS (analysis services) and MDX for data warehouse and data mart solutions.
• Experience in migration of DTS packages in to SSIS packages.
• Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user-defined functions.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Installed, configured and maintained SSRS server.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Experience with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Experience in designing the logical data model and physical data model.
• Experience in supporting large databases up to a size of two terabytes.
• Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
• Strong knowledge in webservices
• Delivered 24/7 support including scheduled and emergency night and weekend work.

PROJECT EXPERIENCE

Confidential,IN June’10 – Present
Sr. SQL BI Developer

• 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.
• Closely worked with the End users to gather the requirement and Analyzing business processes and performing in-depth work analysis.
• 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
• Implemented SQL Server SSIS packages for ETL methodologies
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Migrated DTS packages to SSIS Packages
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc. to Access etc.
• Migrated Data from SQL server 2005 to SQL Server 2008 using SSIS.
• Experience with the Share point 2010 to upload the SSIS packages in to Web portal.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• 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.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Responsible for database design, including optimizing the database schema and coding database procedures/queries.

Environment: MS SQL Server 2008R2, SSAS, SSRS, T-SQL, OLAP Services, MDX, Share point 2010, Netezza, ASP.NET, XML, Microsoft Source safe, Clear Quest

Confidential,FL June’09-May’10
Sr. SQL BI Developer

• 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 debuggingcomplex stored procedures, cursors, triggers,Inner Joins, Outer Joins,viewsandUser-defined functions.
• Implemented LDAP authentication with .NET frame Architecture & ASP.NET framework
• Experience in migrating from IBM Data stage to SSIS.
• Migrated Data stage hash files to SSIS raw files and rewrite the Data stage jobs in SSIS.
• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate theinsurance datafrom various source systems feeds usingSSIS.
• Installed, configured and maintainedSQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in code reviews, performance tuning strategies at ab initio and Database level
• Implemented SQL queries and stored procedures and validated code against designs.
• Data mining scripts were created usingSSISand stored procedures.
• ImplementedSlowly Changing Dimensions (SCD)to maintain historical data in various data marts.
• WroteDTSActiveXscripts that extract data from database tables and write the data to text files.
• Dropped and recreated the indexes on tables for performance improvements. Tuned SQL queries using execution plan for better performance.
• Experience with theShare point 2007to upload theSSISpackage designed documents in to Web portal.
• Developing web applications using .Net 2005 (ASP.Net)
• Querying of source and target database for unit testing.
• Maintain Operators, Categories,Alerts, Notifications, Jobs,Job Steps and Schedules.
• Monitored connections, locks andperformance of SQL server.
• ImplementedSQL Server OLAP services (SSAS)for building thedata cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS)and querying the data withMDXscript.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• Designed the User Interface (UI) web interface of the application using prototyping.
• Designing and building data load procedures usingMS SQL Server.
• Performance:Troubleshoot system issues performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for better performance.
• Used Bridge design pattern in Object Oriented Design(OOD)
• Designed and developed the classes usingC#.Net,ADO.NET,XMLfor database connectivity.
• Involvement in defining scope for new releases and helping business in solving existing issues.
• Provide24 X 7 supportsto all production, development and staging. Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), T-SQL, OLAP Services, DTS,MDX, Share point 2007,Oracle 10g , DB2, Microsoft Source safe.

Confidential,Cleveland, OH Jan’08- May’09 Sr. SQL BI Developer

• Extensively involved in interacting with the business users and gathering the requirements for the data warehouse.
• Analyzed the requirements and provided best possible solutions.
• Created project plan and a business requirement document and presented it to the client for their review.
• Tuned SQL statements, stored procedures with EXPLAINPLAN
• Migrated data from MS Access & Ms-Excel sheets to Oracle 10g Data warehouse.
• Loaded data from flat files to Oracle 10g Data warehouse with Oracle SQL*LOADER.
• Creating the complex stored procedures, user defined functions to meet the business rules.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, and generated Schema in the Database.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Used MDX to query the OLAP database in order to generate OLAP reports.
• Developing calculated measures and assigning these aggregation levels based on dimension hierarchies.
• Created Dimensional Hierarchy (Geo Calendar Product Distributor) Level based Measures.
• Responsible for detecting KPI changes, surprising values data, data exploration and explanation through data mining algorithms etc.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Involved in Unit testing integrated testing and System testing.
• Used Visual Source Safe for version control.

Environment: SQL Server 2008/2005, Oracle 10g, SSRS, SSIS, SSAS, T-SQL, Visual studio 2008/2005, Windows Serer 2003, HTML, IIS, Visio, Visual Source Safe 2005.

Confidential,Middletown, CT Oct’07 – Jan’08
Sr. SQL BI Developer

• 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.
• Reviewed and corrected diagnostic reports from MS Project Server 2007and SQL server2005
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Creating complex cubesfor seeing business data from different perspectives by slicing and dicing the data
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Wrote stored procedures to support the data processing engine in database intensive operations like complex joins, pivoting, query performance tuning, partitioning, parallel querying, algorithm and Data Mining
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• 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.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries
• Design and development of classes using C#.Net, ADO.NET, XML for database connectivity.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, DTS,MDX, Share point 2007,Oracle 10g,DB2, Active X, ASP.NET, C#.NET, XML, Microsoft Source safe, Clear Quest, Windows 2003

Confidential,CA Dec’06 to Sep’07
SQL BI Developer

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Migrated objects from SQL Server 2000 to SQL Server 2005
• Used intergraded Master Planning using MS Project Server 2007
• Involved in designing of Conceptual Logical Model and Physical Model
• Wrote various T-SQL stored procedures and Triggers, Inner Joins, Outer Joins to carry out tasks.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the customer data from various source systems feeds using SSIS
• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Designed and developed various data mining procedures to enable intelligent querying.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Involved in capturing requirements, preparing business blocks UML, Use Cases, Collaboration Sequence, and Activity diagrams.
• Designing and building data load procedures, using MS SQL Server
• Generated database SQL scripts and deployed databases including installation and configuration
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Tested SQL code in PowerBuilder with Sybasedata to ensure reliability of interfaces
• Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Used Microsoft Source Safe for version control and configuration management.
• Provided 24/7 support to all production, development, staging and clustered servers.

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SSRS, SSAS, Visual Basic 6.0, DTS, T-SQL, Share point 2007, Oracle 9i,Active X, C#.NET, ADO.NET, XML, Sybase, Teradata V2R5/V2R6, Clear Quest, Windows 2003