SUMMARY

• Accomplished IT leader specialized in Business Intelligence (BI), Data Warehousing, Analytics and data integration with over 20 years of proven management, functional and technical performance in complex businesses across US (+17 yrs), Dubai - UAE (2 yrs) & India (+3 yrs).
• Years of experience as leader in managing teams, complex projects and delivered various strategic BI and Data Warehouse initiatives applying traditional waterfall and agile SDLC methodologies. Maintained an engaging and energetic leadership style with technical competence on projects to drive business results.
• Excellent understanding of various Business Intelligence and operational reporting/analytical tools with expertise in BI implementation projects across different business functions. Distinct emphasis on I.T./business collaboration and engagement, user acceptance and post go-live support strategy.
• Thought leader, innovator, analyst, team player and advocate of BI and Data Warehouse best practices to advance consistency of delivery and streamline repetitive business and technical processes.
• Business knowledge and industry experience of businesses in Rental, Manufacturing, Auction and in leading systems including SOX compliancy, Process control, E-commerce credit card, Bidding, CRM, Vendor Management, Production Management and Enterprise Financial Management

TECHNICAL SKILLS

• Dashboards, Reports, Visualizations, Analysis, Forecasting
• OBIEE Repository (RPD) modelling, iBots/Agents, BI Publisher, Data-level & Object-Level security, OBIEE Integration with other systems for SSO
• Data warehousing, STAR schema modelling, Building Mappings & Workflows, Micro ETL, Data Virtualization, Performance Optimization & Parallel processing
• Oracle BI Apps - Implementation, Customization & Upgrade of various modules, in-depth understanding of Change Capture process, SCDs, Delete capture process for various source system including E-Business Suite & Siebel CRM
• Scheduling, Metadata Container Management
• Object-Level-Security and User Authorization for OBIEE with SSO integration, data security model using VPD (Virtual Private Database)
• Data Conversion, ERP Implementation, Integration
• OBIEE (12c, 11g, 10g), OBI Apps, DAC (11g, 10g), Tableau (8.x Desktop), IBM- Cognos (10.x, 8.x, ReportNet 1.02/1.1 - Cognos Connection, Report Studio, Analysis Studio, Query Studio, Frame work Manager, Power Play), SAP-Business Objects (Crystal Reports), Microsoft SQL Server Reporting Services (SSRS), Crystal Reports for .Net
• Informatica (9.x, 8.x, 7.x), ODI (11g, 12c), SQL Server Integration Services (SSIS), DTS
• Oracle PL/SQL, SQL Server T-SQL
• Oracle 12c/11g/10g/9i/8i, MS Access 2016/2013/2010/2007/2003/2000 ,
• SQL Server 2012 / 2008 / 2005 / 2000 / 7.0 / 6.5 , Progress OpenEdge 11.4
• Oracle R12, RentalResult
• SaaS, Web Service API, AJAX, Windows Services, .Net v 3.5 / 3.0 / 2.0 / 1.1 / 1.0
• ASP.Net, ASP, VB.Net, VB, ADO.Net, C#, HTML, XHTML, CSS, DHTML, XML, XSL, VBA, Adobe Director Lingo
• SHell, COM/DCOM, ActiveX, VBScript, JavaScript, Jscript
• TOAD for Oracle, SQL Developer, MS Project 2016, MS Visio 2016, Visual Studio.Net 2013 / 2008 / 2005 / 2003 , VS 6.0, TeamSite 4.5.1, MS Front Page, Macromedia Dreamweaver / Director / Authorware, Adobe Photoshop 6.0, CyberSource E-Com Suite 2.0
• Linux, Windows 2012 / 2008 / 2003 / 2000 / NT, MAC OS 9x, IIS 8.0 / 7.5 / 6.0 /

PROFESSIONAL EXPERIENCE

Enterprise Manager

Confidential

Responsibilities:

• Managing Business Intelligence function as a business owner - hiring, developing and managing talent while managing expenses, capital plans, operational budgets & leading BI Steering Committee
• Responsible for the definition and delivery of Business Intelligence solutions across the enterprise on all aspects of BI including Project Management, administration, development, delivery, maintenance & leading the BI Team.
• Setting and monitoring the milestones and resources, ensuring project completion on schedule and within budgets.
• Conducting system and functional analysis on prepared specifications.
• Drove improvements in data processing, integrity and synchronization (data governance) with transactional systems and reporting environment to ensure accuracy, viability and business value.
• Liaised with and managed third party IT vendors to provide oversight of BI projects.
• Created new service offerings for supporting BI initiatives.
• Designing and developing the database, writing queries, procedure and creating triggers.
• Writing automated tools to manage various aspects of the project and software engineering.
• Implementation, Management and development of OBIEE solutions with OBI apps of Financials, Procurement & Spend, Supply chain & Order Management and various disparate data sources and solutions (including Oracle R12, custom SQL Server DBs, Progress OpenEdge Dbs, Oracle CRM) by developing custom mapping & workflows in Informatica, modifying existing RPD, developing new execution plans, authoring new dimension/fact modelling, KPIs, Metrics, dashboards, reports, agents, alerts, BI publisher reports, data security model using virtual private database (VPD), object level security, custom roles & responsibilities implementation, integration with LDAP, database design and population, optimization.
• Implementation, Management and development of IBM-Cognos solutions by developing various complex reports, dashboards and KPIs.
• Oracle R12 Financials, Order Management & Supply Chain Implementation with Data conversion, Integrations, reporting solutions
• Rental Result (ERP system Implementation) - Sales & Operations (Quotes, Order Processing, Shipping), Billing, Accounts receivable for Mobile Modular business of MGRC.
• MobilemodularRents.com - portal with live regional inventory of in-stock building floor plans. Users can request a quote, services (repairs/relocations/returns) and view on-rent reports.
• Cool.MobileModularRents.com - admin site to manage the above-mentioned portal as well as a CRM tool to update/manage customer, quotes, opportunities and credit & collections data.
• VPMS.MobileModularRents.com - Vendor & purchasing management system to update/manage vendors, request quotes, issue purchase orders, do invoice approval & track Sku receiving.
• ERentTestEquipment.com - procurement program based on reverse-auction to secure test equipment online rental quotes for customers from multiple vendors.

Software Programmer Analyst

Confidential, Newark, CA

Responsibilities:

• Designed and developed applications for third party customers and implemented them on site
• Interacted with the clients to understand technical, functional and design requirements.
• Designed suitable interfaces for third party Internet service providers / payment gateways.
• B2B capital asset auctions and valuation services company. The important features of this online market to buy and sell used capital equipment, scheduled auctions and liquidation events via WebCast, Email, and Phone.
• Developed the online payment system of this application and also the German currency version.
• Worked on few other projects with McGrath RentCorp, as a Consultant, before joining them on permanent basis.

Software/Web Engineer

Confidential, Daly City, CA

Responsibilities:

• Worked as an onsite Web consultant and implemented solutions for customers' to include SolutionCentral.com and DoveBid.com.
• Developed and maintained SolutionCentral.com, the largest online database of Courses, Seminars & Events on the web at that time. The application was a meeting place for IT professionals & vendors to transact in IT related products, services, training or technical solutions. Also has a Round Table with guest experts to answer queries. Also worked on VMS.SolutionCentral.com, a vendor management system for the portal mentioned above.
• Simultaneously worked on a number of projects as Multimedia & Web Programmer for overseas clients, primarily in e-learning space, in development, testing and debugging roles.