𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭:• Developed web applications from conception to production, including layout, style and programming scripts.• Data importing tools• API services𝐒𝐞𝐫𝐯𝐢𝐜𝐞𝐬:• Software:o Install operating systems.o Install, configure drivers and applications.• Hardware:o Assemble, install, operate, maintain, repair computers and peripherals, including power supplies, network devices and routers.• Virtual Web Hosting:o Install, setup multiple virtual hosts on a single physical host computer.• Other:o Electrical wiring: Plan layout, installation, mounting switch boxes, circuit breaker panels and conduits for wall wiring.o Alarm systems and security video surveillance.

Projects: Developed and maintained forms in Creatio (CRM)

PROJECTS• Developed and maintained ETL scripts.• Developed data gathering script with custom parameters to gather data for analysis which were imported by ETL scripts.• Developed and maintained Shiny applications:o An application that reports the availability of data in database and versions of ETL scripts that imported the data.o An application that tests new versions of ETL scripts against previously imported data in DWH database.o An application that gathers analyzed data between projects to compare previous results with current data. • R package:o Generate database links.o Encode and decode passwords in database links.o Other custom functions.• Shell scripts as services to monitor applications and run daily ETL tasks.• Developed and maintained web application:o User interface for maintaining projects.o Import data of projects from multiple data sources into the database.• Developed and optimized SQL scripts.• Database design and development.• Bamboo plans to test and deploy ETL scripts.TOOLS USED• R Studio 2021.09.0• R version 3.6.3• DBeaver database tool• PostgreSQL• GIT Extensions• PHP 7.4• VS Code

PROJECTS• Group Scoring System: a new generation of scoring systemo Converted a non-periodical QlikView application into a periodical incremental load application.o Enhanced data loading performance and removed the load from the SQL server thus taking less time to process the calculations.o Ability to run the application in a single mode across all countries or in a multi-mode where all countries are executed in parallel to reduce the execution time.• Group Finance Reporting:o Generating Excel and PDF reports and distributing them over the network to SharePoint from a QlikView application.• Design DTS Packages & SSIS Packages:o Integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. o Writing expressions in SSRS and fine-tuning reports. Created drill through and drill down reports using SSRS.o ETL processing using SSIS packages.• Reporting Automation:o Creating parameterized reports.o Automating report generation and distribution.o Reports being delivered by e-mail, SFTP and network shared folders.• Creating Star Schema and Snow Flake Schemas.• NPrinting:o Installed and maintained NPrinting server for QlikView reporting.o Created and designed reports in NPrinting as well as used complex filters with large set of rules and conditions, On-Demand reports, emailing reports to recipients with custom filters for each recipient.• QlikView:o Created dynamic charts and objects based on selected data and filters at runtime in macros.o Integrated applications by using QlikView Development Framework. QDF makes it easy to manage and migrate applications between Development, UAT and Production servers.TOOLS USED• QlikView 12• NPrinting • Oracle Database 11g• Tortoise SVN• Microsoft Office• Microsoft SQL Server Integration Services

Projects:• Market Contact Audit (MCA Automated): Transformed the company’s core product, MCA Automated, from desktop applications (reports, dashboards, graphics) to the web.• Developed various applications that were executed and fetched data from SQL database using simple and complex statistical functions and applied fast numerical calculation scripts to number crunch thousands of surveys.• Applications:o Bug reportso Vacation Schedulero Tasks and Calendaro Data importero Generating reports on clients’ machine using JavaScript and internet explorer.o Generating reports in server side. TOOLS USED• Microsoft Visual FoxPro 9• Visual Basic 6• Microsoft SQL• ASP• ISAPI• JavaScript