PROFESSIONAL SUMMARY:

• Senior Information Technology professional with deep expertise as a Business Analyst in the area of Business Intelligence, Analytics, Visualization and Data Warehousing skills resolving business challenges and gaining clients trust through System Development Life Cycle.
• Specialty in playing a role of Business Analyst with planning, design, development, deployment, implementation, testing, training and various other skills within Cognos BI learned from industry leaders such as Chevron, Confidential, Confidential and Hewitt Associates while playing key leadership roles as BI Architect, BI Developer, Project Manager, Business Analyst & Technical Analyst navigating through software development life cycles.
• Qualified and experienced in implementation of innovative solutions across variety of industries including Financial Services &Banking, Insurance, Biomedical, Pharmaceutical, Oil & Gas, Manufacturing, Media and Entertainment for clients across the globe.area of expertise
• Extensive experience in working with both internal/external clients to understand requirements and business processes with an emphasis on data quality, data integrity, KPI calculations etc.
• Experienced working with clients on multiple iterations to ensure desired reporting and analytics requirements requests have been accomplished.
• Deep experience with SQL codes and querying databases including Oracle, SQL Server and Teradata.
• Hands - on experience with leading BI tools such as Cognos (7.x, 8.x, 10.x, 11.x) and Tableau (9.x, 10.x) with understanding of inner workings of Power BI and Qlikview for dashboard development and visualizations projects.
• Strong background in data evaluation and processes leading to meaningful insights and KPIs.
• Deep experienced working as data analyst on design and development of data warehouse projects.
• Experienced with Confidential Unica application leveraged for new campaigns including segmentation, campaign and customer analysis within the banking industry.
• Experienced with data cleansing, data mapping within reporting and analytics platforms.
• Adherence to System Development Life Cycle leveraging Agile/Scrum methodologies.
• High level of proficiency using Microsoft Office suite for gathering requirements, presentations and documentation.
• Proficient in multitasking and ability to work on multiple projects simultaneously.
• Skilled in effective facilitation, presentation and managing expectations of business clients technical & functional skills Deep expertise in both technical and functional skill set in design and development of BI & Analytics reporting systems by partnering with business clients and providing desired results on time and on budget.
• Experienced with design and development of Cognos Report Studio reports based on requirements collected from business clients.
• Advanced in design and development of a three layered Cognos Framework Manager model including configurations settings, model validation, package level security and optimized for queries.
• Architectural expertise in design and development of multidimensional Transformer cubes from IQDs, dashboards and other visualization.
• Skilled with querying against Oracle and SQL Server databases for troubleshooting report performance, data quality and data integrity.
• Comfortable collecting requirements from business clients and managing clients’expectations.
• Managed medium and large projects involving building Enterprise reporting platforms, exposure to Tableau visualization tool, interactive dashboards, OLAP multidimensional Transformer cubes, Framework Manager metadata models and packages, conditional based alerts and notifications, Cognos Connection and security configuration including row level and package level securities.
• Extensive knowledge including best practices with reference to inner workings of Cognos (v7.x, 8.x, v10.x) MS SSRS, Crystal Reports, OLAP vs OLTP systems, Normalized vs Denormalized databases, Star Schema vs Snowflake Schema, Normal Forms, limitations of SQL Server vs. Oracle databases, Data Architecture, Data Lakes, BIG Data, Hadoop, HDFS data store, Map Reduce, HBase/Hive/Spark/Sqoop/Cloudera Hue & Impala, pros and cons between Bill Inmon vs Ralph Kimball data warehouse architecture design among others.
• Creative in resolving business issues, building and strengthening client relationships, requirements gathering, project management, art of obtaining consensus with a group of business stakeholders, consulting background with enhanced communication skills including effective facilitation style, presentation and relaying of complex technical concepts broken down into easy to understand concepts and analogies.
• Competent in conceptualizing architectural solutions, designing Proof of Concepts and building roadmaps comprised of 'As-Is' and 'To-Be' solutions leveraging MS Visio.
• Contributed to RFP/RFI proposals, keeping up with innovation & technology trends, assisting with defining strategic and tactical roadmaps, identifying business case, staffing projects, resolving project issues, defining project scope, building and deploying project timelines and work plans.
• Accomplished managing CAB member and team members both onshore and offshore.
• Working knowledge of Business Object, Crystal Reports, Micro Strategy, Qlik View, DB2, SAS and Unix.
• Comprehend inner details of Object Oriented Programming and related codes not to mention Encapsulation, Data Abstraction, Polymorphism and Inheritance. core accomplishments
• Analyzed inappropriate Cognos License allocation during annual software licensing forecasting and budgeting period. This is where standard users were granted developer grade licensing. This resulted in significant savings in the IT OPS department. It also initiated saving awareness in this area across the board.
• Devised and automated distribution of standard Cognos reports to a wide range of users on a periodic basis. This resulted in 45% reduction in Cognos Connection portal traffic.
• Diagnosed slow performing reports by refining and recoding Cognos reports, reconfiguring Framework Manager models, building aggregated tables, re-indexing database tables, redefining table relationships joins and cardinalities. This resulted in improving report performance with a positive impact on user productivity by about 65%.
• Managed to turn around couple of almost derailed projects by analyzing the project situation first,partnering with key stakeholders and re-organizing efforts in proposing alternative solutions leading to significant savings in contractor budgeting.

PROFESSIONAL EXPERIENCE:

Lead Technical Analyst/Architect

Confidential, San Ramon, CA

• Monitored RIMS (Reliability Information Management System) and EIS (Equipment Information System) applications leveraged for safety, reliability and efficiency of refinery assets and equipment.
• Collaborated with onshore and offshore resources in providing hands on support with reporting, analytics, metadata modeling and web application modifications.
• Orchestrated RIMS upgraded project by engaging in the Proof of Concept project and getting it approved through varying levels of stakeholders.
• Modernized by upgrading RIMS to No SQL MarkLogic application and ASP.Net technologies by working with and collaborating with MarkLogic consultants.
• Redesigned and optimized a large percentage of Cognos global reports, analytics and other BI artifacts for refineries across the globe.
• Led onshore and offshore resources regarding application support, quality codes and change management.
• Interfaced with cross functional team, business partners and managed expectations with on time delivery of deliverables.
• Upgraded and supported legacy RIMS to MarkLogic application comprised of state of the art No-SQL database with integrated search engine.

Management BI Consultant

Confidential, San Francisco, CA

• Contributed to multiple BI related projects and provided innovative solutions to Confidential clients.
• Made immense contributions to scores of clients by improving their BI platforms through analyzing their needs, wants, skill sets, systems and processes.
• Implemented new BI platforms or overhauled existing ones resulting in significant amount of savings ranging from labor hours to simplifying BI environments.
• For Project Details click here and scroll down.

Senior BI Consultant

Confidential, San Francisco, CA

• Specialized in implementing Information and Technology solutions.
• Strategized in gathering requirements and building proof-of-concept around as-is, to-be and laser sharp focused on delivering gaps.
• Leveraged agile methodologies in software development life cycle throughout project.
• For Project Details click here and scroll down.

Junior BI Consultant

Confidential, Chicago, IL

• Gained experience with Information Technology as a BI developer specializing in Cognos BI and Analytic
• Implemented and applied proven BI methodologies and best practices within software development life cycle.
• Increased the number of positive comments from satisfied clients and continued making enormous contributions.
• For Project Details click here and scroll down.