Ajay Kumar Galla

CRIMS, application and infrastructure support to CRD customers in the Fixed Income and Derivative space.

Responsibilities:

• Respond to requests for technical assistance via phone, email or in person (remotely or on-site).
• Diagnose software issues and recommend the appropriate solution.
• Analyze problems, answer questions and provide training related to the CRIMS software.
• Identify and test workarounds for bugs or deficiencies in the software.
• Research issues dealing with third party software.
• Follow a standard set of procedures and methods when responding to customer requests or inquiries.
• Conduct research on questions and issues using available information resources and other product specialists.
• Contribute to the continuous enhancement and improvement of support processes and methods
• Successfully handle “sensitive” issue related situations that affect the perception of how CRD resolves customer problems
• Manage special projects as required
• Keep a detailed log of all customer interactions and prepare resolution reports for issues reported by the customer.
• Environment: SQL developer, Azure, CRIMS, SSMS, Oracle, SQL server, Unix, Bloomberg terminal, Kettle, SSRS

• Quality Docs migration from Documentum to Veeva Vault using TRUseries Tools.
• Responsibilities:
• Writing SQL, DQL and VQL queries to extract data from systems like Oracle, MS Access, Documentum and Veeva.
• Configuring TRUCompare job to compare data between source and target systems.
• Creating jobs and connections to various data sources like Documentum, Oracle, MS Access, Veeva and Excels
• Step by Step process documentation for Dry run and Production runs.
• Consolidated data comparison report creation with detailed analysis for data differences between source and target systems.
• Deleting quality documents from Veeva using Postman as part of maintenance.
• Creating audit trail reports of QDocs using TRU series audit trail generator.

• Commercial Data warehouse (DW), is a system used for reporting and data analysis, and is considered as system of truth across enterprise. DWs are central repositories of integrated data from multiple sources. They store current and historical data in one single place and is a source for sales ODS and many MARTs, which are used for creating Semantic layer for analytical reports and data analysis.
• Responsibilities:
• Implementation and automation of Extract, cleansing, transformation and loading of data from heterogeneous sources (IMS, Medpro, Veeva, Value Centric, Solution Rx, Salesforce (CRM), and Epsilon) to target systems (Oracle, Salesforce) data structures.
• Designed and Developed ETLs using Informatica power center to extract data from different sources and load data into ODS, MART tables.
• Worked on materialized views, views and procedures to extract data and load it to semantic layer.
• Developed shell scripts and DOS scripts to FTP/SFTP files from remote servers and rename the files as per informatica ETL and to modify Parameter files at run time.
• Prepared technical/procedural documents for re-occurring tasks and gathered requirements to automate the tasks and to reduce the manual effort.
• Involved in Unit testing, Integration testing, System testing, Regression and UAT testing along with other team members.
• Extensively worked on External tables to load data from external systems and developed PL/SQL programs to dump data from temporary tables into base tables.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Associated with DBA’s in monitoring the performance related issues using Explain Plan, SQL Trace and TKPROF utility.
• Created complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions.
• Participates in Team meetings to get better insight of Project, Views and Materialized Views of Data Warehouse projects.
• Involved in Unit testing, Integration testing, System testing, Regression and UAT testing along with other team members.
• Environment: Informatica Power Center 10.2, Oracle 12c/19c (SQL, PL/SQL), SQL
• Loader, SVN, Atlassian JIRA, AIX, Windows, Toad, SQL developer, Unix Shell scripting, DOS scripting.

• Data warehouse (DW), is a system used for reporting and data analysis, and is considered as system of truth across enterprise. DWs are central repositories of integrated data from multiple sources. They store current and historical data in one single place and is a source for sales ODS and many MARTs, which are used for creating analytical reports and data analysis.
• Responsibilities:
• Developed ETLs using Oracle Data Integrator (ODI) to extract data from different sources (OMS, AMS, FOW, LPIP etc)and load data into ODS, MART tables.
• Worked with product owners and Business to resolve the issues with data and understand the requirements for creating reports using Pentaho BI.
• Developed various reports for business analysis using Pentaho, SSRS and scheduled the reports using schedulers and set up email notification to user when report execution is completed.
• Involved identifying the reports required for business users and migrating them from Actuate to Pentaho and worked on issues and comments raised by user as part of migration.
• Worked with admins and Pentaho team to upgrade BI and testing the reports, resolving issues raised as part of migration.
• Developed jobs to run the SQL
• LOADER with the help of Perl and Shell scripting to load data from various sources form of either Excel, CSV or flat files into the target database tables.
• Worked on SQL and PL/SQL to extract, process and load data for ETL jobs developed with the combination of Perl and Shell scripting and production issues, failure of ETL jobs, to load data to data warehouse and ODS and data issues related to reports.
• Prepared technical/procedural documents for re-occurring tasks and gathered requirements to automate the tasks and to reduce the manual effort.
• Performed SQL query tuning using explain plan to improve the performance of queries in ETLs and reports to help them execute faster.
• Developed User Defined Functions and created Views, Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• In-depth knowledge of Software Development Life Cycle & methodologies Agile (Scrum) & V-Model.
• CreatedJiras for bugs identified and fixing them as based on new/changed the requirements.
• Involved in Unit testing, Integration testing, System testing, Regression and UAT testing along with other team members.
• Environment: Oracle Data integrator (ODI), Oracle 11g (SQL, PL/SQL), SQL
• Loader, CI/CD, Git, Atlassian JIRA, OMS, AMS, FOW, AIX, Windows, Toad, Perl, Unix Shell Scripting

• RASCAL is a passenger revenue accounting system, the basic purpose of this system is to manage the control, reporting, use and accounting of tickets, MCOs, excess baggage tickets and other ‘accountable’ documents. In doing so, this will provide maximum efficiency in processing ticket data, and posting and billing accurate values and validates all transactions, and initiates recoveries.
• Responsibilities:
• Involved in complete system development life cycle.
• Involved in the team for documenting functional and technical specifications, including specifications for others to build.
• Involved in modifying existing PL/SQL Procedures, Functions and Packages and developing new ones.
• Developed procedures to run the SQL
• LOADER to load data from various sources in the form of either Excel, CSV or flat files into the target database tables
• Developed Error Logging and Data logging to better understand the performance of the ETL procedures and to associate the errors to the procedures.
• Wrote SQL, PL/SQL, views and Bulk Collects for implementing business rules and data transformations.
• Extensively used various data transformation functions of PL/SQL.
• Extensively used tools like TOAD, SQL developer, Microsoft Visio.
• Responsible for writing Install Scripts for migration of the code through various environments and implementing.
• Involved in Unit testing, Integration testing, System testing, Regression and UAT testing along with other team members.
• Environment: Oracle 10g/11g (SQL, PL/SQL), SQL
• Loader, Microsoft Visio, TFS, ALM, Windows, Toad.

• AFVT - Account Forecast Validation Tool contains actual and forecast values for Apple's Sell in and Sell Through unit sales along with forecasting tools, analysis and accuracy measurements.
• Responsibilities:
• Involved in complete Software Development Life Cycle (SDLC).
• Worked on fixing defects and minor code fixes.
• Perform root cause analysis of defects and document them on defect loggers and trackers. Perform analysis to prevent further occurrences of the same.
• Highly adept at troubleshooting system level and scheduling issues while providing 24/7/365 on-call support for any major incidents, outages, weekend releases and/or upgrade events, worked effectively both independently and as part of a team.
• Level 3 support for the apple AFVT production, test environment with minimal supervision.
• Independent problem solver who troubleshoots analyzes and resolves any production batch processing failure, primary shift function is to ensure nightly batch processing begins without delays.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Associated with DBA’s in monitoring the performance related issues using Explain Plan, SQL Trace and TKPROF utility.
• Developed jobs to run the SQL
• LOADER with the help of Perl and Shell scripting to load data from various sources form of either Excel, CSV or flat files into the target database tables.
• Used AutoSys for batch scheduling.
• Created complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions.
• Involved in data analysis and reducing data discrepancy of the source and target schemas.
• SQL tuning using SQL TRACE and TKPROF tools for Explain Plan, collection of statistics and creation of indexes.
• Aided in developing test scenarios, test scripts and test data to support unit and system integration testing.
• Environment: Oracle, SQL, PL/SQL, Perl, Shell Scripting, AIX, MAC OS X, CVS, Espresso

• TRAXi3 - AppleCare (Repair or Replace) Transportation Management System uses SAP R3 environment to send and receive data to and from Precision Software's flagship product TRAXi3 which is a proven domestic and global trade logistics solution as a fully integrated transportation management system that improves operations and increases visibility to allow manufacturers and their customers to move goods quickly and predictably through the global supply chain. TRAXi3 offers multiple deployment options to reduce customers’ transportation costs, prevent transit delays, and comply with global trade regulations. Precision’s product architecture, which was built to embrace open standards, can be deployed on a Service Oriented Architecture (SOA) platform.
• Responsibilities:
• Level 2 support for the apple repair/replace services for production, test environment with minimal supervision.
• Prepared technical/procedural documents for reoccurring tasks and training documents for new team members.
• Monitored and responded to the incident requests via Apple ticketing management system (Espresso).
• Worked closely with TRAXi3 team to integrate SAP R3 with TRAXi3 and printer applications.
• Coordinated with Traxi3 L3 Support and apple business team in resolving application, Printer and SAP label queue issues.
• Associated with DBA’s and system administrators in monitoring the performance related issues and application issues.
• Highly adept at troubleshooting system level and scheduling issues while providing 24/7/365 on-call support for any major incidents, outages, weekend releases and/or upgrade events, worked effectively both independently and as part of a team.
• Worked on P0, P1, P2 and P3 as per the business SLAs
• Environment: Oracle, AIX, MAC OS X, CVS, UNIX shell scripting, Espresso

• HMS is a contact center application. It intends to help the general public get in touch with the contact center via telephone, SMS, mail etc and get help regarding various health related issues. Objective of 104 Health Advices
• 104 Tele Advice provides:
• Handles all the incoming service requests round the clock 365 days of the year advice on health-related matters.
• Expert Medical Advice and Counseling based on algorithm & Disease summary List.
• Provide Hospitals, Doctors, Blood Bank etc Information.
• Complaint Logging on various institutes and escalations to the concerned officers
• Transfer Call for Emergency.
• Generate Reports on the calls coming.
• Responsibilities:
• Gathered the business requirements by interacting with users.
• Responsible for making decisions on coding standards and documentation.
• Drawing ER Diagrams Using Micro Soft Visio.
• Design schemas, Creating Database, Build tables, FKs, PKs, Views etc.
• Maintaining the server and keeping it running. Concerned with backups, security, replication etc.
• Development of various PLSQL modules (Procedures, Functions, Packages etc).
• Bug fixing and code enhancement.
• Writing DOS batch scripts.
• Used ODBC for accessing and retrieving the data from database to Jasper Reports.
• Worked on installation and maintaining PostgreSQL DB on Development and Test environments
• Regular backups and replicating PostgreSQL DB using Slony and securing databases by controlling user access by creating various roles.
• Scheduling DB jobs using pgAdmin III.
• Environment:PostgreSQL, Windows, DOS Scripting, MS Visio, pgAdmin III, Slony, Bugzilla, pgpool-II

• Emergency Response System is the complex software integrates with many critical systems for managing emergencies. It integrates several vendor-supplied systems to create a single seamless solution including Computer Telephony Integration (Computer Communication Toolkit - CCT) Voice Logger system, Geographic Information System (GIS)/Maps, Global Positioning System (GPS)/Automatic Vehicle Location Technology (AVLT), and Mobile Communication. This system automates all the activities of the call center and support activities of emergency handling, automating vehicle tracking, automating patient care, such as medical assistance to critical patients, ambulance management, equipment management and partner tracking. ERS system implemented with objective of 99.9% uptime with fault tolerance and back up provisions. This project also designed for handling 2 LK emergency calls per day.
• Responsibilities:
• Participated in all the Life Cycle phases including requirement analysis, Client Interaction Design, Coding, Testing, Support and Documentation
• Created Functional Specification document and High-level design document
• Responsible for making decisions on coding standards and documentation
• Drawing ER Diagrams Using Micro Soft Visio.
• Design schemas, Creating Database, Build tables, FKs, PKs, Views etc.
• Maintaining the server and keeping it running. Concerned with backups, security, replication etc.
• Development of various PLSQL modules (Procedures, Functions, Packages etc).
• Bug fixing and code enhancement.
• Writing DOS batch scripts.
• Creating and automating the regular Jobs, Expertise in Transact-SQL (DDL, DML, and DCL) and in Design and Normalization of the database tables.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Used ODBC for accessing and retrieving the data from database to Jasper Reports
• Worked on installation and maintaining PostgreSQL DB on Development and Test environments
• Regular backups and replicating PostgreSQL DB using Slony and securing databases by controlling user access by creating various roles.
• Scheduling DB jobs using pgAdmin III.
• Environment: PostgreSQL, Windows, DOS Scripting, MS Visio, pgAdmin III, Slony, Bugzilla, pgpool-II