SUMMARY

• Over 8 years of experience in data warehouse development (SQL, Stored Procedures, Indexes, ETL Development) with experience in MS BI tools such as SSMS / SSIS / SSAS / SSRS.
• Excellent understanding of relational and muti - dimensional data design and development techniques including star schema, snowflake schema, cube design and creation, MDX and others.
• Extensive experience in writing MDX Scripting and MDX Queries using Muti-Dimensional Expressions (MDX), mathematical formulas, and user-defined functions (UDFs).
• Experienced in working with Star/Snowflake Schema modeling to develop ROLAP/MOLAP/HOLAP Cubes using SQL Server Analysis Services.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers using SQL Servers.
• Expert in creating indexes, user defined functions, and common table expressions (CTEs) to facilitate efficient data manipulation and data consistency.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experienced in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, 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.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning adviser, and Dynamic management views.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server R2 and 2008R2 to 2012.
• Experience of Developing web application on Java/J2EE, JSP, Servlet, HTML, CSS, JavaScript
• Experience and knowledge of various Java/J2EE development and deployment environments
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005/2000
• Oracle 9i/10g/11g
• MS Access
• Business Intelligence Development Studio (BIDS)
• Qlikview
• SQL Profiler
• Enterprise Manager
• Query Analyzer
• MS SQL Server Integration Services
• DTS
• BCP (Bulk Copy Program)
• MS SQL Server Reporting Services
• Crystal Reports
• Performance Point Server 2007
• SharePoint
• MS SQL Server Analysis Services
• T-SQL
• PL/SQL
• C
• C++
• .NET
• JAVA
• VB Script
• VBA
• ERwin
• MS Visio
• Windows (NT/2000/XP/7/8)
• Microsoft Office
• HTML
• XML.

PROFESSIONAL EXPERIENCE

Confidential, Oak Brook, IL

Data Warehouse Analyst

Responsibilities:

• Enhance, maintain, and administer complex ETL processes using MS SQL Server 2008/2012 (SSIS)
• Enhance, maintain and support data and system architecture, schedule management, and expansion of the current environment
• Enhance, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements
• Manage and participate in the development, maintenance, and administration of the current Business Objects infrastructure
• Provide maintenance and production support for a self-service Business Intelligence environment
• Troubleshoot and fine tune existing Data Warehouse application and new BI reporting data
• Support the development of data integration efforts with the development team
• Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the Business Intelligence environments
• Evaluates existing subject areas stored in the data warehouse and provides assistance in incorporating it into a future enterprise model.
• Be able to define requirements, analyze data, design solutions, program, test, implement, and train end-users and fellow IT team members.

Environment: SQLServer2012, SQLServer2008 R2, SQLServer2005, SQL Server BI Development Studio (BIDS) 2012, SSIS, SSRS, Business Objects, ASP.Net, ADO.Net, Java, Javascript, DB2, Oracle 9i/10g/11g, ClearCase, Clear quest, Visual SourceSafe, T-SQL, MS Access, Microsoft Master Data Services (MDS) 2012, IIS 7, Windows Server. Sharepoint, Oracle for SQL Developer, TPS, Visual Source Safe, SSIS Package Searching Tool, IBM MQ Series

Confidential, Santa Clara, CA

MS SQL Server / BI Developer / SQL Architect

Responsibilities:

• Worked on data collection, data analysis, data cleaning, performance tuning, troubleshooting and debugging.
• Responsible for SharePoint designing which is including sites design, library design, layout modifying and roles distribution.
• Worked with Cognos and Clickview to create Dashboard and Charts base on end user requirements
• Excel Reports designing combines with SSAS cube and Power BI tools
• Dealt with dynamic data in Excel, UI design by Powerpivot and PowerView, which are including connection handling, slicer design, Charters design and Dashboard design.
• Responsible for data modeling, designing and developing data driven SQL Server database with data warehouse components.
• Working on designing time sensitive BI reports and schedule arrangement on SharePoint and report server.
• Involved in testing, bug fixing and documentation for the project.
• Worked with a DBA in creating complex Stored Procedures.
• Created multi-dimensional cubes using SSAS to support business reporting and forecasting process.
• Periodically running ETL to transfer data from Oracle to SQL.
• Writing queries in Oracle and SQL to tune up the tables
• Writing SQL queries for data verification and writing and calling variables and expressions on SSIS packages.
• Designed and tested packages to extract, transform and load data using (SSIS)
• Developed ETL Packages using SSIS to extract data from staging tables.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down, Drill through, Parameterized reports and Graphical presentations such as Charts and Dashboard type metrics.
• Created various reports SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting.
• Generating Excel report with PowerPivot add-in and various formulas

Environment: SQLServer2012, SQL Server BI Development Studio (BIDS) 2012, SSIS, SSRS, Crystal Report, ASP.Net, ADO.Net, Java, Javascript, Oracle 9i/10g/11g, ClearCase, Clear quest, Visual SourceSafe, Cognos, T-SQL, MS Access, Windows 7, Linux, Microsoft Master Data Services (MDS) 2012, IIS 7, Windows Server. Sharepoint, Oracle for SQL Developer

Confidential, Chicago, IL

MS SQL Server / BI Developer / SQL Architect

Responsibilities:

• Worked on data collection, data analysis, data cleaning, performance tuning, troubleshooting and debugging.
• Involved in testing, bug fixing and documentation for the project.
• Worked with a DBA in creating complex Stored Procedures.
• Wrote SQL queries for data verification and writing and calling variables and expressions on SSIS packages.
• Responsible for data modeling, designing and developing data driven SQL sever database with data warehouse components.
• Editing scripts by using VB.NET and C#.
• Wrote complex T-SQL queries and used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Interacted with the officers for understanding the system requirement.
• Designed and tested packages to extract, transform and load data using (SSIS)
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Wrote connecting codes to connect VB.Net, Java and C# to SQL.
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into destinations.
• Configured working environment on virtual machine.
• Generated parameters, sub report, drilldown, drilldown through, dynamic matrix, different charts, dashboard, KPI, tabular and pivot table using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012, IIS, report builder, report services configuration manager.
• Setting catches and snapshots on the server, ensuring security like distribute and change different security roles for users, scheduling the reports delivery to clients email or shared files.

Environment: SQLServer2012, SQL Server BI Development Studio (BIDS) 2012, SSIS, SSRS, Crystal Report, ASP.Net, ADO.Net, Java, Javascript, Oracle 9i/10g/11g, ClearCase, Clear quest, Visual SourceSafe, Cognos, T-SQL, MS Access, Windows 7, Linux, Microsoft Master Data Services (MDS) 2012, IIS 7, Windows Server.

Confidential, Paterson, NJ

MS SQL Server/BI Developer

Responsibilities:

• Worked in Database programming, server side programming and Client Server computing in multi-threaded software systems using Java technologies.
• Performed analysis of existing Java and PL/SQL logic to facilitate new development.
• Designed Data warehouse schema like star schema and snowflake by using Erwin
• Using Microsoft Master Data Services (MDS) 2012 to create model, entities, attribute and hierarchies.
• Muti-dimensional data design and development techniques including star schema, snowflake schema, cube design and creation
• Designing Snowflake and Star Schema Designs for the operational data.
• Involved in Designing cubes, calculations, KPI’s and deployed cubes in SSAS environment
• Designed multidimensional data modeling in conceptual, logical and physical levels
• Designed and tested packages to extract, transform and load data using (SSIS)
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Used ETL to implement the slowly changing dimension to maintain historical data in data warehouse.
• Writing connecting codes to connect VB.Net, Java and C# to SQL.
• Developing web application on Java/J2EE, JSP, Servlet, HTML, CSS, JavaScript
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Worked as a developer in creating complex Stored Procedures.
• Wrote complex T-SQL queries and used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Worked with system administrators to keep the database and reporting service environments are up to date and well maintained
• Generated parameters, sub report, drilldown, drilldown through, dynamic matrix, different charts, dashboard, KPI, tabular and pivot table using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012, IIS, report builder, report services configuration manager and Sharepoint designer.
• Setting catches and snapshots on the server, ensuring security like distribute and change different security roles for users, scheduling the reports delivery to clients email or shared files.
• Worked closely with the developers and testing team to resolve Bug Issues.

Environment: SQLServer2012, SQL Server BI Development Studio (BIDS) 2012, SSIS, SSRS, Crystal Report, ASP.Net, ADO.Net, Java, Javascript, Oracle 9i/10g/11g, ClearCase, Clear quest, Visual SourceSafe, Cognos, T-SQL, MS Access, Windows 7, Linux, Microsoft Master Data Services (MDS) 2012, IIS 7, Windows Server.

Confidential, Lake County, IN

MS SQL Server / BI Developer

Responsibilities:

• Involved in testing, bug fixing and documentation for the project.
• Interacted with the officers for understanding the system requirement.
• Designed data models, created ERD and database tables in SQL 2012.
• Created packages for bulk data migration using SSIS from MS Excel, flat files and XML, provided logging and error handling. Developed ETL Packages using SSIS to extract data from staging tables.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Conditional Split, Derived column in SSIS.
• Created various reports SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down, Drill through, Parameterized reports and Graphical presentations such as Charts and Dashboard type metrics.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services (SSAS).
• Created multi-dimensional cubes using SSAS to support business reporting and forecasting process.
• Involved in designing OLAP Cubes in SSAS environment using Snowflake/ and Star Schemas.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes.

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, SQL Profiler, Windows XP, Lotus Notes, Microsoft Word 2010, Visual Source Safe, .Net

Confidential, Lisle, IL

MS SQL Server/BI/ETL Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Designing Snowflake and Star Schema Designs for the operational data.
• Involved in Designing cubes, calculations, KPI’s and deployed cubes in SSAS environment
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.

Environment: MS SQL Server 2005/2008,Business Intelligence Studio, SQL Server Reporting Services, SSIS, TSQL, PL/SQL, SQL Profiler, Windows XP/ NT / 2000/2003, SQL Query Analyzer, SQL Profiler.

Confidential, DeKalb, IL

MS SQL Server/BI/ETL Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to AMS.
• Created functional specification and technical specification from BRD.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Involved in integration of the front end with the SQL Server back end.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Involved in unit testing of Store Procedure and UI as per requirement on different server (Dev, DIT, SIT).
• Developed Test Cases bases on Requirement Specifications and Design Documents.
• Created reports to retrieve data using Stored Procedures that accept parameters.

Environment: MS SQL Server 2005/2008 Enterprise Edition, MS SSRS 2008, MS SSIS 2008, Visual Studio 2008/2010, T-SQL, VB Script, MS Access, Query Analyzer, BCP, SQL Profiler, ASP.NET v4.0, Crystal Reports 9.0, IIS, Source Control System(TFS,VSTF), Windows 7, XML.

Confidential

MS SQL Server Developer

Responsibilities:

• Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Created Views to reduce database complexities for the end users.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Developing web application on Java, CSS, JavaScript

Environment: MS SQL Server 2005, T-SQL, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, MS Access, Crystal Reports 10/9, Visual Studio 2005.