SUMMARY

• Over 10 years of extensive experience in system analysis, design, development, and deployment of data warehouse/data modeling, database reporting and testing of data warehousing applications.
• Experienced and passionate about Business Intelligence and Data warehousing. Consistently delivered Business Intelligence solutions to various Clientele
• Strong work experience in database design, analysis, installation and configuration, backup & disaster recovery, troubleshooting, performance and advanced query tuning, development, testing and on call production support. Broad skill set in multiple technologies.
• Extensive experience in developing applications using SAP Business Objects Suite (Business Objects XI R2, Supervisor, Designer, Reporter, Web Intelligence, XCelsius, Dashboard Manager, SAP Business Information Warehouse and Crystal Reports).
• Expertise in highly intuitive web - based applications and Data warehousing reporting tools. Well versed in creating Metadata Structures, Ad-hoc, full & thin client reports.
• Diverse applications on variety of platforms and databases including Microsoft (Win 8.x/Server 2012 R2, Microsoft SQL Server 2012/2014), Unix (Solaris, HP), Linux (MySQL), Oracle (Database and Data warehouse).
• Strong foundations in SQL, PL/SQL, ETL Tools, Microsoft Power BI and Microsoft SQL Server Packages.
• Enjoyed opportunities of serving as a team project leader and project manager at Microsoft Corporation using fine-tuned multi-tasking skills to achieve desired results.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• A highly motivated, energetic individual and a team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

OS: UNIX (Solaris, Linux), Windows 7/8.x/Server 2012 R2

Databases: Oracle 11g/12c, MS SQL Server 2012/2014, MS Access.

ETL: Informatica, Power Center, Oracle Warehouse Builder & SQL*Loader

Reporting Tools: Business Objects XI, WEBI, Broad Cast Agent, Xcelsius, Microsoft Power BI, SSRS

Database Skills: Stored Procedures, Database Triggers, and Packages.

Languages: C, C++, C#, VC++, SQL, PL / SQL, PERL, Java

Design Tools: Erwin, Oracle Designer

GUI: Visual Studio 2013, Android Studio, Eclipse

Internet Tools: Applets, Servlets, HTML, JavaScript, VBScript, JSP, XML, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineering Lead/Manager (BI & DW)

Responsibilities:

• Managing a team of BI developers, testers and vendors working on Microsoft Performance point server 2007, SharePoint BI and Microsoft Power BI for Office 365
• Design/development and team lead for the existing BI framework to support high availability high transactional OLTP enterprise application systems.
• Working on the reporting infrastructure of one of the most important groups at Microsoft which relies on Business intelligence tools such as SSRS, SSIS to extract data for the higher management.
• Creating Adhoc reports using SSRS as well as MS-Excel by pointing to appropriate data sources.
• Managing the team which was involved in making changes to the existing extraction, transformation and loading logic which brings in data from a normalized Software Quality Management Data warehouse.
• Developed cubes which act as data sources for various reports used within the group and queried data from the multi-dimensional data warehouses using MDX.
• Writing Complex stored procedures using T-SQL that form the basis of the business logic underlying these reports.
• Involved in Physical, Logical and conceptual Data modeling of the OLTP data sources.
• Develop SSIS packages that load data from disparate Data sources such as XML,Blobs, SQL Server and Oracle.
• Implement error handling and logging in SSIS as well as at the database level.
• Deploy and support Performance point Dashboards that include different scorecards, KPIs and reports to provide cutting edge decision support data for the Analytics team within my current org.
• Also actively involved in project planning and estimation because we follow Agile development methodology and are supposed to follow the scrum planning and plan our development efforts for each sprint.

Environment: Microsoft BI Platform including PPS, SharePoint BI, Microsoft Power BI for Office 365, SQL Server Reporting, Analysis and Integration services, Excel PowerPivot, Business Scorecard Manager

Confidential

Senior BI Consultant/Developer

Responsibilities:

• Interacting with the end users for business requirements and creating the reporting design brief.
• Analyzing the universe design through the design document and documenting the analysis procedure.
• Created multiple universes, having summarized as well as detailed data.
• Setting up the universe parameters.
• Created Classes, Measured Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic while creating the universe.
• Resolving the universe issues like loops to remove cyclic dependencies between the tables and traps through aliases and contexts
• Checking on the universe integrity and refreshing the universe on regular basis to keep it updated with the changes in the database.
• Designed, developed, tested and maintained highly complex reports.
• Created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), used complex SQL queries and joins for reporting purposes.
• Used various reporting functionalities such as sectioning, filtering, Alerters, Breaks, Sorting, Ranking, slice and dice panel to create the reports and organizing data in them.
• Created variables at reporter module for creating the reports
• Used Free Hand SQL for creating some ad-hoc reports.
• Unit testing the reports and checking and resolving on the data issues in the reports.
• Tuning of the SQL queries for performance issues in the reports.
• Exporting universe to the repository.
• Performed the UAT testing with end users and supported the system testing and provided client support as needed.

Environment: Business Objects XI R2, WEBI, Infoview, Scheduler, Import Wizard, SQL Server 2000, T-SQL,Windows 2000 Server.