SUMMARY

• Over 11+ years of experience in Business Intelligence and analytics with deep technical expertise in multiple technologies - SAP Business Object (BOBJ/BO), Tableau, Power BI, MicroStrategy, SAS, Power BI, Margin Minder (Salient Interactive miner), Informatica, SSIS, Snowflake, Oracle, Netezza and Teradata.
• Experience in implementing business intelligence solution across sales, marketing, operations, banking and finance, and managing the complete BI/Datawarehouse project with BI reporting, Database, ETL and analytics tools.
• Expertise in SAP Business Objects (BOBJ/BO) Web Intelligence, UDT, IDT, Webi Rich Client, Crystal Reports XI/2008, Dashboard Designer, CMC, CMS and CCM.
• Extensive Experience in universe and report development- tabular, cross tab, chart, graph and hyperlinked report in WEBI and Crystal report.
• Extensive experience on Cognos 10/11, Report Studio, Query Studio and Framework Model and administration.
• Extensive experience in BOBJ/BO/Cognos administration - created users, groups, publication, events, scheduling and migration of reports, BO disaster recovery and restoration.
• Experience on Tableau Desktop, Tableau Reader and Tableau Server, Build Tableau reports and visualization based on user requirements.
• Experience in Power BI - Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Well versed with the MicroStrategy product suite namely MicroStrategy Developer, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• Experience on Snowflake database, data and ETL job migration from Netezza to Snowflake.
• Extensive Experience in SAS Administration - SAS9.3/SAS9.4, worked on EG, SMC, Linux environment and take care of Hot Fix, License update, Security setup, code promotion, SAS DI Job and Macro development and support.
• Extensive experience in Salient Margin Minder administrator, ETL job development and support.
• Expertise on multiple databases oracle, Netezza, SQL server, Snowflake and Teradata. Created complex view, materialized view, function and procedure and expert in SQL for implementation of any complex logic.

TECHNICAL SKILLS

• Reporting Tools: SAP BOBJ/BO, WEBI, Crystal Reports, MicroStrategy, Cognos 10/11, Tableau, Power BI, and Salient Margin Minder
• ETL Tools: Informatica PowerCenter, SQL Server Integration Services (SSIS), Business Objects Data Services (BODS)
• Database: Oracle, Netezza, Snowflake, Teradata, SQL Server.
• Languages: English (Write & Read & Speak fluently)

PROFESSIONAL EXPERIENCE

Confidential

Cognos reports development and administrator

Responsibilities:

• Working as a Tech Lead on BI reporting, ETL tools and taking care of development and production support.
• Meeting with business to gather, review and validate the requirement for new development.
• Created different types of canned reports - tabular, cross tab, chart, graph and hyperlinked report.
• Created profiles, publications, events, users and groups. Worked on movement and migration of reports.
• Scheduled the reports on daily, weekly, monthly, quarterly and yearly basis with and without event and using notification.
• Create different types of complex database views to meet the customer requirement.
• Created multiple SSIS job using all transaction and scheduling in production using Active Batch.
• Took care of Production issues, analysed different types of job failures and data issues.
• Analysing and back tracking data issue reported by business users in Reports to database, ETL job and source file and fixing the issue.

Environment: Cognos 10.2,11, Netezza, Power BI, Linux, Snowflake, SSIS, Service-Now, MS-Excel and Windows XP.

Confidential

Tableau, MicroStrategy Developer and administrator

Responsibilities:

• Worked as a Tech Lead on BI reporting, ETL tools and took care of development and production support.
• Worked on MicroStrategy Developer and administrator and took care of all business requirements.
• Designed and developed reports in MicroStrategy and Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Created different types of canned reports - visualization, tabular, cross tab, chart, graph and hyperlinked report.
• Created profiles, publications, events, users and groups. Worked on movement and migration of reports.
• Worked in oracle and Created view, materialized view, procedure and function. Restored the deleted users and reports after restoring the CMS and FRS backup.
• Took care of Production issues, analysed different types of job failures and data issues.

Environment: MicroStrategy, Tableau, Oracle,BODS, Unix, Service Now MS-Excel and Windows XP.

Confidential

SAP Business Object Development and Administrator

Responsibilities:

• Worked as BO developer and administrator.
• Designed and developed universe and reports.
• Created different types of canned reports - tabular, cross tab, chart, graph and hyperlinked report in WEBI and Crystal report.
• Created profiles, publications, events, users and groups. Worked on movement and migration of reports and universe and server management.
• Scheduled the reports on daily, weekly, monthly, quarterly and yearly basis with and without event and using notification.
• Worked in oracle and Created view, materialized view, procedure and function. Restored the deleted users and reports after restoring the CMS and FRS backup.
• Extensively worked on BODS/BODI Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Worked on SAS administration and took care of SAS license update, Hot Fix, code promotion, security tasks and resolve all type of SAS platform issue.
• Take care of development and support of SAS Di job and Macro.
• Installed and tested hot fixes for SAS 9.3 and SAS 9.4.
• Attend meeting with SAS Users in order to resolve their day-to-day SAS issues/special requests
• Coordinate with the users and SAS support in reporting any bugs or resolving any issues
• Supported the SAS environment end to end, all type of platform issue.

Environment: SAP BI4.1 SP6, SAS 9.3, SAS 9.4, Teradata, DataStage, BODS, HANA, IBM Tivoli TWS, IBM Zeke Scheduler, Service Now MS-Excel and Windows XP.

Confidential

SAP Business Object Development and Administrator.

Responsibilities:

• Worked as BI Lead and took care of BO/BOBJ and Informatica development/administration.
• Designed and developed many universes using all functionality and best practice.
• Created different types of canned reports - tabular, cross tab, chart, graph and hyperlinked report in WEBI.
• Created profiles, publications, events, users and groups. Worked on movement and migration of reports and universe and server management.
• Scheduled the reports on daily, weekly, monthly, quarterly and yearly basis with and without event and using notification.
• Worked on Informatica and created many ETL jobs to load data from various sources.
• Developed Informatica mappings that perform Extraction, Transformation and load using various powercenter transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Expert in oracle, created view, materialized view, procedure and function.
• Worked on Teradata Created view, procedure, trigger, Collect Statistics, users.
• Worked on Erwin and data modeling.
• Worked on software estimation tool iEST.

Environment: SAP BO 3.1/4.0, Informatica, Teradata, Oracle, MS-Excel and Windows XP