SUMMARY:

• 10 years of successful IT consulting experience working in all phases of data warehouse development lifecycle (SDLC), from gathering Business Requirements, Data Analysis, Data Blending, Data Prep, Database Design, Development, Migration, Testing, Implementations and support
• Extensive Experience in On site - Off shore model Development
• Experience in dimensional data modeling and developed Enterprise Master Data model to load data from multiple transactional systems
• Perform reverse engineering of physical data models from databases and SQL Scripts
• Experience in establishing an enterprise-wide data governance & Master Data Management framework, with a focus on improving data quality & security by creating new or upgrading existing organizational policies and standards
• Experience in providing technical guidance in the installation, configuration, upgrades and implementation of various ETL & BI products
• Extensive experience in writing queries, stored procedures, functions, packages & triggers using SQL,T SQL and PL/SQL
• Professional experience in the MS BI stack: Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Worked POC on Data Visualization & Virtualization products with Power BI & RedHat
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and Scheduled data refresh as per business need.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports
• Designed and developed complex KPI’s including Usage Tracking in OBIEE
• Data Mining - Analyzed Student assessment data and predict their achievement and calculate school grade Projections using SPSS analytics tool
• Implemented OBIEE Multi User Development and administering Power BI, OBIEE & Cognos
• Extensive experience in BI Modeling/Report Authoring using Cognos 11 (Report Studio, Analysis Studio, Query Studio, Framework Manager, Analysis Studio, Workspace and OLAP Cube
• Migrating data from Cloud environment to on premise database and designing Operation Data Source as per Business Requirement. Experience in Hybrid Cloud environment
• Expertise in Business requirements study, system analysis, technical design & development, test plans preparation, unit testing, system integration testing and documentation
• Identify root causes of problems. Analyzing both, the long and short-term effect of solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines

TECHNICAL SKILLS:

ETL Tools: SQL*Loader, Oracle Warehouse Builder 9.x, 10.x, 11.1.0.3, 11.2.0.3, Informatica 7.x/8.x, ODI 12c,Oracle Golden gate, SSIS

Reporting Tools: Oracle Discover, Business Intelligence (OBIEE), BI Publisher, Cognos 11.0.10, SSRS, SSAS, Power BI, Tableau, Data Visualization, R, IBM SPSS

Databases: Oracle 9iR2/10g/11g/12C, SQL Server 2000/2005/2008 R2/2016, MS Access

Data Modelling: Erwin,SQL Data Modeler, IBM Info sphere

OS: UNIX,WINDOWS SERVER, XP, VISTA, NT/2000/98/95, Red Hat LINUX (5.6/6.4)

Applications: MS Office suite and MS Visio, SharePoint, project, PowerShell, Oracle APEX

Cloud Platforms : MS Azure, Oracle Cloud

Other Tools: MS Project, Visual Studio, HP Quality Center, APEX,SAP HR

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Data Warehouse & Power BI Lead

Responsibilities:

• Lead the EDW team including the business intelligence, data warehousing, metadata management, enterprise data integration & database modeling
• Designed LMS data model using Info sphere in EDW to load canvas data
• Optimize and update Logical & Physical Data Models to support new and existing DW projects
• Worked on Integrating skyward Data into data warehouse using ETL tools like SSIS and OWB
• Worked with BPO on business requirements and preparing technical design document to convert data from OLTP to Data warehouse
• Worked with vendor and BPO on different data integration/conversion issues and developed long term solutions without affecting core process
• Worked on both live and import data to Power BI for creating reports and Power BI gateway to Schedule daily job to refresh data
• Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data formatting.
• Implemented DAX functions for various fact calculations for efficient data visualization in Power BI
• Created SSIS Packages to export data from SQL server tables to flat files like excel, csv and other delimited files and vice versa.
• Update and Create student reports using SSRS like Drill-down reports, Drill-Through Reports,
• Parameterized Reports, Report Models and ad-hoc reports and Dashboards.
• Developing, deploying, monitoring and scheduling SSIS Packages on daily, weekly and monthly basis in development, staging and production environments.
• Maintaining SQL Scripts, SSIS packages and SSRS reports within Team Foundation Server (TFS).
• Implemented Student Information System ODS for adhoc reporting and data mining
• Oversees team day to day activities like code review, Year End Processing and Production Support for Database/BI Application

Confidential, Orlando, FL

Data Warehouse & BI Architect

Responsibilities:

• Engage with users and understanding strategies, objectives and needs, both functional and technical
• Lead Data warehouse team in designing Data dictionary template for Data Integration project
• Worked on creating Source to Target mapping reports and helped users to understand BI dependencies
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Created procedure for Data extracts and automated them using Crontab
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services (SSAS).
• Worked on creating DataMart’s for different assessments data to support Teacher Incentive Fund project
• Migrated different projects into new environment deployed and ran successfully
• Lead BI team in Upgrading OBIEE Application to 11.1.1.7.15
• Worked on Existing Dimensions and Facts to design Data marts for OBIEE Reports
• Created external tables for flat files and analyze different source systems to get loaded into Data Mart
• Monitoring schedules production jobs and weekend on call support
• Worked on OBIEE reports performance issues and fixing them analyzing queries or changing application settings

Confidential, Orlando, FL

Sr Data Warehouse & BI Developer

Responsibilities:

• Oracle Warehouse Builder upgrade from 11g R1 to 11g R2
• Worked on multiple projects simultaneously with analyzing complex requirements to determine the best ETL process to support BI applications
• Worked on design and integrating sub systems like Access Student to EDW
• Worked on creating complex procedures to create extract files for vendors and automated process using shell script worked on various Data Extracts for Digital Curriculum Department
• Designed and Implemented Data Warehouse/ODS integrating data from Finance, HR and Student Systems into Fact and Dimension tables to feed multiple cubes
• Worked closely with Users and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to BI Repository
• Security management for users and distribution groups using the various authentication systems such as LDAP authentication
• Created and used Repository Variables, Session Variables, Presentation Variables and Initialization Blocks in BI Admin tool

Confidential, Windsor, CT

Sr DataWarehouse & BI Developer

Responsibilities:

• Analysis of source system, Design, Develop and Implementation of new data marts in the warehouse
• OWB upgrade from 9i to 11g R1
• On call production support and Maintenance for existing functionality of Data warehouse
• Coordinating with Off Shore Team regarding OWB upgrade and Enhancements
• Extensively worked with APPS team in designing Data Model for OBIEE Report requirements
• Analyzing source systems to get transactional data in Data Warehouse
• Developed and mappings through OWB design center and scheduled the mappings and process flow using Control M scheduler
• Worked with OBIEE team to develop the BMM layer according to requirements
• Maintained Business Intelligence portal for Executive users
• Designed different subject area in OBIEE and created Answers and Dashboards according to Business Requirements

Confidential, NY

Business Solutions Consultant

Responsibilities:

• Analysis of source system, Design, Develop and Implementation of new data marts in the warehouse
• Understanding & Maintenance of the existing functionality of the warehouse
• OWB upgrade and patching from Release 1 to Release 2 (10.1.0.4 to 10.2.0.3)
• Developed and scheduled ETL mappings and process flows using OWB 10g Release 2 for all the functional areas from source systems to staging and staging to the data marts.
• Developed Process Flows using OWB and deployed to the workflow manger. Monitored the process flows using Oracle Workflow monitor
• Monitoring the Audit details using Repository Browser and scheduled purging the audit data frequently
• Developed complex views involving Analytic Functions, grouping sets etc based on requirements.
• Involved in designing and developing the RPD in OBIEE at all the levels of physical, business and presentation models
• Designed and Implemented OBIEE Subject Areas to full fill the business needs and imported the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Developed several reports and dashboards using Oracle Business Intelligence tools (OBIEE) for different Key Performance Indicators (KPI’s) and metrics
• Configured iBots in Oracle Delivers to manage the schedules, dependencies and notifications etc
• Developed Materialized Views to replicate the data from distinct sources and improve the performance
• Performance tuning of the Oracle SQL queries and database tuning
• Create Interactive and Master/Detail Reports using Oracle APEX for Legacy Data

Confidential, Basking Ridge, NJ

Data Warehouse & BI Developer

Responsibilities:

• Managed off shore team in completing tasks and production support
• Responsibilities included collecting user requirements, performing feasibility analysis, prepared technical specifications for off shore team
• Extensively used PL/SQL in Writing database packages, Stored Procedures and Triggers in Oracle 11g Database.
• Worked with Data Architect in Data Modeling, Physical database design, Forms design and development, Data conversion, Performance analysis and Tuning
• Developing Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS)
• Developed SQL*Loader scripts, Oracle Warehouse Builder mappings to load XML files, Flat files and Excel Files into tables.
• Developed detailed ETL Plan for loading the staging area from the Oracle database and then from Staging area to the Data Mart.
• Used Reverse Engineering in Erwin feature to design Data Model from Database
• Worked on Migrating Legacy systems data to Oracle Database
• Extensively worked on developing simple and complex reports on Cognos Report Studio
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
• Involved in testing and quality assurance of all the reports before delivering them to the end users

Confidential, NY

Data Warehouse Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created Informatica workflows and mappings to load data into Data Warehouse.
• Created cubes, dimensions, hierarchies, mappings and complex mapplets using Informatica PowerCenter designer
• Performance Tuning, Query tuning, Database tuning using explain plan, Used Dynamic SQL to improve performance of queries.
• Worked Closely with DBA to resolve performance issues
• Created Oracle PL/SQL Packages, Procedures, Functions and Triggers to load data into ODS
• Created ad-hoc queries and stored procedures for generating reports.
• Developed modules in Shell scripts to send emails, FTP, archive
• Worked on shell scripts to automate data integration process