DENIS DRANOVSKY

Wharton NJ *****

973-***-****

ac4ksy@r.postjobfree.com

SENIOR TECHNICAL ANALYST

DATA ANALYST, BUSINESS ANALYST, JAVA DEVELOPER, MS SQL DATABASE ADMINISTRATOR Senior Technical Analyst / Programmer with 12 years of experience. Data conversion, client implementation, and application development specialist. Experienced trainer. Adept at resolving business challenges through technical innovation. Solutions driver who bridges the gap between business and technology while envisioning the bigger picture. Devises strategies to align multiple disciplines, coordinating efforts between business groups, and driving complex systems integration for robust, high-quality systems that solve business problems and provide cost-saving results, while maintaining the highest level of integrity and team mentality.

● Contributed to improvement and enhancement of processes and procedures.

● Supported team’s abilities and functions through positive customer relations.

● Gained additional knowledge and stayed on top of current technologies through employee and company sponsored training, periodicals, and regular interaction with other team members. TECHNICAL SKILLS

Database Administration Microsoft SQL, DB2, Oracle, SyBase, Microsoft Access Programming Java, Javascript, C++, CICS, JCL, VBA, Quickjob, Cobol, SSIS, SSRS Web Technology HTML/XML, Javascript, JSP/Servlet, Windows Server 2003, 2008, Unix Desktop/Web Software QlikSense, Cognos, Google Analytics, Microsoft Excel, PowerPoint PROFESSIONAL EXPERIENCE

CONDUENT, INC., Secaucus, NJ 2005–2017

Senior Technical Analyst

Developed and / or collected business, technical, and strategy requirements; coordinated the following development with all parties involved, accordingly. Generated Monthly and Quarterly internal and client data analysis to support client reporting, billing, and data analytics needs using reporting tools including but not limited to QlikSense, Cognos, Microsoft Excel, Microsoft Access, PowerPoint. Accommodated ad-hoc data inquiry requests for internal and external parties, with compliance with company and legal regulations. Trained clients and staff via weekly web-based sessions on online benefit management website tools. SQL queries and optimization. SQL Server database management and connectivity with multiple database sources (Oracle, DB2) to collect reporting data for the QlikSense Data Analytics tool. Performed Data analysis of internal and client interfaces.

● Programmed automation of the Electronic Employer Setup process for the benefits management system, reducing the group setup effort by 50%.

● Programmed and / or maintained a series of Microsoft Access Databases and Microsoft Excel utilizing VBA, Macros, and other Advanced Microsoft Office functionality.

● Programmed collection of group indicative setup data across multiple databases for transmission and setup on partner’s database

● Managed the Project of Employer Management System implementation on the web, centralizing the data across multiple databases and improving Employer Setup / Individual enrollment process by 20%.

● Coordinated automation of electronic funding data exchange process between benefits administration system and partners.

● Coordinated automation of the collection of employer funding flat file transfer, improving time, efficiency, and overall data integrity.

● Setup SSIS process on the SQL Server to gather data across multiple database for reports generated in Qlik Data Analytics tool

● Setup and maintained QlikSense dashboard, user reports, and user access rights EDUCATION

Kingsborough Community College, Brooklyn, NY

Liberal Arts Major