sayed mohammad

* Month end Validation Project: * Worked with business user to gather month end data discrepancies in SAP BW and TAL_BI(Oracle 11G). * Created POC for the month end validation reports and presented to all the stakeholders. * Developed the BOBJ Universe by importing all the related tables form the TAL_BI database in the SAP BOBJ Designer and created queries for each report and implemented the same in the WEBI 3.1. * Resolved JIRA issues pertaining to each report and deployed the solutions in different month end releases with the help of SAP BW, BEx and Crystal Reports 2008. * Created Unit test documentation for reports and solution releases.

Created Mobile Usage Analytics reports, data warehouse and data integration process for the Chicago METRA using SQL Server 2014, SQL Server Development Tools (SSIS, SSAS, and SSRS) and Microsoft Power BI. This helped business find out various fraudulent activities with respect to the ticket usage and take strategic decisions to increase revenue. Lead BI team in Oracle BI (OBIEE, ODI) to MSBI conversion project. This helped the business reduce significant yearly licensing cost. Created Esri ArcGIS Map analytics in Power BI for the department heads to deliver daily Station and Rail Line KPIs. Conducted lunch and learn sessions for the report users.

Consulting Solutions To Silicon Valley Bank USA

Worked at the Process Control Department of the Hot Strip Mill. Presented a total flow diagram of HSM Department and suggested multi slab caster with individual receiver to enhance the productivity.

* Responsibilities: * Technical & Functional support for Ti10 the Titanium Scheduler(Clinical Scheduler). * Development & Maintenance of UC Counseling & Psychological Department website using Adobe CQ5. * OQ-45 Analyst maintenance. * Maintenance of Intranet(Joomla) & Microsoft Windows Server 2008. * Administered Facebook page & Twitter Handle of the department. * Assisting in providing outreach to UC students.

* Developed web applications and system troubleshooting using UNIX and ASP.NET. * Assisted medical students on their system and applications queries. * Taught MS Excel and PowerPoint to a class of 40 Medical Science students.

* Consumer behaviour research: * Created statistical modeling of the consumer reponse data spanning 5 years using SAS for marketing research. * Tools used: MS Word, Excel, Powerpoint, SAS, Qualtrics, Direct RT, Media Lab, SONA * Certifications: Completed CITI ethics training to conduct research involoving Human Subjects in an ethical manner.

* Conducted requirement gathering and source data analysis sessions. * Designed and developed Data Model Design for the US Department of Labor Unemployment Insurance Analytics DataWarehouse. * Designed and Developed Data Integration(ETL/ELT) and execution Strategy to perform full and delta load of the data warehouse. * Performed unit testing, created UAT environments, documentation, knowledge transfer, and training sessions. * Technologies and Tools: SQL, PL SQL, ODI 11G, Oracle 12C, SQL Data Modeler, OBIEE 11G and BI Publisher

Capgemini is headquartered in Paris, France and is present in over 40 countries. It is, above all, a people company with 180,000 people worldwide. Capgemini, one of the world's foremost providers of consulting, technology and outsourcing services, enables its clients to transform and perform through technologies. Capgemini provides its clients with insights and capabilities that boost their freedom to achieve superior results through a unique way of working, the Collaborative Business ExperienceTM. The Group relies on its global delivery model called Rightshore®, which aims to get the right balance of the best talent from multiple locations, working as one team to create and deliver the optimum solution for clients.

Activities and Societies: Lindner Finance Club New York Professional Trip

Activities and Societies: ARRG Team lead Microsoft Campus Club member