Provided an international marketing research firm in Washington, DC with insight on the heavy equipment industry in the Middle East.Assisted a client in Kuwait with establishing themselves as a viable and successful contractor for the US Army by attaining the proper ID numbers, creating business processes, developing bid capabilities, pricing strategies and policies.Worked on multiple projects simultaneously while managing multiple tasks independently to meet deadlines.Served the requirements of infrastructure projects by rendering my technical business expertise in mechanical and heavy equipment matching technical requirements with domestic and international sources, submitting offers, negotiating deals and finding the best method of shipping.Developed many ad-hoc VBA Excel projects for financial and economic purposes.
Managed international business that includes sales, marketing, procurement, and shipping of heavy equipment and spare parts for a total value of 2 million.Managed all treasury activities and financials such as costing, cash budget planning, cash management, invoicing, account reconciliation, wire transfers, and communicating customers' accounts balance.Interviewed with stakeholders to determine which fields need to be captured, redefining data types in Teradata, as well as writing SQL Scripts that enables data to be loaded to Teradata.Connected Excel-based scorecards to the Data Warehouse Teradata through the use of SQL Scripts embedded in Excel VBA Macros.Assures that application designs are consistent with industry best practices application attributes including scalability, availability, maintainability, and flexibility Developed for overall application design, including interfaces with other applications and systems.Implemented the design which involved writing VBA and SQL codes as well as building Teradata connection.Performed project design, planned data transformation, data validation, and redesigned scorecards.Performed project planning and analysis, addressed business requirements as well.Identified system requirements by gathering information through engaging with clients.Utilized profound expertise in SQL, VBA, advanced MS Excel, and Teradata.Performed a detailed project which involved all stages of System Development Life Cycle.Utilizing MS Excel to transform and analyze data by developing pivot tables and graphs.Publishing insights through the programming and design of dashboards in Qlikview.Performing data visualization through developing reports - tables and graphs - that depict current process.Performed variable clustering - cluster analysis - in an attempt to group similar variables in groups that have similar effect on the process/target variable.Performed logistic regression and determined predicted probabilities for target variable - close on time.Utilizing SAS Enterprise Guide, SAS Enterprise Miner, and JMP to develop statistical models such as regression, cluster analysis, and models validation.performing complex statistical analysis and modeling to explain mortgage process, highlight substantial process drivers, and predict the behavior of target variable.Performing data analysis and ad-hoc analysis to develop strategic insights that drive mortgage process improvement.Building summary and detailed reports through SQL and SAS programming.Performing extract, transform, and load ETL data from SQL server/DB2 and prepare them for analysis.Tableau, QlikView Developer, SAS, SAP, SPSS Statistics, MS SQL Server, Teradata, MS Excel StatPlus, Analysis ToolPack, MS Word, MS Access, MS PowerPoint, MS Visio, CRM: Siebel, Sage SalesLogix, and DBSi
SAS: SAS Base, SAS Enterprise Guide, SAS Enterprise Miner, JMP.Sensitivity, Scenario, Simulation Analysis.Predictive Analytics - Regression Classification Models.Excel: VBA, Macros, Matrices, Pivot Tables, VLOOKUP, Complex Statistical Analysis.Profound knowledge and experience includes: Advanced quantitative and analytical skills that have been acquired through intensive engineering and business courses and business ventures.
#Forecasting statplus professional#
Result oriented professional with a profound knowledge and experience in project management, IT, and financial and statistical analysis.
0 kommentar(er)
