SUMMARY

• 16+ years of experience in Data warehouse and BI - design, development and maintenance
• Strong experience in BI Environment Transformations, requirement gathering, Data Modeling, Data warehouse design, metadata design, report development and performance optimization of business intelligence reports
• Extensive experience working with Executive team and developing Executive Dashboards
• 10+ years of implementing large-scale Data warehouse/BI projects
• 14+ years of Experience in various BI tools such as Tableau, Power BI, IBM Cognos Analytics, SSAS, SSRS
• 14+ years of ETL experience using various leading ETL Tools
• 14+ years of PL/SQL experience
• 4+ years of experience working, maintaining, scaling Cloud Data Solutions - AWS, GCP, Azure
• 4+ years of experience working Python Codes and API Extracts
• Experience creating BI Solutions for various ERP Systems, Oracle EBS, SAP, JDE
• Designed Data warehouse and Data-Marts to seamlessly integrate multiple ERP systems
• Proven expertise in creating critical, fast performing and Executive Friendly Dashboards
• Expertise in Relational Database Management System (RDBMS) and data modeling
• Provided extensive end user training and support

TECHNICAL SKILLS

BI Tools: Power BI, Tableau, SSAS, SSRS, Cognos Analytics, OBIEE, SAS

Data Integration: Python, Nifi, Informatica, SSIS, IBM Infosphere 11 Suit

Cloud BigData: AWS, Google Cloud Platform, Azure Cloud

EBS Systems: Oracle EBS, SAP, JDE

Data Modeling Tools: Oracle Data Modeler, Erwin

Databases: AWS Redshift, Snowflake, Teradata, Netezza, Vertica, Oracle 12/11/10, SQL server 2016/2012/2008 , MS Access, DB2

Database Query Tools: TOAD, SQL Navigator, SQL Query Analyzer, WINSQL, SQL Developer

Programming Skills: Python, PL/SQL, VB.Net, ASP.Net, JavaScript, XML, DHTML, C

PROFESSIONAL EXPERIENCE

Confidential

BI and Data Integration Solution Architect

Environment: Power BI, Google Cloud Platform, MySQL, BigQuery, Nifi Dataflow, Python

Responsibilities:

• Interacted with Executive and Business Product Owners to gather requirements
• Designed and developed Executive Dashboards for global leaders
• Architected Dashboards making it easy to drive specific decisions
• Design Contract performance reports with Row Level Security to ensure compliance and privacy
• Architected the Data Pond for the Contracts Management and Commercial Center teams
• Developed ETL processes from various source systems to enable integrated process dashboards
• Designed the data models to make analytics user friendly
• Created dashboards solutions with end to end analysis by integrating data from various business processes
• Developed and established BI Standards to be used by all users and locations globally

Confidential

BI and Data Integration Solution Architect

Environment: AWS Redshift, Teradata, IBM Analytic 11, Power BI, Informatica

Responsibilities:

• Architected Semantic layer for effectively implementing the self-serve analytics
• Designed and implemented Dynamic Cubes for self-serve users
• Designed the Metadata Model to make analytics user friendly
• Led the project to design and develop Executive Dashboards
• Trained users in report and analytics development
• Successfully on-boarded power users from each department to the self-serve environment
• Improving the overall user experience and business enablement

Confidential

Datawarehouse Solution Architect

Environment: Tableau, AWS Redshift, IBM Infosphere 11

Responsibilities:

• Designed an integrated data warehouse solution for financial reporting
• Led the team to develop the Data warehouse solution in IBM Infosphere
• Designed and implemented Executive Dashboards using Tableau
• Designed Quarterly Scorecards for key ridership and financials metrics
• Established data governance rules and procedures
• Established reporting Standards and best practices for the team

Confidential

Data Integration Manager

Environment: Tableau, IBM Analytics, Informatica 9.6,Sql Server 2012, SSIS, Oracle Apps 11i (EBS)

Responsibilities:

• Architected Data warehouse to seamlessly consolidate data from various ERP systems
• Designed Executive Dashboards in Tableau using Active reports
• Designed Scorecard consolidating various key metrics into a Monthly Summary book for the Executive Team
• Developed Road map for unifying distributed BI environments from disparate business units of NOV into a centralized BI System.

Confidential

BI Team Lead

Environment: SSRS, SSAS, IBM Cognos, Transformer, Sql Server 2005,MS Access 2003/2000, Oracle 11g/10g/9i

Responsibilities:

• Responsible for assigning tasks, conducting code review, providing technical expertise and reviewing progresses for the team
• Successfully led Cognos Pilot, Deal-Info and Pearl and Executive Dashboard Projects
• Responsible for gathering requirements from business users and executive management
• Conducted root analysis, designed interface and spear headed collaboration across teams for Executive Dashboard project
• Designed Dashboards to provide for senior executives with a company oversight with ability to drill to department level details and integrated the same into the company intranet
• Architected designs and developed OLAP models to support business analysis
• As SME designed an enterprise wide BI model by analyzing existing MS Access reports and converting them using Cognos BI Suite to achieve a central reporting environment
• Assured implementation of industry best practices

Confidential

Senior Business Solution Analyst

Environment: Cognos EP series 7.3/7.1 (Impromptu, PowerPlay, Impromptu Web Reports (IWR), Upfront, Transformer, Access Manager), Oracle 9i, MS Access 2003, Windows Server 2003

Responsibilities:

• Led the report development team for the project
• Involved in the entire project life cycle from evaluation of business requirements, installation of Cognos, development of reports and UAT
• Rendered extensive analytical and technical acumen and research capabilities, in the areas of report management, data procurement, and project development
• Guided discussions with the senior management to gather business requirements
• Created reports for Executive Leadership Team, corporate and regional managers
• Optimized the cube performance and the report response time