SUMMARY

• Expert in Software Development Life Cycle SDLC which includes Analysis, Design, Implementation Coding , Testing, Deployment, and Maintenance
• Experience working with Analysts, Controllers, Traders, Business/Executive Management and Staff etc. to create Dashboards and Reports, which are ultimately a summary and drilled-down detailed analysis of the business operations
• Rapid Application Developer RAD and expert in using various programming languages and software to develop financial applications
• Able to perform Data Analysis on an advanced level using various tools
• Developed Dashboards, Reports, Financial Models, Graphical Analysis of business and technical operations
• Experience independently managing the entire project from its inception Working with Controllers, Analysts, Management, and Staff to understand the business operations and requirements , to its completion development of technical applications in accordance with User requirements
• Worked with creating databases and structuring of Big Data on servers SQL and Sybase and in applications, using data generated from live and static feeds in a variety of formats
• Experience working with aggressive project schedules to meet the demands of a high paced environment

TECHNICAL Computer Skills

• SKILLS Programming: T-SQL, SQL, SSIS/SSRS/SSAS SQL Server Integration /Reporting /Analysis Services, Sybase, Haddop, Visual Studio, VB, VBA, Classes, COM, ADO, API,
• XML, PERL, Access, EXCEL, ETL
• Software: MS Office Suite Excel, Access, Word, PowerPoint All Versions, SharePoint,
• MS Project
• Other SW: SAP, Bloomberg, SMS, Reuters, Reuters Kondor, TCP/IP, FTP, UltraEdit,
• Filezilla, Internet Email Programs
• OS: Windows All Versions, UNIX, DOS
• FINANCIAL Knowledgeable of Risk/Return Analysis, Quantitative Measures, and Financial Instruments
• SKILLS Quantitative Analysis Monte Carlo Simulation, Capital Asset Pricing Model CAPM , Regression
• Good understanding of Fixed Income, Equities and Derivatives Valuation and Portfolio Performance Evaluation Systems
• Experience working with the development of Financial Models
• Strong understanding of financial principles for Application Development, Data Analysis, and Reporting Development
• Skillful in gathering, analyzing and interpreting complex financial data
• MANAGEMENT Managed from inception to completion, a variety of technical/financial projects to produce a synopsis of
• SKILLS business operations for Management, Analysts, Traders, Staff and others.
• Additionally, in the Technology, Financial, and Chemical Engineering industries, managed a team of individuals committed to creating products utilized in the technology, financial and engineering domains.
• EDUCATION New Jersey Institute of Technology formerly Newark College of Engineering
• Major: Chemical Engineering
• Degree: BS Chemical Engineering

PROFESSIONAL EXPERIENCE

Confidential

SQL, Application, and Report Developer / Data Analyst / Business Analyst Contract Position

• Comprehensive comparative analysis and evaluation of historical and current customer sales, volumes, and operations caused explosive growth in size of Access databases used exceeded the 2Gb limit . This created a need for growth and to accommodate big data structures on the SQL Server level. Technical design and creation of applications was necessary to produce corresponding financial reports.
• Worked in the financial department to automate the creation of financial analysis of chemicals manufactured, developed, and sold to clients like Proctor and Gamble, Colgate, Merck, Revlon, etc.. The company uses various technologies to obtain a complete picture of their current, historical and forecasted Sales, Revenue, and Financial Performance. Advanced use and knowledge of technical applications, Pivot Tables, and PowerPivot was required, to provide a wide range of scenarios and summaries representing financial statements and reports.

Confidential

• The projects were constructed to enable technical and financial growth in the production of reports and analysis, eliminating the current MS Access databases and moving to a more robust SQL and Oracle platform. An interface was created between the SQL Server and Excel, with Excel as the Front End Reporting Tool, and also expounding on SQL security features.
• FINANCIAL MODELLING
• Worked on design and creation of Financial Model to generate customer Sales and Volume analysis
• Calculated Weighted Average of each Customer's Relative Sales, to determine Top Producers of Sales, and to identify opportunities with Outliers
• With a graphical analysis of the Price-Volume Curve Risks Outliers were more readily identified using a Straight Line Fit
• Calculated Standard Deviation SD from Average Price of Product to identify Risks. Customers paying prices outside of the normal range were identified, to mitigate the risk of moving their business to other producers offering more competitive product prices
• Pivot tables and PowerPivot were used to segment specific populations of customers and analyze their Weighted Average contribution to the overall Sales for a specific Region, type of Product sold, Sales for a specified Quarter, etc. The Price and Volumes obtained from the Pivot tables were fed into calculations existing on the backend of a Summary Report
• Used High-Low Chart of Prices to identify the where customers fit into specific Price ranges and their Price position Top, Middle, or Bottom of the range . This evaluation also identified Opportunities and Risks.
• DATABASE DEVELOPMENT / REPORT CREATION
• Created DB on SQL Server, which included Tables, Schemas, Views, Accounts, Application Roles
• Transferred all tables in Access to SQL Server using SSIS, MS Access Upsizing Wizard, and bcp
• Handled Big Data records totaling in the millions to upload data into SQL from SAP
• Worked to ensure normalization of tables to minimize redundancy, and validation of SQL Server Data integrity
• SQL's Database Diagram used to create Table Relationships, and testing of Table Relationship was performed to validate Referential Integrity
• Created Schemas to differentiate Market and Local Databases
• Used TSQL to develop Indexes, Primary Keys, Constraints, etc., to further develop tables
• Created application on the front end in Excel, which included User Login Security, and interfaced with data on the SQL Server
• Designed, coded, and tested complex SQL and VBA scripts to create an interface between the SQL Server and Excel
• Queries, Stored Procedures, Triggers, , Views, Indexes, Constraints were created on SQL Server to obtain the data used to populate Excel Pivot Tables/PowerPivot on the Front End, generating the final reports
• Used a number of SSMS features Sys Dynamic Management Views and Graphical Execution Plans to resolve issues with slow running queries and poor SQL Server performance
• Created Excel Front End application with security to enable various levels of access to data and reports by management and analysts
• Data from the SQL Server was stored in cache or memory using Pivot Tables and PowerPivot for Excel, and automatically loaded into customized Pivot Tables to reflect the financial summary and analysis reports
• Experienced a plethora of technology issues using the company's current technologies in place, which required the need for exhaustive troubleshooting techniques and workaround methods to successfully accomplish project goals

Confidential

SQL, Application, Report Developer / Data Analyst Contract Position 12/2013-3/2014

• Automated applications were created to generate new formats and modify existing CCAR and Y9-C reports. Raw data on SQL was created and modified to include new and existing fields required by the FCC. Data was also downloaded from SharePoint and collected into ACCESS, EXCEL and SQL. Using TSQL and VBA CCAR and Y9-C reports meeting FCC requirements were created.
• A plethora of Access databases and Excel reports were developed in varying formats throughout the company for various departments and operations. To establish a universal platform and company-wide standards that enabled departments to work more cohesively, the project entailed development of Enterprise level models, by moving all associated data to SQL and Oracle Servers. Associated scripts and reports were moved to web based technologies using SSIS, SSAS, SSRS, Java, etc.
• As a Rapid Applications Developer, developed, implemented, enhanced supported high performance, comprehensive risk valuation management systems auxiliary tools to support strategic risk operations
• Used SQL, SSMS and SSIS, Sybase, Excel VBA, Access VBA and Microsoft Applications Excel, Access and Word to design, develop and deploy software applications, including the Comprehensive Credit Analysis and Review CCAR application. used to produce reports submitted to the Fed on a quarterly basis
• Provided design for technology solution to resolve CCAR issue:
• Provided separate reports to the Fed to present Outstanding loans and report loans on a Facility level
• Upgraded plan combined the two reports to present the Outstanding loans products on a detailed basis this data was then rolled up into the Facility level to produce a summary report

Confidential

• Recommended and designed client/server process to interface with individual client desktops and main Access database to expedite the update of data from 25 business sources
• Used Excel and Access VBA, modules and classes interfacing with SQL/TSQL scripts and standalone applications to design and improve process technology solutions and expedite the processing of reports
• Created and/or revised TSQL/SQL queries and stored procedures to process, analyze and move big data and implement data integrity initiatives for various business units.
• Used Excel VBA, formulas, data and name management features e.g. conditional formatting, named ranges with formulas, etc. , to automate data quality analysis of counterparties and exposures to process large volumes of data, and assist with the production of reports
• Used XML to create and modify Excel and Access menus to house application commands
• Used SSIS to automate ETL processes for manipulation of large volumes of data between SQL and Sybase
• Used SSMS and TSQL/SQL to produce scripts and Access pass-through queries for efficient processing of big data and conversion project which is transferring Access databases to SQL Server
• Participated in training sessions to learn and understand company standards and guidelines for business operations and technology software development lifecycle, ensuring design and development of both new and existing software applications meet business specifications
• Gathered business requirements to perform system analysis of current software processes in place
• Participated in project planning sessions with project manager, Business Analyst, team members, and Users to analyze business requirements
• Reviewed BRD's and current process flow to produce documented technical solution
• Worked with various business professionals in understanding operational risks and risk reporting processes
• Developed an extensive and practical understanding of the reporting applications and process flows to overhaul systems and provide process improvements
• Documented detailed application specifications to translate technical requirements necessary during SDLC
• Transferred business requirements into software design and development, providing UAT and support Reviewed and analyzed the effectiveness and efficiency of existing systems, to develop strategies for improving or further leveraging these systems.
• Developed IT solutions to optimize application development by bringing business rules and parallel processes together in encapsulated modules where these functions were performed together
• Outlined development activities and estimates of process duration to schedule planning of process development
• Actively participated in revising development solutions to deliver accurate solutions, and design application solutions that fully implement business requirements.
• Designed and implemented application modules and unit testing of all requirements to ensure all basic functionality works, and errors are handled properly.
• Provided troubleshooting of application production issues
• Provided update to Users and Business Managers on work in progress, work completed, work planned, and issues potentially impacting the on time completion or quality level of work.

Confidential

SQL, Application, Report Developer / Data Analyst Contract Position 5/2013-6/2013

• Special Contract -Client proposed Short-Term 2 month contract, to meet a critical business deadline
• Growth in BNP's banking business required utilizing technology expertise to further develop financial software to incorporate new branches, portfolios, and folders for new business into trading and reporting applications
• Developed reports and apps using T-SQL, Sybase and VBA to add new and monitor existing Treasury and Corporate Deposit and Loan business and transactions
• Worked directly on Trading Floor with Front Office to modify and develop Reuters Kondor financial software for Analysts to use as their primary trading tool
• Modified/created Balance Sheet Report summary and detailed analysis , Intraday Report, Overnight Report and other financial reports using T-SQL scripts, VBA, SQL/Sybase and Excel
• Created Excel Spreadsheets/Reports, and VBA Macros to automatically update Excel workbooks with trading data, quote data and other kinds of financial data requested by clients
• ETL, and script creation/modification of exceptionally large data sets in SQL and Excel
• Modified auto-upload and download of Reuters Kondor and SQL/Sybase large data to and from multiple Excel spreadsheets
• Developed and enhanced Excel VBA code to generate reports and enable them to operate more efficiently
• Created and modified complex Excel VBA scripts that interfaced directly with complex Sybase/SQL scripts
• Utilized query and macro functionalities to insert asset and liability data directly into reporting tables and reports

Confidential

• Applied Excel automation to enhance ETL of data and reporting capabilities
• Designed and modified SQL Queries, Stored Procedures, Triggers, etc., to extract data from SQL/Sybase database directly into Excel reports
• Modified Excel VBA code to connect Excel directly to SQL/Sybase database
• Managed and created extremely large data-sets using SQL/Sybase Queries, Stored Procedures, Triggers, etc.
• Used VBA code to automate data import/export to and from Excel and SQL/Sybase
• Compiled Excel Stored Procedures using Unix code, UltraEdit for modifications and Filezilla for uploads to Unix server
• Applied security for individual users utilizing XML file created with Excel VBA code
• Extensive reporting and automation to connect Reuters Kondor financial application
• Utilized strong Excel skills for advanced functionalities, including analysis, macros, spreadsheet design, etc.
• Utilized expertise with Excel development to apply functionality to macros and add-ins
• Applied knowledge of database normalization concepts and proficiency in SQL Server queries, stored procedures, triggers, and complex joins
• Applied background knowledge in data-feeds, including market data and internal feeds to access data from Kondor financial trading application to create/modify reports
• Utilized background in data integration, application connectivity, and data aggregation
• Utilized expertise in business intelligence analytics to clearly decipher documented project scope requirements and enable the design/modification of interfaces with Bank application
• Communicated with IT staff and business clients including Front Office while providing deliverables under tight deadlines.
• Leveraged analytical skills to analyze system data to determine trends and actionable intelligence needed to take financial application and reporting system to next level adding new branches, portfolios, and folders to BNP's business .
• Applied numerical and statistical analysis of financial data and reports
• Implemented system performance testing and analysis throughout scope of project

Confidential

Application Developer / Global Data Analyst

• Technology/Programming/Business Intelligence Initiatives
• Used scripting languages VBA and T-SQL and applications SQL Server Management Studio SSMS/SSIS, MS Excel and MS Access to ultimately produce financial and business reports
• Mathematical and technical calculations created in Excel to analyze and organize data to produce reports reflecting business and financial operations.
• Used T-SQL, Access, and SQL to manage the integration of large data sets and data technology, as well as advise and consult on procuring new methodologies or technologies as a need was identified
• Used T-SQL, VBA, and complex formulas for computational analysis to transform large data sets into results oriented data, visualizations, and/or reports
• Transformed, manipulated, and charted data ETL using T-SQL/SQL, Excel, and ACCESS, into various reporting formats
• Managed large, complex data sets, with strong attention to detail to ensure accuracy of reporting information
• Organized reports in Excel as comparative analysis of current and historical data to enable client to evaluate trends in spending, profits, and associated risks
• Used knowledge of databases to design, create, modify and support databases, stored procedures, and perform query analysis of data using SQL Management Studio SSMS/SSIS and MS Access
• Collected, organized, and analyzed data into business and financial reports for client to use to track and improve their expense/financial decisions and business practices.
• Created databases and programs using MS Access and Excel to generate charts, graphs and other visualizations that reflect identifiable trends, data analysis
• Contributed to the creation of business requirements and programming specifications, by anticipating business related and data analysis issues, while recommending technical solutions
• Leadership Skills
• Provided leadership on business intelligence initiatives by uniting efforts of all team members, and translating these efforts into data and reports that met the client's goals and needs
• Worked independently on reporting projects from inception to completion including data ETL, manipulation, and report creation
• Worked on aggressive project schedules, beyond normal hours weekends or evenings to support turnaround of reports within 2-3 business days, to meet stated deadline in Service Level Agreement
• Independently managed the day-to-day activities of the reporting process for all scheduled and ad-hoc reports

Confidential

• Managed all reporting tasks from Service Level Agreement, Data Extraction, to Report Creation to ensure adherence to all deadlines
• Operated in a fast-paced, high demand environment with quick turn-around times
• Communication and Liaison Initiatives
• Conferred with system analysts, business and technical managers, personnel and customers to resolve problems of inaccuracy or feasibility, output requirements, input data acquisition, coding use and modifications and inclusion of internal checks and controls
• Consulted with and Liaison between Technology, Business Management, and Clients to ensure reporting of Key Metrics to client and production of Adhoc Reports
• Consult with MIS on technology issues, integration projects, as needed to resolve or change project issues and related components
• Demonstrated excellent verbal/written communication skills to communicate across all lines of business, with client staff, business management, and other internal staff members, to coordinate and facilitate work in a team environment.

Confidential

Application Developer Business Analyst

• Gathered information to understand the present organization and flow of client's operations
• Analyzed current business operations and future business requirements
• Organized information gathered to establish a link between business requirements and technology needs
• Provided report s to outline business operations and current/future technology needs to achieve long-term business goals
• Streamlined business functions by designing automated applications, database applications, and reporting solutions based upon analysis of business operations and requirements
• Developed specs, generated source code, maintained and enhanced computer applications
• Automation of manual processes, programming of SW, application development and database design using VB, VBA, MS ACCESS, EXCEL, SQL, Sybase, MS Office Suite, and other technologies
• Developed EXCEL VBA programs to facilitate the use of financial data
• Provided troubleshooting and support services for new and existing computer applications
• Integration of changes and testing of applications during each phase of development, until completion of application development
• Communicated with Users during each phase of application development
• Incorporated changes and implemented User Acceptance Testing to employ Quality Controls
• Provided Final Testing and End User Data Analysis, Training, and Technical Support for automated processes developed

Confidential

Application Developer / Computer Consultant Contract Position

FINANCIAL TASKS

• Worked directly on Trading Floor of Investment Banking division GFLM/CIO as a Rapid Applications Developer RAD , interfacing with and providing application development services for Front Office Traders , and Middle Office, Analysts, and Management.
• Worked with Investment Banking IB Technology team to coordinate and develop new global financial system and tools to replace legacy systems which measure current financial metrics provided by Reuters, IRFE and Back Office Systems, all ultimately used by Traders to make instantaneous and long-term decisions
• Analysts were able to instantaneously evaluate their individual portfolios by inputting the COB Close of Business Date and selecting their name. A report was created that included the following:
• Trade Description type of trade
• Product Treasuries, Equities, Foreign Bonds, Swaps, Munis, etc.
• Strategy
• RISK
• Basis Point Value BPV for the Spread or Duration
• VAR
• Vega, Theta, Gamma
• NOP Net Operating Profit
• Prices Closing Entry
• P L's Daily, Weekly, Monthly, Year
• Portfolio Reports were generated using VBA and Excel which included Duration, Spread, VAR, Vega, Theta, Gamma, Closing Price, Entry, Daily P L, etc.

TECHNICAL TASKS

• Involved with the entire lifecycle of projects from gathering requirements to application development and maintenance
• Development, enhancement, and provided support/ management/ troubleshooting services for Front and Middle Office systems using
• Reuters application and market data
• SQL, SyBase queries and stored procedures

Confidential

• VB/VBA object oriented programming, ADO, functions, classes
• EXCEL and ACCESS advanced queries, functions, ADO
• UNIX shell scripts/commands and PERL modifications
• Accessing this broad range of pricing and real-time market data expedited business analysis and generation of linked reports
• Interfaced with data layers using SyBase and various systems for use with designed applications used by Traders
• Used technical expertise, knowledge of financial market data, and mathematical analysis, from inception of project through test and production phases
• Investigation, troubleshooting, and resolution of program application tools
• Regularly attended in-company sponsored Financial Training Classes provided for the development of financial skills

Confidential

Application Developer / Business Analyst

• Programming, Business Analysis, Project Management, IT Services:
• Provided the following services for various departments Accounting, Financial Controls e.g. Equity, Financial Analysis, Financial Planning, Wealth Management, Risk Management , Communications Center, New Business Unit, Tax, Escheat, Employee and Investment Products Groups, Shareholder Relations, Human Resources Mgt. Outsourcing :
• Designed and created software applications to automate the processing of information for budget forecasting and analysis, dividend checks, stock and cash options, trades executed and cleared, accounts payable/receivable records, tax documents, reconciliations, units used to track and measure employee and business performance, state filings for unclaimed property, etc.
• Program/SW application development and database design using VB, VBA, MS ACCESS, EXCEL, SQL, Sybase, MS Office Suite
• Sole Developer for the automation of Mellon's manual operations in NJ offices
• Developed, implemented and supported VB/VBA applications in client/server environment
• Implemented databases, automated applications, and financial reporting packages for NJ Offices using VB, VBA, MS ACCESS, EXCEL, SQL, Sybase, ODBC, DAO, DLL's, COM, ActiveX Components, Win API, multi-tier architecture, etc.
• Analyzed software application performance to provide enhancements in design and Access database structure
• Debugged existing applications to fix run-time errors, modify GUIs and enhance reporting schemes
• Used MS Access and EXCEL VBA modules to improve error-handling routines and streamline code using Access/Excel/VBA/ODBC/ADO/ActiveX and Win API tools.
• Conducted discovery meetings with Department Managers and End-Users
• Developed software requirements for new products and enhancements to existing products
• Gathered, analyzed, and documented software product requirements and business specifications
• Developed documents to outline detailed requirements specifying business process and functional requirements using diagrams, flowcharts and other tools
• Managed and tracked changes to requirements throughout the development, testing and maintenance lifecycle, maintaining accurate documentation at all times.
• Maintained continuous communication with Managers and End-Users throughout development and testing lifecycle to ensure final product meets requirements and expected outcomes
• Employed Quality Assurance throughout project cycle by developing and executing test plan and scripts.
• Provided modifications, and problem solving throughout User Acceptance Testing.
• Provided End-User training, manuals and instructional documentation.
• Provided maintenance, future upgrades/enhancements and troubleshooting services
• Played an instrumental role in the company's growth by providing CEO, COO, Executive and Senior Management with technically developed financial reports which provided budget forecasting, staffing predictions/analysis and division/company performance evaluations
• Functioned solo as Project Manager and Program Developer for all business solutions, by developing and compiling data, designing automated applications, testing and implementing software applications developed
• Developed detailed business project plans to outline company's operational and technology objectives. Plans include key stakeholders, value added outcomes, program automation objectives, technologies leveraged and detailed description of scope of mission s of technology project.
• Provided advanced troubleshooting, technical support and training for all applications, designed using VB/VBA, SQL, SyBase and MS Office Suite

Confidential

Application Developer / Business Analyst

• Programming Responsibilities:
• Worked in Financial Office Environment i.e. Financial Analysis, Investment Banking, Wealth Management Divisions and, directly on Trading Floor providing development solutions for global financial applications, which are used by Traders and Middle Office.
• Enhanced the development of applications which interfaced with Reuters, IRFE and other external feeds, used to supply portfolio positions and financial valuations.
• Functioned as Applications Developer to design and implement business and database applications using VB, VBA, MS ACCESS, EXCEL, SQL, Sybase, MS Office Suite
• Develop, implement and support VB/VBA applications in client/server environment
• Develop EXCEL VBA programs to facilitate the use of financial data, charts, and graphs
• Troubleshooting: Desktop and network applications
• IT Responsibilities
• Provide LAN/WAN and workstation technical support for US and overseas operations
• Install, upgrade, and troubleshoot PC's, printers, peripherals, laptops, and PDA's
• Rollouts and migration of new computers and all software packages
• Troubleshooting MS Office software writing VB/VBA programs for MS Office Suite Install, configure, and troubleshoot MS Office software, market data and other applications
• On-site, remote and overseas Helpdesk services in high call volume environments
• Maintain physical network systems including hubs and cabling
• Troubleshooting: LAN/WAN, desktop PC's, laptops, printers, PDA's, peripherals, etc.
• Provide training for users operating hardware and software systems
• Documentation of software training materials and maintain hardware records