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 Business Intelligence and Software tools to build models using the following:
• Compile and aggregate various sources of raw data from live (streaming data) and static (flat files, databases, spreadsheets, etc.) feeds
• Characterize, clean, transform, and partition data for processing
• Descriptive statistical methods such as Central Tendency (Mode, Median, Mean), Distribution of the Data (Standard Deviation, Variance) and Inferential Statistical methods (Confidence Intervals and Hypothesis Tests) to further
• Summarize data, exploring, and quantifying relationships that exist between data members
• 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 - Microsoft, Oracle and Sybase) and in applications, using data generated from live and static feeds in a variety of formats, and employing Query Optimization and Tuning
• Experience working with aggressive project schedules to meet the demands of a high paced environment
• Experienced with the use of the many features of SQL Server Business Intelligence (BI) tools (SSIS/SSAS/SSRS) in conjunction with Visual Studio to create Control Flow and Data Flow Tasks with Debugging and Breakpoints incorporated; Deploy packages for the scheduling of jobs from SQL Server (SSMS), using the following:
• SSAS - to develop Fact and Dimension tables into multidimensional Cube structures for comparative data analysis and data consolidation
• SSIS - to create Control Flow and Data Flow Tasks, for Data Profiling, Data Cleansing and Data Quality Analysis, ETL of data, FTP of data; Data Flow Transformations created to manipulate SQL scripts, Copy columns, create Derived Columns and Expressions, Aggregate Functions, and Variable Expressions
• SSRS - for the creation of reports interfacing with Datasets to produce customized formats

TECHNICAL SKILLS:

SKILLSProgramming: Microsoft SQL (T-SQL), Oracle SQL, Sybase SQL, SSIS/SSRS/SSAS - SQL Server Integration /Reporting /Analysis Services, Sybase, C# Knowledge, Hadoop, VisualStudio, VB, VBA, Classes, COM, ADO, API, XML, XMLA, 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 (UNIX Shell Scripting) DOSFINANCIAL -Knowledgeable of Risk/Return Analysis, Quantitative Measures, and Financial InstrumentsSKILLS -Quantitative Analysis - Monte Carlo Simulation, Capital Asset Pricing Model (CAPM), Regression

PROFESSIONAL EXPERIENCE:

Confidential - New York, New York

SQL Developer, Application Programmer, Report Developer / Data Analyst / Business Analyst

Responsibilities:

• Worked independently and as Technical Lead Developer / Operations Expert employing a wealth of Technology Services (see page 3 for technology details), for Project Management (PMO) Business and Financial Operations, while also providing support for PMO Planview Operations.
• Worked in Operations to develop Confidential ’s Core Business and Financials managed by the PMO Group. This division creates, manages and implements businesses and services offered to Confidential ’s clients, generating the Revenue for Confidential, which is responsible for the company’s stronghold of the market share in its industry. At any given time, more than 100 business/finance projects were being managed in the PMO pipeline, necessitating the quick generation and delivery of Business and Financial Reports, summarizing operations employed for the release of each phase of every project.
• Worked with PMO and Financial Executives in WebEx and Conference Meetings with Planview to identify and resolve issues related to the integration and upgrade of vendor (Planview) maintained Big Data with Confidential operations
• Limited scope of outside vendor, Planview, reports and data provided: did not allow the use of Financial Concepts like the creation of the Efficient Frontier Curve (combination of projects with the more optimal return), to validate the Financial expectations produced by Finance Team, did not allow use of Business Analytics in report development
• High latency periods due to data transmission over lengthy remote network lines between PV and 3rd party vendor sites to Confidential ’s desktops, caused long wait times for reports requested by users to be created on their desktop
• With an understanding of the PMO business/financial needs, PMO data and using advanced technology skills, I was able to implement the necessary technology, management and user requirements, and troubleshoot problems encountered with the transfer of data from Planview’s site to Confidential ’s site
• Reconstructed PV’s limiting and simple reports into Analytical Reports that reflected the actual PM Operations
• Established a Direct pathway to obtain Confidential data, which enabled the use of Key business and financial data needed to in corporate Business Analytics into PMO Reporting
• Created Productivity and Financial Reports representing Key Indicators of the Business
• Created new reports reflecting historical and current operational and financial trends, for improved analysis and reporting of PM Operations
• Incorporated use of CapEx and OpEx data into business and financial reporting, which eventually flowed into the creation of Financial Reports (Income Statement, Balance Sheet, Statement of Cash Flows, Executive Management Reports, etc.), and enabled the production of Financial analysis like the Efficient Frontier Curve
• Participated in meetings with other Client Reporting Divisions to enhance development of Confidential global reporting structure and systems
• Passthrough Queries created to obtain live data from SQL Database, to develop advanced VBA Scripts, Tables, Queries and Forms used in the creation of business and financial reports
• Created the direct download of web data into Access for use in generating reports
• An Interface between Access and Excel enabled additional data manipulation and calculations used to generate operations and financial reports
• Produced automated processes for expedited creation of reports
• Automated processes released to business population enabled business users to independently manage the creation of their reports
• Provided advanced development of report creation, to streamline the next level of data presentation/report creation for the Operations Progress Report
• Created VBA Scripts, Queries, direct data Connections to SQL, and MS ACCESS interface to obtain data used in EXCEL to generate business and financial reports
• Directly downloaded and incorporated SQL data into EXCEL to create business and financial summary analysis in the form of Pivot Tables, complex Charts, Graphs, and Advanced Reporting Designs
• SQL data in Excel enabled complex Calculations in reports, to organize and group business and financial data by divisions by dates (Quarters, Years, Months, Historical and Current, etc.) for high-level financial and operations analysis and the analysis of trends by CapEx and OpEx categories to enhance the generation and validation of the Balance Sheet, Income Statement and Statement of Cash Flows, captured in Financial Reports to reflect the productivity of business operations relative to financial expenditures
• Created Stored Procedures, Complex Queries, Joins, Triggers, Views, Functions, Tables to enhance complex database needing modifications and updates to accommodate new Business Analytics Reports
• Cleansed SQL data using SSIS and Data Profiling Task to Cleanse Data
• Created direct Connections to SQL from within Visual Studio
• Created SSIS Data Flow and Control Flow Diagrams to extract, transform and load data between SQL, Visual Studio, Excel, and Access
• Created reports using SSRS from data extracted using SSIS, and data manipulated using SSAS
• Created an email application in Visual Studio to send emails to Program Managers and Management highlighting deficiencies identified in analytical reports, which resulted in the overall improvement of PM Operations
• This Key Alternate Route provided access to all of Confidential ’s financial and operational data, which opened the door to move Confidential PMO Reporting to the level desired by Financial and Operations Executives. With this discovery, several major improvements were implemented into business operations:
• Business Analytics and Financial Analysis of PM Operations could now be incorporated into the reporting of financial and operational data. Unification of a full scope of business and financial data enabled the analysis and validation of business assumptions using the actual operations data, which provided an accurate account of Financial Analysis of PM Operations
• This new information was ultimately summarized in the development of Productivity and Financial Reports for Executive Management which reflected Key Indicators of the Business, and allowed a thorough evaluation of how PM Operations and Finance were working together to accomplish goals identified by Finance. This ultimately provided information and findings to enable Executive Management to improve their decision-making process
• I was able to work independently to dissect, analyze and understand the SQL database architecture, system design, and advanced database development constructed over several years by the outside vendor, Planview and their IT Team
• The SQL System contained over 1,000 objects, including Stored Procedures, Complex Queries, Joins, Triggers, Views, Functions, Tables, Flat table structures to generate hierarchical structures and views, data structures used in conjunction with SSIS, SSAS, and SSRS, and other Business Intelligence Tools.
• Understanding the complexity of this advanced SQL System had to be accomplished within a very limited time span, in order to maintain the continuity of operations, and not interfere with the large quantities of projects in the pipeline, and their various phases
• Understanding of how this complex array of SQL architecture functioned, enabled Confidential to operate independently, and eliminate the need for and costs associated with outside vendor management of Planview reporting, which resulted in a significant cost savings for Confidential .
• With the understanding of this complex SQL structure/database created by the outside vendor’s IT Team, I was able to identify a pathway of direct access to obtain Confidential ’s PMO data needed to move Business and Financial Reporting to the required advanced level. This direct data access pathway identified, also alleviated the need to create reports by accessing data remotely over complex network lines from the outside vendor’s site, to Confidential ’s site and desktops.
• This direct access of PMO data for report creation, resulted in the re-structuring of Confidential ’s PMO reporting process, which included some of the following improvements:
• Re-negotiation of the outside vendor’s contract for development of the complex SQL system, which resulted in the removal of astronomical costs incurred by Confidential, while using the outside vendor to develop and manage a complex SQL System and Development of Reports. Savings from the re-negotiation translated into funds for increased headcount for the PMO Group (additional PM employees added to Confidential staff). Direct access of S data also enabled Confidential ’s PMO Group to create their own advanced Key Indicator Reports in-house. The new reporting structure incorporated the required advanced data analysis requested by Operations, Finance, and Executive Management, while also enabling the in corporation of Business Analytics into the PMO reporting structure. The resulting reports created highlighted productive and problematic operations used for process improvements
• Removal of remote data transmission for report creation which caused high latency periods. Direct access of the PMO data, for report creation, increased report generation efficiency by more than 90%.

Confidential - Jersey City, NJ

SQL Developer, Report Developer / Data Analyst / Business Analyst

Responsibilities:

• With an understanding of the network data operations, tracked and reported on key data collected to monitor network security systems
• Managed millions of records of raw data collected on Firewalls to tell a story of the varying types of security in place and to assist in identifying system vulnerabilities
• Using SQL extracted raw data maintained on enterprise database server and developed complex TSQL scripts and queries
• Utilized Excel Pivot Tables to develop summary ad analysis of key indicators chosen for reporting
• Recommended Slowly Changing Dimensions to track historical and current data and changes in data stored on enterprise system
• Created direct connection between Excel and SQL using system interface and SSIS packages to expedite processing of queries
• Developed complex SQL scripts and SSIS packages to enable direct download of data from enterprise database to Excel direct import into reports
• Automated creation of reports using complex SQL Scripts, Stored Procedures, Triggers and Joins with Error Control, and using VBA, Excel, and Access
• Identified and determined which system parameters were key indicators to report, monitor and measure the effectiveness and efficiency of network security
• Quality assurance of network data was monitored and tracked using SSIS packages containing Data Profiling Task, Data Flow Component Error Output, Conditional Split Transformations.
• Generated weekly reports to identify and track the various types of network security existing across the enterprise system
• Tracking of operational data based upon security categories, to identify areas posing the greatest threat to the network security system
• Generated reports to track operations warehouse data related to security parameters currently in use and the rate of deletion of unused security parameters on the network system
• To mitigate security risk, created reports which included operational data stored in Excel files, Flat Files, and OLE DB source files
• ETL of operational data collected was conducted using SSIS packages including Control Flow Tasks with Bulk Insert Task, Script Tasks, FTP Task, and Data Profiling Task; and Data Flow Tasks including Execute SQL Tasks, Data Conversions, Derived Columns and Expressions, Aggregated/Sort/Multicast/Conditional Split/Union All/Merge Transformations
• Excel and SSRS reports generated provided an analysis and audit of the status of authenticated and authorized user accounts, permissions/privileges, and associated network firewall security codes
• Consistent monitoring of a multitude of operational data relating to the movement of users migrating from old to new network systems and defined user roles revealed a potential security breaches alteration and modification operational data was necessary to control and alleviate the security breaches revealed in consistent report analysis
• Established graphical reports on a departmental and regional level, which enabled quick and immediate identification of skewed trends, allowing for immediate resolution of potential security issues
• Used new Access Control Application process to develop reports on Key Indicators, which were evaluated to analyze the efficiency of network security operations
• Created SSIS packages, and modified previously existing packages to move and manipulate operational data from the Access Control Application to the Enterprise Server
• A multitude of big data needed to produce IT and client reports was easily accessible by modifying previously generated SSIS packages and complex TSQL Stored Procedures and Scripts
• Operational data collected using SSIS packages, included application requests submitted, approved, and rejected
• Generated reports used to track the number of new application requests
• Used Excel and SSRS to generate reports to monitor client and employee security access information processed in the Access Control Application
• Created reports to track IT team’s review of new application requests, to keep track of IT teams’ role in creating user network access, user connections, permissions, and firewall creation
• Monitoring of this collected operational data through reports generated on a consistent basis, contributed to controlling security access to enterprise network applications
• Reports generated tracked each IT employee’s role in the design, preparation, and implementation of user, network, and firewall security created to accommodate application requests
• Reports generated monitored the length of time required to design, prepare and activate network security implemented by IT team for application requests
• Created reports to track the current and obsolete authenticated and authorized user data and accounts
• Replicated database Tables and Views SSIS, SSAS, and SSRS Business Intelligence Tools
• Reproduced Tables and Views containing Firewall Policy data by transferring Big Data with historical and current data to SQL Server, using SSIS
• Complex TSQL and VBA scripts were used to create an interface between the SQL Server and Excel
• Created ODBC connections for direct data download of data from SQL Server to Excel
• Operational data was obtained from the manipulation of complex TSQL Queries, Stored Procedures, Triggers, Views, Indexes on SQL Server and used to populate Excel Pivot Table reports on the front end
• Automated the creation of graphical reports using Excel on the front end, for immediate analysis of operational data
• Created final network security reports and analysis using SSRS

Confidential - Florham Park, NJ

SQL Developer, Report Developer / Data Analyst / Business Analyst

Responsibilities:

• Worked in the financial department to automate the creation of financial analysis of chemicals manufactured and developed.
• Advanced use and knowledge of Excel, Pivot Tables, and PowerPivot was required, to provide a wide range of scenarios and summaries representing financial statements and reports.
• Eliminated the current MS Access databases by creating database and structure from scratch on SQL Server SQL, which was used for Microsoft SQL and Oracle SQL platform.
• Created interface between SQL Server and Excel Reporting Tool
• Incorporated SQL security features into design using SQL Server security and TSQL Scripts
• 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
• Developed graphical analysis of the Price-Volume Curve Risks with Straight Line Fit to identify Outliers
• 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 Price Chart Analysis to identify 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.
• Created database for Financial Division on SQL Server, which included generation of Schemas, Tables, Complex Queries, Stored Procedures, Triggers, Views, Accounts, Application Roles, etc.
• Used SSIS, BCP, and MS Access Upsizing Wizard to transfer all tables from Access to SQL Server
• Transferred Big Data (millions of records) to upload historical and current data from SAP into SQL using SSIS
• 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
• Designed, coded, and tested complex TSQL and VBA scripts to create an interface between the SQL Server and Excel
• Created application on the front end in Excel, with User Login Security, using Application Role scripts and SQL Server security
• Queries, Stored Procedures, Triggers, Views, Indexes, Constraints were created on SQL Server to obtain 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 between slow running queries and poor SQL Server performance
• Used BIDS to accommodate Big Data for the more complex drill down analysis needed with financial data
• Installed Visual Studio with BIDS (SSAS, SSIS, SSRS) for the eventual deployment of applications on MS Analysis SQL Server and to schedule jobs in SQL Server Agent
• Developed Dimensional Model, which included Fact and Dimension Tables, Cubes, Schemas, and Calculations
• Dimensional Model and Measures were created with Snowflake Dimension using Top Down Approach
• Applied Dimension Security for customized access to Dimension Data
• Deployed SSAS Cubes to SQL Server
• Cubes deployed to MS Analysis Server were used to create customized reports using SSRS
• Cubes were modified to adapt to User specific requests by implementing changes in Dimensions and Measures
• Cubes also interfaced with Excel to produce user customized reports and formats
• Employed SQL Query Optimization and Tuning when performance issues involving Queries and Stored Procedures were encountered
• Analyzed Stored Procedure scripts, associated Caching, and Statistics obtained from various Query Execution Plan Types
• Evaluated statistics of the Clustered and Non-Clustered Indexes, Filtered Indexes, and Tables on the Heap using Query Execution Plan, Seeks, Scans, and Bookmark/Key Lookups
• Performance Tuning Tools including Profiler, Dynamic Management Views (DMVs), and Dynamic Management Functions (DMFs) were used to optimize the functioning of scripts
• Encountered deadlocking in production application when multiple users attempted to access and use the Sales and Analysis application features
• Employed Deadlock analysis and prevention techniques to detect and understand the causes of deadlocks, which included changing code and the use of locking commands (e.g. Isolation Level commands)

Confidential - New York, NY

SQL Developer, Report Developer / Data Analyst (Contract Position)

Responsibilities:

• 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 Microsoft SQL and Oracle Servers. Associated scripts and reports were moved to web based technologies using SSIS, SSAS, SSRS, 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 BI tools, TSQL, 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 issues:
• 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
• 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
• Explored the use of SSAS/SSIS/SSRS for more extensive development of SQL data in Excel
• Fact and Dimension Tables were created using tables on SQL Server
• Cubes created using Top Down/Bottom Up approach
• Cubes were configured to include Measures and Dimensions for Reporting Services reports in SSRS
• Cubes were modified with changes in Dimensions and Measures to adapt to User requests
• Cubes interfaced with Excel to produce user customized reports and formats
• 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
• Used XML to create and modify Excel and Access menus to house application commands
• Created and revised TSQL/SQL queries and stored procedures to process, analyze and move big data and implement data integrity initiatives for various business units.
• Used SSIS/SSAS, 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 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 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 transfer BRD’s into technical applications and 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 for 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 of work.

Confidential - New York, NY

SQL Developer, Report Developer / Data Analyst

Responsibilities:

• Developed new financial reports and applications to in corporate the financial activities of the new branches added to the business.
• Used T-SQL, Sybase and VBA to add new and monitor existing ALM / Treasury and Corporate Deposit and Loan business transactions
• Worked in Front Office, directly on Trading Floor, to modify and develop Reuters Kondor financial software for Analysts to use as their primary trading tool
• Modified/created Balance Sheet Reports (summary and detailed analysis), Intraday Reports, Overnight Reports and other financial reports using complex T-SQL scripts, VBA, SQL/Sybase and Excel
• Created Excel Spreadsheets/Reports, and VBA Macros to automatically update Excel workbooks with Transfer Pricing Data, trading data, quote data and other financial data requested by ALM and clients
• ETL, and script creation/modification of exceptionally large data sets into SQL and Excel
• Modified the auto-upload and download process 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
• Applied Excel automation to enhance ETL of data and reporting capabilities
• Designed and modified SQL Queries, Stored Procedures, Triggers, to extract data from SQL/Sybase database directly into Excel
• 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 Shell Scripting, 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