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
• 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:

TECHNICAL SKILLS:

SKILLS Programming: Microsoft SQL (T-SQL), Oracle SQL, Sybase SQL, SSIS/SSRS/SSAS - SQL Server Integration /Reporting /Analysis Services, Sybase, C# Knowledge, Hadoop, Visual Studio, 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, UltraEditFileZilla, Internet & Email Programs

OS: Windows - All Versions, UNIX (UNIX Shell Scripting) DOS

FINANCIAL SKILLS:

• Knowledgeable of Risk/Return Analysis, Quantitative Measures, and Financial Instruments
• 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
• Managed from inception to completion, a variety of technical/financial projects to produce a synopsis of 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.

PROFESSIONAL EXPERIENCE:

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 OLEDB 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

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 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 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

Confidential, New York, NY

Application Developer / Global Data Analyst

Responsibilities:

• 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
• 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
• 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
• 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, Kearny, NJ

SQL Developer, Report Developer & Business Analyst

Responsibilities:

• Gathered information to understand the present organization and flow of client's individual business operations
• Provided Executive Summary for client of their current business operations and necessary requirements for implementation of requested application automation services to be provided by Confidential
• Developed flowcharts to outline recommendations for implementation of application development
• Provided periodic progress reports to client outlining testing and implementation of phases of application development into current business operations
• Generated complex TSQL Queries, Stored Procedures, Triggers, Views, etc. to interface with EXCEL and ACCESS Reports on Front-End
• Customized business and financial reports created using EXCEL and ACCESS on the front-end, interfacing with SQL Server on the back-end
• SQL Business Intelligence package (SSAS/SSIS/SSRS) used for data migration, development of Cubes, and customized reports
• Data from various feeds was analyzed for quality, formatted, and migrated to SQL Server using SSIS
• Tables on SQL Server were used to create Fact and Dimension Tables in SSAS
• Cubes created with Measures and Dimensions and deployed to SQL Server
• Cubes on SQL Server were used to create customized reports using SSRS
• Final testing of applications and End User Data Analysis, Training, and Technical Support for automated processes developed
• Provided ongoing troubleshooting and support services for applications deployed into production, as well as for client’s existing computer applications