I'm an experienced professional with solid data management, critical thinking, and communication skills. I bring a practical set of engineering skills from the analyst side, and am adept at liaising between management and technical teams. Contracts are preferable in most cases, but I'm ideally seeking a home with an innovative company with good people and exposure to NoSQL/MapReduce architecture or structured data at scale.
| Very Proficient - Database development: TSQL/PL-SQL, analytic functions, cursors, UDFs, stored procedures
| - DW to Datamart integration work
| - SQL Server and Oracle platforms. Additional experience with analytic databases like Netezza/Vertica
- Tuning and performance optimization for 50 MM row sets
- MS Office: Access Excel pivots, index/match, indirect, lookups, table references
- Project leadership for related work
| | Some Proficiency - Visual Basic .NET application development
| | | - R and Python
- Statistics: regressions NHT
- Marketing-mix modeling
| |
| Sr. Data Architect 6M Contract - Lead architect for DW/data mart integration projects spanning 30 clients. Client-facing lead in consulting and codifying requirements technical lead in developing enterprise data/process models, logical/physical database designs, QA, and hands-on coding for end-to-end implementation.
- TSQL: dynamic SQL, cursors, stored procedures, analytic functions, UDFs
- Tableau for client deliverables
- Built datamarts integrating advertising industry data sources: ad server Doubleclick for Advertisers, Sizmek , campaign management Prisma, Mediatools , DSP, etc.
|
| Confidential |
| Sr. Data Analyst/AML Systems Tech 3M Contract |
- Built KYC profiles of customers transacting in cash through high-risk/high-cash-volume RSPs. Aggregate transaction visualization.
- PL/SQL, data visualization.
|
| Confidential |
| Sr. Data Reporting Analyst 1Y Contract |
- Business intelligence role: mined insights from newly-implemented multidimensional data warehouse. Modeled consumer segments and usage patterns to enhance media sales to advertising partners. Created 9 major regional reports for top tier executive and sales teams.
- Matched market test demonstrating TWC's ability to target bilingual consumers.
|
| Confidential |
| Data/Business Analyst Contract |
| Developed merchandise and financial plans for the fund's portfolio of start-up brands. Developed/automated planning data to merge with enterprise transactional databases. |
| Confidential |
| Data Analyst 3M Contract |
- KPI reporting derived from multiple data warehouses and BI tools Nielsen, SAP Business Objects for executive management.
- Queried multi-million instance data sets via SQL. Automated pass-through reports and ODBC data flows in MS Access Excel.
|
| Confidential |
| Senior Policy Analyst , Bureau of Planning Management |
- Benchmarked and evaluated key statistics of DA Vance's Criminal Court reform initiative. Presented seventy-page monthly reports on crime and prosecution trends to the DA and his executive team.
- Modeled data warehouse transition to merge structured and unstructured intelligence data for the new Crime Strategies Unit. Worked with senior prosecutors to strategically use data to link intelligence to prior prosecutions and arrests, including ArcGIS mapping.
- Acquired 1.9 MM in capital funding from the Mayor's Office of Management and Budget for technology and infrastructure projects. Assistant project manager for capital projects.
- Managed RFP procurements according to New York City procurement policy. Slashed 70k in operating cost inefficiencies.
- Ad hoc and project-driven SQL queries and statistics for the Office.
|
| Confidential |
| Proprietary Trader |
- Series 7, 55, 63 licensed trader for the firm's proprietary account.
- Managed a team of 19 junior traders.
- Coded and back-tested trading strategy algorithms client-side, JavaScript .
- Designed MS VBA performance analytics.
|
Privacy Policy
