Professional Summary

• Over 8 years experience as MS SQL Server BI Developer, involved in Design, Development and Support of MS SQL Server 2000/2005/2008/2008 R2/2012.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Configured report subscriptions both data driven and time driven.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
• Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and loading using SSIS and designed data conversions from wide variety of source system.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services DTS and SSIS with MS SQL 2005/2008/2012.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008/2012.
• Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence SSAS .
• Involved in migration of DTS Packages 2000 to SSIS 2005 and troubleshoot migration issues.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. Deployed reports across Test, Dev and production environments.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Hands on experience in using transformations like Aggregate, Row Count, Data Conversion, Lookup, Merge, Union all, Derived Column, Multi Cast, OLEDB Command and Conditional Split in different scenarios.
• Worked Extensively on Creating and Calling Complex Stored Procedures, Views, Functions, Cursors, Triggers, Indexes using SQL Server 2000/2005/2008/2012.
• Developed dashboard reports using SQL Server Reporting Services SSRS , Report Model and ad-hoc reporting using Report Builder.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services SSRS .
• Working knowledge in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, Drill-Down, Parameterized and for the end user requirement Ad Hoc Reports using SQL Server Reporting Services SSRS in Business Intelligent Development Studio BIDS .
• Experienced in developing reports in different rendering formats like Excel, PDF and Word
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Expert in calculating measures and dimension members using multi dimensional expression MDX , mathematical formulas, and user-defined functions.
• Expertise in Error and Event Handling which involves Break Points, Check Points, Precedence Constraints, and Logging.
• Scheduled SSIS and SSRS jobs to run automatically by creating a job scheduler using SQL Server Agent and Tidal Scheduler.
• Microsoft Team Foundation Server TFS to manage the team's software development lifecycle.
• Used Versioning tools like PVCS and Team Foundation Server for version controlling of the application.
• Excellent Team member with an ability to perform individually, good interpersonal relations, strong communication skills and high levels of motivation.

Technical Skills:

Professional Experience:

Confidential

SQL BI Developer

Confidential, an independent licensee of the Blue Cross and Blue Shield Association, is a reliable name in Hawaii health care. Established in 1938, and it is the largest and experienced provider health care coverage in the state. HMSA also offers a variety of programs, services and support to help improve the health and well-being of members and community.

Responsibilities:

• Actively participated in interacting with users, team lead, DBA's and technical manager to fully understand the Application/System and Business requirements.
• Worked to resolve IM tickets generated by production control when a job in production fails or output is not appropriate.
• Created custom made Calendars, Events and Actions in Tidal Scheduler to send an email after job Success/Failure.
• Scheduled SSIS and SSRS jobs to run automatically by creating a job scheduler using SQL Server Agent and Tidal Scheduler.
• Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and For-Each loop container in SSIS scheduled the same SSIS packages by creating the job tasks.
• Actively supported business users for change requests.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Worked on the Reports module of the project as a developer on MS SQL Server 2012, 2008 and 2005 using T-SQL, scripts, stored procedures and views .
• Using SQL server reporting services SSRS and Web-enabled reporting to create reports that draw content from a variety of data sources.

• Loading data from various sources like OLEDB, flat files, Excel files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Used various transformations like Derived Column to write expressions, Row Count Condition split, Aggregate transformation and Multicast transformations based on the need and business requirement.
• Expertise in using File System task to do FTP operations.
• Used Lookups Transformation to get the data from reference data sets.
• Used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Created Tidal jobs of different kind like FTP and MS SQL jobs.
• Loading data from OLEDB into flat files and Excel files.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Experienced in understanding the SQL queries/SP, SSIS Packages and SSRS reports written/designed by others to modify/redesign them according to the new requirements.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Using SSIS Packages and created data mappings to load the data from source to destination.
• Creating Reports as per user requirements using MS Reporting Services 2008/2005.
• Created SSIS Packages to migrate slowly changing dimensions.
• Created SSIS packages to load data into SQL Database using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, and active script task.
• Created Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages.
• Deployed reports across Test, Dev and production environments.
• Created sub reports, bar charts and matrix reports using SSRS.
• Involved in Unit Testing of the results of SQL queries before actually testing team do.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Extensively worked on generating SSRS reports in different rendering formats like Microsoft office word 2010/ 2007, PDF and Excel 2013/2010/2007.
• Written test cases for Unit testing purposes.
• Involved in demoralization of tables for reporting purposes.
• Excellent report creation skills using Microsoft Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.

Environment: MS SQL Server 2012/2008/2005, Windows 7/2008/2000/NT/XP, SSIS, SSRS, T-SQL, TFS 2013, OLTP, MS Office 2010/2007/2003, Excel 2013/2010/2007, MS Office Access 2010 and Microsoft Visual Studio.Net.

Confidential

SQL BI Developer

Confidential is a global investment bank which provides financing and risk management services to large companies, institutions and government clients and is represented in Confidential

Responsibilities:

• Using SQL server reporting services SSRS and Crystal Reports delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used Lookups Transformation to get the data from reference data sets.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Developed Multi-dimensional Objects Cubes, Dimensions using MS Analysis Services.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Actively supported business users for change requests.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2005 Reporting Services.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modelling standards in SQL Server 2005 that maintained data.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 and 2005 using SSRS, T-SQL, scripts, stored procedures and views .
• Actively participated in meetings with users, business analyst, team lead and technical manager to fully understand the business requirements.
• Updated functional specification and technical design documents. Studied the existing OLTP system s and Created facts, dimensions and star schema representation for the data mart.
• Experience in creating views, books and libraries in proClarity web professional.
• Created SSIS Packages to migrate slowly changing dimensions.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS using 2008/2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005
• Created Data warehouse environment for OLAP Data mining in SSAS.
• Microsoft Team Foundation Server TFS to manage SQL Scripts.
• Created Dashboards and reporting services web parts using MOSS 2007.

• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Involved in demoralization of tables for reporting purposes.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Environment: MS SQL Server 2008 R2/2005, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, ProClarity, MS Office 2003.

Confidential

SQL BI Developer

Confidential operates a travel agency was founded in 1951. It offers vacation, honeymoon, flight, hotel, cruise, tour, and business travel packages to many destinations worldwide. It also provides travel planning, travel insurance, and group travel services also.

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Experience in developing User reports and management reports using MS SQL Server Reporting Services SSRS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Created several Dashboards and Scorecards with Key Performance Indicators KPI in SQL Server Analysis Services SSAS -2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS ETL packages for loading data from Oracle and Flat files 3GB to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Used VBA to develop new algorithms to analyze the data, then used charting capabilities in Excel to display the results.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export DTS , SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C .NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential

SQL Developer

Confidential is one of the world's largest integrated financial services organization which offer products like Whole life insurance, Universal life insurance and Term Life insurance.

Responsibilities:

• Implemented various DDL modifications and developed Script libraries for generating Tables, Viewsand Functions for Reports.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 using SSRS, T-SQL, scripts, stored procedures and views .
• Work with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Developed complex SQL Scripts for various data manipulations and validations across ETL, Reporting and OLTP systems.
• Extensively used triggers, stored procedures with complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created complex correlated sub queries to generate reports.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Excellent report creation skills using Microsoft Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Training and Mentoring the Business Users to help them understand OLAP Cubes by having one on one Training Session Using ProClarity 6.2 Client tools.

Environment: Windows Server 2003, SQL Server 2005, SSRS, SSIS, SSAS, Enterprise manager, PPS, MS PowerPoint, SharePoint.

Confidential

MS SQL Server Developer/Report Developer

Confidential is a 14th ranked hospital in whole U.S.A. Methodist is a leader in DIFFERENT specialties and provides treatment of cancer, organ transplants, endoscopic surgery, nephrology/kidney disease, otolaryngology, neurology and neurosurgery, orthopedics and urology. The Methodist Hospital's mission is to provide the best care and service in a spiritual environment.

Responsibilities:

Actively participated with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Created permanent tables, temporary tables and table variables.
• Translating business requirements into technical design specifications.
• Used Query Analyzer to optimize SQL queries.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Worked on DTS/SSIS for transferring data from Heterogeneous Database Access database and xml format data to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2005 / 2000 2003, 64 bit edition of SQL server 2000 , DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.

Confidential

SQL Developer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Data migration import export BCP from Text to SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Managing historical data from various heterogeneous data sources i.e. Excel, Access .

Environment: SQL Server 2005/ 2000, Windows 2000, T-SQL, DTS, BCP TOAD.