-------------------------------------------------------------------------------------------------------------------------------------------------------

SUMMARY:

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments, C , .NET framework, OOPS Concepts, and on various business domains like Health care, Financial and Insurance.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products SSIS, SSAS, SSRS including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013, Performance Point Server and ProClarity analysis server.
• Experience in Developing and Tuning T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF'S, triggers, views, Indexed views and error handling using Try-Catch blocks
• Experience in supporting Very Large databases VLDB and Very large tables with millions of rows and troubleshooting the problems
• Implemented Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions.
• Thorough understanding of Kimball's' theory, KPIs, Perspectives, Translations and SQL 2008 Architecture.
• Experience with data modeling, logical and physical database design using Erwin.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
• Experience in using Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2000/2005/2008R2/2012.
• Designed and built complex cubes using Multidimensional Expressions MDX of SQL Server and manipulating the multidimensional data stored in OLAP cubes.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. Table, chart and matrix report .
• Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012 and Crystal Reports X1.
• Experienced in sorting the data, defining data source and subtotals for the reports Expert in Cube designer in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Developed data interface layer using ASP.NET and C for data access.
• Worked in performance tuning, query optimization, client/server connectivity and Database Consistency Checks using DBCC utilities.
• Expertise in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Expertise in Dashboard design with a working knowledge of Performance Point Server including the ability to design and develop scorecards and dashboards using ProClarity.
• Experience in developing Life Cycle using Agile Methodology.

SKILLS:

EXPERIENCE:

Confidential

Sr. SQL Developer SSIS, SSRS

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology
• Involved in migration of SQL Server 2008 to 2012
• Assist with testing and quality assurance activities with data extracts, research and analysis
• Monitoring and resolving Data warehouse ETL Production issues.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
• Prepared required documentation for system support and end users and provide end-user training for the reports and analytical solutions
• Developed SSRS reports and dashboards using Microsoft Reporting Services platform SSRS
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into report
• Customize output formats from SSRS to Excel, PDF, and CSV.
• Creating Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports in SSRS 2012
• Provided technical support for SSRS business applications.
• Worked closely with stakeholders from different business units to determine reporting and application requirements, perform analysis to create statement of work and provide time estimates
• Designed layout of SSRS reports and determined the best way to present data to the end users
• Maintained an awareness and understanding of technological advances provide continuous research and assessment of new resources and technology

Environment: SQL Server Business Intelligence Development Studio 2005/2008/2012, Microsoft Visual Studio, SQL Server SSAS/SSRS/SSIS, T-SQL, Aqua data 9.0, XML, MS Excel, HTML, CSS, Javascript

Confidential

Sr. SQL Developer SSIS, SSRS

Responsibilities:

• Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Created SSIS packages to clean and load data to data warehouse.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2012.
• Identified the Data Source and defining them to build the Data Source Views.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Perform unit level analysis on all work done before handing over to the testing team
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
• Create SSRS reports according to user requirements and technical standards
• Customize output formats from SSRS to Excel, PDF, and CSV.
• Creating Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports in SSRS 2012
• Designed and implemented stylish report layouts.
• Creating dashboards consisting of grids, charts and reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client's workstation.
• Improved Report Performance and performed unit testing.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Environment: SQL Server Business Intelligence Development Studio 2005/2008/2012, Microsoft Visual Studio, ASP.NET, IBM DB2 AS400 iSeries , SQL Server SSAS/SSRS/SSIS, T-SQL, Aqua data 9.0, XML, MS Excel.

Confidential

Sr. SQL Developer SSIS, SSRS

Responsibilities:

• Involved in migration of SQL Server 2008 to 2012
• Created User defined functions and stored procedures to meet the requirement.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions UDF and Scripts using T-SQL Code.
• Identified and defined the Datasets for the report generation.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Identified all the existing aggregations calculations in the existing system using all the MDX queries used in the current system
• Migrated Crystal reports to SSRS 2008.
• Responsible for monitoring and tuning SSRS Report Performance.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created ad-hoc reports with incorporated filters, sorting etc and presented them at the client side to note the changes they may need.
• Deployed reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Developed data interface layer using ASP.NET and C for data access.
• Created dashboards/scorecards against SSAS cubes using ProClarity and SSRS
• Designed OLAP Cubes for and worked with ProClarity front end tool to design and view report analysis.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services SSAS .
• Created excel reports from relational databases, cubes and using power pivot.
• Created UDM for cubes in SSAS.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.

Environment: SQL Server Business Intelligence Development Studio 2005/2008/2012, Microsoft Visual Studio 2005, SQL Server Management Studio 2008, ASP.NET, Informatica, T-SQL, IBM DB2 AS400 iSeries , SQL Server SSAS/SSRS/SSIS, Aqua data 9.0, XML ,MS Excel.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Upgrade / Migration of large data from Sql Server 2005 to Sql Server 2008.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created SSIS packages with which data resources are loaded daily in order to create and maintain a centralized data mart. Made the package dynamic so it fit the environment.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Identified the Data Source and defined them to build the Data Source Views.
• Used DBCC commands for checking database consistency and fixing data corruption in user databases.
• Done performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Created a number of cubes, dimensions using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design Star Schema and maintenance.
• Developed Query for generating drill down reports in SSRS 2008 and Crystal Reports 9.0.
• Designed and created drill down reports in SSRS 2008.
• Identified and worked with parameters for parameterized reports in SSRS 2008.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005.
• Responsible for creating summary Reports, Sub Reports, Drill Down Report, dynamic grouping.
• Maintained report security by creating Service Accounts and Security Groups and configuring in the Report Server.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Developed Flowchart automation with Visio/VBA/Excel/SQL which was used in storing Flowchart elements.
• Developed and implemented Backup and Recovery strategies. Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per the business needs.
• Created score cards with executive summary dashboards in MS Performance Point Server 2007 Dashboard Designer deriving data from a SQL Server 2005 OLAP data source.
• Deployed Reports using SQL Server Reporting Services SSRS and ProClarity.
• Designed and built SSAS complex cubes which include millions of records which are complex and large.
• Built MDX queries used in reports of various patients' health related documents.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Done database server trouble shooting and maintain maximum available time.

Environment: MS SQL Server 2000/2005/2008, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server SSAS/SSRS/SSIS, SQL Server Business Intelligence Development Studio 2008/2005, Microsoft Visual Studio 2005,MS Performance Point Server 2007, ProClarity, C , ADO.net, XML ,MS Excel.

Confidential

SQL BI Developer SSIS/SSRS

Responsibilities:

• Worked closely with Database Lead to design and implement database components in timely manner.
• Created complex SSIS packages for transferring and reviewing data from heterogeneous sources like Excel, MS Access, MySQL, PostgreSQL, CSV, flat file, Text Format Data .
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Created both automated and manual reports using SSRS SQL Server Reporting Services .
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Designed the usage summary and detailed reports in SSRS 2005 from the requirement document and the old reports Mock-Up in MS Excel.
• Responsible for the reports deployment through SSRS on the Reports Server. Returned the stored procedure and the UDF for the reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS and Crystal Reports with .NET applications.
• Involved in the design, development and implementation of web user interfaces using C . NET, ASP.NET
• Implemented data mart, facts, dimensions, star schema and OLAP cubes using SQL Server Analysis Service.
• Created Multi Dimensional Expression MDX for accessing OLAP cubes.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Created calculated measures and dimension members using multi dimensional expression MDX , mathematical formulas, and user-defined functions.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Created daily and weekly reports based on the data from OLAP cubes and the SQL database using SSRS 2005.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Designed OLAP Cubes for and worked with ProClarity front end tool to design and view report analysis.
• Conducted performance tuning of database and query optimization.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Implemented site information architecture utilizing various SharePoint resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling
• Managed index and optimized queries using execution plan.

Environment: MS SQL Server 2005, SQL SSAS,SSRS,SSIS, T-SQL, OLAP, SQL Server Business Intelligence Development Studio 2008/2005, Share point, Procalrity, MS Access, MySQL, ASP.NET, Postgre SQL, DTS to Import Export Data, VB Script, Windows XP.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Checking database integrity, Creating new databases, tables, views and Stored Procedure.
• Creating complex SQL Queries to partition and aggregate the data based on cookie and session ids of millions of visitors.
• Performed backups using Backup / Recovery, Attach / Detach data tools, Developed complex DTS packages.
• Involved in migration of SQL 2000 to SQL 2005.
• Dashboards and Scorecards with Key Performance Indicators KPI in SQL Server 2005 Analysis Services SSAS .
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developed complex T-SQL code, stored procedures, functions, views and triggers for the application.
• Created ETL SSIS packages both design and code to process data to target databases.
• Fine tuned DML, DDL scripts with lock hints for performance boost.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers
• Responsible for writing T-SQL code for creating cursor and handling data validations.

Environment: MS SQL Server 2000/2005, SQL Server 2005/2000 Enterprise Edition, SSIS/SSRS, T-SQL, OLAP,Windows Server 2003, Windows XP.

Confidential

SQL Server Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle SDLC and developed use Case diagrams, Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose
• Implement high availability through database mirroring and Merge Replication.
• Performed Import / Export using DTS
• Propping up the new schema changes and additional new features on Development, Staging/QA and Production servers.
• Configured Log Shipping between Primary and Secondary servers.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Developed web based ASP.NET internet applications
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables.
• Discussions with Product team for new features.

Environment: Microsoft SQL Server 2000, Windows XP, ASP.NET, Rational Rose.