PROFESSIONAL SUMMARY:

• Over all 7+ years of experience in Telecom, Health, Banking and Retail domains as a Developer in SQL server, BI (SSIS, SSAS, SSRS) and Oracle.
• Experienced in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005, Oracle 10g, MS Access.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Good in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Hands on experience on T-SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experienced in Data Extraction, Transforming and Loading (ETL) to data warehouse databases, data mart databases using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and process SSAS cubes to store data to OLAP databases.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS and providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• Created and Configured Data Source & Data Source Views (Snow Flake and Star Schema), Dimensions, Cubes, Measures, Partitions, MDX Queries (SQL Server 2005) and SQL Server Analysis Services(SSAS) 2012/2008/2005 .
• Experience in developing custom reports and creating various types of reports like on demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and former Business Intelligence Development Studio (BIDS).
• Experience and knowledge in writing stored procedures for Transaction and Appraisal reports and developing reports using Crystal Reports 2008 and maintaining proper documentation of the reports for future reference.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in Query Optimization, and Performance Tuning using SQL Profiler and Index Tuning Wizard. Involved in Database Backup and recovery.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Good analytical and communication skills and ability to work independently with minimal supervision and perform as part of a team

TECHNICAL SKILLS:

Database: Database SQL Server 2012/2008 R2/2008/2005, Oracle 12c/11g/10g/9i/8i, MYSQL, MS Access.

Database Design/Modeling Tools: MS SQL Server Enterprise Manager, SQL Profiler, MS SQL Server Agent, SQL Profiler Database Engine Tuning Advisor (DTA), MS SQL Server Denali, MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Business Intelligence tools: MS Visual Studio (SSIS, SSRS, SSAS), Power BI, Crystal Reports XI/X/9/8, Informatica Power Center, OBIEE, Crystal Reports, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), ProClarity, Microsoft Office, Excel Power Pivot Excel Data Explorer, Tableau.

Statistical tools: IBM SPSS, Minitab, Microsoft Excel.

Programming/Scripting Languages: C, C++, C#, Java, PL/SQL, TSQL, Dynamic SQL, MDX, DAX, Shell Scripting, VB 6.0.

Productivity Applications: MS WORD, MS EXCEL, MS Project, MS Power Point, MS Visio, MS SharePoint Server(MOSS) 2007, MS Performance Point Server.

IT Processes: Software Development Life Cycle (SDLC), Project Management, Business Requirement Analysis, Kimball & Inmon, Waterfall and Agile Methodologies.

Operating System: Windows NT/ Vista//XP/98/95, Windows Server, LINUX, UNIX.

Web Technologies: HTML, DHTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

MS SQL BI Developer

Responsibilities:

• Analyzed Business Requirements Documents to get better understanding of the system both on technical and business perspectives
• Upgraded database tables from 2000 to SQL 2005 and SQL 2008, 2005/2008 to 2012 SQL environment.
• Created and optimized performance of various SQL scripts, TSQL scripts, views, Complex stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Assisting in transferring databases, including TempDB, to new servers using TSQL scripts
• Responsible for creating Databases and their backup and restore, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views
• Successfully created database diagrams and physical models for the project
• Involved in Performance Tuning and optimization in SQL Server 2012 using SQL Profiler and Data Loading and rebuilding Indexes and Tables as part of Performance Tuning Exercise. Also, Troubleshoot and diagnose customer issues, documenting recreation steps
• Creating and automating the regular Jobs using SQL Server Agent
• Involved in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent. Used Performance Monitor/Profiler to solve Dead Locks.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, Derived column using SQL Server Integration Services (SSIS) and schedule them as SQL Server Agent.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases. Created linked servers to fetch data from Oracle, DB2, MySQL.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Few times worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data. Used C#.NET, VB.NET for Script Task in SSIS
• Involved in developing Data Marts from Oracle Data Warehouse, to migrate the data from different sources into the databases using SSIS in generating customer profile reports
• Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play dimension in SSAS
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Involved in creating calculated members, named sets, and Identified Key Performance Indicators (KPI) for Business needs in SSAS 2010
• Partitioned Cubes for optimizing the performance of Query and reduce time.
• Wrote Parameterized Queries for generating Tabular reports, Parameterized and Cascading Parameterized reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Extensively used VB Script to pass multiple parameters for Stored Procedures, User Defined Table(UDF) to read and write database table.
• Converted crystal reports to SQL Server reports using SSRS 2010.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Involved in Project Management activities like Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling and Drafting remedy procedures

Environment: SQL server 2012, Windows 7 Ultimate, MS Office 2013, SQL Server Visual Studio 2010, Crystal Reports, Visual Studio.NET, C#.NET, VB.NET, MS Access 2013, MS Project 2013, XML, Oracle, DB2, MySQL, COSMOS, Tableau.

Confidential, Oklahoma City, OK

SQL Server/SSRS /SSIS/ Server Developer

Responsibilities:

• Worked with Business Analyst and System Analyst in gathering business requirements and specifications from different stakeholders.
• 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.
• Developed SSIS Packages to extract, load and transform data on daily, weekly and monthly basis using SQL Server Agent Jobs from SQL server to different files and external databases.
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging and Development.
• Created VB.Net Script for Data Flow and Error Handling using Script component in MSBI (SSIS).
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server
• Developed Dynamic and Static Stored Procedures and Queries to maintain central Database and store details of locations and consumer lines.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Extensively used SQL Server Reporting Services 2010 (SSRS) with relational and multidimensional data.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Designing and Deploying Tabular, Matrix, List and Chart reports with Drill Down, Interactive sort, Drop down menu option, Parameterized and Sub reports.
• Developed several 2010SQL Reporting Services (SSRS), with Visual Studio and supporting Stored Procedures. Defined report layouts including report parameters.
• Created parameterized, drill down in MS SQL environment using SSRS 2010.
• Received MS SharePoint 2010 application development training covering Visual Studio 2010, SharePoint Designer 2010
• Backup and restore databases.

Environment: MS SQL Server 2012, SSRS, SSIS, SSAS (2010), T-SQL, MS-Excel, XML, XSD, Windows XP/7 Ultimate, DB2, MS Access 2010, Oracle PPS, MOSS dashboards, SharePoint 2007.

Confidential, Richmond, VA

MSBI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system
• Created and maintained Business Use cases and System Use cases, Use Case diagrams, Flow Diagrams, Business Flow Diagrams, Activity diagrams and Sequence diagrams throughout the SLC
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, and XML to create and maintain a centralized data warehouse by using different transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, script components, and error handling.
• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007 and SharePoint.
• Deployed designed PPS dashboards and reports in MOSS site using PPS Dashboard Viewer Web Part for web-based access for multiple end users.
• Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Extracted data from various sources like SQL Server 2008R2, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Implemented various SSIS Transformations like Slowly Changing Dimension- SCDs type 2, Data Conversion, Derived Column, Lookup, Fuzzy Group, Multicast, etc.
• Fields are updated on time basis like day, month, quarter, year using SSIS packages.
• Monitored performance and optimization of SSIS packages for maximum efficiency.
• Actively monitored performances of queries and stored proc on SQL server using SQL Profiler and optimized it using Index Tuning Wizard

Environment: SQL Server 2008R2, SSRS, SSIS (2008), C#.NET, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer, Windows XP, Minitab, MOSS dashboards, SharePoint 2007, Windows XP/7 Ultimate, FTP, CSV, MS Excel.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences,
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions. packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, per the requirements in Oracle data warehousing.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Used Dynamic SQL programming technique to build and process SQL statements at run time.
• Developed PL/SQL scripts for Data cleansing. Developed UNIX shell scripts that help as a scheduler for data load.
• Used TOAD, PL/SQL developer tools for faster application development. Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 9i/10g, PL/SQL, TOAD, Oracle SQL Developer Data Modeler, Linux, Windows XP/7, Microsoft Office 2007, Minitab, Oracle Designer 2000, SQL*Plus, Erwin 4.1.

Confidential

SQL Server Developer

Responsibilities:

• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Actively involved in design of a new normalized data and De-normalized data.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Performed ETL operations on data from multiple input sources and loaded data into SQL Server.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Gather requirements and design of data warehouse and ETL development packages.
• Creation of complex procedures to Populate Dimension and Fact level data to retain all Dimensional and member level data to meet the Essbase requirement in SSAS service.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS)

Environment: Microsoft SQL Server Management Studio 2005, MS Visual Studio 2005(SSIS, SSAS, SSRS), DTS, MS excel 2007, T-SQL, Windows XP/7, MDX, C#.NET, XML, SQL Profiler, Team Foundation Server.