Data Entry Sql Server
Resume:
Michael Steinberg
Old Bridge, NJ *8857
****.************@*****.***
SUMMARY: Experience in computer programming utilizing advanced technologies solutions for business and financial applications development. Implementation of Client/Server, Object Oriented, GUI design, Event-Driven Programming. Problem solving; ability of analytical and research skills. Excellent communication and interpersonal skills. Current skills include full project life cycle development, business analysis and requirement definitions.
EDUCATION: BS in Computer Science at Kishinev State University
STRONGEST KNOWLEDGE/SKILLS:
OOP, Database Modeling, Complex Queries, Store Procedures, Triggers
SOFTWARE: PowerBuilder, PFC, Jira, Toad, Oracle, Sybase, MS SQL Server, T-SQL, PL/SQL
EXPERINCE:
12/2022–09/2024 HPD NYC.gov New York, NY Sr. Programmer/Analyst
12/2011–08/2013 Created Tables, Packages, Functions and Store Procedures. Numbers of reports for different departments.
Maintained Oracle Database data integrity. Went through Database Normalization phases analyzing needs of relations between the data base objects. Creating and optimizing indexes. Created Auto Processing of some part of the Systems replaced Manual Process of Data Entry following Business Rules and Requirements. Created new objects and modified existing ones using OOP. Created different Reports and Letters which are required for processing and fill in Forms. The Applications involved support critical work in enforcing the City’s Housing Maintenance Code and in developing affordable housing for the City’s residents. Modified different modules and created new ones for HPD Applications. Numbers of fixes for Production Issues. Gathered Business Requirements and Created Functional Requirements Documents and Task Cases, Unit Testing and Production Support.
PowerBuilder, Oracle, TOAD, Jira
03/2021-05/2022 Huntington Learning Centers, Inc. Oradell, NJ Sr. Programmer/Analyst
09/2006-02/2009 Numbers of reports for different Departments were created and modified such as Financial Analysis reports, Payments and Charges reports, Students Attendance reports. Inquiry Reports
Participate in design of Monthly Invoices System, which updates the system by running batches on monthly basis that include numbers of Store Procedures
PowerBuilder, Oracle, TOAD, Excel, SQL Server
04/2020-02/2021 Assured Guaranty New York, NY Sr. Programmer/Analyst
08/2013-07/2014 Modified different modules for Accounting and Financial systems.
Worked on Database Optimization and its objects. Created Packages and Store Procedures for reports and Data Windows as representation for reports.
PowerBuilder, Oracle, TOAD
07/2014–12/2019 Argo Insurance Group Jersey City, NJ Sr. Programmer/Analyst
01/2011–11/2011 Created Packages and Store Procedures and Functions for reports, Triggers as business rules integrity. Database Normalization Process. Writing complex queries for data reconciliation
Optimized existing and creating new DB Objects such as tables, Store Procedures and Functions in both PL SQL and T-SQL scripts. Analyzed data and making data mapping. Created composite DataWindows for reports/letters send to the clients, quotes, binders and policy coverages. Modified and created different modules, Coding, Unit testing
PowerBuilder, Oracle, TOAD
06/2010–12/2010 Emblem Health Insurance New York, NY Sr. Programmer/Analyst
Analyzed existing system and implement new features for IMFACT which provides users to add new customers, new coverage to existing customers as new group part of multi coverage. Analyzing benefit riders and dependent benefit riders based on coverage effective date. Allowing user store new records and updating the existing information for customers. The data can be loaded manually or transferred in the
batch files to populate Database. and reports for DataWindows. Created complex queries for retrieving, manipulating and presenting data for different use.
PowerBuilder, Oracle
03/2009–04/2010 InDemand Media Networks New York, NY Sr. Programmer/Analyst
Designed and coded functionalities of Web menu driven Application for Human Resources Department, which helps tracking, inserting and updating data for different type of employees. Administrative tools and various types of reports (financial, employees, departments, agencies and etc.). Extensively worked on the Triggers, Functions and Database Constraints.
Designed numbers of tables, which are normalized in existing database system, to provide necessary relation and data integrity with existing tables.
ASP technology and MS SQL Server 2000, SyBase12, Visual Studio 2005.
06/2000–09/2006 Credit Suisse Asset Management New York, NY Sr. Programmer/Analyst
Created, designed, and maintained numerous business and financial application which performed improvements of Asset Management business for the Mutual Fund Company. Applications were designed as Risk Management, Accounting Reporting Tools, supporting software for Traders, and Money Management for Portfolio Managers who oversee worldwide mutual funds.
PowerBuilder, Oracle, SyBase, ASP
04/1998–06/2000 Warburg Pincus Mutual Funds New York, NY Programmer/Analyst
Created, designed, and maintained business and financial application which allows users such as Portfolio Managers and their Assistants, Accountants to conduct company business.
PowerBuilder, Oracle, SyBase, ASP
09/1995–04/1998 Pepsi Cola Company, Somers, NY Programmer/Analyst
Designed, developed high quality maintainable software such as Bottler Data Collection. It provided the Customer and Bottler a seamless view of all their Pepsi-related business. This process was implemented nationally, and included Customer Reporting, National Account Processing, Invoice and Payment Process and Price Synchronization.
PowerBuilder, SyBase
Contact this candidate