QUALIFICATIONS SUMMARY:

Result oriented professional with a profound knowledge and experience in project management, IT, and financial and statistical analysis. Advanced quantitative and analytical skills that have been acquired through intensive engineering and business courses and business ventures. Profound knowledge and experience includes:

TECHNICAL SKILLS:

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

Professional Experience:

Confidential

Mortgage Process Analyst/Data Analytics

• Performing extract, transform, and load ETL data from SQL server/DB2 and prepare them for analysis
• Building summary and detailed reports through SQL and SAS programming
• Performing data analysis and ad-hoc analysis to develop strategic insights that drive mortgage process improvement
• performing complex statistical analysis and modeling to explain mortgage process, highlight substantial process drivers, and predict the behavior of target variable
• Utilizing SAS Enterprise Guide, SAS Enterprise Miner, and JMP to develop statistical models such as regression, cluster analysis, and models validation
• Performed logistic regression and determined predicted probabilities for target variable - close on time
• Performed variable clustering - cluster analysis - in an attempt to group similar variables in groups that have similar effect on the process/target variable
• Performing data visualization through developing reports - tables and graphs - that depict current process
• Publishing insights through the programming and design of dashboards in Qlikview
• Utilizing MS Excel to transform and analyze data by developing pivot tables and graphs

Confidential

Data Analyst - Application Architect

• Performed a detailed project which involved all stages of System Development Life Cycle
• Utilized profound expertise in SQL, VBA, advanced MS Excel, and Teradata
• Identified system requirements by gathering information through engaging with clients
• Performed project planning and analysis, addressed business requirements as well
• Performed project design, planned data transformation, data validation, and redesigned scorecards
• Implemented the design which involved writing VBA and SQL codes as well as building Teradata connection
• Developed for overall application design, including interfaces with other applications and systems. Assures that application designs are consistent with industry best practices application attributes including scalability, availability, maintainability, and flexibility
• Connected Excel-based scorecards to the Data Warehouse Teradata through the use of SQL Scripts embedded in Excel VBA Macros
• 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.

Confidential

Business Development Manager/Analyst

• Managed all treasury activities and financials such as costing, cash budget planning, cash management, invoicing, account reconciliation, wire transfers, and communicating customers' accounts balance
• Managed international business that includes sales, marketing, procurement, and shipping of heavy equipment and spare parts for a total value of 2 million
• Developed many ad-hoc VBA Excel projects for financial and economic purposes
• 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
• Worked on multiple projects simultaneously while managing multiple tasks independently to meet deadlines
• 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
• Provided an international marketing research firm in Washington, DC with insight on the heavy equipment industry in the Middle East

Confidential

Senior Sales Engineer, Heavy Equipment

• Performed credit and financial analysis utilizing MS Excel and user-defined functions
• Performed ad hoc financial analysis and present findings that cover benefit/cost analysis for lease with option to buy schemes analyzed capital investment for big ticket equipment and highlight residual values
• Established a strategic agreement with a financial institution to facilitate our accounts' finance application
• Negotiated, managed and executed several multi-million dollar contracts to prime contractors of the US Army, as well as local construction companies
• Forecasted and monitored sales annually, analyzed sales performance and market trends using CRM programs Siebel SalesLogix , evaluated business results, and identified improvement
• Advising clients on the type of products that meet their technical specifications in the most cost effective way using Caterpillars 3600 approach as well as incorporating investment analysis, machine lifecycle and replacement costs

RESEARCH PROJECTS:

• Studied the relationship between percentage change in the exchange rate and the differentials of macroeconomic variables for Chile and Brazil. The project involved data compiling, data normalization, and analysis of quantitative and qualitative economic data. Performed complex statistical analysis such as multilevel regression and correlation utilizing SAS coding, SAS graph, ODS, Tabulate, and reporting.
• Performed a case study for faculty members at a junior college. Using predictive analytics utilizing SAS, I investigated whether female faculty have been underpaid compared to male faculty
• Performed a case study for assessing the capability of a manufacturing process and determining the associated probability defect items
• Green built member of a six sigma team for business process improvement. The accomplishments of the project mainly were creating a separate profit center for equipment delivery and having more sales time available for sales engineers.