PROFESSIONAL SUMMARY:

• A Microsoft Certified Business Intelligence Professional using SQL Server 2005/2008R2 and Microsoft Technologies
• Over 6.5 Years of experience with Data Warehousing/OLTP applications across various Oil Gas, Engineering, Financial, Banking and HealthCare Domains
• Extensive Experience using Microsoft BI Tools SSIS 2008/2005, SSRS 2008/2005, SSAS for various mission critical applications
• Expert in Design/Development/Supporting OLTP/OLAP applications using Relational / Dimensional modeling
• Hands on experience with SQL Server and T-SQL in constructing Stored Procedures ,triggers, tables, user functions, views, indexes, relational database models and various other database objects
• Experienced in ETL/Data warehousing systems, Data mapping, data dictionary, ODS/Staging/EDW
• Expertise in SQL Integration Services SSIS involving ETL/Migration/Development/Deployment /configuration of SSIS Packages in both ETL/OLTP environments
• Extensively used various features of SSIS Packages Control Flow tasks, Data Flow tasks, Transformations, Migration tasks
• Successfully extracted Data from Different Databases like Oracle, DB2 and Sybase and file systems like Excel/Flat Files
• Expert in Migrating DTS Packages to SSIS and scheduling them
• Created SSIS Packages to import and export data from Excel Spreadsheets, ACESS, Text files and CSV files
• Expertise in Installation/Configuration/Deployment of SSRS Report both in Native/ SharePoint mode and supporting Enterprise Reporting for various customer needs
• Well Experienced in Generating parameterized reports in SSRS
• Extensive experience in basic and advanced report creation with thorough knowledge of report serving architecture
• Experience in creating various types of reports table, chart, list and matrix report
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services SSRS
• Knowledge of RDBMS and Data Warehouse concepts, OLTP OLAP
• Proficient in using Profilers for both performance and auditing purposes
• Expertise in Resolve database performance issues, Query optimization using execution plans, DMFs, DMVs and various other diagnostic tools
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services DTS , and SSIS, Bulk Copy Program BCP and Bulk Insert
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Excellent Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Strong conceptual, analytical, and design skills and excellent communication skills with leadership qualities

TECHNICAL SKILLS:

• Relational Databases : SQL Server 2000, 2005, 2008, 2012 , IBM DB2, Oracle 10G, MS Access
• Reporting Tools : Reporting Services SSRS 2008/2005
• ModellingTools : SQL Server Analysis Server 2008 SSAS
• ETLTools : Microsoft Integration Services SSIS 2008/2005 , DTS
• Server Scripting : ASP, PHP, JSP, VBScript
• DataMiningModels : Classification, Association Rule Mining, Clustering.
• Web Portal Technologies : HTML, Photoshop, SharePoint, Visual Studio, MS Front Page,
• ASP.NET, HTML, XML, Web Services
• Operating Systems : Windows XP/7/8 , Windows Server 2008/2003, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI T-SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in design and architecture of the entire project flow and integration with third party tools. Interfaced with Business in understanding the present functionality of Planner Reports and defining the phases in which the development would be done
• Experience in development of extracting, transforming and loading ETL , maintain and support the enterprise data warehouse system and corresponding marts
• Created sophisticated SQL Server database to responsively handle complex queries triggers, stored procedures, views , functions
• Experience in ACTIVE-X script tasks for file verification, e-mail notifications and data transformation tasks in DTS for logging records and future Agent Term Dates drop
• Creates technical specifications, test plans and test data to support ETL processes
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS packages before migration, scheduling jobs for DTS packages
• Experienced in DTS Package migration using Migration Wizard and manual upgrade
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Used various transformations like Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of LOAD processes
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS packages before migration, scheduling jobs for DTS packages
• Experience with Snapshot Replication from DB2 to SQL Server 2000 database
• Worked on SSRS to generate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2005
• Developed OLAP cubes using SSAS SQL Server Analysis Services and calculate the metrics that were revealed in the functional analysis

Environment: SQL Server 2012/2008r2/2005, SSRS, SSIS, SSAS, Visual SourceSafe, Visual Source Safe, DTS, OLAP, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory and Windows XP platform, .NET 2.0, DB2 Main-Frame , VB Script, MS Visio, Crystal Reports 9/10.

Confidential

SQL Server /SSRS/SSIS Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL , Analytics and Reporting needs
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Created Packages using Complex Store Procedures and TSQL queries
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party tools like Control m
• Deployed Packages on both File System and SQL Server MSDB Using bat files, dtexec Utility and Import Export Wizard
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
• Configured, Installed, Administered Reporting Services 2005/2008
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Developed Cubes using SQL Analysis Services SSAS and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions
• Deployed reports across Test, Development and Production Environments
• Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level
• Involved in Trouble Shooting Complex Reports
• Created Large Number of Report Models for users to create their own reports
• Involved in code reviews, change control and auditing procedures

Environment: SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Business Intelligence Development Studio BIDS , MS Excel, Visual Source Safe VSS , Windows XP, Crystal Reports, Oracle9i, VBScript

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in supporting the BI Integration and Design, Design, develop and support high-profile corporate internal Websites LCAWeb, OneLCA, OneNoteGateway, HRWeb and MSW
• Wrote user requirement documents and translated functional requirement into technical specifications for the ETL and Reporting Systems
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Indexes and various other database objects
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles
• Responsible for optimizing T-SQL stored procedures/queries using execution plans, DMFs and DMVs
• Created and scheduled SSIS packages to pull data from various data sources like Excel Spreadsheets, Flat File and import into SQL Server and vice versa
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task and different data flow tasks
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and scripting components
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Created large Enterprise reports for various Business functionalities using SSRS 2008/2005 for various business applications
• Configured a Reporting Services SSRS 2008R2 for SharePoint 2010 using Reporting Services Configuration wizard
• Involved in upgrade the SharePoint content Database from SqlServer2005 to SqlServer2008
• Developed Complex SSRS Reports involving Sub Reports using new SSRS 2008 features like Tablix Reports, Charts and Graphs
• Good Hand on Resolving complex issues and Error Handling in SSIS for handling Delta load changes
• Handling Initial and Delta loads and processing Cubes Star Schema across all environments.
• Adhere to change control policies and procedures

Environment: SQL Server 2005/2008, Oracle 11i/10G,MS-Access,S Windows Server 2008/2003, ASP.NET, C , VB.NET, ASP.NET, VB Script, ASP, MTS, EXCEL, Visio, Fiddler, CSS, SSIS,SSRS, PPS2010, BIDS, Erwin

Confidential

SQL Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program
• Optimized SQL queries for efficiency and the front-end developer with their queries and procedures
• Migrated access objects to SQL Server 7.0
• Created Tables, Indexes and Constraints
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL
• Configured and monitored database application
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports
• Designed and implemented several complex reports and administration modules
• Defined stored procedures for module integrity and application
• Wrote database triggers in T-SQL to check the referential integrity of the database
• Designed VB forms using the forms and crystal reports were made for business reporting purpose
• Involved in performance tuning of the database and T-SQL queries using Execution Plan

Environment: SQL server 7.0, Visual Basic 6.0, Win NT, Crystal Reports 8.0 and MS Visio professional

Confidential

Programmer Trainee

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance
• Coded Stored Procedures, functions and triggers at high level
• Fine Tuned the SQL queries using hints for maximum efficiency and performance
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Participated in User Acceptance Testing for different modules
• Implementing user training and providing technical support
• Prepared proper backup and recovery plans
• DBA activities like creating users, roles and granting and revoking privileges
• Merging data into a single server for achieving better control, consistency security of data
• Designed the Logical and Physical design of database for projects on basis of user requirements

Environment: Windows 2000 Server, MS SQL Server 2000, T-SQL, SQL Query Analyzer, Profiler