SUMMARY

• Over 5 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL,SQL SERVER, UNIX & OLAP.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, temporary tables, views, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Excellent hands - on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Very good experience with installation, configuration and migration across different versions of SQL Server 2005/ 2008/ 2008 R2/ 2012.
• Experience in optimizing the queries by creating various clustered, non-clustered indexesand indexed views.
• Experience in creating jobs, SQL Mail Agent, Alerts and scheduledDTS and SSIS Packages.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, Bulk Copy Program(BCP).
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLTP databases.
• Created dashboards consisting of grids, charts and reports in Performance Point to detail the costs.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Provided 24x7 Support to PRODUCTION jobs with OFFSHORE and ON SITE Teams.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzingcubes and dimensions.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in Service Broker, Replication data distribution tools
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Good understanding ofRetail,Health careandFinancial Industry
• Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in trouble shooting database issues.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.Experience in 24X7 production support, ETL executions and resolving root causes.

TECHNICAL SKILLS

Operating Systems: Windows Vista /XP/NT/2000/98/95, Windows sever 2003, Unix, Linux

Languages: C, PL/SQL, T-SQL, XHTML, Perl, PHP,Java Script, C# .NET

Databases: SQL Server 2012/2008R2/2008/2005,MySQL, Oracle, MS-Access

Database Tools: SQL Server Management Studio, SSIS, SSAS, SSRS, DTS, BCP, Business Intelligence Studio, Enterprise Manager, Query Analyzer, SQL Profiler, crystal reports and Toad for oracle, Informatica Power Center 9.x,8.x, Data stage 8.1/8.0/7.5/7. x, TOAD, IBM Cognos

Other Tools: Erwin, Microsoft Visual Studio 2003/2005/2008/2010 , Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, AR

MS SQL BI Developer

Responsibilities:

• Worked on T-SQLprogramming, storedprocedures, user-definedfunctions, cursors, viewssetup and management of linked servers to Non-SQL-Server databases.
• Worked with TechnicalArchitects and Databaseanalysts for the Design of Summary tables required for efficient Report Design.
• CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports with error description.
• DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Worked as On CallSupport Person to monitor the PRODUCTION Jobs that run in Monthly schedules.
• Deployed SSISpackages and Reports to Production Servers.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Worked on both the Project and Package Deployment models.
• Regression tested and implemented first in Dev and QA environment.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Developed some scripts in C#.Net used in ETL Process that works as transformation.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2012/2008R2/2008, SQL Server Reporting Services (SSRS 2010/2008R2/2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, Informatica, MDX, Shell Scripting.

Confidential

SQL Server

Responsibilities:

• 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.
• CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports with error description.
• DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Developed some scripts in C#.Net used in ETL Process that works as transformation.
• ConfigureSSISPackage for run time Parameters and Configuration file.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Used variousSSIStaskssuch asConditional Split, Derived Column, which were used forData Scrubbing, data validationchecksduring Staging, before loading the data into theData warehouse.
• Developed an automated report subscription process usingSSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• ImplementedType 2Slowly Changing Dimensionto maintain Dimension History.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Reporting Services (SSRS 2008R2/2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin.