We provide IT Staff Augmentation Services!

System Analyst Resume

Washington, DC

SUMMARY:

  • Over 11 years of IT experience in Design, Development, Implementation, Migration, Testing and Production Support for Business Applications using SAP Business Objects 4.1/4.2, Tableau and Oracle Discoverer reports.
  • Worked through all phases of SDLC such as Requirements gathering and Analysis, Design, Construction, Testing, UAT and Quality Assurance.
  • Skilled with data management and analysis, and report writing
  • Ability to work independently and perform with little or no supervision.
  • Experience in gathering business requirements in Banking, Financial and Telecom domains by interacting with Business Users and translating them into technical specifications.
  • Good Experience on Discoverer reports to Business Objects 4.1 Web Reports migration.
  • Good Experience on SAP Business Objects 4.1 and 4.2 Web Reports
  • Good experience on developing in Informatica (DW).
  • Good Experience on developing Discoverer Admin and Discoverer Reports .
  • Good exposure on Oracle OBIEE Reports
  • Knowledge of Data Warehousing and approaches like Star Schema, Snowflake modeling, Fact, Lookup and Dimension tables.
  • Working Experience on ACBS Loans Product System .
  • Expertise in Developing Procedures, Packages, Triggers and analytical PL/SQL Reports.
  • Good exposure to Oracle Application Implementation Methodology (AIM 3.0).
  • Working Experience on Implementation, Production Support and Upgradation Projects.

TECHNICAL SKILLS:

Products: ACBS Loans System. Oracle Apps eBusiness Suites.

Language: SQL, PL/SQL, C, UNIX - Shell Scripts

Database: Oracle 8i, 9i, 10g.

Operating System: DOS, Windows NT 4.0, Windows 98, Windows 2000, Windows XP UNIX

GUI: Developer 6i ( Reports6i,10g)Tools: Discoverer4i/10g, SQL Loader, TOAD, Informatics (DW),Business Objects(BO),Tableau, OBIEE and GL Wand

Environment: s: UNIX, Windows server 2003

PROFESSIONAL EXPERIENCE:

System Analyst

Confidential, Washington DC

Responsibilities:

  • Understand business/client requirements to write functional and technical design documents.
  • Gather requirements, analyze and identify problems & subsequently provide solutions.
  • Identify gaps in a process and provide solutions to fix existing issues.
  • Create Functional Specification & Technical Specification Documents for a release by interacting with cross functional teams.
  • Migrated Existing discoverer reports to SAP Business objects 4.1 reports.
  • Develop new BO Webi reports and modifying the existing reports
  • Writing custom sql and creating derived tables in the Universe.
  • Analyzing and implementing code fixes for data bugs in the production warehouse using BO Reports.
  • Responsible for debugging, Defect Tracking and Data Verification.
  • Development of Several Change and Enhancements requests based on the Universes and BO Reports
  • Create folders and giving privileges for access by Business Areas to users in Discoverer Admin edition.
  • Develop new Discoverer reports and modifying the existing reports.
  • Created reports using Business Objects functionalities like Cross Tab, Master Detail, Formulae, Breaks, Calculation contexts, Merging of Dimensions etc.
  • Developed and created classes with Dimensions, Detail and Measure objects.
  • Developed new universe as per the client requirements by identifying the required tables from Data mart using base queries, report Specifications.
  • Write unit test cases and test after completion of the object.
  • Review the QA test cases to ensure the E2E functional testing.
  • Play an active role in analysis of the specifications provided by the customer and coordinate with other teams for clarifications and support during development.
  • Responsible to oversee the quality procedures.
  • Manage co-ordination with offshore team.
  • Report status to all stakeholders on a periodic basis.
  • Provide training and support to business users to promote understanding of Business Intelligence 4.1/4.2 environment and usage of Business Intelligence 4.1/4.2 Web Intelligence reports, and BI Launch pad tools and features.
  • Created few Tableau reports for internal project metrics.
  • Using Remedy to raise tickets for the migration purpose.
  • Involved in the regular meetings to understand the day to day work progress.
  • Worked on pilots, mockups and documentation Interact with DBA team to optimize report performance via database tuning and creating views.
  • Simulate and analyze a reported problem involving code walkthrough of Interfaces, Host Programs and SQL Scripts.
  • Develop stored procedures and complex packages using PL/SQL.
  • ACBS Loan booking system supporting to day to day end user issues.
  • Coordination with third party vendor Product ACBS for Client business user issues.

Data Analyst

Confidential, Dallas, TX

Responsibilities:

  • Develop, maintain and support Oracle based ETL processes and reports for Confidential External Treasury Reporting.
  • Understand Treasury directives as part of the MHA program.
  • Analyzing and Implementing changes and supplemental directives from Treasury and validating the data.
  • Perform data analysis to support user requests.
  • Develop simple to complex Oracle based reports for various CHF business units.
  • Effectively interact with business users to gather project requirements.
  • Analyze Business requirements and make recommendations on solutions.
  • Develop and maintain requirement and specification documents as necessary.
  • Convert the business requirements into technical specifications.
  • Develop and implement the new design using SQL and PL/SQL
  • Unit test case preparation and unit testing
  • Develop SQL and PL/SQL based processes and automation tools to generate daily reports.
  • Analyze and reconcile data from various data sources like Oracle databases, MS Excel and Flat Files and perform data attestation.
  • Design and develop solutions that support current application and other strategic initiatives.
  • Developing Data reconciliation reports to compare data between Source and Target tables
  • Maintaining the quality standards and prepare relevant release documents.

Reports Developer

Confidential, Columbus, OH

Responsibilities:

  • Analysis of the specifications provided by the clients.
  • Enhancement, Maintenance and Support to the application in resolving the bugs in backend Oracle.
  • Mentoring and supporting the team in resolving the issues.
  • Scoping the problem and giving estimations by analysis of particular objects
  • Involved in Technical document preparation (TD).
  • Developing a new report in the Discoverer 10g.
  • Creating the folders and giving the privileges for access Business Area’s to users in Discoverer Admin edition.
  • Creating the reports and sharing the reports to users in Discoverer Plus.
  • Testing the Discoverer reports in Development and test instances.
  • As per Client request preparing the Sql Scripts.

Software Engineer (Onsite Technical Consultant)

Confidential, San Jose, CA

Description

Responsibilities:

  • Analysis of the specifications provided by the clients.
  • Enhancement, Maintenance and Support to the application in resolving the bugs in backend Oracle.
  • Mentoring and supporting the team in resolving the issues.
  • Onsite & Offshore coordination.
  • Scoping the problem and giving estimations by analysis of particular objects
  • Involved in Technical document preparation (TD).
  • Analysis of Function Design Document (FDD)
  • Involved in unit testing.

Software Engineer (Technical Consultant)

Confidential

Responsibilities:

  • Worked on Various Discoverer (Crass Tab & Table) reports in GL, BRM OIC module.
  • Involved in Technical document preparation (TD).
  • Analysis of Function Design Document (FDD)
  • Scoping the problem and giving estimations by analysis of particular objects
  • Developing a new report in the Discoverer 10g.
  • Testing the Discoverer reports in Development and test instances.
  • Customized / Created New Tables, Views, Procedures, Functions and Packages
  • Creation of MD070 For functional design documents.
  • Involved in unit testing.

Software Engineer (Technical Consultant)

Confidential

Responsibilities:

  • Worked for many Discoverer reports from 11i to R12 Implementation.
  • Worked in Alerts for root causing the issues resolution.
  • Migrated Developer reports as per the R12 functionality.
  • Scoping the problem and giving estimations by analysis of particular objects
  • Developing a new report in the Discoverer 10g.
  • Testing the Discoverer reports in Development and test instances.
  • Customized / Created New Tables, Views, Procedures, Functions and Packages
  • Creation of MD070 For functional design documents.
  • Involved in unit testing.

Software Engineer (Technical Consultant)

Confidential

Responsibilities:

  • Simulating and analyzing the reported Problem. This usually involves a code Walkthrough of Interfaces, Workflows, Host Programs and SQL Scripts.
  • Worked in many reports in Purchasing and Payables.
  • Scoping the problem and giving estimations by analysis of particular Support Central Cases.
  • Developing a new report in the Discoverer 10g.
  • Creating the folders and giving the privileges for access Business Area’s to users in Discoverer Admin edition.
  • Creating the reports and sharing the reports to users in Discoverer Plus.
  • Testing the Discoverer reports in Development and test instances.
  • As per Client request preparing the Sql Scripts.
  • Raising the New SR’S and monitoring for code move to Staging and Production.
  • Worked in Informatica (DW) for loading data from legacy to oracle database.

Software Engineer (Technical Consultant)

Confidential, Atlanta.

Responsibilities:

  • Simulating and analyzing the reported Problem. This usually involves a code Walkthrough of Interfaces, Workflows, Host Programs and SQL Scripts.
  • Scoping the problem and giving estimations by analysis of particular Support Central Cases.
  • For the Code change or Data fix the following steps have been performed.
  • The code will be changed in Development instance and tested It after that it will be moved to the Test instance by raising a DBA case and the User Will test the change. If it’s working fine then there is a CCB (Change Control Board) meeting with the Instance Manager where in which we will discuss about the change and the impact of change. Once it is approved then the DBA case will be raised to move the code to Production. Simultaneously the code will be moved to Wincvs to maintain the Version Control.
  • Post Implementation reviews of a particular change will be done with the user and once it is working fine we will close the case.
  • Responsible to log TARS with Oracle Support for standard Application Objects and follow up with them involving the Functional team till the issue is resolved.
  • Involved in Testing with other teams

Hire Now