SUMMARY

• Over 7 years of IT experience in Analysis, Design, Development and Administering Client/Server application using various reporting tools like SAP BO 4.0, MSBI 2008/2005 and IBM Cognos
• Trained in DW/BI Concepts (OLTP & OLAP) and Databases (Oracle, SQL Server)
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Explored and self - taught dashboard tools like Xcelsius and Tableau by implementing proof of concepts and developing interactive and comprehensive dashboards.
• Proficient in T-SQL programming on implementing Stored Procedures, Functions, Constraints, Joins, Keys, Indexes, Views, Triggers, Data Integrity.
• Have good command on Entity Relationship Diagram and Database Normalization.
• Worked around with the scheduling property of various reporting tools and implemented them in BO, Cognos and SSRS.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Worked with multiple data providers, built data marts, maintained the universe repository and managed the WEBI users and connections.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Experience in designing SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Proficient in Dimensional Modeling and creating star and snowflake schema cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Developed reports in various formats like Table format and Matrix format Reporting services.
• Created Ad-Hoc Reports, Cross-tab Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS 2013.
• Developed SSRS 2013 reports by combining various databases like Oracle, Excel and SQL Server 2012 and building combined queries.
• Familiar in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2008 R2.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Vast experience in handling ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Experience in developing dashboards using Qlikview.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports in SSRS 2008.
• Instrumental in establishing the business logic and dataflow for new projects and was actively involved from the presales stage, estimating the cost and resources for each module.

TECHNICAL SKILLS

Databases: Oracle 11g, MySQL, Microsoft SQL Server 2012, Microsoft Access.

SQL Server Tools: MS SSIS 2013, MS SSAS 2013, MS SSRS 2013, SQL Server 2005 Management Studio, SQL Server Business Intelligence Studio.

Tools: Microsoft Visual Studio 2013/2008/2005.

Reporting Tools: Business Objects Enterprise XI 3.1, SAP Business Objects BI 4.0, Crystal Reports for Enterprise, Microsoft SSRS 2013 (SQL Server Reporting Services), OBIEE, and IBM Cognos.

Dashboard Tools: Dashboard Design (Previously Xcelsius), Tableau, Zoho Reports

ETL Tools: Business Objects Data Services XI 3.2/4.0 (BODS), Informatica, Microsoft SSIS 2013 (SQL Server Integration Services)

Languages: Basic Java, Objective C, PHP, Cake PHP, SQL, PL/SQL, T-SQL.

Operating System: Mac OS X Yosemite, Windows 7, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

SSIS Team Lead

Responsibilities:

• Interacted with business users to collect business requirements and transformed them into logical and physical database designs.
• Developed prototypes using Tableau reporting tool to present it to the client pre-sales meeting.
• Estimated cost, time, resources and tools for the project.
• Created and maintained clearly Software Requirements Document as per clients needs.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Designed database schemas using Erwin and Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Suggested the use of SSIS 2013 for ETL functions.
• Planned the project sprints and assigned the deliverables in each sprint to my team of three BI developers.
• Created mapping parameters to be used in different mappings and to support SQL override.
• Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created traces using SQL Server Profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed Dimensional Modeling using SSAS packages for End-User and created Hierarchies in Dimensional Modeling.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Organized weekly update meetings with the team to access the projects and the team’s progress.
• Developed complex WEBI universes using advanced functionalities like Derived tables, Custom LOVs, and many more in SAP Business Objects Enterprise
• Improved report generation time by using Hierarchies, User Prompts, Filters, Variables, User Objects and Conditions in reports and also developed ad-hoc reports.
• Consolidated the reporting by designing client specific templates and grouping the subject areas together to satisfy the clients needs.
• Participated in the entire SDLC of the project and was instrumental in deploying the project in the clients machine.
• Developed a web application in C# to view the SSRS reports and provide a user-interface for the client to customize and display the reports.
• Assisted in maintenance of the project post-deployment and help in troubleshooting compatibility issues.

Environment: SQL Server (2008R2/2012), SAP BO 3.1, Erwin, Tableau, SSIS 2008/2012/2013 , SSAS, Visual Studio 2012

Confidential, Ann Arbor, MI

BI Lead Developer

Responsibilities:

• Met up with the Business Analysts to understand their requirements and provided suggestions on which ETL and Reporting tool to use for their project
• Designed ETL Design Document as per the requirements provided by the client
• Migrated their existing Oracle database to SQL Server 2008 and created a set of new tables and indexes to support their current architecture.
• Extracted and applied business logic to load data from flat files and SQL Server database to a Global Data Warehouse.
• Designed facts and dimension tables and worked around with different types of Slowly Changing Dimensions (SCD)
• Utilized SSIS 2013 (SQL Server Integration Services) to produce a Data Mart for reporting.
• Documented and managed the source-target mappings and applied the required transformation logics to it.
• Developed re-usable transformations and mappings to improve the overall efficiency of the ETL process
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Designed, developed and deployed reports in MS SQL Server environment using SSRS- 2005/2008/2013. Resolved loops and traps in the universe and created aliases wherever necessary
• Used interactive prompts in the universe as well as reports to involve the users in controlling the type of data displayed by the reports.
• Experience in working on Cube Structure optimization for MDX Query performance in SSAS 2013.
• Scheduled the reports using SQL Server Agent jobs to enable the SSIS packages to implement on a daily, weekly and nightly basis.
• Created users, user groups and categories and managed the administrative tasks as well.
• Developed test cases and performed unit testing on the reports
• Developed dashboards using Tableau and Dashboard Design every month to show the progress of the project and to highlight the important developments of various resources.
• Provided support and assistance with deployment and performance issues.
• Enhanced the existing C# application and deployed the reports onto it.

Environment: Erwin, OBIEE, SQL Server (2008R2/2012), SSIS 2013, SSRS 2012, Visual Studio 2013, SSAS 2013.

Confidential, Baltimore, MD

BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) R2 as assigned.
• Experienced in improving and sending the SSIS Packages from advancement server to generation server.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Involved in Report writing according to business requirement using SSRS.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS R2 Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Migrated SSRS 2008 reports into SSRS 2013 reports.
• Perform unit testing at different levels of the ETL.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing at various levels of the ETL.
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Involved in making various types of reports like plain reports, grid reports, sub-reports, penetrate down reports and so forth and conveyed them to the report administrator utilizing SSRS.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Extensively worked on OLAP cubes by creating and managing them in SSAS.
• Formatted the report layout for the requirement of the end users.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification
• Extensively used ER Studio and Erwin for data modeling the Star and Snowflake schema.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.

Environment: SQL Server 2008, SSIS 2013, SSAS 2013, Oracle, Erwin, Cognos 10.1, T-SQL, SSRS 2013

Confidential, NYC, NY

BI Developer

Responsibilities:

• Interacted with the users for requirements gathering and documented the Requirements Summary.
• Responsible for all ETL activities like data extraction, transformation, development and support for large data warehouses using SSIS 2013.
• Involved in creation of dimensions using STAR and SNOW FLAKE Schema using ERwin
• Pulling data on a daily basis from OLTP database to OLAP or staging database.
• Researched in-depth and helped to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Using PL/SQL stored procedures to automate some complex ETL functionalities.
• Applied performance tuning on mappings, targets and sources to increase the efficiency and performance.
• Used parameters on mappings to increase its usability.
• Extensively used SSIS 2013 for performing various ETL operations and to create sessions and workflows.
• Created stored procedures to truncate target data at run time.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Reviewed and developed data models and database designs with development teams
• Performed DBA tasks through Enterprise Manager, Query Analyzer, Import Export wizard
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.Worked with different databases ranging from Oracle 10g, SQL Server 2008 and MS Access.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.
• Created complex drill down, cross-tab and list reports using Cognos 10.1 report studio using functionalities like multipage reporting and conditional formatting.
• Modified the SQL queries in Report Studio manually to fine-tune complicated reports and to increase its performance.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Built UAT and Test environments using Production backups.

Environment: SQL Server 2008, SSIS 2013, SSAS 2013, Oracle, Erwin, Cognos 10.1, T-SQL

Confidential

BI Developer

Responsibilities:

• Involved in Pre-Sales, Planning, Estimating costs, Defining and Designing information focused around business necessities and gave documentation.
• Discussed, designed E-R Models and used it to develop Oracle databases.
• Created Database Objects like Tables, Views, Triggers, Rules, Defaults, client characterized information sorts and capacities in Oracle.
• Used PL/SQL stored procedures to extract, transform and load (ETL) existing information into BO.
• Experienced in migrating BO reports from BO 2008 to BO XI 3.1
• Experienced in building complex universes in BO using multiple inter-related queries in BO Universe Designer
• Perform unit testing at different levels of the ETL.
• Scheduled the reports to run on a Daily, Weekly and Monthly Basis
• Involved in making various types of reports like plain reports, grid reports, sub-reports, penetrate down reports and so forth and conveyed them to the report administrator utilizing BO
• Used advanced reporting functionalities like Drill, Ranking, Filters, Sections, Breaks and so on.
• Experience in coordinating multiple data sources to build one report in BO.
• Installed and implemented the configuration of Xcelsius’ QaaWs module, Live Office and Analytical dashboards.
• Monitored the business metrics by building complex dashboards using inputs from one of the BO data warehouses.
• Done execution tuning to improve the run time.
• Development of day-by-day, week-by-week and month-to-month framework support assignments, for example, database reinforcement, database performance check, indexing and contracting of databases and customary observing.

Environment: Oracle database, Oracle PL/SQL Stored Procedures, OLAP, T-SQL, MS Excel, Windows 2008, SAP Business Objects, Xcelsius.

Confidential

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Gathered the requirements from the client and estimated the cost, time and resources required to complete the project.
• Completed the Software Requirements Document as per the clients requirements.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Experience in deploying projects from development enviroment to test environment and subsequently to production server.
• Experience in using SCRUM methodology for planning, controlling and scheduling the post-production support activities.
• Analyzed and migrated reports developed in Cognos 8 to SAP Business Objects
• Created reports in SAP Business Objects with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Extract Transform Load (ETL) development using Informatica and Stored Procedures.
• Used references from various other ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Strong experience in using Informatica Power Center 8.6

Environment: Windows 2007 Server, SAP Business Objects, Informatica Power Center, Oracle 9i/10g, MS Access, T-SQL, PL/SQL, SQL, Erwin, ER Studio.