SUMMARY

• Business Intelligence(BI) Lead with 10 years of overall IT experience with experience of BI Reporting using OBIEE, SAP BO, Cognos, MicroStrategy, Tableau, SSIS with Database/Warehouse Analysis, Design, Development, Testing and Deploying Data Warehousing solutions using Microsoft Business Intelligence tools SQL Server Integration Services (2005/2008/2012/2014), Informatica, Datastage and OLAP cube development using SQL Server Analysis Services, Essbase along with Designer tools such as Rational Rose, Sybase Power designer and Microsoft Visio.
• Extensive experience in creating BI reports using OBIEE 11g, Tableau, Business Objects and experience on other tools like Cognos,MicroStrategy,ASP.net charts along with .net integration.
• Experience in creating, populating and maintaining Data marts using ETL Tools like SSIS. Thorough knowledge of Kimball and Inmon data warehousing approaches and strong exposure to warehousing data models like Star, Snow Flake and Constellation Schemas.
• Experience in designing and architecting the models using Sybase power designer and Microsoft Visio.
• Expertise in designing, developing, and deploying SSIS packages accessing various data sources like MS - Access, Excel, Oracle, My SQL, Flat file and SQL Server.
• Experience in Performance Tuning of BI Reports identifying and replacing database code to boost up the performance.
• Experience setting up and configuring and Scheduling BI ETL packages and BI reports to designated viewers and users.
• Knowledge and experience in implementing DB maintenance tasks including disaster recovery and high availability as part of backup DBA.
• Strong debugging and analytical skills solving real time issues using various features in most of the technologies listed.
• Strong exposure creating and scheduling jobs using SQL Server Agent.
• Very good knowledge of setting up of Archival/purging process of historical data as part of periodic maintenance.
• Excellent T-SQL programming skill like writing complicated Stored Procedures, functions using SQL Server 2005/2008/2012/2014 with T-SQL.
• Excellent experience in Performance monitoring and tuning using SQL Profiler, Query Analyser, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Good knowledge on Developing SSAS Cubes, Essbase Cubes, Aggregation, KPIs, Measures, Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge of working on different Software Development methodologies like Agile and Waterfall.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall and Agile

Data warehousing: Kimball and Inmon methodologies

ETL Tools: SQL Server Integration Services, Informatica

Databases: SQL Server 2000/2005/2008/2012/2014, Oracle 9i, MS Access

Tools: SQL plus, SSMS, BIDS, Data Tools, Toad

Languages: C#

BI &Reporting Tools: SSRS 2005/2008/2012, Crystal Reports 2008SAP Business Objects, XCelsius 2008, OBIEE 11G, Cognos, MicroStrategy, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Responsibilities:

• Host meetings with business users and understand business requirements.
• Analyse and understand the Business Intelligence dashboard and report requirements from the users.
• Create Logical Model of Data Marts using Dimensional Modelling Techniques addressing Business Intelligence reporting needs of different Line of Businesses.
• Developed adhoc queries on Oracle database and Tera Data.
• Schedule the ETL Jobs using Control M.
• Schedule the SSAS Cube load using Autosys.
• Set up the audit process to audit the ETL Jobs and send notifications to the DEV team on any data discrepancies.
• Provide the reporting solutions using power pivot or oracle discover.

Confidential

Business Intelligence Lead

Responsibilities:

• Host meetings with business users and understand business requirements.
• Analyse and understand the Business Intelligence dashboard and report requirements from the users.
• Create Logical Model of Data Marts using Dimensional Modelling Techniques addressing Business Intelligence reporting needs of different Line of Businesses.
• Developed and Deployed SSIS packages to Extract Transform Load (ETL) data from various data sources using SQL Server Integration Services 2005/2008/2012/2014.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs using SQL 2005 Business Intelligence Development Studio/SQL Server 2014 Data Tools.
• Design and create the supporting database objects like dimension and fact tables, procedures, views, triggers etc to SSIS packages.
• Set up and schedule SQL Server Agent Jobs to periodically load the Warehouse.
• Analyse and identify the bottlenecks in the performance of ETL Jobs and fine tune for optimum performance using SQL Server Query execution plans, profiler, Tuning Advisor.
• Set up the audit process to audit the ETL Jobs and send notifications to the DEV team on any data discrepancies.
• Set up the well-defined custom logging process to easily triage and debug the data loading issues.
• Monitor the ETL jobs and address the data loading failures or issues with-in the SLA’s defined.
• Finally follow SDLC agile or waterfall model to deploy the required BI Dashboards and Reports into production after passing UAT, QA testing.

Confidential

Business Intelligence Developer

Responsibilities:

• Project management reporting requirements.
• Planning, scheduling and Estimation.
• Task allocation & Progress monitoring.
• Escalation of issues/concerns.
• Perform study on complete data warehouse.
• Triaging the DWH concepts and data analysis implementations using various software technologies.
• Perform Code Development, code migration and code build.
• Managing the different stages of databases like stage, OLTP and OLAP models.
• Re-engineering Essbase cubes and SSAS cubes.
• Pulling the data from source using DTS and SSIS packages.
• Developing and delivering high performance reports using reporting tools as crystal reports, SSRS developed using .net technologies.
• Develop dashboards which show the graphical data of the summarized financial data models.
• Sending weekly automated reports to take management decisions.
• Generating monthly payslips for Employees.