TECHNICAL SKILLS:

Skills: SQL Server 2017/2014/2012/2008 , SSIS, SSRS, SQL Server Business Intelligence Studio, Data Modeling, Access, Excel, Word, Power Point, ADO, DAO, VBA, VB.Net, VB Script, HTML 5, XML, CSS, Novell Netware 4.x/5.x. CNE.

EXPERIENCE:

Confidential, Princeton, New Jersey

VBA developer

Responsibilities:

• Responsible for remediating VBA code for MS Excel and MS Access.
• Identify code deficiencies and remedy.
• Develop code that meets regulatory standards for security and best practices.
• This includes password protecting all code, protecting worksheets, locking formula cells, eliminating malicious code, hiding and locking system objects, forcing explicit variable declaration, creating versioning control, eliminating hard coded references, provide add ins, disable access to menu system, correct compile errors.
• Conduct code review and develop code to implement rules based best practices and standards policies.

Confidential, Brooklyn, New York

I.T. Instructor

Responsibilities:

• Instruct I.T. professionals in various development tools including:
• Topics include SQL Server architecture, the database engine and query engine. Logical query processing.
• T - sql standard, page structure. DDL and DML, including create table, schema, view, function, procedure. Case statement, while, if/else, begin end blocks, CTEs, joins, sub queries, derived tables, transactions, triggers, merging, error handling.
• Multiple grouping sets, apply operator, windowing functions including lag and lead, indexing, constraints, data types, indentity column, primary and foreign keys, referential integrity.
• Tasks taught include execute sql, transformation lookup, derived column, conditional split, merge, union, sort, aggregate, containers, including for each, for and sequence.
• Connection managers including OLE DB, ODBC, Excel, Flat File, Cache, SMTP.
• Understanding data types, variables, including the ADO Object type, expression building, scope, parameters, package and project level deployment.
• Understanding design and run time environment differenences including 32-bit and 64-bit options and delay validation. Knowledge of max rows and buffer size.
• The SSISDB catalog, environments. SQL Server agent job scheduling. Data Warehouse topics including fact and dimension tables, surrogate keys.
• Using the Tablix controls, data sets, grouping, parameters, sub reports, conditional formatting, expanding, collapsing data, pagination, page breaks, using images, visualizations, kpi reports, dashboards, publishing reports
• Topics include understanding data warehouse schema, denormalized design, star and snowflake schema, OLAP vs OLTP, dimension and fact tables. Developing a multidimensional cube, building hierarchies, attribute relationships, dimension usage, calculations, deploying and processing cube, mdx basics.
• IDE, data types, procedures, variables, scope, access level, functions, statements, objects, data structures, Access and Excel object Model, properties, methods, events, standard modules, class modules, database connectivity, late and early binding, code extensibility, file system. MS Access - tabledef object, querydef object, recordset, tabledefs and querydefs collections. MS Excel - Workbook object, worksheet object, Range object. Named range, formulas.

Confidential

President

Responsibilities:

• Started my own self-publishing company. Wrote and published a series of children’s stories.
• Designed and coded my own responsive website using HTML5, CSS, some Java Script.
• Created an eBook (ePub) version of the book in fixed layout format using HTML5 and CSS.

Confidential

SQL Developer - Business Analyst - Assistant Vice President

Responsibilities:

• SQL (2012) developer, SSIS, SSRS, Project Leader, Access, Excel, Word, Power Point, VB, VB Script, VBA, DAO, ADO, ODBC.
• Business Analyst SQL developer for mission critical SQL data warehouse for Credit MIS Risk group.
• Scripted DDL, DML, including complex stored procedures, views, triggers, user defined functions, business objects. Experience using CTE, subqueries, grouping and aggregation, windowing, pivoting, derived tables, simple and searched case, branching, functions, temporary tables, cursors, indexing.
• Programmed wherever possible using standard SQL to ensure portability, efficiency and compliance.
• Knowledge of performance tuning and query optimization using proper index utilization, appropriate data types, and correct search arguments.
• Experience debugging and optimizing code written by other programmers. Experience with XQuery and importing XML files into various systems.
• SQL programmer responsible for providing monthly, weekly, daily and ad hoc reports to all stake holders.
• Application developer using Access and Excel.
• In depth experience using VBA, DAO, ADO, OOP to program dynamic, robust, user friendly, secure applications in Access and Excel.
• Experience using all active x controls, list and combo boxes, calendar, tab, tree view, windows common dialog.
• Project leader role on many projects.
• SDLC knowledge. Experience with business requirements gathering, design, developer, tester, trainer, support.
• Experience working with Data Warehouse star schema, denormalizing database design and surrogate keys.
• ETL developer using SSIS. Knowledge of all SSIS functionality, data sources, data destinations, sql task, control flow, scripting, dynamic properties, data mapping, data conversion, error trapping, debugging, packaging, notification.
• Report developer experienced in SSRS, Crystal Reports, Access Reports, some SAS.
• Automated report publication and distribution using SSRS subscriptions, in conjunction with SSIS.
• Some knowledge of basic administration tasks.
• Documenter. Wrote documentation for team members, internal stakeholders, compliance and auditing.
• Crossed trained team members on SQL, reports.
• Reports included ALLL analysis, Risk Rating/Delinquency Migration, Credit Metrics, KPI, Y14 Segmentation, Trial Balance.

Confidential, Brooklyn, New York

COML MIS Manager

Responsibilities:

• SQL Developer for commercial underwriting system.
• Developed SQL stored procedures, views, triggers, user defined functions, DDL, DML.
• Responsibilities included: Supported Bank’s Commercial Underwriting system using SQL 2005/2008, T-SQL, Stored Procedures, SQL Integration Services, SQL Reporting Services, MS Access, Crystal Reports.
• Developed several MS Access applications using VBA, DAO, ADO and OOP.
• Developed SQL database for collateralized mortgage backed securities, using complex sql stored procedures, grouping, aggregating, subqueries, top, order by, user defined functions.

Confidential, Brooklyn, New York

Assistant Vice President - Application Developer

Responsibilities:

• Application developer using various application development tools, including MS SQL Server, Access, Excel and Visual Basic. Programmed Access using VBA, DAO and OOP.
• Used SSIS for ETL to extract data from loan origination systems McCracken and AFS.
• Support in house commercial mortgage origination system developed using Access Data Project and SQL Server 7.
• Wrote complex stored procedures, views, triggers, user defined functions, VB code.
• Developed Collateral Asset Management System.
• Application collects loan portfolio information from various data sources, used ETL process to import to Access, transforms data, including merging, derived columns, matrix translations, applies business rules to produce a file suitable for the FHLBNY, Meridian: Property Search.