Sql Server Power Bi

KEN C. ALVAREZ

Mobile 201-***-****

***.*.*******@*****.***

SOFTWARE:

SQL Server, Sybase, MySQL, VBA - MS Excel/ MS Access (all versions), Microsoft Power BI, Microsoft Teams, Rapid Sql, VB Scripting (.VBS), JIRA, HTML, XML, Tableau, LimeSurvey, Visual Basic.net, Service Now, SharePoint, People soft, MyPhp Admin.

Market Data Applications - Bloomberg API Development, Reuters Market Data (Eikon, DACs and Tibco), FACTSET

Microsoft Cert. - Analyzing Requirements and Defining Solutions

Banco Santander International, Miami FL Sept 2022 to Dec 2024

Senior Developer for Equity Derivatives Group – Derivatives Trade Support

Extensive Project Planning, organize manage and control of new projects. Meeting deadlines for audit and compliance issues.

Regional development lead for in house trading and reporting systems built primarily in VB, SQL server, Sybase

Supporting all DBA activities for distributed/multi-tier systems and application development, including programming languages such as Shell, Python, VBA and Java

Forecasting and physical data models Knowledge of products like Hackolade, ERStudio

Calculate option Volatility, EOD Price marking, interest rate Swaps Risk and Nonstandard Option Reporting.

Partner with business, engineering and tech teams to leveraging data across the firm.

Options in the money on expiry, develop an Excel application with Bloomberg API, Sybase and MS SQL Server to report.

Define database requirements and build into conceptual, logical, physical database design

Build pricing and Risk analytic sheets leveraging off the Firm’s standard analytic libraries and COM components

Algorithms, build, develop and design Algorithms that define a set of rules that precisely predict a sequence of operations.

Middle Office-Create Scorecard applications with reusable stored procedures, tables and triggers in Sybase and MS SQL Server to store and reconcile trade/derivative and order info.

Metrics and Derivative reconciliations in Excel with Pivot tables against Reuters and Bloomberg. Check underlining trade metrics and check against options post expiry.

FTP Text files - Load to Sybase or SQL Server. Create stored procedures and Excel interface to pass parameters and display results in user format. Example Loading Risk Data VOL, Gamma, Theta from Vendors to trading server.

ETF Trading - Use Excel, ADO, Bloomberg API to compare ETF components match Market. VBA to build CSV trade file and auto upload threw BCP and VBScripts to Sybase and SQL Server.

Email Applications - Build stored procedures, pull order and trade data, format and put in Email for Trade Recaps, Commissions by Broker, PnL, Broker-Dealer Activity and Corp Action mailers.

Quantitative investing develop algorithms to find predictable trading patterns, risk management and derivatives pricing.

Working with OTC and Fixed Income groups to define and streamline EOD processing and workflow.

Interact directly with Clients of the firm weekly, for custom reporting, Auto-Emails and FTP’s into their systems. Ensure Current relationships stay strong. Also Build proposals and sample file for courting new customers.

Franklin Templeton Investments, Fort Lauderdale June2018 – Feb2022

MS SQL Server, VBA for Excel and Access, Bloomberg API and functions, VBScript, BAT files and FTP for Front and Back Office reconciliations and for the automation of redundant tasks.

Extensive Project Planning, organize manage and control of upgrading Bloomberg Networks throughout the firm. Upgrade to B-pipe and manage the upgrade of all Bloomberg circuits in each location worldwide.

Microsoft Power BI - Extensive report automation and creation. Gather requirements, plan, organize and build reports. Creating Sql Extracting data from multiple systems compressing and cutting data.

Use Excel with Bloomberg API, Sybase and MS SQL Server to report and calculate option Volatility, EOD Price, interest rate Swaps and Nonstandard Option Reporting And determine if Options are in the money on expiry.

Reuters Eikon, full range of support and Coding within the Eikon Excel Addin

Reuters DACs, responsible for administration of access and entitlements provided to users.

Build Option expiry Application, Excel with Bloomberg API, Sybase and MS SQL Server to report in the money Option.

Risk Reporting - Created Access/Excel Macros and Addins, TSQL & Bloomberg API to report on:

Delta, Gamma, Vega, Theta and RHO. Fixed Income - DV01, Duration and Convexity.

MediMix International, Miami Fl March 2017 - June2018

Sql Server Developer/Data Analyst

Development lead for SQL database and client reporting systems built in SQL, Excel VBA, LimeSurvey and Tableau.

Design technical infrastructure to manage data flow from a global network of doctor’s data on cancer treatments and control data flow to account Project Managers to for sale to pharmaceutical companies. Create Database Table structure with joining keys

Excel/Sql Server utilize VBA/ADO and SQL to extract data, compress and cut data into Simple automated reports

Create Excel applications to Reconcile data breaks and anomalies. Create, Evaluate and Execute solutions and keep audit trail

MySql Sever create Stored procedures, Routines, Views and Queries

Database Administration create user id’s, drop locked connections, reindex tables and preform database maintenance operations.

Design user friendly Spreadsheets to preform complicated SQL server tasks and extraction of data for QC. (Quality Control)

Create data flow thru Sql Databases with calculations for Spider Charts

Providing Technical support and Automated data reconciliation applications.

Algorithms, build, develop and design Algorithms that define a set of rules that precisely predict a sequence of operations.

Extensive Excel VBA coding creating centralized code repository in the form of Addins and compiled XLA’s

Integrate MySql Server with local Excel spreadsheets with VBA Code

Senior Data Analyst / SQL Developer and Microsoft VBA consultant. Translate Doctor survey numbers into plain English and reconcile any data breaks, Handle cancer drug sales figures, market research and Gene or treatment sequencing data. Current position is to take that data and use it to help companies make better business decisions.

Nomura, New York NY` July 2011 to July 2016

Senior Development Manager for Excel trading system

Development, Enhancements and Debugging of the Totoro in house trading system built on a Excel platform,

Technologies include Heavy usage of Sybase, MS SQL Server, VBA for Excel and Access, Bloomberg API and functions, VBScript, BAT files and BCP for Front and Back Office reconciliations and for the automation of redundant tasks.

Extensive report automation and creation. Gather requirements Plan, organize and build reports. Creating Sql Extracting data from multiple systems compressing and cutting data into Simple automated reports. Using Excel,Accesss,Crystal,SQL,Sybase.

Use Excel with Bloomberg API, Sybase and MS SQL Server to report and calculate option Volatility, EOD Price, interest rate Swaps and Nonstandard Option Reporting And determine if Options are in the money on expiry.

Build pricing and Risk analytic sheets leveraging off the Firm’s standard analytic libraries and COM components

Algorithms, build, develop and design Algorithms that define a set of rules that precisely predict a sequence of operations.

Extensive Excel VBA coding creating centralized code in the form of Addins and compiled XLA’s

Microsoft sql server ’08 Maintain replication across global platform, Ensure Server performance and stability

Maintain/create/repair Autosys jobs for trade risk analytics, PnL and database maintenance jobs.

JP MORGAN CHASE, New York, NY March 2005 to MAY 2011

Senior Developer for Equity Derivatives Group – Derivatives Trade Support

Extensive Project Planning, organize manage and control the absorption of Bear Stern assets. Meeting deadlines for audit and compliance issues.

Regional development lead for in house trading and reporting systems built primarily in VB, SQL server, Sybase

Calculate option Volatility, EOD Price marking, interest rate Swaps Risk and Nonstandard Option Reporting.

Options in the money on expiry, Develop an Excel application with Bloomberg API, Sybase and MS SQL Server to report.

Build pricing and Risk analytic sheets leveraging off the Firm’s standard analytic libraries and COM components

Algorithms, build, develop and design Algorithms that define a set of rules that precisely predict a sequence of operations.

Middle Office-Create Scorecard applications with reusable stored procedures, tables and triggers in Sybase and MS SQL Server to store and reconcile trade/derivative and order info.

Metrics and Derivative reconciliations in Excel with Pivot tables against Reuters and Bloomberg Using C# and .Net out of process. Check underlining trade metrics and check against options post expiry.

Build C# application to Run Morning Jobs and Create custom Launch Menus.

FTP Text files - Load to Sybase or SQL Server. Create stored procedures and Excel interface to pass parameters and display results in user format. Example Loading Risk Data VOL, Gamma, Theta from Vendors to trading server.

ETF Trading - Use Excel, ADO, Bloomberg API to compare ETF components match Market. VBA to build CSV trade file and auto upload threw BCP and VBScripts to Sybase and SQL Server.

Email Applications - Build stored procedures, pull order and trade data, format and put in Email for Trade Recaps, Commissions by Broker, PnL, Broker-Dealer Activity and Corp Action mailers.

Quantitative investing develop algorithms to find predictable trading patterns, risk management and derivatives pricing.

Working with OTC and Fixed Income groups to define and streamline EOD processing and workflow.

Interact directly with Clients of the firm weekly, for custom reporting, Auto-Emails and FTP’s into their systems. Ensure Current relationships stay strong. Also Build proposals and sample file for courting new customers.

Tibco Messaging - Excel opening listeners and send requests for both snap shots and spooling requests.

SAC CAPITAL ADVISORS, Stamford, CT June 2003 to February 2005

Senior Programmer – Excel/Access/SQL Consultant and Bloomberg API Developer

Lead developer for multi-tiered applications using Excel and Access VBA and Bloomberg for MIS Projects.

Wrote VBS Scripts to execute FTP’s then validate data and execute VB applications.

Created SQL architecture Stored Procedures, Triggers and Tables to Update, Insert and Store data.

Developed VB Applications to retrieve Bloomberg data via API calls, use ADO to update server.

Designed Excel Interface with Querying ability (ADO), Versioning, Bloomberg and Factset links.

Risk Reporting - Created Access/Excel Macros and Addins, TSQL & Bloomberg API to report on:

oGreeks – Delta, Gamma, Vega, Theta and RHO.

oFixed Income - DV01, Duration and Convexity.

Wrote and Excel FX-Pricing application using XLA add-ins and XML.

Resolved Price breaks and Mark to Market.

Corrected Price and P&L breaks.

Generated inverse trades to flatten positions at the end of day.

Developed Excel Instant Trade Pricing Tools and P&L reporting Positions by Sector.

GOLDMAN SACHS, New York, NY May 2002 to June 2003

Project Leader –VB, Access, Excel Macro Developer and VBA Consultant

Planned, organized and led a team to build balance sheet program to Report Derivative Risk Exposure. Used Access and Excel VBA macros with SQL Server.

Global client server application was designed with SQL 7 stored procedures, Access DB Replication and Excel VBA code with pivot tables to update balance sheets worldwide.

Built daily Controller P&L applications in Excel and Access for EQ, MortBk, FI and FX. Spreadsheets Send Daily P&L estimates and prior actual numbers to SQL Server.

Build Derivatives Price verification. Data from Bloomberg/Factset vs Traders price.

Created analyst application for firms cost to borrow money, using Excel and Access VBA to build interest rate curves from 1 to 30yr Compared to “Lombard” Curve Data.

Using Black-Scholes pricing in SQL and Excel to create controllers pricing tools.

Creating Central code depositories to store XLA addins and INI files, Excel macros detect upgrades in Code .INI file and self-update daily.

DEUTSCHE BANK, New York, NY January 2001 to May 2002

Senior Programmer - Macro Developer and VBA Consultant

Programmer developing applications for offsite client’s responsibilities include:

Developed custom Access applications for hedge funds, Options and Future Pricing

Specialized in custom Hedge Fund and Equity Derivative reporting.

Created Shares Outstanding, Profit/Loss Curves and Risk Assessment Reports.

Debugged and redesigned applications written in VB and VBA for Access and Excel.

Defined Traders’ requirements, programmed, debugged and rebuilt existing Access and Excel applications for new requirements or new severs.

Reported OTC P&L and trade breaks for high net worth clients and company portfolios.

Created Access and Excel macros using VBA code to update P&L and FOREX MTM Built full user interfaces with Pop ups, forms and logon screens.

Used data from Faxset and Bloomberg to generate PL and Compliance reports.

Designed and set up FTP downloads from Servers using Dos Batch Files.

Created/Distributed/Trained Turn-key Access/Excel applications to close Books.

Used MS front page to develop ASP Web applications viewable over the LAN.

Utilized IIS to make web page server on the LAN. Page was updated as soon as analyst finished trade reporting on an MS Access application.

Developed Access and VB programs to reconcile Trade breaks, report on investment performance and use markets beta to calculate Trade risk.

Wrote Scripts in Hummingbird, Extra and Smart-term to send keys to Mainframe systems and performed redundant tasks. Scripts used in Excel, Access and VB.

MORGAN STANLEY, New York, NY March 1999 to January 2001

Macro Developer - VBA Consultant

Responsible for developing processes and systems for Morgan Stanley's Equities Group-(Hedge Fund Trade Reporting).

Specialized in Custom hedge fund/equity Reporting in Access and Excel.

Analyzed requirements and Defining Solutions in VB, Access And Excel.

Created multi-tiered applications using Access and Excel with Sybase data source.

Utilized DAO, ADO with TSQL to connect and use data from Sybase and SQL Server.

Recorded macros for Excel, Access and Word/Edit/Recreate code and assigned to custom Toolbars, Buttons.

Created Distributed COM, DLLs, and ActiveX controls for use in Access and Excel development.

Developed data import OCXs and subroutines for daily data feeds.

Create templates and Tables in Word.

Create Batch files on timers to start up Microsoft Applications and kick off macros.

Designed centralized code database that is shared by multiple Trading applications over LAN.

BANKERS TRUST, New York,NY March 1996 to March 1999

Project Leader –Business Reengineering Group

Worked independently to develop Y2K Compliant applications using Visual Basic, Access and VBA.

Created Excel and VB Scripts to scrape data from Mainframe screens into Excel and automate routine jobs.

Reengineered Access and Dbase applications to Y2K Compliant Visual Basic 3.0/4.0/5.0 and SQL Applications.

Debugged and redesigned 48 smaller applications written in VB, VBA and Access

Developed many small to medium sized SQL databases (Setting up Win NT workstations).

Created advanced, Dynamic SQL Queries in Access and VB.

Maintained, supported and trained employees to use the applications.

Researched new vendors and Programs over the Internet.

Planned, organized, led and controlled the testing of a Ticket Entry System.

PRUDENTIAL SECURITIES, New York, NY September 1993 to March 1996

Operations Technical Liaison

Liaison between users and programmers to create new accounting systems.

Developed spreadsheets on Lotus123 or Excel to generate daily Profit and Loss reports.

Wrote macros and code to automate Accounting procedures and reports.

Provided Excel technical support for OTC, Intl, Options, commodities, and Block trading.

Created schematic drawings and presentations on PowerPoint, Microgrfx and AutoCAD.

EDUCATION:

CURRY COLLEGE, Boston, MA

B.A. in Business Management

Minor in Physics (Concentration in Computer Design and Mechanical Physics); 1993

Contact this candidate