Fazal Fodkar

**** **** ****** *** # *****, PLANO, TX 75074-7342

SUMMARY

Results oriented, highly competent and enthusiastic professional with over 10 years’ experience in the financial services industry. Over 5 years of project management experience in Global Operations, Change and Risk, focused on the implementation of controls, procedures and delivery of high change initiatives.

Skilled expertise in the area of Application development, Data Warehousing and Business Intelligence with a successful record of delivery from strategy through to project closure using Microsoft, SAP Business Objects, QA automation and Oracle Technologies.

PROFESSIONAL EXPERIENCE

I) Capgemini (Client: Goldman Sachs) (NJ)

Senior Technical Lead – Data Analyst & BI Reporting 12/14/2015 - Present

•Supporting BAU functions including Performance analysis, developing MIS, KPI Metric using Business Intelligence Tools (SAP Business Objects, Qlikview),SQL (MS-Access,Oracle,Sybase,Sql Server) VBA Excel and Access Macros.

•Gathered user requirements from different groups for creating BRD.

•Performing analysis and Identifying root cause of issues with the data and addressing them with the solution to resolve the issues by collaborating effectively across the teams.

•Created parameter driven reports in Access and Excel running thru Access VBA front-end and complex SQL queries .

•Creating QVD’s using complex queries and building QVW reports using QVDs. Loading data from multiple databases which includes excel files and scheduling and refreshing reports/dashboards to various destination which includes emails, sharepoint .

•Designed, developed VBA applications to automate manual processes and also involved in documentation and testing.

•Wrote scripts to make the VBA Applications compatible with other OS's and MS Office Versions.

•Managing and resolving production support tickets for Regulatory, Internal and External client reporting Applications.

II) Barclays Capital Inc. (New York)

a) Project Lead – Data Analyst & Reporting – US Wealth Operations and Management 03/2015 – 12/11/2015

•Involved in integration of data using various source systems, scripting UI development,, managing Access point, creating QVD’s using complex queries and building QVW reports using QVDs. Loading data from multiple databases which includes excel files and scheduling and refreshing reports/dashboards to various destination which includes emails, sharepoint .

•Supporting BAU functions including performance analysis, developing MIS, KPI Metric using Business Intelligence Tools (SAP Business Objects, Qlikview)

•Involved in Documentation and Testing.creating reporting dashboards and developing automated processes through Excel Macros, Add-Ins, advanced Spreadsheet Applications

•Gather user requirements in specifying the analysis, design, and development and liaise directly with business users and other business analysts to define and clearly document requirements.

•Performing performance analysis and Identifying root cause of issues with the data and addressing them with the solution to resolve the issues by collaborating effectively across the teams.

b) Project Lead – Data Analyst & Reporting - Global Risk Control and Regulatory Mgmt. 01/2014 - 2/2015

Projects : Global Asset at Risk and Legal Entity reporting tool.

•Control mapping project to establish a repository of accounts and control associated with ensuring the balances are validated and reconciliation exists to support the balance in the account at month end.

•Global reconciliation breaks reporting

Responsibilities:

•Designing and creating MIS, KPI and Metric reports and Dashboards using multiple reporting tools (BO,Qlickview,VBA excel).

•Involved designing and VBA coding for Excel spreadsheet automation to provide tactical solutions.

•Produced monthly risk reporting and attending the senior executive risk forums and BCI legal entity meeting across the global operations. Established a culture of escalation through partnership with the line, whereby, issues / risks are raised effectively and timely in order for the assess exposure to the firm and take action as appropriate.

•Involved implementing a regional risk and control framework to ensure that all functions have clearly documented risks, controls and identified any exposure to the business as a result of any gaps across Global Operations.

c) Data Analyst/Project Lead, & Reporting –Global Operations 10/2009 – 12/2013

Project: Global Operations Control trade reconciliation breaks Database Project.

Responsibilities:

Supporting and developing MIS, KPI and Metric reports and Dashboards using SAP (former Business Objects reporting tool Webi, Deski, Xcelsius, Qlikview, vba (Excel,Acces),Oracle,SQL server,Toad for Equities/Fixed Income, Tax,Treasury and Risk and Control Group.

Managing Implementation of Reconciliation Software and business Objects reporting tool for Global Analytics and reporting.

Assisted with Performance analysis analysis and automation of Operations control department's manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Designed, developed VBA applications to automate manual processes.

Gather user requirements before analysis, design, and development and liaise directly with business users.

Involved in the designing and building of Universes,CMS administration, Classes and Objects for financial reports. Designed and developed complex Webi Reports using Crosstabs, Formulas for providing analytical calculations.

Involved in integration of data using various source systems, scripting UI development,, managing Access point, QVW reloads on server and troubleshoot errors and failures.

III) Sunsoftwares Inc (Client: Capital one, New York)

Data Analyst/Lead Developer (Analytics and Reporting) 02/2009 - 09/2009

Project: Incentive Compensation Application

Responsibilities:

•Development of Incentive Plans and performance analytics for the Banking Segment across all 3 Lines of Business (Consumer, Small Business and Commercial. )

•Designed and Implemented incentive reports as requested by senior management using BI Tools SAP (former Business Objects reporting tool SRC, Webi, Deski, Xcelsius, vba (Excel,Acces),Oracle,SQL server,Toad.

IV) Nexage Inc (Client: Nomura Securities/Holdings, New York)

Project Lead (Data Analysis and Reporting) 12/2005 - 1/2009

Project: SOX Compliance, Remediation and Management Reporting Project.

Responsibilities:

•Involved in the implementation of Business Objects and worked with business users and analysts to gather BRD’s and Functional specifications.

•Designed, developed VBA applications to automate manual processes. I was also involved in Documentation and Testing.

•Involved in the Performance analysis, designing and building of Universes, Classes and Objects for financial reports.

•Designed and developed complex Crystal and Webi Reports using Crosstabs, Formulas for providing analytical calculations. Analysis and reverse engineering of legacy MS Access and Excel VBA applications.

v) Employer :Nexage Inc (Client: Merrill Lynch - New Jersey)

Position: Data Analyst/BO/VB Developer 4/2005 - 11/2005

Projects :

1) Reg Sho Letter/Notice Generator

This system gives the user the complete information about the fail of delivery of Securities as defined by SEC regulation SHO. This Application generates a notice letter of Buy-in Intent for the security(s). This application sends the notices using Microsoft Outlook as an attachment in Excel Sheet.

This application generates Reports of the Fail deliveries of securities for the management review.

Responsibilities:

Developed prototypes, Designed specifications and modified existing functionalities for optimization.

Involved in creating COM components, Views, Stored Procedures in SQL server.

Extensive usage of VBA/OLE automation, interfacing VB with MS Outlook and Excel and for reports.

Design and Developed Reports using Crystal reports and exporting Data to Excel.

2) Borrows and Distribution System (BDS)

The BDS system provides a series of queries that allow the user to determine the cost of outstanding borrows and fails to deliver allocated to short accounts controlled at the Business Unit level.

Responsibilities:

•Designed the web pages and programmed the web enabled modules using Visual Interdev, ASP, HTML, DHTML, VBScript, and JavaScript. VBScript and Java Script was used for client end /server side validation and Visual Source Safe (VSS) to control source-code.

•Design and Developed Reports using Crystal reports.

•Involved in requirement gatherings from Business and create the specs for development of reports.

EDUCATION AND QUALIFICATIONS

• Bachelor of Commerce, University of Mumbai, India

• Diploma in Computer Programming and Analysis - (National Computing Center, UK)

• Brain Bench Certified VB,ASP,VB script, RDBMS.

• Undergone Training in Project Management Workshop, Business Objects, Qlickview.

• Certified in Lean Competency system level 1A and 1B

MANAGEMENT COMPETENCY

• Proven ability to lead successful programs and teams.

• Ability to develop and implement control and procedures.

• Adept at training, motivating and managing personnel.

• Strong Leadership and excellent presentation & communication skills.

• Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.

• Ability to produce detailed business requirement documentation for IT implementation.

TECHNICAL COMPETENCY

•Database :MS-Access 2007, Oracle 11, MS SQL Server 2012,DB2

•Programming: VB6,VB Script, ASP, CSS, HTML, DHTML, XML, Java Script, VBA (Excel, Outlook, Access),Cobol, C, Visual studio 6.

•Business Applications & Tools : MS Office 2007, Toad 11.5, Photoshop, Sharepoint, Documentum, Informatica (ETL), Load Runner, Quick Test Pro,Toad, Clear Quest, Rapid Sql, MS Visio, PeopleSoft, Siebel, TDB, IMPACT, Intellimatch, ADP systems.

•Business Intelligence Tools : SAP Business Objects XI R3.x /4.x, Xcelcius, Crystal Reports XI

•Operating System : UNIX, Windows XP/NT/2000, LINUX

• QA Methodologies: Regression Testing, User Acceptance Testing, Back End Testing, Front End Testing using both manual and automated testing tools.

Contact this candidate