We provide IT Staff Augmentation Services!

Business Intelligence Developer/analyst Resume

Arlington, VirginiA

SUMMARY:

  • 6 years of experience reflecting strong technical, and management qualities coupled with “hands - on” experience implementing solutions across the technology spectrum.
  • Over 5 Years of IT experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes Oracle Data Integrator 10g/11g,OBIEE 10g/11g, SOA Suite 11g, and WebLogic server 10.3.
  • Experience in Dimensional Modeling such as star schema, snowflake schema, creating Facts, Dimensions and Measures.
  • Proficient in requirements gathering, systems design, user-interface design and system architecture.
  • Created reports using multiple data providers, filters, prompts, sub queries and SQL.
  • Strong knowledge in Software Development Life Cycle (SDLC) methodologies.
  • Ability to work independently, and also within a team environment, having performed several technical roles within a customer-focused environment.
  • Highly skilled in Business Intelligence system study, design, development and implementation of applications and Client/Server technologies.
  • Excellent written and verbal communication, team player and ability to work across organizations to achieve results with minimal handholding.
  • Well trained and skilled software engineer with expertise in databases, Business Intelligence, Data Warehousing and OLAP based technologies.
  • Ability to impose structure on ambiguity and prioritize critical issues.
  • Experienced in managing multiple full project lifecycles from business development to final delivery.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2003 Server.

Languages: T-SQL, HTML.

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, ODI 11g

Databases: MS Access, MS SQL Server 2012, Oracle 11g, 12c.

Tools: /Utility Enterprise Manager, SQL Server Management Studio (SSMS)

Reporting Tools: OBIEE, SAP Business Objects, Tableau Desktop, Birst, Excel, SQL Server Reporting Services 2012, 2008.

Other Tools: MS Office, Visio, MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, Virginia

Business Intelligence Developer/Analyst

Responsibilities:

  • Design, develop, and maintain a functional and flexible Business Intelligence (BI) capability in conjunction with the TSA Financial Data Warehouse and Oracle Federal Financials (OFF) Release 12 using Oracle Business Intelligence for Applications (OBIA) with Oracle Business Intelligence Enterprise Edition (OBIEE)
  • Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Deployed RPD and catalogs using Enterprise manager.
  • Created new reports and dashboards as per the business need.
  • Creating and submitting status reports to up line managements.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
  • Designing, creating, troubleshooting, and executing Oracle OBIEE reports
  • Assisted the QA team in preparing Test Plan, Test Cases and Test script.
  • Assisted with user testing of systems (UAT), developing and maintaining quality procedures and ensuring that appropriate documentation is in place.
  • Created & executed queries in SQL server to analyze, validate and maintain large market data
  • Assigned the defects to appropriate software development teams for fixes

Confidential, Arlington, Virginia

Business Intelligence Developer

Responsibilities:

  • Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
  • Worked as BI developer/admin performing tasks like report development, universe design and administration of the Business Objects XI R2 Platform in a data warehouse environment.
  • Created reports using multiple data providers, complex filters, prompts and sub-queries.
  • Designed and developed the universes using designer
  • Documented the functional requirements, defined user profiles, supplementary requirements and assumptions to execute the trading platform
  • Scheduled meetings with developers and testers to collaborate resource allocation and project completion using MS Project
  • Created Mock-up forms in MS Access for better visualization and understanding of the software solution
  • Assigned problems to appropriate software development team for fixes via MS Project
  • Conducted quantitative analyses on available metrics and briefed senior leadership, enabling them to improve analytical products to maximize visibility and usefulness to the community.

Confidential, Elkridge, MD

Business Intelligence Developer/Analyst

Responsibilities:

  • Used BI tool Tableau to examine trends and create reports as requested
  • Analyzed company’s fuel usage and determined the best course for future purposes
  • Identified process boundaries and developed opportunities to automate processes and functions
  • Created reports using multiple data providers, filters, prompts and sub-queries.
  • Assisted senior staff with development of effective presentation
  • Ensured compliance with established internal control procedures by examining records, reports, operating practices and documentation.
  • Recommending solutions for creating more revenue and reducing costs using data/visualization created using Birst Analytical Tool
  • Act as a liaison between the senior management and the technical teams, gathered Business requirements by conducting interviews, brainstorms and meetings with various stakeholders and compiling the Business Requirement Document (BRD).
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives to each other and resolve any outstanding issues
  • Conducted the GAP analysis “As is” and “To-be” for the project.
  • Interacted with the stakeholder to finalize the business requirements and vendor on RFP and SOW.
  • Documented requirements, worked on end-to-end traceability and project auditing.
  • Developed Use Cases based on the business requirements.

Hire Now