SQL Server/MS Office/Reports Developer

Avi Jaman

Edison, NJ

Cell: 917-***-**** * E-mail: ********@*****.***

SQL Server Development & Administration

Reporting Development

MS Office Development

Synopsis:

Data Professional with over 10 years of experience in building databases, packages, stored procedures, views, and code in various database management platforms; Most recent experience in SQL Server Administration; Solid experience with developing data migration between disparate systems of data structures; Proven excellence at gathering and analyzing business requirements.

Areas of Expertise:

Languages:

●T-SQL (Stored Procedures, Functions, Cursors, Dynamic SQL)

●PL/SQL (Packages, Stored Procedures, Functions)

●JavaScript, VBA Access/Excel, VBScript, C#

DBMS:

●SQL Server (2008R2, 2012, 2014, 2016) SSMS, SSIS

●Oracle (11g)

Software:

●SQL Server Management Studios 2005, 2008R2

●MS Office Suite 2000, 2003, 2007, 2010

●Toad for Oracle

●Cognos 10 Report Studios

●Crystal Reports

Other Skills:

●Proven trouble-shooting and problem-solving skills

●Business requirements analysis

●Dedicated team player

●Able to communicate technical concepts in easily understandable, non-technical terms.

Experience:

Programmer Analyst, CompNova (Short-Term Contract to Victoria’s Secret) Nov 2017 – Present

Developing a MS Excel Planning Tool using VBA and backend data imports from SQL Server.

SQL Server Developer, C&A Global, Inc. – Edison, NJ Jan 2017 – Aug 2017

Troubleshooting of ETL processes between wholesale orders, internal inventory management systems, outbound EDI transmissions, shipping information for wholesale consumer electronics business. Assisted in report development. Managed and performed troubleshooting on SQL Server 2014.

Key Achievements:

●Organized tactical flowchart detailing where ETL breakdowns occur and why, directed reconciliation efforts as appropriate.

●Developed tools to assist with rapid data analysis in C#, Excel VBA.

Database Administrator, Fiscal I.T., Young Adult Institute, Inc. – New York, NY Nov 2015 – Jan 2017

Oversee integrity and functionality of 5 principle SQL Servers (version 2014) of the organization. Create and modify database maintenance plans, SQL Agent Jobs, and scripts for analysis and quality assurance as needed. Provide support for end users concerning data security privileges, and legacy MS Access applications.

Key Achievements:

●Coordinated routine database backups, restores and other administrative operations among all SQL Servers.

●Developed scripts to analyze database integrity and assure successful completion of ETL processes.

●Analyzed new business requirements, and developed enhancements in stored procedures and functions as needed.

●Developed code logic to changing file standards, instituted by Medicare (YAI’s principle source of income), impacting successful conversion of file information to data.

SQL Developer/Programmer, Applications I.T., Permal Group – New York, NY Mar 2012 – Jan 2015

Develop stored procedures in T-SQL (SSMS) as enhancements to Marketing Database to extract data from various data sources, and perform quality control on that data. Perform data mining and analysis to reconcile data between different data-driven applications throughout the company. Create stored procedures and packages in PL/SQL for report writing using Crystal Reports, Excel. Write code in Excel to automate custom checks on ranges, formulas etc. against changes in imported data. Analyze end user issues and enhancement requests for Sharepoint Intranet Site. Utilize T-SQL, VBScript, and VBA to troubleshoot and enhance Hedge Fund performance reporting application for Marketing Department.

Key Achievements:

●Developed procedures, functions and views in T-SQL (utilizing dynamic SQL, cursors) to respond to changing data requirements for marketing materials. Supported MS Access ADP front-end VBA.

●Developed T-SQL Backend for data integrity check application for website to assess whether monthly updates are captured as expected.

●Developed various PL/SQL packages for Crystal Reports.

●Assisted in checks on data migrations to new systems, as a result of Permal’s acquisition of Faucier Partners.

●Developed Sales Model using PL/SQL and VBA Excel to pull in data, employed automation for financial calculations in response to end user input and data changes.

T-SQL Developer/Programmer Analyst, Fortress Investment Group – New York, NY Mar 2011- Jan 2012

Used SSIS packages to import data from various sources (CVS, XLS) into funding and asset pool tables. Performed troubleshooting / enhancements on SSIS errors. Required knowledge of error handling, and T-SQL querying pool tables for errant data. Facilitated DTS packages responsible for data flow between asset management system (Wall Street Office) and asset reporting system (Clarity), Use C# for file manipulation/file streaming.

Key Achievements:

●Developed T-SQL scripts in SSMS for cross-data analysis between different Asset Management systems (Wall Street Office, Investran).

●Developed and maintained complex SQL Server project. Developed scalar functions and stored procedures in response to user interface. Coded objects to handle business logic between UI and SQL database.

●Developed ADO objects to handle data transactions to and from back-end data, wrote VBA Excel to respond to data.

●Performance tuning using SQL Profiler, analysis and recoding T-SQL views, stored procedures and scalar functions of one asset management system increased performance and cut turnaround time by 70%.

Database Developer, Morgan Stanley Smith Barney – New York, NY Sept 2007 – Mar 2011

Served as lead developer and project manager of complex internal applications that monitored client information, employee time tracking, client issues management, and billing. Responsible for implementation, testing, troubleshooting and upgrading. Applied SQL, VBA, and relational database design in response to business needs. Oversaw technical management of custom MS Access database that processed third party Equities Management data. Gathered, analyzed, and implemented business requirements for reporting needs for our division’s upper management.

Key Achievements:

●Developed and maintained complex SQL Server/Access VBA in-house applications.

●Developed complex SQL scripts to generate specialized reports and user interfaces to support them.

●Developed reporting interfaces to generate complex roll-up reports on client activity, allowing management to make informed business decisions about employee-client time tracking vs. profitability.

●Developed an intuitive user interface used by management to build queries without any SQL knowledge.

Education:

Chubb Institute, New York, NY

Web Development Business Programming Diploma

Rutgers University, New Brunswick, NJ

B.A., Biology

Contact this candidate