Sr Bi Tools Administrator/technical Lead/ Architect Resume
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
