We provide IT Staff Augmentation Services!

Sap Bo Reports Developer Resume

San Antonio, TexaS

SUMMARY:

  • Achieved a record of zero defects for all the development projects that I have worked.
  • Designed and developed two reusable Unix script, which is currently used across the Line of business (LOB) in the organization. And it has benefited $150K approximately per year.
  • Developed 4 Unix scripts to automate few manual business process and to handle failed control - M job scenarios which has benefited $100K approximately per year.
  • Received star of the month nine times and twice as star of the quarter and one star of the year awards.
  • 7 Years of IT experience with strong knowledge in Design, Development and Testing of UNIX Shell scripting, SQL, PLSQL, SAP BO and ETL Datastage methodologies.
  • Expertise in developing Business Objects Universe through UDT/IDT and Webi reports.
  • Extensively worked in all the phases of the Data analysis, Database design, Data Migration life cycle.
  • Experienced in working as a BO admin. Worked extensively in CCM (Central Configuration Manager) and CMC (Central Management Console).
  • Capability to solve complex BO reporting issues, Unix shell scripting issues, SQL query issues rapidly.
  • Experience in TM1 cubes, developing views and TI (Turbo Integrator) processes in IBM Cognos TM1. Extensively worked in TM1 architect, TM1 perspective and TM1 Web.
  • Expertise in develop Datastage jobs for ETL process.
  • Extensively worked in Unix Shell scripting, Data load and Data retrieval through PL/SQL codes.
  • Experienced in developing Pro*C programs to handle high volume of data extracts from Oracle DB.
  • Experienced in working on diversified business domains including investment, (Brokerage managed and non-managed accounts, Mutual funds, cost basis calculations, Internal & external account transfers), Banking, insurance
  • Expertise in creating process and data flow diagrams, and skilled in unit testing, system integration testing and user acceptance testing.

TECHNICAL SKILLS:

Tools/Technology: Business Objects 3.x/4.x, Universe Design Tool, Information Design Tool, IBM Cognos TM1 9.5.2, Control M workload automation Version 8, Data Stage Information Server 8.x/9.x (Designer, Director, and Administrator), SQL Developer, SQL Server Management Studio, slickedit, Jedit

RDBMS: Oracle 11g/9i, MS SQL Server 2005-2008

Programming Languages: SQL, PL/SQL, UNIX shell scripting(bash shell, korn shell), Perl, Pro*C

Operating Systems: Windows 95/98/2000/XP/Vista/7, AIX, Linux 7.x/6.x

Domain: Investment, Brokerage, Mutual funds, Insurance, Cost basis, Portfolio management for managed accounts, Corporate applications

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

SAP BO reports developer

Environment: - SAP BO 4.1 sp6, SAP BO 3.1 sp5 (Development and Admin work), IBM Data stage v9.1, IBM Cognos TM1 v9.5, SQL server 2008, Oracle 9i/11g

Responsibilities:

  • Estimates business requirements, prepare time lines and project execution plans.
  • Prepare design documents and work on the small modification/ development tasks.
  • SAP BO development and admin work for General Counsel BO reporting environment.
  • Support business on application issues and data issues. Also create new process to automate the existing process to minimize the manual work by business team.
  • Co-ordinate with application vendor for application upgrade and major upgrade issues.

Confidential, San Antonio, Texas

BO webi reports and BO universe developer

Environment: - Linux server, Data stage V9.1, SAP BO4.1 sp5, SQL Server 2008

Responsibilities:

  • Prepared the analysis and design documents .
  • Work with DBA to design new database structure.
  • Develop data stage jobs to load financial data to the data base. Design BO universe (in IDT) and develop the reports in webi.

Confidential, San Antonio, Texas

Sr Unix scripting-SQL/PLSQL developer

Environment: - Oracle 11g, SAP BO4.1 sp5, UDT

Responsibilities:

  • Analysis of all oracle tables that handles brokerage accounts, positions and balance data.
  • Worked on data mapping between as-is and to-be systems, and work with DBA for data modeling and database design for the new vendor data.
  • Write the oracle queries and develop the business reports in SAP BO from new database.

Confidential, San Antonio, Texas

Sr Unix scripting-SQL/PLSQL developer

Responsibilities:

  • Requirement gathering and preparing the A&D document for Unix and pl/sql code changes.
  • Modify the middleware codes to add new tax distributions.

Confidential, San Antonio, Texas

Unix scripting, SQL/PLSQL developer

Responsibilities:

  • Write system requirements. Prepare analysis and design document and process flow diagram.
  • Implement business logic for handing internal and external account transfers through DTCC in unix and pl/sql(coding). Load the data received from DTCC in oracle tables and also send the files to Scivantage maxit.

Confidential, San Antonio, Texas

Unix scripting, SQL/PLSQL developer

Responsibilities:

  • Write system requirements and prepare A&D documents and job flow diagrams.
  • Write Unix script and PL/SQL coding to get the real time trade order files from Fiserve and send to CRD’s CRIMS(Charles river investment management statem) system for trade execution and then send the executed trade details to Fiserve.

Confidential, San Antonio, Texas

QL/PLSQL developer

Responsibilities:

  • Prepare analysis and design document and job flow diagrams.
  • Write the code in Unix script, Perl script, PL/SQL and pro*c to calculate commissions and generate commission trade report.

Confidential, San Antonio, Texas

Unix scripting, SQL/PLSQL developer

Responsibilities:

  • Prepare the A&D document and process flow diagram for Cost basis transfer process.
  • Write the codes in Unix scripting and PL/SQL to get the CBRS user master file from DTCC, load it in Oracle tables and sent it to Scivantage Maxit system. Generate CBRS new users report.
  • Write the Unix script to change the scivantage tax lot file to DTCC accepted file layout.

Hire Now