Sr. Migration \ Sr. Bi Specialist Resume
Orlando, FL
SUMMARY
- Identify and evaluate new technology, tools and products for Business Intelligence and Decision Support Solutions.
- Strong attention to detail, good analytical, problem solving skills and out of the box thinking
- Managing and Hands - on development of Business Intelligence reporting(Visualization, Distribution, Maintenance)
- Working with and knowledge of Big Data, Business Objects, VBA, JAVA, Tableau
- Extract Transform and Load(ETL) data into data warehouse(BODS, Datastage)
- Work within multiple methodologies including (SDLC) Software Development LifeCycle
- Manage internal and offshore consultants in order to maintain database repository
- Establishing guidelines(Documentation) and gather requirements needed for tasks.
TECHNICAL SKILLS
Software Applications: SAP BO Applications(WEBI, BEx, DESKI, Explorer, CMC..), ETL(Datastage, BODS, SSIS), Peoplesoft, APOS, Tableau, Eclipse, JIRA, ASP\JSP, SDK, Shell, PL-SQL, Powerbuilder, VBA, SAP (ABAP, SapScript, BASIS), C, SQL, Java, SAS, DDL
RDBMS: SQL Server, Oracle, Teradata, Informix, Sybase, DB2, MS Access
Operating Systems/:
Servers: Linux, UNIX (Sun Solaris, HP-UX & AIX), Windows (multiple platforms), Safeboot Security Boot, Putty, IIS, Tomcat, Apache, Weblogic
Tools: & Utilities: 360+, SSMS, APOS, Toad, SQL Analyzer, Teradata Client, SQL Navigator, MS Access, Shell Scripting(vi, awk, sed),Telnet, LoadRunner, Service Now, Microsoft Suite of tools (including Word, Project & Excel).
PROFESSIONAL EXPERIENCE
Confidential, Orlando, FL
Sr. Migration \ Sr. BI Specialist
Responsibilities:
- Setup and Manage User Security and Groups on accessing environments (BO 6.x through 4.x).
- Universe design\maintenance; development of reports based on needs and requirements
- Migrate reports and Universes(IDT and UDT) along with assist to implement and support BI tools (SAPBO)
- Manage and maintain the database connectivity, including regularly evaluating datasets working heavily with SQL coding for troubleshooting and performance tuning database. Databases use includes Oracle, SQL Server, Sybase, DB2, Informix and Teradata. SQL engines include SSMS, TOAD, SQL Analyzer and SQL Assistant.
- Data Mining within Photopass RDBMS system for reporting purposes
- Implement the department s continuous improvement initiatives to upgrade processes, systems, and reporting using Business Objects.
- Prepare documentation for development tracking and training internal users.
- Gathering requirements from department heads to implement reporting solutions using WEBI and Tableau.
- This included development of simple to complex reporting with Tableau where using Excel spreadsheets; Visualization reports were produced to assist departments in decision making
- Work within Service Now ticketing and follow up accordingly
Confidential
BI Data Analyst\Developer
Responsibilities:
- Business Objects(Admin, Universe(IDT and UDT), Reporting(Webi, Data Visualization: Explorer & Tableau)
- APOS
- SQL Server (SSMS, SSIS)
- Using these tools perform upgrade of SAP BO to version(4.2 sp3) and apply patch accordingly.
- Maintain User Security access for all users(between 1000 - 3000)
- Gather data requirements and maintain reports using SQL Server database along with SSIS ETL for building and maintaining datawarehouse.
- Work with APOS tool in order to set up massive busting of thousands of emails as needed.
- Work within technical and business team in order to develop new BI Model
Confidential
BI SAP BO Developer
Responsibilities:
- I used my SAP background with SD and other components in order to deliver what was requested
- I developed Universes and Reports using SAP BW brought into a Datawarehouse by ETL(BODS) management tools
- Including Data Visualization using Explorer along with Universe support
- I documented areas of reporting and application training as needed to assist the Business Analysts
Senior Business Intelligence
Responsibilities:
- Focus on the development of solution approaches and designs for projects using BI Tools including Business Objects 4.0 suite(WEBI, Rich Client, Designer(UDT; IDT), Publisher Import Wizard and CMC).
- Using ETL(Datastage); leverage the information available in order to create and maintain database(DB2) tables used within Universes(datamarts).
- Design and Develop reports and dashboards using WEBI & Rich Client using BO suite. Reports created; range from simple to complex using multiple universes. Set up Scheduling of reports to groups of users. Use CMC in order to obtain latest reports\universes within BIAR files and implementing them onto multiple systems for continued development as needed.
- Discuss technical concepts, issues and ideas with technology and business stakeholders by initiating collaborative discussions, and presentations.
- Perform ASP maintenance as needed for use within WEBI application
Senior Business Intelligence
Responsibilities:
- Using Business Objects XIR3 and suite of applications I was in charge of BI environment.
- Using SAP BODS as the ETL application I developed and maintained the datawarehouse(Oracle).
- ABAP Development used to leverage SAP BW so to work with BODS and reporting
- Adhoc, and Canned reports were developed using WEBI, Rich Client. They ranged in complexity from simple, crosstabs and visualization dashboards. Reports were also scheduled and bursted to individuals and\or groups.
- Development of Data Visualization reporting was completed and maintained using: Polestar Explorer and Xcelsius. Assist Administrator in the support and maintenance of users, servers and application suite including the use of Universe Designer, Import Wizard and CMC.
- Hold training seminars in order to educate department users on reporting using WEBI as well as the Visualization tool: Explorer
- Maintain documentation for universes and reports used by the users in order to better understand
Business Intelligence Consultant
Responsibilities:
- Administer and Development using Business Objects and its suite of applications including Universe Designer, Import Wizard, CMC along with Data Services(ETL).
- Conduct detailed assessment of current data warehouse and reporting infrastructure and define reporting and analytic needs of the College.
- Work with IT personnel and department directors defining requirements and implement solutions.
- Using Business Objects Webi, Rich Client and Polestar Explorer to build and implement visualization dashboards in order to support College strategic planning. Develop presentations and reports that translate complex information into clear communication for users.
- Conduct professional development seminars to empower campus community on the utilization of BI and data visualization tool(Explorer).
- Develop documentation library for internally educating departmental personnel.
Confidential, New York, NY
BI Developer Consultant
Responsibilities:
- Meet with user teams to discuss and gather requirements
- Successfully implement new or enhanced Analytics for Global Securities Lending team.
- Develop data marts(Universes) for report development and create reports as recommended
- Maintenance of reports as outlined by changes in requirements\needs
- Work with DBAs on table\index creation using SQL Server as Database
- Develop supporting documentation adhered to on stringent bankruptcy laws
Confidential, Radnor, Pa
Business Analyst Consultant
Responsibilities:
- Provide leadership direction for team members and Interface directly with Human Resources on report requirements, status on day to day and cycle (bi-monthly) processing activities.
- Identify and improve performance, stability or functionality of existing reports including working with Database(Oracle) team
- Maintain User Security environment through BI area using Business Objects security modules
- Develop\maintain ASP pages for use with WEBI interface into BO reporting application.
- Perform JSP maintenance as needed for use within WEBI application
- Work on migration to new release of Business Objects XI R2 from original 6.5 version. Test out new version and work on plan of action for implementation\migration.