We provide IT Staff Augmentation Services!

Programmer Analyst Resume

Austin, TexaS

SUMMARY:

  • Over 13 years of strong technical BI experience using Reporting Applications that include Designing, Development, Unit testing, Integration testing, Cut over testing, Go - live, Document preparation, User, and Production support
  • Over 12+ years of Extensive experience working with Business Objects, Crystal Reports, Web Intelligence, in designing complex Universes using Universe Design Tool and Information Design Tool, Xcelsius, Tableau and generating corresponding reports/dashboards and Publications.
  • Hands on Experience in SAP BW/BI, Xcelsius Dashboards
  • Strong SQL writing capabilities across different Database Platforms like Oracle, Teradata, Microsoft SQL
  • Written SQL Scripts for Testing and Data Mining purposes for Report Testing and Data Analysis purposes
  • Used SQL scripting for Data Analysis and identifying issues with Reports and also providing Root Cause Analysis for any issues reported
  • Understanding of the EDI methodologies and standards utilized in Healthcare systems
  • Involved in Data Mapping for the technical requirements based on the discussions with the Business Users
  • Created Views using complex SQL Scripting and also derived tables for report requirements
  • Developed WebI/Crystal/Desktop Intelligence report, Advanced Analysis reports using BO 4.0 suite with OLAP Universe
  • Good Understanding and trained on the HIPAA standards and for safeguarding any Health or PHI related information
  • Strong Analytical and Problem Solving techniques
  • Experience in BO Administration and handling activities like Server Administration, User Administration, Promotion Management, establishing connectivity to new Data Sources
  • Have Four full life cycle implementations experience in building reports using SAP Business Objects
  • Played major roles in Development, Testing and Support Phases of the Project
  • Involved in User in providing technical on the solution built for the End User and the functionality incorporated
  • Strong in Data warehousing concepts and using Star Schema and Snowflakes methodologies
  • Worked on Performance Techniques to improve performance of Reports. These Involved Database/Universe and Report Level approaches
  • Understands the ETL functionality which helps in what data is flowing in for the Report purpose
  • Worked on Onshore/Offshore model and passing work to Offshore at the End of Onshore Day and setting expectations to the team as to what has to be delivered in alignment with the client Expectations.
  • Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
  • Efficiently managed teams of various sizes and worked with the team to achieve company and client's goals

TECHNICAL SKILLS:

Reporting: OLAP

Data Mining: Business Objects 4.1, Business Objects 3.1/XI R3/R2/6.1/5.x, Crystal Reports XI/Enterprise, Crystal Management Console, OBIEE 11G, Tableau, Xcelsius Dashboards, APOS, Sherlock

ERP: SAP BW, SAP HANA

Databases: Oracle Exadata/10g/9i/8i, HANA, Teradata, MS SQL Server 2005/2008

Languages: SQL, PL/SQLl

ETL: Informatica Power Center 9.1/8.x/7.x/6.2, Informatica Power Mart 5.1.1/5.0

Other Tools, Packages: Microsoft Office, TOAD, SQL Developer

Systems: UNIX, Linux, HANA 1.0

Testing Tools: Mercury QC 9.0, HP Quality Center, Clear Quest

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential, Austin, Texas

Responsibilities:

  • Analyzing the legacy system reports and coming up with Technical design documents for the reports
  • Creating queries and analyzing the data and comparing it with the legacy system data to make sure that the reports look similar
  • Providing more flexibility to users with the capabilities provided by the WebIntelligence functions
  • Implemented the solution using the Master/Derived Universes concept
  • Involved in the Unit Testing and UAT phase of the project
  • Created Complex WebIntelligence Reports with the help of Multiple Data Providers and complex report level Variables
  • Worked on Universe Designer to create Joins and complex Objects/Filter Conditions to meet report requirements
  • Implemented Aggregate Awareness wherever applicable in the Universe
  • Was always ready to provide expertise as and when needed and also played major roles when BO Code was moving to higher Environments
  • Used Aggregate Awareness in the Business Objects Universe when using multiple Fact tables along with Aggregate Navigation
  • Extending the existing Contexts and creating new Contexts for the new requirements for Single Bank
  • Created Functional Requirements/Design Documents and Test Case Document for the Project as necessary at each phase of the project

Confidential, Columbus, Georgia

SAP BO 4.1/4.0; Oracle/Microsoft SQL Server

Responsibilities:

  • Analyzing the existing Universes to validate the Impact of the Single Bank Changes in the current Prod System
  • Creating queries and analyzing the data and data mapping to come up with a solution for the Single Bank Changes
  • Minimizing the rework/maintenance on the Universes by coming up with an optimal solution
  • Modified the Universes in both the Universe Design Tool (UDT) and Information Design Tool (IDT) for the Single Bank Changes
  • Implemented the solution using the Master/Derived Universes concept
  • Involved in the Unit Testing and UAT phase of the project
  • Modify the existing 70 + Universes with the Single Bank Changes
  • Created Derived tables in the Universe to have Customer queries for reports as per the User Requirements
  • Used Aggregate Awareness in the Business Objects Universe when using multiple Fact tables along with Aggregate Navigation
  • Created new Dimension Objects for further enhancements that came during the discussions with the Business Users
  • Extending the existing Contexts and creating new Contexts for the new requirements for Single Bank
  • Involved in documenting the material and provide User as to how the BO Reports/Universes will behave post go-live
  • Created Functional Requirements/Design Documents and Test Case Document for the Project as necessary at each phase of the project

Confidential, Tampa, Florida

BO Administrator

Responsibilities:

  • Handling failures of BO Scheduled Jobs using Failure notifications, Event Based triggers for Sequential Job scheduling and Email notifications for Publication Job completion.
  • Creating and Modifying WebIntelligence Reports as per the User Requirements
  • Creating Users to access the BO system and providing them with the correct access by creating the appropriate groups and providing the corrects rights and restrictions
  • Handling Servers by creating new Services to accommodate specific Jobs during the Month End activities when the data volumes are high
  • Providing sessions to front end users as to how to build Reports using WebIntelligence and creating Report level Variables
  • Establishing Connectivity to new Servers hosting Database Sources for new Reporting Requirements
  • Resolving issues with Universes built on Information Design Tool and Universe Design Tool as there was a lack of expertise in the company
  • Modified Contexts and Implemented Aggregate Awareness in Universes with multiple Fact tables
  • Converting the .unv Universes to .unx format and repointing the Reports to the new Universe which also includes testing and User Testing for the reports.
  • Using Query Builder within the BO products to get the inventory of the objects existing the BO Server
  • Used Query Builder to assess and get details of the Activities in the BO system
  • Starting and Stopping Servers on the Unix Box using automated Crontabs and manual Overrides.
  • Creating Scripts to delete unnecessary Logs which reduce the Performance of the System

Confidential, West Bend, Wisconsin

Software Engineer

Responsibilities:

  • Working on Work Requests and Prod Defects prioritized by the Project Management team with the given timelines
  • Simultaneously also supported the Operational Activities on a daily basis
  • Working with the BA’s and Business in gathering requirements and working collaboratively with the other stake holders to make sure all the requirements are met in the BO Reports
  • Created Complex WebIntelligence Reports with the help of Multiple Data Providers and complex report level Variables
  • Worked on SQL Server 2005 and was involved in writing queries to support the report requirements and Testing the report output
  • Worked on Universe Designer to create Joins and complex Objects/Filter Conditions to meet report requirements
  • Implemented Aggregate Awareness wherever applicable in the Universe
  • Created complex Filter conditions in Designer using Exists clause extensively to meet report requirements
  • Was always ready to provide expertise as and when needed and also played major roles when BO Code was moving to higher Environments
  • Used LCM as a versioning tool for Business Objects and always made it a point to maintain history of the Objects that were modified as part of Work requests
  • Involved in creating/Modifying Technical Specs as per the Functional Specs provided by the client
  • Worked with other stakeholders to get a complete understanding of the functionality

Senior Consultant

Confidential, Bellevue, Washington

Responsibilities:

  • Working with the Business Stakeholders as to identify the existing pain areas and the manual reports that they receive from other source systems and thinking of ways to convert these manual Report in a more automated process.
  • Developed attribute views, analytical views and calculation view using SQL and CE functions
  • Modifying Procedures and Creating SQL scripts for reporting purposes
  • Creating Reports using WebIntelligence from multiple source systems and also creating charts and tabular formats
  • Creating Functional Requirements basing on the discussions with the Business Users
  • Managing an offshore team and assigning tasks to them on a daily basis.
  • Managed Resource Allocation as the project progressed from the Design to the Development stage
  • Created Sample WebIntelligence Reports for users as a POC to showcase the capabilities of Business Objects Reporting tools
  • Working with other internal teams to understand the data that we receive from the source systems regarding the prospect data.

Confidential, Dallas, Texas

Software Engineer

Responsibilities:

  • Involved in the Design and Solution part of the CII 2.0 Application from a technical perspective
  • Working with the Business Analysts in clarifying gaps in the Functional Documents and also recommending best solutions as per the needs
  • Designed the Hi-Performance universe by Business Objects data model, selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, used Aggregate Aware function and created the objects which are grouped into classes based on Business Functionality.
  • Implemented User Level Access Security in the Universe
  • Understanding of the HL7 standards that are utilized for clinical data and administrative data used by multiple healthcare providers
  • Worked as Team lead and working with Offshore team to enable 24/7 support for the Project.
  • Co-ordinating and Assigning tasks to team members and setting expectation as per the priorities and deadlines set by the project timelines
  • Onshore BO Lead for the Project and making sure the Universe and WebIntelligence Reports were abiding by the standards set by the client
  • Making sure all the WebIntelligence Reports are Performance compliant from the client set expectations
  • Worked on creating a strategy as to how to run the Publications and making sure the Performance was not affected.
  • Onshore coordinator and gathering requirements and clarifications from the Business for the reports that were to be delivered
  • Build Webi and supported Crystal Report Development and jumped in as and when there were issues faced by the team

Confidential, Denver, Colorado

Software Engineer

Responsibilities:

  • Contributed to successful transition of the project from Development to the AMS team
  • Supporting the Europe Activities related to the Dock and helping the Europe Business with a Business Understanding of the Report Calculations and other functionalities
  • Interacting with the Business Users and gathering requirements for Report Enhancements
  • Getting the Users involved in different phases of the project and providing them updates on the Release Management schedule
  • Created a few Dashboards using Tableau for the POC purposes which pulls data from multiple sources
  • Creating complex dashboards using charts and tabular formats on Tableau
  • Was the only resource from the Client location with expertise on OBIEE and also worked as an Onsite lead in gathering requirements and making sure the offshore team understands them well and the technical implementation is done efficiently
  • Setting expectation with the Offshore team and aligning them to the client expectations
  • As a Team lead was also responsible with the team deliverables from both EU and US Support perspectives
  • Managing CR’s and aligning them for each release and sharing the same with the client for approvals and other processes
  • Implemented single sign-on & security layer with row level restrictions.
  • Configuring new environments and also customizing the OBIEE application with the branding as per Confidential standards
  • Created Drill-Through reports to provide users with more detailed information and query linking.
  • Configuring LDAP functionality to enable SSO authentication
  • Working on performance tuning of the OBIEE reports.

Confidential, Santa Monica, California

Team Lead

Responsibilities:

  • Involved in preparing the processes involved for the Support Engagement
  • Worked on Resource allocation at different phase of the project
  • Minor Enhancements in the Dashboards as per the requirement
  • Minor Enhancements in repository
  • Gathering new requirements from the Business Users and coordinating with the team to have them in the Reports
  • Providing optimal solutions which is out of scope of the Project and meet the client requirements
  • Coordinating with the Onsite team and resolving gaps that are required for the Reporting purpose
  • Coordinating with the ETL team on the changes to be made to the ETL DataFlows for the new requirements
  • Involving in client discussions for new Requirements and proposing efficient/scalable solutions.

Confidential, San Francisco, CA

BO XI 3.1, Oracle 10G, PL/SQL Developer

Responsibilities:

  • Involved in creating/Modifying Technical Specs as per the Functional Specs provided by the client.
  • Develop Unit Test Scripts required for the reporting
  • Created and managed Universes in the Universe Designer.
  • Created the WebIntelligence reports using universes as the main data provider.
  • Created Aliases and Contexts for solving the join problems in Business Objects.
  • Created charts to display summary of the data.
  • Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
  • Created Hierarchies and Predefined Conditions using Business Objects.
  • Exported the Universes to the Repository to make resources available to the users
  • Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report
  • Formatted the WebIntelligence Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.
  • Minor Enhancements in the BO Universe as per the requirement
  • Develop WebIntelligence Reports as per the requirement
  • Coordinating with the Onsite team and resolving gaps that are required for the Reporting purpose.
  • Published reports using Info view, and trained end users for ad hoc reporting.

Confidential

Systems Analyst

Responsibilities:

  • Involved in creating Dynamic prompts using Business View Manager which are mapped in Crystal Reports
  • Developed Complex Crystal Reports on the Oracle Database using SQL Queries
  • Created Report level variables in Crystal Reports
  • Implemented complex formatting at the Crystal Report level as per the requirement
  • Building Complex Business Objects Universe using Universe Designer For Adhoc Reporting
  • Resolved loops between multiple fact tables using Contexts
  • Set the Aggregate Navigation to set incompatibility for the objects from various fact tables
  • Created Derived Tables at the universe level and created reports using this as the data provider.
  • Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting to create formulas for the reports
  • Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
  • Formatted the Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.
  • Involved in Creating Unit test cases for the Crystal Reports and Business Objects Universe
  • Developed Functional (Business terms) and Technical Design documents.
  • Provided inputs wherever necessary to the Client manager to provide a better solution for Reporting and Universe Design

Confidential

Team lead

Responsibilities:

  • Communication to the customer were done on a regular basis along with the team members
  • Modified Universe and implemented User Level/Row Level Security in the Universe
  • Modified Existing Report based on the Change Requests from Business users
  • Created charts to display summary of the data
  • Created Drill-Through reports to provide users with more detailed information and query linking.
  • Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
  • Building Free Hand SQL reports as per the requirement with Drill Down capability
  • Developed Complex reports with multiple data providers and Charts to represent the data across different dimensions
  • Provided Expert guidance to critical issues and also provided inputs on the different capabilities of Business Objects
  • Involved in Client Interaction with the Onsite and Offshore teams during the delivery of the project

Confidential

Software Engineer

Responsibilities:

  • Created and managed Universes in the Designer.
  • Created the reports using universes as the main data provider.
  • Created Aliases and Contexts for solving the join problems in Business Objects.
  • Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
  • Created Hierarchies and Predefined Conditions using Business Objects. Exported the Universes to the Repository to make resources available to the users.
  • Created users, user groups and managed access privileges using Business Objects Supervisor
  • Created new Classes and user Objects in designing the Universes.
  • Formatted the Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.
  • Created complex Canned reports using multiple data providers and synchronizing the data between those data providers
  • Created Desktop Intelligence reports with horizontal and cross-tab reports
  • Worked on fine tuning the reports and the existing universe
  • Trained the users on the features of Business Objects and gave an overview of the features that were used in the canned reports created
  • Was the SPOC when there were issues in Business Objects Universes/Reports

Confidential

BO Admin

Responsibilities:

  • Creating/Deleting UserId’s using CMC in the desired access rights for the corresponding users, Publishing the Business Objects Reports and WebIntelligence Reports
  • Modifying rights for the users as per their requirements
  • Exporting Web-Intelligence Reports to the Corporate Documents, Exporting Universes to the Production Environment
  • Created Desktop Intelligence Reports using Stored Procedures
  • Creating WebIntelligence Reports and Full Client Reports to users as per their requirement
  • Making changes to universes like editing the joins adding objects and changing the security level of the objects in the universe
  • Resolving Production Issues involving technical issues faced by the users in Business Objects Reporting and Access Permissions
  • Was involved in the migration from BO 6.5 to BO XI R2
  • Was involved in testing of the reports and Universes and also the User Access post Migration to BO XI R2
  • Monitoring the Workflows in Informatica Workflow monitor and sending update mails to the user community accordingly

Confidential

Software Engineer

Technology: BO XI R2, Crystal Reports, Oracle 9i

Responsibilities:

  • Worked on Business Objects XI R2.
  • Worked on Designer module of Business Objects XI R2 to develop the universe for Global Inventory
  • Developed Technical Specification documents for Universe & Design Layout document for Crystal Reports
  • Developer complex universe for Ad hoc Reporting
  • Unit Testing and checking the integrity for each object on the universe
  • Created dynamic prompts using the Business View Manager to enhance the performance of reports
  • Used SQL queries as middle ware for Crystal Reports
  • Generated Canned Crystal Reports for front end users for their Business Analysis purpose
  • Used Web Controls to display filter at report level for Drill Down requirements
  • Created Sub Reports in Crystal Report as per the user requirements

Confidential

Software Engineer

Responsibilities:

  • Worked on Designer module of Business Objects XI R2 to develop complex universe
  • Unit Testing and checking the integrity for each object on the universe
  • Created dynamic prompts using the Business View Manager to enhance the performance of reports
  • Used SQL queries as middle ware for Crystal Reports
  • Generated Canned Crystal Reports for front end users for their Business Analysis purpose
  • Created Sub Reports in Crystal Report as per the user requirements

Confidential

Software Engineer

Responsibilities:

  • Creating new data structures (Staging, Dimensions and Fact tables)
  • Created and managed Universes in the Designer.
  • Publishing the Universe to the Corporate Repository and giving access to the users.
  • Created the reports using universes as the main data provider.
  • Created Aliases and Contexts for solving the join problems in Business Objects.
  • Created charts to display summary of the data.
  • Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
  • Created Hierarchies and Predefined Conditions using Business Objects.
  • Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By Region wise and reports based on time like Year, Quarter, Month, Week, Geographic location and Comparative.
  • Unit Testing and checking the integrity for each object on the universe.
  • Performance Tuning of the reports.

Hire Now