Summary:

Advanced knowledge of Microsoft SQL Server Database Modeling and Programming (i.e. Transact-SQL Query Design and Execution Plan Optimization Analytics, Stored Procedures, User Functions), Index Structural allocation, and data retrieval methods using SSIS packages, and Trouble Shooting using the SQL Profiler.

Possess a wide range of Software Design drawing from VB.Net, C/VC++; Website development using HTML/CSS, ASP, JavaScript; Office Software: Excel, Word, PowerPoint; Database solutions as Access, FoxPro, Oracle, and SQL Server products. High aptitude to consume off-the-shelf solutions and research current programming techniques (i.e. Listed as “Inventor” of a patent pending email encryption tool (60/213,760))

Stakeholder proficient in design methodologies (Documentation, Life Cycle Interpolations) and Standard Operating Procedures. Responsible (Stakeholder) Engineer interfacing with clients in order to define specifications for new project features.

Experience:

3//1/2018 – Present Alvarez and Marsal Holdings

Data Analyst/ SQL Developer

Analyze and process Accounting A/R data using Agresso Smart Client ERP software. Regularly interfaced with co-workers on a worldwide basis which includes London, Paris, and Hong Kong.

Based on t-SQL, created new Agresso menu options to update data tables, data cleansing table relationships as well as providing reporting analysis.

Developed and implemented system test plans for new development initiatives.

Monitored production systems to anticipate possible system failures. Resolved database locking issues.

10/2016-3/1/2018 Reach Marketing

Sr. SQL Developer.

Analyzes raw data sources supplied by client. Expert level of data cleansing and manipulation. Solid knowledge of t-SQL 2012 and 2016 SSMS software including store procedures and functions within the SSIS framework.

Current project includes analysis of email newsletter deployment and analysis of Digi-Key electronical consumer campaigns. Required to determine recommendations of electronic product to consumer broadcasting of an international consumer market.

8/2011-9/2016 Ovation Travel Group

SQL Developer/Database Administrator

Responsible engineer in all areas of database software solutions in the New York City, Dallas and Chicago offices.

oArchitected normalized table models, related user stored procedures, functions, and triggers coded to take advantage of the underlining indexing. Study the active behavior third party database via the Profiler tool. Oversaw the backup process, disk spaces monitoring, and general system health. Monitored twelve proprietary SQL Servers ranging from 2005 to 2012 databases systems.

oCoded solutions to increase the Business Intelligence of Travel Agents by applying advanced SSIS/SSRS language techniques to match raw data with known industrial standard Hotel data. Designed internal Travel Agent performance “report cards” by polling data from the human resource, Agresso ERP database, and Sales Force system.

oRoutinely interacted directly with both clients and departmental managers to define specifications to capture, encrypt/decrypt, data cleanse and post various forms of travel data. Required to maintain internal websites and create new user interfaces for various users.

7/2004-8/2011 I.D. System Inc. (NASDAQ: IDSY)

Senior Application/Database Developer

Voted as one of New Jersey’s top 500 growth companies is a fast-pasted Fleet Management Company, responsibilities included maintaining data integrity by examining T-SQL stored procedures/user functions/triggers, optimized code via clustered/non-clustered indexing as well as foreign key and field constraints in order to ensure data integrity. Provided Clients with specific enhancements including aggregation activity reports, specialized code to exchanged data among independent systems, issued database enhancements (DML/DDL) to satisfy an individual request, and oversaw replication model depicting inventory. Regularly chosen to be the team lead to present solutions to clients either on-site or via web-conference.

Modified various proprietary baseline systems (CRM Software, Dynamic Link Libraries, and Services) to capture data transmitted via radio airwaves. Routinely expanded standard database model by designing new Tables/Indexes/Stored Procedure to parse, display, and report new features.

T-SQL database programmer required to design database systems for such clients as Ford, Wal-Mart, Avis, Audi, and the United States Post Office. Project included automating the transmission of data among proprietary systems.

9/2001-3/2004 Marts and Lundy

Senior Data Analyst

Nationally recognized as the prime source of charitable income source for Hospitals and Universities, daily tasked include interfacing with both Client and Sales Staff to generate detailed personal monetary profiles of potential donors by coding applications and T-SQL stored procedures to match raw personal information to internal data sources (Thomson Financial, Dun and Bradstreet, Lexus-Nexus, Federal Election Files) to ascertain individual personal wealth. Responsible Engineer required to research potential new optimization solutions among industry solutions (Group1, First Logic, Trillium, AccuZip).

3/2001-9/2001 Ernst and Young

Data Analyst Consultant

As an independent contractor, worked directly with divisional management to implement an APRIMO CRM application. Applied Trillium Software techniques to correct and standardized client data on an internal Company and Client data files. Processed data was enhanced with external files (Dun and Bradstreet) data sources. Designed a database system to identify regional client data business information.

EDUCATION:

Bachelor of Science in Computer Science from the William Paterson University of New Jersey.

Specialized training in Database Design and Normalization Theory from the Oracle Corporation.

Business Intelligence and Big Data Solutions with SQL Server. (NetCom Learning Center)

Designing, Optimizing, and Maintaining a Database Administrative Solution (NetCom Learning Center)

Contact this candidate