OBJECTIVE:

A full - time position in the field of Management of Information Systems/ System Business Analysis/Database development

PROFESSIONAL SUMMARY:

• 10+ years of IT experience with expertise in programming, database development, including extensive experience in coding, maintenance, troubleshooting and support of database applications using PL/SQL T-SQL shell scripts for Windows and MacOS environment with expertise in SQL coding of user-defined functions, stored procedures, views, table-valued functions and common table expressions.
• Years of experience in design implementation maintenance and support of front-end applications for Windows and MacOS platforms.
• Equally successful in both team and self-directed settings
• Extensive experience in troubleshooting and solving complex technical problems
• Adapts rapidly to new environments and result oriented
• Quick learner and fast applier of new technologies in daily routine
• Excellent communication, interpersonal skills and analytical mind
• Adept at articulating complex technical concepts to users of varying technical understandings
• Able to communicate goals and instructions in a clear and efficient manner.
• Work with the business side of the company to determine the best course of action and level of effort when designing an information system/process/application/tool.
• Able to listen to and interpret what the business side wants to see accomplished, discuss details in an easy-to-understand way, and then translate it all into technical.

TECHNICAL SKILLS:

OS: Windows NT/2000/XP/7/8/10, MacOS/UNIX

Office Software: Microsoft Office, Outlook, Acrobat, IE, Visio

Development environments: Visual Studio 2010, Eclipse, X-Code, Interface Builder, Borland Delphi, Borland C++, Dev C++Programming languages VBA, C#, Objective-C, C/C++, Delphi, Java

Databases: SQL Management Studio, SQL Server 2012, Access, PostgreSQL, PL/SQL, T-SQL, ETL, pgAdmin, EMS SQL Manager, SQL RedGate, Oracle SQL Developer

Data Modeling Tools: ERPlus, ER Studio, Power BI, Tableau

Web: HTML, DHTML, XML, JavaScript, CSS

Other skills: Excellent knowledge of Advanced Computational Methods in Science. Strong Math/Calculus/Physics and Statistics background.

PROFESSIONAL EXPERIENCE:

Confidential

SQL/ETL Developer/Data analyst

Responsibilities:

• Database design and maintenance. SQL development. Writing views, user-defined functions, stored procedures and reports for enhancing performance and extension functionality of information system.
• Business requirements analysis, application design, dimensional data modeling, data modeling, designing, coding, development, testing and implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment applications for financial department.

Confidential, Conshohocken, PA

Business System Analyst/SQL Developer

Responsibilities:

• Identify, analyze and design processes to improve an overall flow of information within operations.
• Document current applications and processes.
• Support the development of overall corporate systems strategy and roadmaps.
• Partner with business/management side to understand and identify needs and initiate projects to meet those needs.
• Analyze business processes and system functionality, identify inefficiencies and required functional enhancements.
• Development of processes comply business logic requirements.
• Database design and maintenance. SQL development. Writing views, user-defined functions, stored procedures and reports for enhancing performance and extension functionality of information system.
• VBA coding, debugging, testing, QA and support front-end business applications.
• Design implement and deploy ETL solutions.

Confidential, Buffalo, NY

Business System Analyst

Responsibilities:

• Design and implementation of business process for a wide range of company products and creating business rules and specification tables for distinct distribution areas.

Confidential, Buffalo, NY

Information systems management/SQL Developer

Responsibilities:

• Design, implementation, maintenance and support of information systems.
• Writing of SQL code to support business applications in accordance with business logic.
• Creating views, user-defined functions, stored procedures, for enhancing performance and extension information system functionality.

Confidential, Orchard Park, NY

System &Data Analyst, Database Engineer

Responsibilities:

• Database design, programming, management and maintenance. Writing SQL code to for business applications.
• Writing views, user-defined functions, stored procedures, for enhancing performance and extension database functionality. Queries optimization.
• Writing, debugging and testing Objective-C code. Perform quality assurance.
• Development and implementation data integration and workflow solutions using SSIS.

Confidential, Buffalo, NY

Scientific Programmer/Researcher

Responsibilities:

• Wrote C++/C#/Java/Delphi/Maple code for scientific applications and projects in the field of experimental physics. Tested and optimized application’s performance. Adapted code for multiprocessor platforms.

Confidential

Team Leader/IT Engineer

Responsibilities:

• Managed a team of software testers, created test plans, controlled and coordinated team work with developers.
• Designed and maintained database of customer issues. Wrote code of stored procedures and user defined functions (T-SQL).
• Tested and evaluated new versions of software, provided QA, performed support of enterprise users. Dealt with customer concerns.