Application Engineer (microstrategy Developer/ Architect) Resume
TECHNICAL SKILLS:
Languages: SQL, Java, jQuery, Visual Basic, R, Python(beginner)
Software: SAP Business Objects, MicroStrategy (Enterprise Manager, Command Manager, Architect, Object Manager, Developer, Web, SDK, URL API), Power Designer(Data Modeling), DMExpress (ETL), SPSS, SAS, SQL Assistant, MS SQL, MS Projects, WEKA, MS Visual Studios Team Foundation Server(TFS), Tableau, Power BI, Qlik View, Azure, SharePoint, Remedy ticketing, Jira, Rally, UNIX
Databases: Teradata, MS SQL Server, MS Access.
PROFESSIONAL EXPERIENCE:
Confidential
Application Engineer (MicroStrategy Developer/ Architect)
Responsibilities:
- Drive business Confidential by creating dashboards at summary level and deep diving into detail level to increase business visibility
- Reduced manual process by the business to send reports to management and stakeholders by over 90% by consolidating reports into one platform
- Created KPI to help drive business performance through reducing supply expense, inventory inaccuracy and increasing revenue
- Reduced dashboard and scorecard runtime more than 70% by creating intelligent cubes
- Worked closely with the business to gather, review, and validate business requirements and create scripts based on business logic
- Increased adoption of MicroStrategy Visual Confidential and Document from 90 pilot users to over 1000 user by creating dashboard that are functional for business use
- Create Facts, Metrics, Attributes, Logical tables, and Intelligence Cubes in MicroStrategy
- Create Dashboards using documents and Visual Insights in MicroStategy
- Work with BI tools team on MSTR security and Warehouse cataloging
- Create migration packages and import packages within environments (Dev, QA, Prod)
Confidential
BI Developer
Responsibilities:
- Model database schemas to meet enterprise data standards using SAP Power designer.
- Extract, upload and automate weekly Unix extracts for Healthtrust and troubleshoot failure points
- Develop, maintain, and support Confidential reports in Deski and Webi 3.4 and 4.1 environment, and make Universe changes as needed
- Analysis of Confidential and Vista reports to convert to MicroStrategy
- Write queries used to develop KPI reports and create dashboards in MicroStrategy
Confidential
Business Process Analyst
Responsibilities:
- Created Supplier onboarding toolkit to help reduce the time - frame for on-boarding new suppliers significantly
- Created responsibility matrix for supplier on-boarding to recognize and reduce bottle necks
- Tested contract approvals to ensure compliance with maximum set spend limit
Confidential
Business Intelligence Analyst
Responsibilities:
- Analyzed procurement process for non-M&R items ordered by boat and based on my findings wrote a report detailing my findings and recommend improvement solutions with results expected to increase efficiency by 30% and cost by at least 10%
- Created dashboard to show data on Spend category in Tableau
- Developed Pareto chart to determine the category codes responsible for 80% of spend
- Used information queried from the ERP system(PeopleSoft) to analyze spend per boats, vendors with the most POs, item most purchased in terms of PO count and PO quantity, item with the most spend.
- Worked with the GM, Accounts Payable and Financial Projects to upgrade PeopleSoft from its current version 9.0 to 9.2
Planning Analyst Intern
Confidential
Responsibilities:
- Generated ideas on increasing revenue by a minimum of 30% by offering value added service to products in transit
- Analyzed dry repair cost and extended life cycle to make decision between scraping a barge and repairing it, this was done by analyzing the scrap value, repair cost and potential revenue that could be generated from repair
Confidential
Procurement Summer Intern
Responsibilities:
- Analyzed bids to ensure cost efficiency, by utilizing custom Confidential ’s PeopleSoft software for Confidential
- Oversaw migration of NIGP codes to ensure accuracy of information on Item long description
- Worked with the 7-member systems management team to standardize procurement queries/reports for all state agencies
Confidential
NOC Team Lead
Responsibilities:
- Gathered, analyzed, and reported daily/weekly/monthly service statistics sent to the Chief Operating Officer and operations manager, which reduced our Confidential by an average of 30%
- Responsible for the team maintaining an average weekly site availability of 99.5%
- Shortened the learning curve of new staff significantly by initiating an on-the-job mentoring program with older staff