We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

5.00 Rating

Los Angeles, CA

SUMMARY

  • BI/DW Architect/Engineer with over 10 years of experience in Information Technology Domain, with key emphasis on Analysis, Design, Development, Testing, Implementation and Application Management.
  • Currently working for Confidential as a Business Systems Analyst and Project Lead.
  • Proficient in eliciting, analyzing and translating business requirements to technical architecture, articulate a vision, evaluate risks and define roadmaps to build and strengthen BI capabilities, processes, and infrastructure/system investments.
  • Creative problem solver/engineer that excels in conceptualizing, analysis, and rapid development of Pre - sales, Proof of Concepts, and prototyping of industry and company specific data/information solutions.
  • Experience working in a fast paced environment on multiple projects simultaneously performing different roles of Project Manager, Analyst and Architect.
  • Led development teams of up to 13 and managed development project budgets to $1 MM.
  • Major technical contribution towards building a practice around Salesforce Wave Analytics and responsible for the one of the first licenses sold for the product in Jan 2015.
  • Technical expertise in Oracle Business Intelligence Applications (OBIA), Siebel Analytics/OBIEE 11g and 10g, Informatica/ETL, Informatica Cloud, DAC, SQL, Cloud BI (Salesforce Wave Analytics) and Oracle.
  • Experienced in various modules/applications of OBIEE/OBIA such as HR Analytics, Financial Analytics, Supply Chain Management Analytics, Sales Analytics, Service Analytics, Marketing Analytics, Marketing Segmentation, OBI Delivers, Multilingual functionality and Disconnected Analytics.
  • Extensive experience in building Physical, BMM and Presentation layers in RPD including developing star/snowflake schemas, creating dimensional hierarchies, defining measures/metrics, creating variables and implementing data-level & object level security.
  • Experience in installing and configuring OBIA 7.9.6.3 components that include OBIEE 11.1.1.5, Informatica 9.0.1 and DAC 10.1.3.4.1 on Windows and Linux platforms.
  • Expertise in designing and architecting Data warehousing Concepts (OLTP/OLAP System Analysis, Data Modeling, Data Integration, Dimensional modeling) using Inmon and Kimball methodologies.
  • Extensive hands on experience in building Informatica mappings, workflows, tasks and sessions for various subject areas like Sales, Service, Marketing, Finance and HR.
  • Solid hands on experience in using various Informatica transformations such as Source Qualifiers, Connected & Unconnected Lookups, Aggregator, Router, Joiner, SQL transformation, Expression, Sequence Generators, Normalizer, Filter etc.
  • Extensive experience in designing and building dimensions, facts, aggregates, bridge tables, hierarchies (balanced and unbalanced) etc for datawarehouse
  • Tuned nightly ETL performance by inducing parallelism, optimization of workflow parameters, balancing between source qualifier queries and lookups etc.
  • Provided architectural recommendations for datawarehouse design encompassing ODS, Oracle Golden Gate and Data Loading strategy for high availability of BI applications.
  • Experience in OBIEE with various source ERP/CRM tools such as Siebel, Oracle EBS and JD Edwards.
  • Knowledge of core Finance business processes (Order to Cash, Procure to Pay), AP, AR, GL and Profitability.
  • Capable of administering Informatica in both Windows and Linux platforms.
  • Single-handedly installed, configured and setup OBIA Financial and Supply Chain Management analytics with JD Edwards Enterprise One as source ERP mounted on IBM iSeries.
  • Experience extracting data from various source ERP/CRM tools such as Siebel, Oracle EBS and JD Edwards.
  • Knowledge of core Finance business processes (Order to Cash, Procure to Pay), AP, AR, GL and Profitability.
  • Published a white paper on OBIEE and JD Edwards Accelerated Implementation Fundamentals.
  • Knowledge of Big Data, Hadoop and Pig Latin.
  • Ability to assess and recommend Business Intelligence tools and Products.
  • Vastly experienced in drafting project proposals, project scoping, effort estimation and resource loading.

TECHNICAL SKILLS

Primary Skills: Informatica 7x,8x,9x

Operating Systems: Linux, Windows

Languages: PL/SQL, Pig Latin

OLAP/Reporting Tools: OBIEE 11g/10g, Siebel Analytics 7.8.4, Salesforce Wave Analytics Cloud

Source Systems: Familiarity with - Siebel CRM 7.7/8.0, Oracle EBS R12, JD Edwards Enterprise One 9.0

Databases: Oracle 11g and 10g

Domain Knowledge: Financials, Sales, Pharmaceuticals, Telecommunication and Supply Chain Management

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Business Systems Analyst

Environment: OBIEE 11.1.1.7, Informatica 9.5.1, Oracle R11, Oracle EBS R12

Responsibilities:

  • Conducted meetings with business users to understand their reporting needs and ensure client satisfaction
  • Stabilized HR Analytics application by Analyzing and identifying gaps in the current data model and designed custom ETL process flows (using Informatica) to fit Jacobs’ business process
  • Streamlined implementation processes and adopted new techniques for ensuring data consistencies across applications
  • Drafted functional specifications for Employee Consolidation and Workforce Profile projects
  • Designed data model and ETL processes for Employee Consolidation project that integrates and standardizes employee information from Oracle Human Resources, Peoplesoft, Alesco and other flatfile sources for global headcount reporting needs
  • Defined and implemented Datawarehousing, ETL and OBIEE best practices and standards
  • Performed root-cause analysis for production issues and designed & developed mappings and workflows to resolve them
  • Provided architectural recommendations for datawarehouse design including ODS, Oracle Golden Gate, Data Loading strategy for high availability of BI applications
  • Conducted meetings with business users to understand their reporting needs around Project data
  • Understanding source system business processes and data flow
  • Vendor management, scoping, estimation and resource loading for the project
  • Led team of 6 (six) resources towards design and development of the project
  • Validating datawarehousing design principles, overseeing project design (ETL & OBIEE) and execution
  • Performed data validation and identified gaps in the out-of-the-box model. Recommended custom solutions to bridge the gaps
  • Designed object and data level security (based on project key members)
  • Performed data modelling for custom solution, designed ETL process flows for custom hierarchies, fact extensions and aggregate tables
  • Used various Oracle Index techniques and partitioning concepts on databases to improve the query performance.

Confidential, Atlanta, GA

Analyst / BI Architect

Environment: Informatica Cloud / Salesforce Wave Analytics (Cloud BI) / Sql Server

Responsibilities:

  • Built technical expertise in Salesforce Wave Analytics & Informatica Cloud and SAQL (proprietary Salesforce language built on Pig Latin)
  • Responsible for building a practice and capability around Salesforce Wave Analytics for Cognizant with directions from senior leadership
  • Single handedly built a technical proof-of-concept on Salesforce Wave Analytics & Informatica Cloud around Agent onboarding for Confidential using production data with ~300 mi records
  • Built close to 30 reports and 5 dashboards on Salesforce Wave Analytics. Used Informatica Cloud for ETL transformations and to upload data on Salesforce Analytics cloud
  • Demonstrated the proof of concept to Confidential senior leadership that eventually led to the purchase of the products (Salesforce Wave Analytics & Informatica Cloud)
  • Defined and built overall solution architecture involving Salesforce Wave Analytics, Informatica Cloud and Sql Server Database
  • Productionized the proof of concept
  • Requirements Gathering & Analysis of E2E Agent Maintenance for EU project
  • Designed and Developed Informatica Cloud tasks and mappings to extract data from Salesforce CRM, multiple Sql Server instances and flatfiles
  • Used Informatica Cloud‘s capabilities to extensively transform the data by using aggregators, lookups, expression & filter to standardize, scrubbing off duplicates and build close to 50 measures
  • Created datasets in Salesforce Wave Analytics for reporting
  • Responsible for one of the first licenses sold for Salesforce Wave Analytics considering product was launched in Oct 2014
  • Received accolades and appreciation from Cognizant and Salesforce
  • Put Cognizant in high ranks and one of the preferred Implementation partners for Salesforce

Confidential, Atlanta, GA

Analyst / BI Architect / Assistant PM

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, Oracle R10, Siebel 8.0, Oracle EBS R12, Revchain

Responsibilities:

  • Conceived, scoped, architected and executed various projects such as Customer Retention Analytics, Finance KPIs for Balanced Scorecard and Revenue Pipeline etc. alongside support and maintenance of core BI application.
  • Responsible for the entire maintenance, support & enhancement, Quality Assurance and final implementation of the core BI application.
  • Led a team of 13 resources towards design, development and implementation of Change Requests and Enhancement.
  • Provided technical leadership to architect solutions using BI tools such as Informatica, DAC and OBIEE etc.
  • Performed data modeling, designed ETL processes for Order Management and Product Simplification project. Designed near real time order monitoring dashboards and reports using metadata-driven ETL process
  • Performed data modeling, designed ETL processes for Revenue Pipeline project that captures revenue at different stages of Quoting, Ordering and Billing across different source systems
  • Designed star and snowflake schemas for various projects
  • Identified and discovered various business process gaps/opportunities for optimization through data analysis and proposed solutions to key stakeholders to address them.
  • Formed a BI Governance team that ensured data governance and quality, consolidate effort towards similar engagements and abide by data-warehousing best practices.
  • Represented BI team in change control board meetings to identify new requirements, assess business priorities and revise/build project plans.
  • Worked as a Business Analyst and Data Integration Specialist for building Finance KPIs for Balanced Scorecard (Revenue, Customer Counts, CSAT, Revenue & Customer Churn etc) using Inmon methodology.
  • Preparing Business Requirements Document and Reporting Solution Design.
  • Managing incident tickets and task assignment.
  • Nightly load and micro ETL load monitoring
  • Coordinating with Onsite and Offshore for daily deliverables and status.
  • Project planning and estimation.
  • Designed near real-time order monitoring dashboards using metadata driven approach in ETL to implement enhancements faster
  • Built close to 90 reports (using OBIEE & ETL) for Retention department in a span of 2 months.
  • Built story-telling dashboards that helped improving Retention queue (dropped to 1800 tickets from 2900).
  • Transformed the way Retention users had been analyzing the data that gave instant recognition.
  • Developed consensus amongst different business functions to report same “Sold Revenue” number and proposed Revenue
  • Pipeline solution that tracks revenue at different stages of Quoting, Ordering and Billing process to senior leadership.

Confidential, Atlanta, GA

Business Analyst / Module Lead (Onsite)

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, Oracle Exadata

Responsibilities:

  • Conducted meetings with stakeholders to understand their reporting needs and conceiving, scoping and executing projects such as “Sales Funnel (for different channels)”, “Executive Scorecard” etc to completion.
  • Performed business analysis, gathered requirements and provided technical leadership.
  • Architected BI solutions that encompassed sourcing data from diverse source systems such as Siebel, Cisco, Avaya, Omniture, ShopperTrak etc.
  • Defined various KPIs and measures for the implementation of Sales Funnel for different channels such as Retail, Online, Inbound, Outbound etc.
  • Led a team of 10 resources towards design, development and implementation of projects using BI reporting tools such as OBIEE, Informatica, DAC etc.
  • Designed star and snowflake schemas for the projects and ETL processes to populate tables and schemas
  • Performed OBIEE Reporting Performance Tuning and presented OBIEE 11g new features with business use cases.
  • Project planning, estimation and status tracking.
  • Built a prototype “Executive Dashboard” for SLTs that represented complex and high volume data in a true interactive BI form eventually replacing legacy excel reporting. The prototype was extremely well received by Senior Executives of the firm despite the fact that they were used to seeing their excel reports for years.

Confidential, Muscatine, IA

OBIA Architect / Tech Lead (Onsite)

Environment: Oracle EBS R 12, OBIA 7.9.6.3, OBIEE 11.1.1.6, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle 11.2.0.3

Responsibilities:

  • Conducting Oracle BI orientation sessions to familiarize client personnel with OBIEE/OBIA technology and product capabilities.
  • Conducting workshops, Gathering & analyzing end-user business requirements.
  • Performing Report Rationalization, Prioritization, Gap Analysis and Solution outlining.
  • Installation of OBIA components - OBIEE 11.1.1.6, Informatica 9.0.1, DAC 10.1.3.4.1 on Red Hat Linux servers.
  • Setup and configuration of OBIA 7.9.6.3 Financial Analytics.
  • Preparing Functional and Technical Design documents.
  • Leading offshore technical team.
  • Designing and modeling star/snowflake schemas in ETL & RPD.
  • Creating custom reports (as per the requirements) and implementing object level security.
  • Customization of ETL (Informatica) mappings and workflows to populate warehouse tables.
  • DAC configuration and customization.
  • Unit Testing and Final Implementation.

Confidential

OBIA Architect

Environment: JDEE 9.0, OBIEE 11.1.1.5, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle 11.2.0.1, OBIA 7.9.6.3

Responsibilities:

  • Installed and setup OBIEE 11.1.1.5, Informatica 9.0.1 and DAC 10.1.3.4.1 .
  • OBIA setup and configuration for Financial and Supply Chain Management Analytics.
  • Identifying and addressing gaps/challenges in the prebuilt out-of-the-box JDE adapters. Worked closely with Oracle to enhance their product.
  • Implemented workarounds/resolutions for the issues/bugs encountered (out of the box) on the ETL (Informatica + DAC) and Reporting (OBIEE) layers.
  • Setup LDAP authentication mechanism in weblogic and Implemented object-level security.
  • Setup OBI Delivers to send reports via email.
  • OBIEE and ETL Infrastructure Sizing.
  • Taking care of all the Administrative tasks, Deployment and Maintenance of Oracle Business Intelligence Applications (OBIEE, Informatica & DAC).
  • The project is a unique implementation of OBIA for JD Edwards ERP mounted on IBM iSeries DB2 platform. OBIA configuration has not been done for an ERP on IBM iSeries before which posed unique set of challenges and exposed gaps in the pre-built JDE adapters.
  • As the sole member of BI module, I was responsible for the entire installation, setup, configuration, testing and deployment of OBIA 7.9.6.3 Financials and Supply Chain Management Analytics (OBIEE, Informatica & DAC).

Confidential

Senior Developer

Environment: Oracle Apps, Siebel, OBIEE, Informatica, DAC, Oracle

Responsibilities

  • Actively involved in the maintenance of the application and resolving day to day issues raised by the markets.
  • Analyzed, designed and developed new requirements.
  • Fixed issues/bugs pertaining to OBIEE RPD, webcatalog, Informatica and DAC.
  • Mentored junior team members and assisted them in their assigned tasks.
  • Interacted with the end clients to discuss the status of issues.
  • Prepared Change Request and code migration documents.
  • Involved in Unit and System testing.

We'd love your feedback!