Sap Data
Resume:
Muhammed Ismail
MBA (Technology)
adhk7d@r.postjobfree.com
Experience Summary
● 20 years of IT experience that includes 15+ years of developing and supporting Business Intelligence solutions.
● Connected SQL server and Oracle data to spotfire for analysis
● Used R and Python for creating Visual analysis.
● Developed dashboards, reports using Power BI, Xcelsius (SAP Dashboard Design), BOBJ, Tableau and Spotfire.
● Expert in designing dashboards using complex multiple data sources
● Developed best practices for business objects reporting/dashboarding solutions.
● Experience working in SOA architecture and in a validated environment.
● Performed the roles that involved requirement gathering, validation, implementation, maintenance, coordination, business analysis and supporting of various business critical reporting systems.
● Experienced in coordinating SDLC release activities for the team in multiple projects and locations. Technical Skills
Analytic Tools/Technologies: Power BI, Azure, TIBCO Spotfire Professional, TIBCO Spotfire webplayer, Spotfire JSViz, SAP Dashboard Design, SAP BO 4.0 FP3, SAP Lumira, SAP BO Design Studio, BIWS, Business Objects Crystal Xcelsius Designer 4.5, Xcelsius 2008, Query As A Web service, BO Live Office, SAP BOXI R3 Crystal Reports, Business Objects Web Intelligence Webi, Business Objects Universe Designer, Business Objects Infoview, Tableau, D3, Oracle, TOAD, SQL Server, SQL, PL/SQL, SAS, MS Access, MS Excel, R, Python, Linux Ubuntu, Cloud computing, Amazon s3, AWS, EC2 Web/Internet Technologies: SAPUI5, OPENUI5, SAP WEB IDE, JavaScript, HTML, XML Work Experience
Jasmin, Inc. Jan 2016 – Current
Houston, TX
BI Lead/Architect
● Developed multi-tab reports using Spotfire and Information Link to publish them on the Spotfire Library.
● Architected solutions to use data on Power BI connected to Azure server
● Created Pivot transformations to provided summarized data across business units
● Scheduled TIBCO Spotfire reports and dashboards.
● Analyzed data and in various source systems (Oracle DB, SQL server) to deliver data in multiple formats
● Consolidated requirements and recommended solutions to address business needs and challenges
● Led the Permian Workforce Planning Spotfire Analytics from concept to implementation
● Developed multi-tab reports using Spotfire and Information Link to publish them on the Spotfire Library.
● Deployed geo analytics Spotfire solutions using shape files, color and size and information links on demand.
● Trained users and resolved technical issues and coordinated release of solutions in the Spotfire Library
● Tested functionality to identify and resolve technical issues in the spotfire Platform.
● Created Information links, expressions and calculated columns to help calculate GOR and derived measures
● Developed oil and gas analysis in Spotfire to calculate downtime and initial production performance
● Designed and Developed complex system solutions on financial data.
● Designed Spotfire information links for re-usability across reports and created charts such as line, bar, combo, pie etc.
● Connected multiple data sources into Spotfire DXP visualization using information links
● Utilized spotfire JSviz to create org hierarchy and customized spotfire scripts as per the needs of the business
● Supported spotfire solutions that were built inhouse and enhanced capability as per business needs
● Created dashboard visualizations in Tibco Spotfire, Tableau and Power BI
● Utilized TERR, R and Python in spotfire to create visual analytics
● Used R script in Spotfire to calculate latitude and longitude distance location Muhammed Ismail 860-***-**** Page 1 of 4
● Used R to get json data as dataframe to Spotfire for analysis
● Worked on Amazon webservices (AWS) and on Amazon S3, EC2 cloud and Azure
● Worked on gathering metrics from source and target tables, views and snapshots from various datamarts
● Created webi reports, dashboards utilizing universe, webservice in SAP Dashboard Design (Xcelsius)
● Created dashboards utilizing dynamic visibility, formulas and triggering of queries
● Create and edit SQL queries within Tableau to build calculated fields.
● Created various charts using measures and dimension in Tableau
● Build and publish interactive dashboards on Tableau Server.
● Architected SAP design solution and recommended optimal choice of tools
● Updated SAS scripts to create data for analysis
Clients: Exxonmobil, Consumer Energy, Mckesson, IGT ConocoPhillips Oct 2013 – Dec 2015
Houston, TX
Sr BI Developer/Analyst
● Develop reports and dashboards using Spotfire and published them to view on webplayer.
● Created Information links, expressions and calculated columns to help calculate measures
● Developed oil and gas flare analysis in Spotfire to reduce flaring as per NDIC regulation (FCT Tracking Map)
● Designed Spotfire information links for charting data such as line, bar, combo, pie etc.
● Connected multiple data sources into Spotfire DXP visualization using information links
● Deployed geo analytics Spotfire solutions for ConocoPhillips using shape files, color and size.
● Scheduled TIBCO Spotfire reports and dashboards.
● Created solutions integrating SAP BOBJ with Spotfire tools
● Led the P2P financial dashboard from concept to implementation
● Connected SQL server data to spotfire analysis
● Published dashboard to SAP Netweaver portal
● Created BIWS, passed prompts to BI webservices and used dynamic visibility components
● Connected SAP Dashboard to SAP BEX queries utilizing BICS connection with triggers in dashboard Jasmin Inc Dec 2010 – Sep 2013
McAllen, TX
BI Developer/Architect
Business Intelligence
● Created and helped maintain SAP dashboards for various clients such as in the gas and retail industry
● Helped clients understand the BO architecture and the necessary tools for various analytics
● Created exploration views on biondemand SAP cloud architecture
● Utilized Geo Analytics (Google Maps) to show location centric analytics in Xcelsius
● Connected SAP Dashboard Design to SAP BEX queries utilizing BI Webservices
● Utilized with triggers in dashboard to call BIWS
● Debug XWIS Antivia component issues after migrating to SAP BO 4.0 environment
● Created SAP dashboards to showcase the latest SAP tools capabilities for the SAPHIRE Exhibition
● Worked in a SAP Dashboard design BO 4.0 FP3 environment with SAP Visual Enterprise Viewer, Author, Xcelsius
● Created alerts on 3d analytics and Xcelsius plugin (GMaps Plugin) to show location centric analytics
● Connected SAP dashboard to Steps and Views in SAP Visual Enterprise Viewer mod
● Architected SAP dashboard design solution and recommended optimal choice of tools
● Led the MJP executive dashboard from concept to implementation
● Created connection to SAP BEX with Information Design Tool in a SAP BO 4.0 environment
● Created Safety & Reliability dashboard in SAP BO Xcelsius by working with the business
● Improved load time of several dashboards by performance tuning
● Created and optimized SAP BOBJ BO QAAWS triggering mechanism in the dashboard
● Created template dashboard with corporate branding and improved performance
● Created and modified objects in the BOBJ universe to be used in the dashboard.
● Analyzed data and created necessary queries for the dashboard
● Developed finance dashboard for Parexel to gain insight into accounts receivable and profit margin Muhammed Ismail 860-***-**** Page 2 of 4
● Developed and Utilized BOBJ LO (Live Office) in Xcelsius 2008 from Webi Report
● Utilized flash variables data connector to pass data into the dashboard
● Worked with graphics designer to produce custom dashboard visualization as per the business requirements
● Developed finance dashboards for Barclays Wealth to be consumed by senior management
● Developed and Utilized Business Objects BOBJ LO (Live Office) in Xcelsius 2008 from Crystal Reports
● Analyzed data and created necessary queries for the dashboard and D3 charting
● Created SAP BO universe joins, prompts and derived tables
● Created Business Objects QAAWS to connect it to dashboard
● Used flash variables data connector to pass data into the dashboard Clients: Consumer Energy, Parexel International, Celgene Corporation, Barclays Capital Amgen Inc Mar 2010 – Nov 2010
Thousand Oaks, CA
Senior Business Intelligence Consultant
Manufacturing Operations, Business Intelligence
● Consult with Amgen IS personnel for the development of Web Intelligence reports
● Perform SAP BOBJ Universe enhancements regarding joins, visibility, inputs and navigation
● Developed Analytics solution for end users
● Develop Xcelsius dashboard and WEBI reports to support lot disposition
● Architected, developed and deployed dashboards using Business Objects
● Created dashboards utilizing QAAWS, LiveOffice webservice in SAP Business Objects Xcelsius Designer 2008
● Created metrics business requirements and design specification documentation.
● Developed IIT dashboards using SAP Business Objects Xcelsius 2008 Hartford Life Inc Jul 2009 – Feb 2010
Simsbury, CT
Senior Business Intelligence Lead
Performance Measurement and Analysis, Business Intelligence
● Create live reports using business objects XI and SQL stored procedures
● Developed and documented best practices to enable optimal tool benefits
● Created cross platform reporting solutions utilizing XML, .NET, webservice, aspx, SQL server
● Business Analysis and data analysis of Metric Management and Scorecards
● Unit tested application and compared performance metrics to determine system load times Pfizer, Inc
New London, CT
Senior Business Intelligence Developer July 2005 – Jun 2009
● Developed and Tested Design specification and architecture scope as per the needs of the business.
● Developed and deployed reports, dashboards and scorecards using Business Objects and Hyperion tools
● Developed and Utilized Business Objects QAAWS (Query As a Web service) to Crystal Xcelsius 4.5 Dashboard
● Developed Web Services using Flynet Web Service Generator for Databases for Xcelsius dashboards
● Created Live office Reports from Business Objects Universe, Webi Reports & Crystal Reports XI
● Created webservice using Business Objects Universe, QAAWS and Flynet Web Service Generator for Databases.
● Configured Crossdomain.xml to host dashboards in multiple domains and Business Objects Infoview
● Created scorecard and metrics business requirements and design specification documentation.
● Utilized XML Mapping and flashvars for live data into Business Objects Xcelsius 2008 Engage dashboard
● Created an Program Management Dashboard and Business Objects XI Crystal Reports
● Performed Data Analysis for the PM dashboard in IPM database, Hyperion Essbase cube data and Ariba.
● Worked with Business objects EPM Enterprise Performance Manager (scorecard/dashboards)
● Consolidated multiple scorecards into Hyperion System 9 Performance Scorecard instance.
● Created custom user preferences and navigation interface in Scorecard Application database
● Developed Test scripts and Test Plans adhering to ISLC process and documentation
● Created and executed SQL scripts to compare databases and to create snapshots Muhammed Ismail 860-***-**** Page 3 of 4
● Configured and connected Oracle 9i database to Hyperion Scorecard
● Liaised between “Research” and “Development” project teams to ensure their issues are addressed
● Utilized SAS clinical reporting systems to create graphical output
● Supported Clinical Investigator meetings and FDA Advisory committee meetings for SAS analysis
● Worked on Food and Drug Administration (FDA) 21 CFR Part 11 compliant systems Keane, Inc.
Danbury, CT
Senior SAS Systems Analyst Apr 2000 - Jun 2005
● Worked on documentation and automating SAS Electronic Submission publishing process
● Published study report tables to DMPS (Documentum) and worked on CDISC Data publishing
● Validated SAS datasets using SAS scripts and SAS macros to automate submission publishing process
● Worked with Regulatory data to create CFR Part 11 compliant data for FDA submission
● Led ESUB Data publishing team and worked with various teams to ensure regulatory and system compliance
● Worked with SAS/Unix scripts to publish documents to regulatory document management system
● Maintained study report tables of multiple projects and supported submission for Rapid response filing to the FDA
● Global Data Administrator (US, UK, France, Italy) for SAS data component and technical support of ESUB.
● Worked on creating and publishing best practices for SAS reports complaints in 21 CFR Part 11
● Provided application support for Documentum 4i (DMPS) and SAS based ESUB (Submission Assembly Tool).
● Worked extensively with Adobe Acrobat for creating, editing and publishing SAS generated PDF reports.
● Worked with various Statistical Analysis and Reporting teams to publish SAS datasets to ESUB/SAT.
● Worked on submission of NDA’s and IND on various drug projects
● Provided support for INET RDC which is an On-line casebook to enroll patients and access
● Trained INET end users to use the electronic CRFs (case report forms) to enable SAS analysis.
● Developed and maintained a (DCF) tracking database
● Created weekly status reports for CRA’s (Clinical Research Associate) and Data Managers
● E-Investigators training, 21 CFR Part 11 (Electronic Records; Electronic Signatures) training Hartford Life Inc Sep 1999 – Apr 2000
Data Analyst
Hartford Life Inc, Investment Product Division
● Helped in creating reports for managing workflow information
● Worked with various financial systems to update Automatic Income of annuities Eastern Connecticut State University Feb 1999 – Sep 1999 Web Developer / Analyst / Support
ECSU, J. Eugene Smith Library, Management Information System Dept
● Web Developer for the ECSU Biology Department and Webpage Editor of ECSU library website
● Provided technical support to library patrons and system administration on various operating systems
● Tested and developed an Intranet website that was linked to an MS Access database. Education and Training
● MBA in Technology (University of Wisconsin)
● BS in Business Administration (Eastern Connecticut State University) -Management Information System Muhammed Ismail 860-***-**** Page 4 of 4
Contact this candidate