Software Database Engineer Analyst Administrator/Information System Ap

YURIY GRIGORYEV **** Nostrand Ave Apt *T Brooklyn NY 11229 718-***-****

Software Database Engineer Analyst Administrator/Information System Application Developer

********@*****.*** US Citizen

SUMMARY

Phenomenal abilities to build strong working relationships, to understand and link business and technology

Focused on high quality tasks completion; result oriented with attention to details; work well as a member of a team or independently; perfect information management, customer support, and organizational skills

Able to and to interact effectively with people holding different positions as well as different responsibilities

Skilled in communicating with technical and business constituencies in writing effective business specifications, requirements, instructions and user manuals

Expert skills in: business process analysis, data integration, modeling, database administration, reporting

Possess an energetic positive attitude; has a willingness to maintain effective procedures and methods for operations; adapt quickly to a new responsibilities and effectively learn new skills using all variety of tools

Over 10 years of experience in information system monitoring and administration; data system analysis, modeling, design, integration, QA, development, maintenance, support; automated process modeling

Proficient with: various business system, MS SQL Server, MS Office Excel, Word, Access, system requirements analysis, data flow modeling, ETL transformation process automations involving various file formats, building packages, creating SQL/T-SQL queries, stored procedures and reports, performance maintaining, debugging and troubleshooting

Able to identify an effective scope of work and maintain a project plan to track tasks and deliverables and to report on status; able to develop test plans to deliver functionality for queries and reports; able to transfer knowledge to end-users who will be responsible for maintaining and developing

Tools: MS Office Access, Excel, Word, PowerPoint, MS SQL Server 2005/2008/2012, SQL, T-SQL, SQLS Management Studio, SSIS, ORACLE 8/8i/9i/10g, PL/SQL, MySQL, HTML, XML, UML, Use Case, MS Visual Studio, Visual Basic, VBA, VBScript, Java, JavaScript, C#.Net, ASP.Net, Unix/Linux, Crystal Reports, Informatica, Erwin, Adobe Photoshop

EXPERIENCE

Engrade LLC/McGraw-Hill Education, New York, 9/2013 – 2/2015, Data Integration Support Analyst/Sr. ETL Developer/Database Administrator/Business System Data Analyst

Perform data analysis, ETL development and maintenance on source systems data for documenting source to target mapping and transformation rules defining data dictionary and metadata management working with business clients and project team to understand the business needs and data flow in/out

Serves as expert on client data workflow, providing analysis, design, development, technical implementation, business priorities management, analyzing and interpreting client data, developing processes, presenting recommendations, translating client specifications into technical specifications to refine requirements, determines data source integration details, conducts validation, create source to target mapping documents

Works directly with account's representatives on end-to-end implementations of enhancements, modifications, documented specifications, developing logical data models into physical databases to integrate systems

Participates in the ongoing development for data transformation, integration, maintenance, capacity, migration, data quality, data cleansing, testing, and support of complex data loads

Provides data transformation process design and automation coding, data mapping, writes scripts and stored procedures to load data, troubleshoots and improves ETL processes; developing reliable and complex SSIS ETL processes and SQL/T-SQL scripts to support integration and QA activities; creating queries, views, stored procedures, reports, technical system specification documents

Milberg LLP, New York, 4/2005 – 6/2013, Information System Developer/ETL SQL Application Developer /Data Analyst/Database Administrator/Litigation Support Specialist

Performed day to day support for the Institutional Investors Portfolio Monitoring Database System acting as a liaison between clients and users to investigate recoverable losses of fund shareholders, data flow analysis, documenting source to target mapping and transformation rules defining data dictionary and metadata

Interface with legal and administrative staff to understand databases needs and coordinate software initiatives

Identifies the complex issues and does an analysis, prioritizes on the critical issues and get them fixed

Worked with all levels IT groups to build the logical database area and provided technical guidance during all phases of the development process, worked with vendors in evaluating and implementing new technologies

Coordinated and executed the processing of electronically stored information, assisted in review support, production development and user support requests, quality checks data and image files from vendors and other third party sources for loading into litigation support applications

Collaborated with business users to analyze information needs and functional requirements, worked with network and server engineers to remediate problem areas, to maintain reliability and security of data, to develop business process workflow enhancements, and to troubleshoot database infrastructure issues

Managed and trained staff on data downloads, improving reports, SQL queries, and data manipulations

Performed monitoring database growth, data mapping and transformation coding for new data integration, create logins and roles with appropriate permissions, administered performance and tuning enhancements

The Louis Berger Group Inc. /the Port Authority of NY & NJ Engineering Department, 4/2000-4/2005, Information System Data Analyst/SQL, Access, ETL Application Developer/Database Administrator

Worked with business clients at meetings and discussions to capture ideas and solutions to help achieve a state-of-the-art 3-tier architecture environment that meets current and future business objectives

Managed and maintained SQL Server and Access based applications, including data migrations from Access, Peoplesoft, Oracle to SQL Server production database, database modeling, GUI, queries, stored procedures, views, triggers, database security schema design and modifications in order to achieve optimal performance

Analyzed and documented user requirements and functional and technical specifications, researched capabilities of systems and determined system interface requirements, created business management systems prototypes and data flow diagrams, and managed the change request process, tested designed applications

Researched and evaluated alternative solutions for business issues, participated in enhancing performance and functionality, determined information needs, data relationships, data flow and storage requirements, data output and reporting capabilities, created ad-hoc reports utilizing various data sources

Designed, developed and performed day to day support for HR Information Management System within SQL Server database, administering, integrating and migrating data, implementing Oracle and PeopleSoft data, creating views, functions, stored procedures, reports, providing user trainings, creating manual documentation

Designed, developed and implemented Digital Asset(Electronic Documents and Drawings) Management System web application using ASP, metadata database using SQL Server, and integrated it with Canto Cumulus 5.5 digital assets catalogs search engine software

Provided technical support during the development, implementation and enhancement of production databases, and documentation for procedures to manage software development life cycle

Designed GUI tools to assist in management of the database and transaction processing environment

Created ETL/ELT processes and DTS Packages from Access, Excel and text files to SQL Server database

Developed GUI and advanced reports with functions, parameters, sub reports, summary reports, cross tabs, OLAP reports, using Business Intelligence and Crystal Reports

Assisted with: SQL Server installations, production and development environment upgrades, backups, restores, implementation and monitoring of transactional replications on production environment, ETL architecture design for data transfer from the OLTP to OLAP, converting stored procedures and reports to improve the efficiency and flexibility of the systems, foreign key constraints design and referential integrity checks to maintain the optimal performance, security and encryption, naming standards for tables, indexes and views, implemented business logics using triggers and raising customized error messages

Designed and developed executable module, which included transformation package and stored procedures, and creates XML file for web site, execution log file, and automatically send e-mails messages about execution to users using intranet for Minority and Women Business Enterprises System

Designed and developed database, implemented HR Soft Charter 9, created data transferring executable module and SQL Server DTS packages for Organizational Charts web based application

Designed and developed SQL Server database and MS Access application, created user manual, conducted user trainings for Education and Training System, which allowed to manage a compilation of employees training courses, certifications and other information related to HR personnel data, and produce reports

Designed automated process of loading data(data transformation module, DTS packages, stored procedures), matrix, tabular, parametric, and summary reports for Engineering Department Costs Data Warehouse

Assisted in disaster recovery of databases and applications after September 11, 2001

JP Morgan Chase Bank, Securities Investment and Insurance Service Department, New York

2/97-4/2000 Information System Developer/SQL ETL Analyst/ Database Administrator

Conducted business requirement analysis, databases modeling, logical database design and normalization, integration, financial sales and business management reports for various financial system applications

Tested and migrated FoxPro and Access databases to the MS SQL Server production databases

Participated in backup/restore strategy for production environment and database mirroring implementation

Managed physical database resources, created maintenance plans for database consistency checks, indexes maintenance and performed design and optimization of stored procedures and T-SQL queries

Designed, developed and daily supported database applications: Help Desk Ticketing, Employee Contacts, Computer Inventory, Investments and Insurance Reports, Business Management, Investments and Insurance Services Reports, Policy Owner’s Tracking, and Licensing, using MS SQL, Access, Crystal Reports, VB

EDUCATION

MS in Electrical Engineering, Major in Computer Science, The National Technical University of Ukraine

Certificates in DB Administration/SQL for MS SQL Server 2012/Oracle10g, Compu21 Corp., Flushing, New York, 2013

Certificates in MS SQL Server SQL Development and Administration, SQL/T-SQL programming; Web Development with ASP & HTML; Visual Basic 6 Enterprise, COM+, and XML Programming, Learning Tree Int., New York, 2003

Certificate in Java Programming, ALMA Inc., New York, 2000

Diploma in PC Programming using ORACLE SQL/PL SQL, C/C++, UNIX Shell script, COPE Business Inc, New York 1998

Contact this candidate