JOSS CASTELLANOS
5901 Camino Del Sol,FL
Overview
12
12
years of professional experience
Work History
Data Analyst / Business Analyst
Publishers Clearing House
09.2014 - 07.2015
- Project: BA functions create BRD and FRD documentation for email service provider transition from eDialog to Experian
- DA functions create standalone data quality SSIS packages to verify data from different sources using third party Cozyroc SSIS components
- Technologies: Microsoft SQL 2012, Microsoft Office with Visio 2013 and Project 2013, Windows Server 2012
- Agile, VersionOne
- Responsibilities: BA create business BRD and functional FRD requirement document for Experian migration
- DA create standalone Data Quality packages written in Microsoft SSIS 2012 to compare datasets from different sources based on based on SQL queries stored in tables
- Data Modeling of DataQuality database SSIS development with SQL 2012 XML reporting Work in an AGILE environment, create and update stories
- Conduct Scrum meeting
- Perform the role of project manager on different projects
- Methodology included waterfall and agile
- Tools included Microsoft Project, Visio and VersionOne.
Technical Lead / Data Analyst
Citibank (IBSG Information Barrier Surveillance Group)
09.2012 - 12.2013
- Project: Senior Member of a team commissioned to implement third party software, Apama Software, for firm trading accounts in the US markets
- Apama Software would automate the current manual process of gathering information and analyzing trading patterns using spreadsheets
- Technologies: SQL 2008 R2, Windows .NET, Sybase ASE, Microsoft Office, Visio, Visual Studio C# and VB.NET, CA Autosys, Microsoft SharePoint, Windows Server 2008 R2, Powershell 2.0 and Apama Software Ag
- Responsibilities: Data Modeling of Staging database for data acquisition and retrieval with archival and purging process
- Data Analyst - Analyze data requirements related to trades, security master, daily prices, accounts and restricted security list to ensure that source data would satisfy the necessary compliance models for Apama
- Design and implement using Microsoft SSIS the necessary ETL process for all data sources and any additional processes needed
- Coordinate with Windows Systems team to setup up the different server environments, DEV, QA, UAT, PROD and COB
- Design and Implement job streams and scheduled processing using Autosys CA, Microsoft Powershell 2.0, SSIS packages and Command Batch Files
- Coordinate with QA team to verify accuracy and processing all data sources
- Provide level 3 support for all data related issues.
Technical Data Analyst
Bank Of America (Merrill Lynch Compliance)
06.2011 - 03.2012
- Project: Team member of a highly structure compliance data warehousing group responsible for gathering trading activity on a global basis
- Team consisted of 3 data architects, 4 DBAs and 5 technical data analyst
- Data Analyst followed a strict process of analysis, verification and implementation schedule
- Compliance models consisted of both regulatory and exchange audits in foreign markets
- Foreign markets included Taiwan, Jakarta and Argentina
- Models included layering, best execution and wash trades
- Technologies: Oracle 11g, PL/SQL, Data Warehousing Design, Microsoft Office, Visio, Erwin 7.1, Toad 10.5, CA Autosys, Microsoft SharePoint, and Actimize
- Responsibilities: Integrate new data requirements into existing data warehouse
- Analyze BRD for layering compliance model in Taiwan and Jakarta
- Provisioned 5 new dataset consisting of “Tick Data” and securities from Thompson Reuters
- Analyze BRD for best execution and wash trades for Argentina exchanges
- Provisioned 3 new datasets consisting of accounts, orders and execution
- Provide a Scope and Assessment document (gap analysis) for each dataset necessary to complete surveillance models
- Documents were presented to business owners and required signoff
- Coordinated and held meetings with various business and technical teams (DBAs, ETL and .NET developers) regarding surveillance models
- Develop SQL necessary to verify the accuracy of any new datasets and existing data to ensure that said datasets would satisfy all business requirements.
Software Developer
LMB Consultants
03.2011 - 06.2011
- Project: Convert client from existing CRM to a newly custom developed CRM to meet business objective and increase productivity
- New CRM is writing in VB.NET using Microsoft Visual Studio 2008, Backend SQL Server 2005
- Technologies: Microsoft SQL Server 2005/2008, T-SQL, VB.NET, C# .NET, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Microsoft Office
- Responsibilities: Design CRM database specific to clients requirements Develop data model and migrate existing data into new data model using SSIS
- Designed complete CRM client application.
Oracle Conversion Analyst
HHS Connect NYC (Health and Human Services)DoITT
09.2010 - 03.2011
- Project: Project involved designing, developing and implementing a data conversion strategy from various legacy systems into an existing third party data model implemented in Oracle 11 database for the NYC Health and Human Services
- The target model is based on the third party CURAM web application designed for state/government agencies
- Technologies: Oracle 11g, PL/SQL, SQL
- Loader, SQL
- PLUS, Oracle SQL Developer, Microsoft Office, Erwin 4.3, Visio
- Responsibilities: Designed overall strategy and phases for transformation process which consisted over 40 different data feeds from different legacy system
- Design and implement staging database to house different data feeds
- Developed in PL/SQL, SQL standards, templates, common functions and numerous utilities to be used in the transformation process
- Developed logging and error recording sub-system for business reporting needs
- Developed in PL/SQL and Oracle SQL Developer over 20 individual transformations
Senior Developer
Neuberger Berman, Inc.
06.2009 - 12.2009
- Project: Project involved converting four financial legacy applications written in Visual Basic 6 with a Microsoft Access 2003 database
- Technologies: Microsoft SQL Server 2008, T-SQL, VB.NET, Web Services, XML, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)
- Responsibilities: Convert numerous applications from VB6, C++ and MS Access 2000 to Visual Basic 2005
- This included reworking the base code to remove obsolete third party controls
- Design new application database in MS SQL 2005
- Create XML data layer using web services as well as reuse existing web services to reduce the overall coding and development time necessary
- Use of SQL T-SQL for intense server processing
- Migrated application data from Microsoft SQL 2000 & MS Access 2003 to Microsoft SQL 2005 using SSIS
- Created reports using SSRS to replace the existing obsolete Crystal reports.
Data Analyst / ETL / SQL Developer
Lehman Brothers, Inc.
01.2004 - 03.2008
- Project: DIA/RDS is an enterprise project designed to consolidate over 60 data feeds and three major portfolio systems into a multi-dimensional Data Warehouse
- The data store facilitates and streamlines the reporting process for clients, investment managers, brokers and firm compliance requirements
- Designed to store over a million accounts and provide 18 months of historical account holdings and transactions
- The multi-dimensional data store logical model is divided into ten subject areas and occupies over six terabytes of storage
- Technologies: IBM UDB, IBM DB2, Informix 7.1, Data Warehouse Design, Microsoft SQL Server 2000, T-SQL, .NET Technologies, Toad, DbArtisan, Erwin 4.3, Microsoft Office, Visio, Informatica, Unix, Korn Shell, CA Autosys, SSAS (SQL Server Analysis Services) Responsibilities: Build Data Mart for the purpose of building a Business Intelligence System
- Provide developers support to create proper and optimize SQL queries, views and stored procedures
- Provide developers with expert knowledge in the different subject areas
- Automated the process to check data consistencies and data quality on a daily basis after nightly loads
- I named the process ASTEC (Automated SQL Testing Environment)
- The process included 5 KSH and 3 T-SQL procedures to load and compare values
- Build ETL and monitored ETL process including troubleshooting
- Used Informatica PowerCenter 8: Designer, Workflow Manager, and Workflow Monitoring
- Designed data models for new requirements or augmenting existing databases
- Responsible for maintaining logical model diagrams
- Model is maintained using Erwin 4.1
- Porting the model to Erwin 7 was in progress
- Upon receiving approved changes meet with users, analyze requirements, create documentation, discuss with production staff, document lineage, modify model, schedule changes to database with DBA staff and signoff on the request
- Provided expert knowledge and business intelligence for T-SQL process and transformations.
Education
Bachelor of Science in Computer Science -
Queens College – City University of New York (CUNY)
Implementing a Microsoft SQL Server 2008 Database, Developing Web Applications Using MS Visual Studio 2008, Project Management Certification Preparation, JAVA Hands-On training Course 471 Learning Tree, NY, NY, Informatica Data Transformation Primer Lehman Brothers, NY, NY, Guerilla ASP.NET in C# Developmentor, Boston, Massachusetts -
New Horizons Computer Learning Center
Skills
- Visual Studio 2003 Thru 2022 (C# and VBnet), Eclipse 32
- Windows, Windows Server, UNIX
- Microsoft SQL 2005 Thru 2016 UDB 81, Informix 71, Oracle 111, Sybase ASE
- Erwin 43 & 71, DbArtisan 81, Toad 105, SSMS, MS Office, Visio, MS Project, Crystal Reporting, SSRS, VersionOne
Page
2, 4
Filename
Castellanos_Jose 7.0.doc
Personal Information
Title: Data Analyst / SQL Developer
Timeline
Data Analyst / Business Analyst
Publishers Clearing House
09.2014 - 07.2015
Technical Lead / Data Analyst
Citibank (IBSG Information Barrier Surveillance Group)
09.2012 - 12.2013
Technical Data Analyst
Bank Of America (Merrill Lynch Compliance)
06.2011 - 03.2012
Software Developer
LMB Consultants
03.2011 - 06.2011
Oracle Conversion Analyst
HHS Connect NYC (Health and Human Services)DoITT
09.2010 - 03.2011
Senior Developer
Neuberger Berman, Inc.
06.2009 - 12.2009
Data Analyst / ETL / SQL Developer
Lehman Brothers, Inc.
01.2004 - 03.2008
Bachelor of Science in Computer Science -
Queens College – City University of New York (CUNY)
Implementing a Microsoft SQL Server 2008 Database, Developing Web Applications Using MS Visual Studio 2008, Project Management Certification Preparation, JAVA Hands-On training Course 471 Learning Tree, NY, NY, Informatica Data Transformation Primer Lehman Brothers, NY, NY, Guerilla ASP.NET in C# Developmentor, Boston, Massachusetts -
New Horizons Computer Learning Center
Similar Profiles
Luis MeroLuis Mero
Mechanical Maintenance Engineer at PUBLISHERS CLEARING HOUSEMechanical Maintenance Engineer at PUBLISHERS CLEARING HOUSE
Eve FishEve Fish
AVP, Consumer Marketing at Publishers Clearing HouseAVP, Consumer Marketing at Publishers Clearing House
Robert A. LevineRobert A. Levine
Senior Manager of Analytics and Business Intelligence Reporting at PUBLISHERS CLEARING HOUSESenior Manager of Analytics and Business Intelligence Reporting at PUBLISHERS CLEARING HOUSE
Vinton EllisVinton Ellis
Manager at Publishers Clearing HouseManager at Publishers Clearing House
Gabriel CastellanosGabriel Castellanos
Driver at EssenmedhousecallsDriver at Essenmedhousecalls