Clive Dcruz Email & Phone Number

Austin, Tx, Us

Charlotte, Nc, Us

Charlotte, Nc, Us

• Led the implementation of a custom home grown event alerting framework that sends out data driven alerts which greatly enabled tech, product, marketing and leadership teams to make informed business decisions• Powered automation of credit card arrangements by using machine learning concepts • Integrated with ad platform API’s such as Google Ads, SA360, Bing, Facebook, Yahoo and so on to download campaign, ad and metric level data for attribution and ad targeting insights• Integrated with affiliate network API’s such as ImpactRadius, CJ, Rakuten and so on to ingest conversions that redirected into the BI reporting warehouse• Built multi-dimensional reports to unlock data insights for marketing optimization

Indianapolis, Indiana, Us

• Led the implementation of microservice architecture pattern for backend data stores and designed the platform integration effort for member, provider and dataWarehouse domains.• Led the efforts for decoupling existing monolithic code and transformed them into domain-based micro services.• Designed and developed configuration driven member and provider data models that enable faster client implementations.• Managed, mentored and led onshore/offshore teams to effectively deliver projects on time and within budget.• Collaborated with DevOps and infrastructure teams to setup AWS public cloud and Anthem private cloud environments.• Worked closely with architecture team to evaluate vendors and third party tools that were leveraged.• Acting as a scrum master, managing agile sprint workloads and prioritizing tasks based on business requirements• Consolidated business requirements and documented detailed SOP for the technical solutions implemented• Implemented several enterprise shared services that were leveraged by multiple solutions/products

Lombard, Illinois, Us

American Utility Management (AUM) is a utility management and billing company for multi-family property's across the globe. AUM also provides additional facilities and services to residents in terms of their Utility usage and consumption on a month to month basis.At American Utility Management (AUM), I designed, enhanced, developed and supported their resident billing system called RBMS. I had taken initiative on several AUM client needs as well as in house department needs and delivered high quality software products that had greatly increased the company’s profits and grown their business year over year. I was part of a successful migration effort that required rewriting several database objects to upgrade the database software from Oracle 8i to Oracle 12c without any major issues. I had also successfully implemented the EDI 810 and 820 data exchange processes within AUM's system that cuts costs of manual data entry and significantly reduces cycle time for invoices. In 2014, I had successfully designed and implemented Missing Invoice tracking mechanism that in turn helped AUM to retain their clients in a proactive manner which reduced disconnects and increased the bottom line by a significant margin. Previously, I had designed and developed a Bench-marking application called SCORE which helped the multi-family Property’s managed by AUM to get more energy efficient. SCORE currently helps AUM’s clients (multi-family Property’s) a great deal to meet their energy efficiency goals faster than they ever thought it was possible.

Dallas, Tx, Us

• Performing service order data analysis, to develop service order data processing techniques, to deploy algorithms to derive the monthly recurring management fee structure, and to test database models and to process the data into format acceptable for billing and invoicing.• Subsequently I also develop comprehensive requirements and programs for implementing the algorithms.• Extensively worked on extracting data from flat files, transforming and massaging it and loading it into the database (ETL process) in a format acceptable to the billing requirement of the client.• Involved in Database design and structure changes based on the client requirements. • Verifying data integrity and consistency based on exchange rates and various other parameters.• Interacting with the client on an ad-hoc basis and resolving their issues based on their queries.• Analyzing the various changes of the billing process and testing the packages after the changes are made.• Writing PL/SQL packages and procedures; creating tables, indexes and views and using Oracle hints for optimization.• Tweaking already developed PL/SQL packages and procedures for faster processing by using explain plan, tkprof• Writing UNIX shell scripts for generating reports and billing package and to perform file level checks of the whole processed data with the feed level data.• Using SQL Navigator and Toad to query the database and perform various manipulations on the data.• Involved in several business process change meetings and also gave several presentations on process improvements within the organization. • Creating database links, partitioning tables and archiving legacy data to the data warehouse• Using awk and sed UNIX programs for pattern matching and data manipulation• Performance Tuning and monitoring statistics of production databases and doing capacity planning for database growth and load.

Atlanta, Ga, Us

1) Technically analyzed, developed & documented FASTRACC (an in house product which deals with the overall day to day business operations of Mercedes-Benz) by going through and understanding UNIX Shell Scripts, JAVA and SQL code.2) Technically reviewed, developed & documented all the batch scripts that update the FASTRACC database on their scheduled run.3) Writing stored procedures, analyzing and optimizing JAVA and PL/SQL code and also developing FASTRACC application.4) Creating Reports for various departments within Mercedes Benz in Cognos & Oracle Reports 9i.5) Analyzing and optimizing PL/SQL code and C++ scripts.6) Using AQT, an Advanced Query Tool used to query and do various manipulations on the company’s Production database.7) Using IBM RAD (Rational Application Developer), required to convert EGL, SQL and COBOL code into JAVA executable files8) Learnt IBM DB2 database and its various functionalities. Learnt PowerBuilder a front end Form Development tool.

Chicago, Illinois, Us

1) Using Pare do analysis methodology for incidents logged in the Remedy Action Request System, documented re-occurring issues that will be addressed in future software maintenance releases against the Oracle ERP Application Suite.2) Was part of a team that analyzed and identified requirements for implementing Kintana, an application used to migrate and deploy code across different instances.3) Gathered requirements for upgrading Tidal, a business applications job sequencing and scheduling tool.4) Implemented Mercury BAC monitoring tool for multiple business critical applications.5) Got an overview and understanding of Oracle Apps architecture and demonstrated knowledge gained on order management module.6) Shadowed the Solutions Architect during the installation of the Oracle Application Express (HTMLDB) on 9iRAC.7) Worked within a Capability Maturity Model (CMM) Level 3 software development organization.

San Jose, California, Us

1) Developed and tested Collaboration and Document Management Products such as “Worksite, File site and Worksite Web”. 2) Installed Worksite Server (an interwoven tool) on Oracle database were the documents used to reside.3) Was responsible for Migration and deployment of interwoven products.4) Learnt basics of automation techniques and automated test cases.5) Interacted directly with clients worldwide for trouble shooting technical issues.6) Participated in code review, requirement gathering, analysis, and also in design documentation.

Postgraduate Degree, Artificial Intelligence And Machine Learning

Master Of Science, Information Technology And Management

Bachelor Of Engineering, Information Science

Education record