Experience Summary

• Six years of strong experience in the IT industry as a BI and SQL Developer.
• Extensive experience in MS SQL Server 2008/2005/2000, Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005.
• Experience in creating VBA Macros.
• Involved in building cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Experience in building the cubes utilizing SSIS platform.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experience in implementing SQL Server OLAP services (SSAS) for building the data cubes.
• Experience in creating new reports and ad-hoc reporting in SQL Server ReportingServices (SSRS).
• Designed and developed more than 100+ enterprise reports(SSRS) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experienced in creating Tabular reports and Subscription reports.
• Expert in creating and deploying ProClarity and Dashboards, Brio reports.
• Experience in creating slicers and Dicers for Proclarity and Dashboard reports as per BRD.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS utility.
• Experience in Migration of DTS packages to SSIS and Executing DTS packages from SSIS.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user functions, SQL joins and query writing.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2005.
• Created SSIS packages to handle large data Migrations from the systems like Oracle, Flat Files and Excel
• Quick learner and good performer both in team and independent job environments.
• Preparing work estimation plan and delivering innovative solutions.
• Trained the new entrants to the projects on technology and domain.
• Good knowledge with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Experience in using quality control tools like Quality Center, ClearQuest.
• Preparing work estimation plan and delivering innovative solutions.
• Experience Working with Development and Production 24/7 Environments including scheduled emergency night and weekend work.

Technologies

Databases

MS SQL Server 2008/2005/2000, Oracle 9i/8i, MS Access

Languages

T-SQL, PL/SQL, C, C#, UNIX shell scripts, XML, HTML, VB.NET, ASP.NET, Visual Basic.

BI Tools

DTS, SSIS, SSAS, SSRS, MS Reporting Services, Proclarity, DashBoard, Brio.

Database Tools

PL/SQL Developer, TOAD, SQL-Navigator, SQL*Plus, Test Director, Win Runner

Data Modeling Tools

Physical and Logical Data Modeling using MS Visio

Operating Systems

Windows NT, Windows 2000, XP, UNIX.

.NET Framework

MS VISUAL STUDIO 2005, C#.NET, ADO.NET

Professional Experience

Client: Confidential, Philadelphia, PA Jan’ 10-Current
Role: Programmer Analyst 
Description: Confidential is a global insurance and reinsurance leader in property, casualty and financial services. I have worked under the PRIMA module enhancing the scope of the Meridian application among eleven applications. Meridian is basically an underwriting system, second oldest system after Subscribe implemented by PRIMA, all servers resides on UK.We get the data in the form of text files. Basically we have two types of data in Meridian system Premium Claim.

Responsibilities:
Leading the development effort for ‘Meridian’, a module for PRIMA application, using ETL and DTS packages

• Active participation in requirement gathering, design and implementation using the SSIS, SSRS packages enabling rapid and error free data transfer from and to the database.
• Developed an ETL batch monitoring tool in C# and ADO.Net.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Designed the cubes by using OLAP, MOLAP, ROLAP levels and appropriate aggregations.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Defined Referential Relationships with the Measure Groups and Fact tables
• Implemented the calculations to aggregate Physical Measures and defined Granularity within a measure group and drill through actions.
• Training new entrants to the project on domain and technology.
• Documented the load of Premium and Claim data into Meridian system for the new joiners in the team.
• Resolved high priority job failure issues in the production.
• Created Cube reports that can be browsed at Summary level and can be drilled down to the detail level.
• Developed DTS Packages for different countries depending on the user requirements.
• Documented the development work and production release for future reference.
• Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.
• Development of high visibility dashboard using tools such as ProClarity and a prime resource for leading the efforts on the development of dashboards using ProClarity
• Coordinating effort in high priority production issues for faster resolution with impeccable quality
• Involved in Unit testing integrated testing and System testing.
• Provide 24 X 7 supports to all production, development and staging.

Environment: SQL Server 2000/2005/2008, SSIS, SSRS, ProClarity, Brio, Visual Studio 2005, C#, ADO.NET

Client: Confidential, Union, MO Feb’ 09-Dec’ 09
Role: Programmer Analyst
Description: Confidential is Leading Company in Auto, Financial services products that help customers prepare for the future and Home Insurance Industry. The main objective of this project to implement ‘Claim’ application for the US region

Responsibilities:

• Extensively involved in developing SSIS packages for extracting the data from database transforming it and loading into the data warehouse.
• Worked on various SSIS objects like Data flow components, Control Flow elements, Connection Manager, Event Handling and log providers.
• 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 complex calculated members, Perspectives, Named Sets and KPI’s using MDX expressions for specific OLAP requirements.
• Worked on optimizing the performance of the cube by partitioning the cube and minimizing the number of calculated members.
• Wrote various stored procedures for the purpose of application development.
• Involved in Creation of Reports, Created ODBC Connections and database Connections.
• Based on the required reports, identified various data sources and constructed data source view.
• Worked with MS SQL Server databases to create complex reports.
• Extensively worked in designing a developing Report services according to Business Requirements.
• Created reports using subscription using both Standard and Data Driven subscriptions
• Designed new SSRS,Proclarity,DashBoard reports required by the user
• Modified the Dashboard reports with proper Drill through Action to RS Report
• As per the Business Requirements created new slicers for the Dashboard Reports
• Involved in job scheduling and alerts.
• Successful delivery under tough deadlines.

Environment: SQL Server 2005, SSIS, ETL, VB macros and Visual Studio 2005.

Client: Confidential, Riverside, CA. Mar’ 08 – Jan’ 09
Role: Systems Analyst
Description: Confidential is a leading financial services company which provides a comprehensive range of financial services: Commercial Loans, Refinance, Loan Programs, Home Purchase, Lines of Credit and Home Equity. The main objective of the project was to collect data from various database sources to perform analysis and then integrate the various source databases into a centralized database.

• Involved in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS
• Created SSIS process design architecting the flow of data from MS Access to MS SQL Server 2005.
• Created ETL (.dtsx files) packages using SSIS to validate, extract, transform and load data to data warehouse databases, data mart databases
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created calculated fields with MDX cube to meet additional measures needs that are calculated from existing measures.
• Developed multiple join statements to retrieve data from several tables.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure on levels of reports.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of data effective.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Involved in solving job failure issues by back tracking the data.

Client: Confidential. Oct’ 06 – Feb’ 08 
Role: SSAS/SSRS developer
Description: Confidential is countries premier insurance provider for various lines of business like health, property and casualty. As a BI developer I was responsible for getting reports out for Standard reporting purposes as well as Microsoft Cubes for Data Analysis purposes.

• Created logical and physical data models for new requirements after discussion with technical team and application users.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created OLAP cubes and dimensions for the analysis of registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Established backup and recovery of SQL server 2005.
• Used Visual Source Safe (VSS) for version control.

Client: Confidential. Jun’ 05 – Sep’ 06
Role: DTS/SSRS developer
Description: Confidential is one of the top credit card issuers in the United States. The company offers Visa and Master Card plastic with a variety of annual percentage rates, credit limits, finance charges, and fees. The main objective is to migrate the data in Oracle to PL/SQL and generate RS Reports after migration as per BRD.

Responsibilities:

• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Worked on DTS Package, DTS Import for Transferring data from Oracle
• Generated Reports using SQL server Report Services 2005.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Looked at the reports and fixing bugs in stored procedures, tables and ETL process.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Developed parameterized existing reports.
• Involved in preparing training document for application development and QA/UAT teams.

Achievements and Accolades

• Recognized top performer in the team with all round appreciation from client and management
• MCPDEA and MCP certified.
• Presented Technical Paper on “Network Security & Firewalls” for the National Level Technical Symposium.
• All round accolades in extracurricular activities
• Submitted an article on “Place of India in today’s scientific world “.