PROFESSIONAL SUMMARY

• Total 6 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment
• Strong technical knowledge in MS SQL Server 2005/2008/2008R2/2012 development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications .
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS and SQL Server Integration Services SSIS 2005/2008/2008R2 .
• Experience in creating dashboards, scorecards and building reports using performance point server 2008.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services SSIS .
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Thorough understanding of Kimball's' theory, KPIs, SQL 2008 Architecture.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Hands on experience on internet information services IIS

TECHNICAL SKILLS

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series Database: SQL Server 2005/2008/2008R2/2012 Operating Systems: HP UNIX, Windows Server 2003/2008/2008R2. Programming Languages: SQL, PL/SQL BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS, Hyperion ETL TOOLS: DTS, SSIS, Informatica 9.5/9.1/8 Database Tools: DBArtisan, SQL Litespeed.

SCM Tools: Visual Source Safe, Star Team.

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008R2/2012
• Written SSIS packages in 2008R2 and did conversion of DTS packages from 2008R2 to 2012
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Created complex stored procedures, Triggers and user defined functions using joins and cursors as required for SSIS packages.
• Completed left over tasks in other projects which includes sending invoice emails, modified excel files before loading them to database.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Expertise in ETL techniques using Informatica Power Center 8.x/9.x, Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Analyze user requirements, functional and technical specifications, preparing test plans.
• Coordinating with Offshore DBAs and sharing changes or any scheduled work seamlessly to appear as on one global team to Customers.

Environment: SQL Server 2008R2/2012, Visual Studio 2008/2010, SSRS, SSIS, DTS, Visual Source Safe, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory, Windows 2008R2

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Individually designed MS SQL Server 2008/2008R2 database, coded stored procedures T-SQL .
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Worked with various XML data and worked on creating ETL packages with loading all package in loop and loading them in SQL server
• Created package with different data sources SQL Server, Flat Files, Excel files, etc and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Created temporary tables and table variables while creating complex queries in SQL Server 2008/2008R2.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Designing, developing, implementing, and maintaining reporting frameworks.
• Created SQL Server Profiler traces used with Database Tuning Advisor DTA for optimum performance of queries.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Built SSRS reports from various heterogeneous sources like SQL Server.
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Creating Ad-hoc reports using Report Builder.
• Adept at rebuilding indexes on various tables.
• Optimized the SQLs and Informatica mappings which handled millions of records
• Adept at debugging stored procedures using SQL Server Profiler.
• Restored QA server from development periodically to test the queries on the QA server.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2008, Informatica 9.1, Erwin 7x.

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Extensively worked on MS-SSRS, SSIS and Slowly Changing Dimensions.
• Adept at rebuilding indexes on various tables.
• Database size exceeded 4 million rows.
• Created SQL Server Profiler traces used with Database Tuning Advisor DTA for optimum performance of queries.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Writing complex SQL queries using table joins inner and outer , temporary tables, and table variables.
• Designing, developing, implementing, and maintaining reporting frameworks.
• Developed/Monitored ETL packages with different data sources SQL Server, Flat Files, Excel files, etc and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in creation of dimensions using Star, Snow Flake schemas.
• Involved in strategic, planning and budgetary responsibilities.
• Created several MDX queries according to Business requirements.
• Wrote MDX queries and expressions for use in Front End BI Applications
• Built SSRS reports from various heterogeneous sources like SQL Server,
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Creating Ad-hoc reports using Report Builder.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, SSIS, Dashboards, Windows Server 2008, MDX, DTA, Ad-hoc

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Extensive knowledge of loading data from various sources like CSV, flat files, to SQL Server database using SSIS Package.
• Involved in the creation and enhancements of the reports in WebFOCUS.
• Created indexes, optimized SQL queries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
• Developed, designing and deploying of various complex reports such as Drill down, Tabular reports, Parameterized, Pie charts using Expressions, Global variables and Functions in MS Reporting Services.
• Generated of Ad-Hoc reports as per the client requirements using Report Builder.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
• Developed complex SQL queries involving stored procedures, cursors, triggers, table inner and outer joins, temporary tables, table variables.
• Developed effective triggers, and useful functions to facilitate consistent data storage.
• Done Performance tuning for stored procedures and optimizing SQL Server performance using SQL Server Profiler
• Involved in monitoring the execution plans of the queries to pre access the resources being used by the queries.
• Good experience in creating Master Child Packages in SSIS.
• Hands on Experience in managing various SSIS Package Configurations in the form of XML Files.
• Generated various Reports using SSRS SQL Server Reporting Services .
• Developed complex stored procedures, T-SQL functions, triggers and views using SQL Server Management Studio.
• Identified and communicate system updates to ensure accurate processing and timely collections.
• Identified denial trends and present issue and solutions to management.

Environment: WebFOCUS 7.x, Developer Studio, Reports Caster , SQL Server 2005/2008 Enterprise Edition, T-SQL, SSRS, SSIS, Windows Server 2003/2008, Erwin 7.1.

Confidential

BI Developer

Responsibilities:

• Actively participated in interactions between users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Worked on SSIS for transferring data from Heterogeneous Database Access database and flat file data to SQL Server.
• Created logical and physical database design using Erwin.
• Wrote DTS packages to move data between production, staging and QA environment.
• Worked on different kinds of transformations in SSIS as per the client's Requirement
• Created report modules to provide interactive reports to the users MS SQL Server 2005/2008 .
• Generated Monthly and quarterly Reports in the form of bar chart reports for the management using different techniques like Drill down, Tabular reports, Matrix reports, List reports, Parameterized, Pie charts, Graphs ,Linked Reports, Drill Through using Expressions, Global variables and Functions.
• Successfully deployed reports to report server using SSRS 2005/2008.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Enhancing and deploying the SSIS Packages from development server to production server.
• 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, Data dictionary and Metadata.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services SSRS .
• Played a major role in the production support of SSIS jobs
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensive knowledge in SQL Server optimization using SQL tools such as SQL Profiler, Index Tuning Wizard, DBCC commands, Statistics.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL, Windows Server 2003/2008, Erwin, DTS Data Transformation Services