HANUMARAJ YADAV AVULA

**** ****** ******** *****

Wesley Chapel, FL – 33543.

708-***-**** (Cell)

EMAIL: adzs2o@r.postjobfree.com

SUMMARY: Recognized senior-level Information Technology professional with over 20 years of extensive experience in Managing projects. Solid experience in leading projects and full-cycle application developments by conducting meeting between business and IT teams. Proven ability to bridge technology and business goals with cost optimization to provide productive solutions. Excellent communicator with emphasis on building client relationship, capable of making professional presentations. Enthusiasm for new technology and quick learner of transitioning changes. Well versed in service-oriented Analysis and Design (SOAD), Object Oriented Analysis and Design (OOAD). Critical thinking and positive can-do attitude. Worked with all types of data to design data models, build data warehouses and data lakes, automate data pipelines, and work with massive datasets.

Education Masters in Information Systems (MIS).

Certification Data Engineer Nano Degree, MS SQL SERVER, DB2

Advanced Database Administration, Hadoop Administration

Training Project Management Portfolio(PMP)

Status: U.S.Citizen.

Personal: Limited Travel.

Relocate: Yes.

Reference: Furnished upon request.

COMPUTER

PROFESSIONAL EXPERIENCE:

Sr.Hadoop Administrator

Centene Corporation

3901 Premier North Drive,

Building 1, Floor 1,

Tampa 33618 June, 2022 to August 2023.

Maintained the cluster by addressing the performance and fine tuned services as required. Supported job execution issues by helping the development team to resolve errors/issues during the Meridian Migration from CDH to CDP and data migration. Worked with the development team for the integration of Kafka and Striim components. Generated Kerberos Headless keytabs for services for job executions. Fine tuned the queues to facilitate the monthly high volume data synchronization. Provided support for patching/upgrades to the OS Teams. Monitored the services status and took appropriate steps deem necessary to keep them running with no down time. Improved cluster monitoring by implementing the Dynatrace and PagerDuty functions. Took Lead role in upgrade. Worked with DevOps with jobs automation process. Implemented Patch updates to addressed Security Vulnerability.

Sr.Hadoop Administrator

Atos

NA BD Cyber Security Services

Irving, Texas – 75063 April, 2021 to January, 2022.

Support production environment in Hadoop, Spark, Kafka, Zookeeper, HBASE, HDFS, Nifi, flink and RabbitMQ both on premises and Cloud. Monitor the Modules and Data queues for AI and provide remedial services. Implement performance enhancements and configuration improvements by adding up hardware as needed. Work on automation process for onboarding new clients through MDR agents and Log Monitoring. Monitor the intervention and response services. Monitor and enhance the Artificial Intellegence (AI) Siem, Soar and Hunting clusters performance and regulate the job executions with oozie.

Hadoop Administrator

BlueCross BlueShield of IL August 2017 to July 2020

Infra Run Tec Orchestration, Foundation Services,

200 Aon Center,

Chicago, IL – 60601

Worked as Hadoop Administrator in the Infra Run Team using Hortonworks Ambari/Cloudera (HDP/HDF) for Hadoop monitoring, maintenance and enhancements and addressed performance issues. Maintained the system/services and provide assistance to the users with data manipulating and analysis. Added queues to improve jobs threshold. Maintained the JDBC and ODBC connections for Hive and Knox. Reviewed logs to identify issues with performance and errors. Controlled access by provisioning through Ranger. Monitored and provided need based assistance for jobs processing HBASE, Hive, Pig, kafka and Spark. Configured cluster as needed to enhance processes and accommodate data loads. Monitoring system resources and job execution with yarn scheduler to check vcores, memory and job executions. Worked with Datawarehouse projects on Cassandra, cloud and AWS. Used Airflow for data Pipeline Projects for ease of use and manipulating terrabytes of data from Amazon S3 bucket and populating to redshift, cbased storage and massive parallel processing for multiple users simultaneously. Did data organization using star and dimensions schemas. Worked on dimensional modelling and column reating OLAP cubes. Extensively used Postgresql for data manipulation.

Environment Analyst DevOps November 2010 to August 2017

TeamSite System Administrator

BlueCross BlueShield of Illinois

300 E. Randolph St

Chicago, IL -60601

Conducting meeting between business and IT teams, Did product analysis for multiple software Products. Responsible for performing the administrative tasks of installations, implementing patches/EBF’s to address issues and develop new content types for various branches in order to meet the changing requirements. Implement Access security for present and new users. Interact with the Database Team for creating the applications specific tables and maintain data. Research on new products available and useful to the team with more flexibility. Participate in the ISE / DCC / ICC meetings for the new application development. Train team members with new enhancements and product details. Provided assistance to the configuration management team with new application changes and deployment paths. Maintaining Public sites and transforming from static to dynamic environment. Create Co’s and assigning tasks and getting CAB approvals. Lead role in gathering requirements for projects, for application development and creating test scripts and implementation to production and post production support. Co-ordinating the application release, Guiding and leading the team members to address production issues. Monitor the performance and coming up with performance fine tuning. Successfully implemented the Disaster recovery for Public Sites. Worked with the Datalake team for obtaining data for Provider finder App and publish to the public sites. Worked on ERS, Client data Exchange, Provider, Producer, Employer, BlueSource and multiple HCSC internet and intranet Public Sites

Lead Developer Mainframe Analyst:

BlueCrossBlueShield of Illinois

300 E. Randolph

Chicago, IL -60101. September 2004 to 2010

Joined as Senior Programmer Analyst and promoted to Team Lead Mainframe Support position. SME for DB2 database related issues and Database Change Control. Researched available tools to integrate with the application. Responsibilities were primarily to Implement application quarterly releases for the membership application. Bluestar Production Support. Handling the help desk incidents and clearquest tickets by assigning to my team members and get them resolved expeditiously. Creating the SDO documentation and responsible for all production migrations and implement procedures for migrations. Implementing the company standard Solution Delivery Methodoly (SDM) procedures and documentation for all object / program changes (Migration requests, code reviews and test cases) by the developers are other responsibilities besides coming up with solutions to improve the performance of the application by fine tuning the existing services and help team members with questions on application and database.

ARCHITECT, LEAD SOFTWARE DEVELOPER

CAPITALONE Credit Cards

5640 COX ROAD

GLEN ALLEN, VA – 23059 February 2004 to September 2004

Enhance the performance of the existing applications. Create functions to move the client-side code for processing the business rules to middle tier and obtain the data from middle tier using XML scripts. Maintain Centralized Code Changes using ClearCase and ClearQuest. Co-ordinated between application development teams to abstract common functionality and develop general functions, which can be used by all applications. Create High level/ Technical Designs for proposed New Development and enhancements.

SHELDON I. DORENFEST ASSOCIATES

DATABASE ADMINISTRATOR

CHICAGO, ILLINOIS – 60610 June 2003 to February 2004

Developed Web Applications using powerbuilder for generating components to be deployed to Jaguar and access from Power Dynamo. Isolated the business logic from client-side logic. Created user interface screens using Powersite. Created stored procedures to maintain Vendors products and categories. Developed Web Application for search and display of Health Information. Generated PDF files to display as reports for faster access and convenience to print from the Web. Co-ordinated the upgrades and Quarterly application releases. Migrated the Access Database to MSSQL Server 2000 database. Created Database and transaction log backup process to restore database in the event of need for recovery. Established Relationship and Referential integrity between the tables. Created indexes for columns involved in retrieval process to speed data retrievals. Organized the security by creating the user groups and assigning permissions based on user level. Moved Client-side application process to stored procedures to enhance performance. Created Auditing tables for Critical tables to control and watch user activity. Implemented the Soft Delete concept for tables, which needs restoring the data, which was deleted when, circumstance change. Modified Applications to write to a log file in the event of error to reduce debugging time and help quick fixing of problems.

RADDON FINANCIAL GROUP

SENIOR POWERBUILDER ANALYST/DEVELOPER

1S660 Midwest Road

OakBrook Terrace, IL – 60181. July 2001 to June 2003

Acquire data from Client's Institutional operation files or MCIF System. Comparing the data from the client call Report (Profit and Loss Statement), Fee Survey (Interest and Non-Interest Fees) and Profit Assumptions Worksheets (Account Profitability and Institutional Profitability). Organizing the data into cost classes and service classes for Segmentation, Analysis and Research. Generate Reports for CEO Strategies. Developed Web Application to gather client data through Internet and display processed Client Reports for Approval. Streamlined the existing application and reduced the execution time by re-organizing the table structure and implementing Application Servers. Took Lead role in solving Production Issues by conducting elaborated meeting with stake holders. Modified the parameter driven process to table driven process. Created and maintained stored procedures to process calculations. Implemented middle tier for Auto Processing. Used PFC for Rapid Application Development and maximize reuse of objects for consistency and reduced coding for optimized development.

SYSTEM SUPPORT & LEAD WEB APPLICATION ARCHITECT

TRICOR INDUSTRIES, INC

Sub-contractors to US Air force

5 EAGLE CENTER

O'FALLON, IL - 62269. Dec' 99 to July 2001

Lead the team of 4 members to develop Web Application with combination of Jaguar CTS (Component Transaction Server) and PowerDyanamo (HTML page Server) for hosting and accessing on NT and Unix environments using the existing powerbuilder objects. Created shared service components for Jaguar to minimize repeated database calls to access relative static data. Generated custom reports based on day-to-day database activity. Designed and developed tools for users to execute and view data-transfers. Working with DBA for Data Manipulation. Made extensive use of PFC to implement consistency in coding, naming conventions and interface design.

SENIOR PROGRAMMER/ANALYST

FASTECH

17197 N. Laurel Park Drive, Suite 540,

LIVONIA MI - 48152 May ’99 to Dec '99

Customizing and enhancing the Time Entering and Scheduling System. Application deals with Entering Time by manual and import procedures and Rules for calculating payable hours for the employee. Methods to calculate premium hours (holidays, sick, vacation etc). Accumulation and disbursement of accruals through banks. Pay period declarations and retrospective adjustments. Designed and Created Databases for applications developed. Interactive Screens for gathering client data through web.

SPAR MARKETING FORCE, INC:

DATABASE ADMINISTRATOR MS SQL SERVER

1757 Northfield Drive,

Rochester Hills, MI – 48309. March ’97 to May '99

Customer Support and Applications Design/Development to run Business. Maintain Information about Merchandisers, Stores, Clients and Tasks. Develop applications to suit the client’s business requirements. Furnish District Marketing Managers with information of Assignments and tasks, job wise for different clients. Collect employee work data by phone calls through IVR into DB2 database, Collect work sheets data by manual entry into informix database. Transfer data collected from multiple environments to the MS SQL Server environment. Do finished task calculations in SQL Server database and send data for processing to

Programmer / Analyst

Mc.Kesson Pharmaceuticals

Livonia, Detroit. Dec ’96 to March ’97

Customer Support and Application Maintenance. Developing reports and interface for generating reports to keep track of Item Inventory, Prescription and Refill details, Doctor Preference, Patient and Doctor information using IQ Professional Report Developer for Report Development and PowerBuilder 5.0 PFC and Microsoft SQL Server 6.5

Contact this candidate