Ajay Kornepati

• Demonstrated strong organizational and time management skills while managing multiple projects.
• Adaptable and proficient in learning new concepts quickly and efficiently.
• Learned and adapted quickly to new technology and software applications.
• Gained extensive knowledge in data entry, analysis and reporting.
• Developed robust design for customer requirements and implemented the same to achieve project objective.
• Developed custom applications using Business Rules, Client Scripts, Script Includes by following best practices to achieve the requirements.
• Inbound and Outbound Integration with external systems and servicenow using SOAP/REST web services and SOAP/REST message functions involving extraction of data from payloads and determine the path for data flow.
• Handled complex data structures in the payload using Arrays, JSON Objects, Array of Objects etc.
• Worked on import sets, transform maps and transform scripts.
• Automated tasks and processes using workflows (start, cancel and restart based on conditions).
• Created conditional Schedule jobs for script execution and for generating reports using performance analytics.
• Designed UI Actions (list & form level), UI policies, UI policy actions to handle certain features of field availability.
• Created interactive filters, operational reports, and performance analytics reports and sent reports using schedule jobs, events and email scripts.
• Configured dashboards and moved them to higher instances and implemented Audit functionality.
• Configured assignment rules to auto populate values in fields based on user selection.
• Configured automatic email notifications and inbound actions when conditions meet the requirement.

Client

Qualcomm India.

Role

Development and implementation

Responsibilities:

· Handled various project related activities in planning, design, coding, deployment, unit test and Load test in tune with the core business objectives.

· Created Business Rules, Client Scripts, and Transform map scripts, UI Policies, using JavaScript.

· Worked on Custom Asset Management.

· Configured Stock rooms and Stock rules for the Custom ITHM.

· Enhancements related to the Custom Portal Widgets.

· Configured the notifications related to Asset life cycles and thresholds.

· Coordinate activities related to IT AM infrastructure setup and configuration, HW and SW asset tracking, coordinate with system and database administrators and project managers, documentation of related to ITAM activities.

· Served as point of contact for clients regarding follow-up, meeting scheduling and responses to questions.

· Kept detailed notes of all correspondence with clients and updated details in company's computer system.

· Initiated success of client's organization by improving performance, hiring practices and management systems.

Boosted success of client's organization by improving performance, motivation, job satisfaction, hiring practices, training programs and management systems

• Client
• Convey Health Solutions
• Role
• Development and implementation
• Responsibilities:
• Worked effectively with cross-functional design teams to create software solutions that elevated client-side experience and significantly improved overall functionality and performance
• Involved in gathering the requirements from the business team and writing the technical design documents
• Involved in configuring the Business Rules, Client Scripts, UI Policies, Data Policies in the ServiceNow
• Created server-side scripts, script includes
• Set up the SLA for the various ITIL processes as per the requirement
• Involved in various ServiceNow customizations as per client's requirement
• Loaded the data into ServiceNow using import sets
• Experience in configuring email notifications in ServiceNow
• Involved in redesigning the workflows using ServiceNow workflow editor
• Followed the AGILE approach with a 2-week sprint cycle and daily scrums
• Contribute to technical discussions and be involved in the decision-making process with other senior engineers to resolve product issues
• Attending client calls to understand the requirements
• Demonstrating the developed stories to clients at the end of each sprint
• Attending daily scrum calls to report progress to the scrum master
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.

• Worked with mapping and session parameters to pass the values dynamically
• Extensively used ETL tool Informatica to load data
• Implemented Type 1 & Type 2 slowly changing dimensions
• Extracted data from heterogeneous sources like oracle, fixed width and delimited flat files transformed the data according to the business requirement and then loaded into multiple databases
• Performance tuning of ETL Mappings to reduce loading times
• Document all technical and system specifications for all ETL processes and perform unit tests on all processes and prepare required programs and scripts
• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL Related Activities
• Provide Technical of Extract/Transform/Load (ETL) Solution for BI Projects
• Work Closely with Business Analyst, Data Modeler and BI Lead to ensure that the design meets end to end Requirement
• Tested troubleshooting methods devised innovative solutions, and documented resolutions for inclusion in the knowledge base for support team use
• Worked closely with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

• Designed appropriate ETL routines and mappings using Websphere DataStage based on the requirements and technical designs
• Integrated the data from Oracle 11g and SQL Server for populating large scale Data Mart and Data Warehouse
• Worked with the applications owners and system analysts to resolve data issues and refine transformation rules
• Coordinated with different teams like DBA, SSO, HLR, IN, AMS, Middle Ware and SDP to resolve Interface issues
• Performed and collaborated on system integration testing and support user acceptance testing
• Managed with different teams like DBA, SSO, HLR, IN, AMS, Middle Ware, and SDP to resolve interface issues
• Supervised scheduling the jobs using Informatica scheduler
• Raised change Requests based on defects faced& prepared SOPs (Standard Operating Procedures)
• Develop the task plan for ETL Developers for a Specific Projects
• Participation and contribution in quality assurance walk through ETL Components
• Support Development team with performance tuning and troubleshooting issues
• Proficient with the DB SQL language for user defined DB Extract or update statements
• Knowledge of logical and physical data modelling concepts (relational and dimensional)
• Managed quality assurance program including on site evaluations, internal audits, and customer surveys.

• Designed appropriate ETL routines and mappings using Websphere DataStage based on the requirements and technical designs
• Integrated the data from Oracle 11g and SQL Server for populating large scale Data Mart and Data Warehouse
• Worked with the applications owners and system analysts to resolve data issues and refine transformation rules
• Coordinated with different teams like DBA, SSO, HLR, IN, AMS, Middle Ware and SDP to resolve Interface issues
• Performed and collaborated on system integration testing and support user acceptance testing
• Managed with different teams like DBA, SSO, HLR, IN, AMS, Middle Ware, and SDP to resolve interface issues
• Supervised scheduling the jobs using Informatica scheduler
• Raised change Requests based on defects faced& prepared SOPs (Standard Operating Procedures)
• Develop the task plan for ETL Developers for a Specific Projects
• Participation and contribution in quality assurance walk through ETL Components
• Support Development team with performance tuning and troubleshooting issues
• Proficient with the DB SQL language for user defined DB Extract or update statements
• Knowledge of logical and physical data modelling concepts (relational and dimensional).