SUMMARY

• Around 7 years of experience in Database Design and Development in MS SQL Server 2008R 2/ 2008/2005/2000 as BI Developer/ Database Developer.
• Proficient in creating highly flexible Database Architecture, Modeling, Data Warehousing, Design, Development and Technical Management
• Implemented complete BI SDLC, as a Lead member in Agile/Scrum/Iterative Methodology
• Extensive experience in implementing BI solutions using SSIS, SSRS & SSAS.
• Proficient in implementing business logic and procedure in backend using stored procedures and user defined functions.
• Experience in creating Dashboards/KPI’s, Scorecards, Gauges, Reports, views\briefing books, pivot tables for analysis in SharePoint, SSRS and MS Excel.
• Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Created Parameterized reports, Cross - Tab reports, Drill down reports & Summary reports.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Expertise in SQL Server 2005 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features.
• Experience in Relational (OLTP) and Dimensional modeling (OLAP) concepts and constructs.
• Experience in building & administering Cubes using SSAS standard interfaces, XMLA and AMO.
• Performed CDC and Change tracking on OLTP systems.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Experienced in creating Views, Stored Procedures, functions and Triggers using T-SQL.
• Experienced in ETL - Extract Transform and Load experience using DTS & SSIS (SQL Server Integration Services) in SQL Server 2005 and 2008.
• Created programs inColdFusion and JavaScriptto run various tasks for user validation, parsing, functioning of site
• Cooperated and communicated effectively, both orally and in writing, with users, technical staff and management
• Established priorities and organize assignments, and to work effectively within timelines and under general supervision

TECHNICAL SKILLS

Tools: SQL Server Integration Services (SSIS),SQL Server Analysis Services (SSAS)SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Visio, Erwin, ColdFusionMX5.0/7.0/8.0

Databases: MS SQL Server 2008/2005/2000, Oracle 8i, 9i/10g, MS Access 97/2000,DB2

Languages: T-SQL, C#,VB.NET,ASP.NET

Scripting: HTML, DHTML, MDX, Shell Scripting, Perl, XML,XSLT

Operating Systems: Windows server 2003, Windows 2000 advanced server, Windows 95/98/NT/4.0/2000,XP,UNIX

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. BI Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis.
• Assisted business users and end users to schedule and write subscriptions on report manager.
• Used Multi-dimensional expressions (MDX) to present the data asked by the user, to simultaneously query on different dimensions.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Created and deployed several packages in SSIS.
• Development and deploying of the SSIS 2005/2008 packages to maintain,update,migrate the data into and from the FACETS application database.
• Deployed and configured the reports in the Report Server.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, XML files, flat files to SQL server 2005.
• Extensively worked on to converting the reports, from VB to SSRS 2005/2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS).
• Structured Terabytes of Data by CUBE Partitions and Dimensions in SSAS
• Created stored procedures and user-defined functions for different Reports.
• Created complex correlated sub queries to generate reports.
• Extensive work on tuning the long-running SQL /PL-SQL Stored Procedures, when needed
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Modify SQL queries to upgrade SQL Server performance using SQL Server 2000/2005.
• Supported OLAP team to provide data from SQL Servers and generating reports.
• Converted crystal, actuate and MS Access reports to SQL reports, generated reports using crystal reports.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Created programs inColdFusionto run various tasks for user validation, parsing, functioning of site
• Optimized and tuned the various ColdFusion Applications to maintain a high degree of availability and uptime for these mission-critical reporting processes
• Upgrade the application from CF5.0 to CFMX8.0 version
• Developed solutions for programming scenarios using C#, ASP.NET.
• Helped QA personnel in deploying and testing the application.

Environment: SQL Server 2008/2005/2000, SSRS 2005/2008, VB, SSIS 2005, SSAS, ColdFusionMX5.0/8.0,C#, ASP.NET, Adobe Dreamweaver MX, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Grand Rapids, MI

Sr. SSRS/SSIS Developer

Responsibilities:

• Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.
• Upgrade SSIS 2005 packages to SSIS 2008
• Loading data from different sources like CSV, Excel, SQL Server 2008 and IBM DB2 into CRM Pivotal-Touch point using SSIS 2008
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Used VB.Net code in SSIS script task for sending dynamic email attachments with customized logging information
• Used VB.Net code in SSIS 2008 script task for loading T Rowe Price documents( pdf, word, JPEG images, excel) from a network secured shared directory into SQL server table
• Created programs inColdFusionand JavaScript to run various tasks such as user validation, parsing, functioning of site and conversion of XML getting user data for mining purposes and assisted Jr.Developers related to ColdFusion
• Set up Client environments and created connections inColdFusionAdmin Server
• Set up the QA environment with CFMX
• Responsible for fixing data issues occurred in Production
• Generated reports using SQL Server Reporting Services, and created user friendly templates, indexes, using xml.
• Developed reports using SSRS 2008 to generate all daily, weekly, monthly and quarterly Reports including current status to keep track of data related to physicians and payers health plans.
• Experience in working with Advanced reporting services programming using SSRS.
• Created cubes using SSAS and Assisted in modifying MDX Scripts for the OLAP cubes
• Worked on report viewer control with server and client reports
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, PDAs and window messengers.
• Efficiently used excel worksheets, flat files for loading data to/from a database.
• Implemented and maintained database security.
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Tuned SQL statements using indexes, SQL stored Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION statement & using the TOP operator to limit the Select Statement in certain Queries.

Environment: SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), ColdFusionMX7.0/8.0, Fireworks/Dreamweaver#, VB, Microsoft Visio, SQL Profiler.

Confidential, San Diego, CA

SQL Developer/Data Analyst

Responsibilities:

• Involved in identification of all the stake holders and held extensive conversations with Subject Matter Experts to understand data and business logic.
• Involved in gathering business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse.
• Created Business Requirement Specification in collaboration with the Business analysts. Once BRS was created was responsible for creating different modules of the project.
• Created complex stored procedures, indexes, views, functions, and triggers on creation and optimization to improve response time and to enforce business requirements through T-SQL.
• Involved in performance tuning, query optimization, database optimization and maintaining data integrity with complex TSQL scripts and implemented business rules.
• Developed SSIS Packages to extract, transform and load data from heterogeneous sources like flat files, Production SQL Servers (2000/2005) and oracle servers into SQL Server 2008 Staging Database and data marts.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources (SQL Server, flat files, excel, access) and determined the hierarchies in dimensions.
• Used proper error handling techniques like logging, checkpoints, event handler etc. to handle errors in the packages.
• Created complex SSIS packages (Master-child) with properties like package configurations, SSIS loggings as well as custom loggings (using event handlers).
• Proper optimizing techniques like parallel execution, buffer usage, checkpoints, optimized query used for optimizing the packages.
• Worked on Optimization and Debugging of ETL packages at Control Flow and Data Flow level along with making proper use of transactions and checkpoints.
• Created OLAP cubes using KPI’s for analyzing financial trends before and after company mergers and also created calculated members.
• Developed SSRS Reports like drill through reports, drill down reports, linked reports and parameterized reports.
• Scheduled several reports to be delivered to multiple users and subscribers in several intervals as well as forms like Excel, PDF and Text.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Environment: Microsoft SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, T-SQL

Confidential, CA

DTS/SSIS/SSRS Developer

Responsibilities:

• Transformation and loading into the target SQL Server databases using ETL tools, DTS 2000 and SSIS 2005.
• Created SSIS packages with which data resources such as Flat files, Excell files, PDF files were loaded daily in order to create and maintain a centralized data warehouse.
• Made the package dynamic so it fit the environment.
• Scaled SSIS to make it work more reliable.
• Expertise experience with administering and debugging DTS and SSIS.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS programs. Hands on working experience with configuring every aspects of SSIS 2005.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Developed reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2000/2005 Enterprise, Hyperion Essbase, Hyperion Report 9, Microsoft Reporting Service, SQL server BI development studio, Microsoft Visual Studio 2005

Confidential 

TSQL/SSIS/SSRS Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Installed and configured SQL Server 2005, SQL Server Integration Services and SQL Server Reporting Services which were highly efficient to Monitor the Central console and SQL server Instances and detecting problems before affecting transaction of Online users.
• Merged Data from Heterogeneous Data stores (Oracle, Access and Excel) to SQL Server 2005 using SSIS packages.
• Participated in to Design ETL architecture and processes insurance and policies related record from different locations. Successfully met challenges of very high volume of data.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Implemented the Online Indexing making the Transaction in SQL 2005 faster nearly three times as compared to the SQL Server 2000.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user defined functions (UDF’s).
• Imported XML data file and put into the desired database.
• Created different type of reports including Drill-down, Drill-Through and many more.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled the Reports in Report Manager.
• Responsible for generating different types of daily and weekly Reports based on requirements using SQL Server Business Intelligence Tool.
• Documented all the work and all the process of integration and reporting services for further references.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, Microsoft Operation Manager, ASP, ODBC, VBScript, Jscript, Visio, Windows 2000/XP, IIS 5.0