We provide IT Staff Augmentation Services!

Sr Bi Tools Administrator/technical Lead/ Architect Resume

2.00/5 (Submit Your Rating)

Washington, DC

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000/98, UNIX (Sun Solaris, Linux, HP - UX) and OS/400.

RDBMS: Oracle 10g/9.x/8.x/7.x, MS SQL Server 2000/7.0/6.5 , DB2

Programming Languages: C, SQL, PL/SQL, HTML, ASP, JAVA

Application Server’s: Web logic, OAS, Oracle 9Ias, Tomcat

OLAP and Reporting: Business Objects XI R2, XI r3,4.2, Micro Strategy 9.3,9.4,9.5,10.x, Tableau 7.0.20/8.0/9.0.18/10.0. , 2019.1,2019.3,2020.1,2020.3

ETL Tools: Informatica 7.x/6.x (Power Center), Data services, Data stage

Scripting Languages: Unix Shell Scripting, Java Script and VB Script

Oracle Utilities: Oracle Enterprise Manager (OEM), SQL*NET, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr BI Tools Administrator/Technical Lead/ Architect

Responsibilities:

  • Provide 24/7 support to Business objects related issues.
  • Managed the Service now tickets que and assigned tickets to each team member
  • Make sure all Business objects environments at SEC are up and running 24/7
  • Leading migration effort to BI 4.2 SP2
  • Installed DEV, Staging environment for BI 4.2 SP2
  • Worked with 508 compliance team for Production deployment of BI 4.2 SP2
  • Worked with SAP Support team on VPAT
  • Opened incidents with SAP on need basis for critical / unresolvable issues.
  • Set up alerts at Server level, service level and application level alerts.
  • Worked on Migration document with sign-off from Business teams and federal COTR/COR.
  • Consolidated duplicate reports, universes from BOXI R3.1
  • Provided issue triage, server alerts, tickets status to management in the form of a excel report.
  • Worked with Technical writers to create Business objects SOP (Standard Operating Procedure ) document
  • Took care of migration from DEV to Staging to Prod
  • Worked on SCR related to migration.
  • Made sure Business objects server was up and running 24/7
  • Worked with end users on report related issues.
  • Resolved daily multiple BI tools issues (Business objects, Micro strategy, Tableau)
  • Currently creating report requirements for tool transition from Business Intelligence 4.2 to Microstrategy 9.5
  • Installed Tableau server, integrated tableau with R
  • Installed tableau desktop on various user machines

Environment: BI 4.2 SP2, BOXI R3.1 SP2, BOXI R2, Sybase, Oracle, Netezza, Micro strategy 9.5/10, Tableau 9.3/10

Confidential, VA

Sr BI administrator

Responsibilities:

  • Initiated meetings with key stake holders for the business objects migration project
  • Got on call with key-business teams to triage their report and universe related issue.
  • Supported key Business teams by granting access, migrating reports, security setup
  • Worked with few development teams for creating multi source IDT.
  • Identified Bugs in BI 4.0 SP11 tool and reported the same to SAP. SAP will be making sure these bugs are addressed in future versions
  • Automated the Servers re-start process & business objects services monitoring
  • Followed SAP best practice to setup BI 4.0 Servers by breaking up the APS (APS Split) into multiple processes.
  • Worked with Windows packaging team for Business objects client install
  • Actively involved in optimizing long running reports and universes.
  • Worked with LAI performance team to fine tune their key financial reports
  • Worked with IBM Architect to resolve report retrieval issue with prompts tied to LAI reports
  • Resolved issues related to SAM team in regards to Crystal and IDT
  • Worked with IRDQ development for free hand SQL reports, found a way to combine Date with user text field using Oracle @date function’s
  • Installed and configured BI 4.2 SP2 on Sandbox servers, worked with packaging team for client tools.
  • Worked on integrating multi source universe at IDT level for critical financial reports
  • Fine-tuned Java code for crystal reports for 4.2 Migration.
  • Resolved issues related to migration in JAVA

Environment: BI 4.0 S11, Oracle 11G R2, Windows 2008 R2, Windows 8, BMC Remedy, Xcelsius, Live Office, Crystal Enterprise, Crystal Reports 2011 SP11,Microstrategy, tableau

We'd love your feedback!