SUMMARY:

• Over 8+ years of IT experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/server applications.
• Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services.
• Working knowledge of Extraction, Transformation and Loading (ETL) between homogenous and heterogeneous sources using SSIS packages.
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Working experience with OLTP and OLAP databases in MS SQL Server ( 2014/2012/2008 R2/2008/2005).
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Expertise increasing Databases, Tables, Cluster/Non - Cluster Index, Unique/Check Constraints, Functions, Views, Stored Procedures, Triggers.
• Expert in developing and modifying multidimensional Cubes in SQL Server Analysis Services.
• Hands on experience in Data Migration and Transformation from different file formats like Flat file, MS Excel and Oracle to SQL Server 2014/2012/2008 R2/2005/2000
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS)
• Expertise in creating drill down reports, parameterized reports and Ad-Hoc reports using SSRS (2012/2008R2/2008/2005).
• Excellent knowledge in creating custom specific and schedule reports using SSRS
• Proficient in the SSAS storage and partitions, aggregations, calculation of queries and developing reports using MDX and T-SQL.
• Expertise in modifying and developing multidimensional cubes using SQL Server Analysis Services (SSAS).
• Working knowledge in Creating tables, Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles using Transact SQL.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server (2012/2008R2/2008/2005).
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Experience in working with Normalization and DE normalization databases for reducing redundancies and dependencies.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Strong programming and excellent analytical skills besides competent experience in handling critical situations.

TECHNICAL SKILLS

Languages: C, C++, PL/SQL, T/SQL, HTML, Java Script, XML, VB.net, ASP.net

RDBMS: MS SQL Server 2000/2005/2008 , Oracle9i/10g, MS-Access

Testing Tools: Quick Test Professional (QTP), TestDirector, Quality Center.

Operating Systems: Windows2000/2003 Advanced Server, Windows NT, Windows XP, Vista, Windows 7

Databases: Oracle, MS SQL Server and MS Access, Rally, JIRA

Defect Tracking & Office Tools: VSS 6.0, MS-Office 2007, TFS, TortoiseSVN, Red Gate Source Control, JIRA, StarTeam, FogBugz, Team City

Other Tools: SSIS, SSAS, MS SQL Server Management studio, MS Visual Studio 2008, MS Visio, ER Studio

App/Webservers and other tools: HTML, XML, Web Logic Server, WebSphere, Soap UI, Web Services, Informatica.

Reporting Tools: SQL Server Reporting Services, Oracle Business Intelligence

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

SQL/BI Developer

Responsibilities:

• Actively involved in gathering requirements from Business Users, and converting them into system requirement specifications and creating detailed use-cases and design documents
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in the SSIS packages.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Developed Dynamic Report Engine for creating the customized reports in SSRS.
• Created custom and Ad hoc reports using SSRS.
• Generated different types of Reports like Tabular, Matrix, and Charts.
• Generated several drill down and drill through reports using SSRS.
• Maintained the consistency of data by performing data profiling and cleaning mechanisms, possible transformations and using variables.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Identified the Data Source and defining them to build the Data Source Views.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Involved in performance tuning of queries for query efficiency.
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Resolved and closed the Production tickets generated due to failure of daily incremental production jobs and provided on call support for Production issues.

Environment: MS SQL Server 2012/2008R2, SQL server integration services (SSIS)2012, Performance Monitor, Server Profiler SQL server reporting services (SSRS)2012, MS Office, Notepad++

Confidential, Minneapolis, MN

MS BI Developer/Support Analyst

Responsibilities:

• Collecting Business requirements from users and translated them as technical specs and designed documents for development.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse.
• Created SSIS package to load data from Excel File to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup including data validation checks during Staging, before loading the data into the Data warehouse.
• Configured files to deploy the SSIS packages across all environments.
• Used PowerShell to combine data from multiple sources.
• Created Stored Procedures involving multiple tables to apply different logics to the data as per business requirements and get the required outputs.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012.
• Generated Reports using Global Variables, Expressions and Functions.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL.
• Responsible for 24/7 Production support and fixing data issues raised by Business on timely Manner.

Environment: MS SQL Server 2012/2008R2, SQL server integration services (SSIS)2012, Performance Monitor, PowerShell, Server Profiler SQL server reporting services (SSRS)2012, JIRA, TSQL, MS Office, Notepad++

Confidential

MS BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Assisted in the design of star schema and snow flake schema
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files
• Modified existing SSIS packages to meet current business needs.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data marts.
• Created SSIS packages for Data Conversion using data conversion transformation
• Used PowerShell and T-SQL combining data from multiple sources.
• Wrote stored procedures to be used in the SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS package involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot.
• Worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Research on upgrading the SQL Server from 2008 to 2012
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspective using SSAS2008R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing
• Optimized queries using SQL Profiler and Database engine tuning advisor
• Used SQL Server Agent for scheduling jobs and alerts.
• Responsible for regression testing ETL jobs before test to production migration.
• Configuration and Deployment of all reports across various SDLC environments.

Environment: Teradata, SQL Server 2012/2008R2, SSRS, SSIS, T-SQL, PowerShell, Oracle 9i/10g, SQL * Profiler, SQL * Loader, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe, UNIX.

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server 2005 on development server for designing and testing

Environment: MS SQL Server 2005, SSIS, SSRS, DTS, SQL Management Studio, and SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler, and Crystal Reports.