Candidates About

 

John Daniel Tadikonda

 

PROFESSIONAL PROFILE

·         About 10+ years of expertise in software design, development, deployment and support. Unicenter Autosys job management, CA Workload Automation AE, WLA 11.3.6,WLA 11.3.5. Autosys 11.0, Autosys 4.5, EEM ,WCC, CA- 7 scheduling, Kofax, Right Fax, People Soft Applications, Siebel Applications, iDash, Service Now, Remedy, Heat Management, Ariba Spend Management, Data Content Management and Production support specialist of large and complex Data warehouse applications.

 

·         Certified professional of ITILV3F. Involved in all the areas of IT Development life cycles as well as Production environments.

·         Around 8+ years of professional experience in various stages of Information Technology in Data Warehousing for business systems like Retail, Insurance, HealthCare, Auto Mobile and Educational Universities.

·         Defines detailed requirements.

·         Analyzes business needs, and validates solutions with the client.

·         Responsible for program design, coding, testing, debugging, and documentation.

·         Responsible for quality assurance review, maintains and creates automated batch standards as well as documentation of automated batch processes and supporting components.

·         Maintains and supports production job schedules and calendars in the automated batch scheduling tool.

·         Experience in insertion of JIL’s into the database and execution of the JIL’s, troubleshooting if necessary and advising the developers on the error –correction if required.

·         Experience in installing Autosys Server & Remote Agents for the different Environment.

·         Good expert in designing/ installing/ implementation/ troubleshooting/ Supporting Unicenter Autosys and CA-WCC a Product of CA (Computer Associates).

·         Work with different Support team remotely and resolving Production issues on time basis.

·         Remote support and troubleshooting experience and identifying the root cause of the issue.

·         Kofax installations

·         Kofax Image processing.

·         Extensively worked with Global variables and Resource to schedule jobs and flow.

·         Expert in CA 7 scheduling tool. Expert in converting CA 7 schedule to Autosys schedule.

·         Creating Autosys Calendars and migrating those calendars from one environment to another environment

·         Experience in using Autosys 4.5 Web Interface for creating and analyzing the Autosys job flow.

·         Experience in analyzing the root cause of the server failure and ensured the backs up servers are in the “High Availability mode” until the server is back up in production.

·         Managed job failure, escalation to the respective department.

·         Analyzed the reason for the job failure and prepared the reports to the senior managers.

·         Highly motivated, dependable troubleshooter and problem-solver.

·         Enthusiastic learner who quickly grasps new concepts and technical skills.

·         Expertise in development and design of ETL methodologies for supporting data transformations and processing, in a corporate wide ETL environment using DataStage 8.X.

·         Proficient in all phases of the systems development lifecycle, including requirements Definition, Data Cleansing, Data Conversion, System Implementation, Performance Tuning and Post production support.

·         Maintenance, testing and implementation of medium – large scale applications.

·         Immense experience in working with different Teams from Development to QA testing.

·         Extensive experience with ETL processes using Data Stage for multiple database source environments to Data Warehouse/Data Mart in UNIX environments.

·         Excellent Experience in Object Oriented Design and Development using UML based tools (Visio).

·         Experience in Implementing Monitoring and updating of (Virus Server) NAV server ensuring Virus signatures are up –to-date and EDI (Electronic Data Interface).

·         Configured and documented the migrations steps for Unicenter Autosys Jobs management for State Street Environment.

·         Experience in integration of various data sources like Oracle, Informix and Flat files into the staging area.

·         Used Both Pipeline Parallelism and Partition Parallelism for improving performance.

·         Experience with Version Controls in Data Stage and scheduling the jobs using Autosys.

·         Concept of dimensional modeling with star, snowflake schemas and Slowly Changing Dimensions.

·         Basic knowledge and Corporate trained on Business Objects, Cognos, Siperian, Remdey and Informatica.

·         Good communication skills, a good team player and self-starter, capable of working independently and motivate a team of professionals.

 

 

AREAS OF EXPERTISE

 

	Hands on Tools	Autosys R11.3.5, Autosys R11, and Autosys 4 5, WCC –Work Load Automation Control, EEM Management, Kofax, Right Fax, People Soft, Remedy Ticketing system Terminal service, Heat Management System, Ariba Portal EPCR management system, Data Content Management, People soft SIR Log, ACCE, JIRA, FTP, SFTP, DataStage 8.X/7.X/6.0, Service Knowledge Management System, Business Objects, Cognos, Siperian MDM, Informatica, SIEBEL, HP-QC, CA 7 ( Mobius Reporting), and Mainframe Scheduling.
	BI Tools	DataStage 8.X/7.X/6.0 (Manager, Designer, Director, Administrator, Parallel Extender, Quality Stage), DataStage Plug-In, OLAP and OLTP.
	Data bases	Oracle 10g/9i/8i, MS SQL Server 2000/7.0/6.5, DB2 UDB.
	Operating Systems	Windows NT/95/98/2000,2003 and 2008 UNIX, LINUX, AIX
	Programming Languages	SQL, PL/SQL, Unix Shell Scripting, Perl scripting.

EDUCATION

Master of Computer Applications 2006, Andhra University, Andhra Pradesh, India

 

CERTIFICATIONS

ITILV3F Certified Professional 2008

IBM DataStage Certified Professional 2009

 

 

PROFESSIONAL EXPERIENCE

 

LFG – Lincoln Financial Group Fort Wayne, Indiana

Mar 2015 to Till Date

 

Environment: Autosys R11.3.6 and Autosys 11.0.1, CA 7, iDash, Main Frame, PeopleSoft Application, CA Workload Automation, WCC, EEM, FTP, SFTP, Remote Agent scheduling, Oracle 12c, AIX, Unix, Linux, MS Visio, MS Office Suite, Windows 2008, 2012, SQL Developer, Unix Shell Scripting, Perl Programming,

 

Role: Autosys Admin Activities

 

Responsibilities:

• Managing the environments across LFG.
• WLA 11.3.6 Agents, Client and WCC installations on different servers.
• Autosys Server Maintenance.
• Resolving the production issues based on priority.
• Working with different teams to make sure all the required components available.
• Adding users to WCC and credential to Autosys.
• Integrating the different environments.
• Applications and Systems upgrades.
• Monitor all production job streams.
• Co-ordinate with development teams to manage failures and restarts.
• Manage job stream promotions from dev through to prod.
• Best practices and standards guidance.
• Proactively monitor performance of consolidated environments.
• Assist in identifying choke points.
• Coordinate with other infrastructure teams to maximize availability of the core Autosys environment (scheduler, event server and consolidated agents).
• Advising the user on the JIL’s. Uploading the Daily data feed to respective Departments and applying and update the patches in the weekends.
• Applied Incremental INC1, INC2 and INC2 patches on AIX servers.
• Applied patches on 120+ servers including Dev, UAT, TEST and PROD environments.
• Analysts who can identify all the steps required to complete processing within the business units realm of responsibility.
• Developer resources to create, maintain and support Autosys jobs.
• Identify all processes and starting pre-requisites for processing within their area of responsibility.
• Identify business owner and source system for any incoming data feeds used by processes on your systems.
• Identify outputs, target system and business consumer of any data being sent to other systems.
• Co-ordinate with other teams to build integrated job streams.
• Follow job stream development guidelines.
• Create and test job streams.
• Identify and correct problems that are preventing job completion.

 

 

OSU – Ohio State University, Columbus, Ohio

Jan 2014 to Mar 2015

                                                                

Environment: Autosys R11.3.5 and Autosys 4 5, PeopleSoft Application, CA Workload Automation, EEM, FTP, SFTP, Remote Agent scheduling, Oracle 11g, Unix, Linux, MS Visio, MS Office Suite, Windows XP,  SQL Developer, Unix Shell Scripting, Perl Programming,

 

Role: Autosys Developer with Admin Activities

 

Responsibilities:

• Involved in scheduling of jobs start utility to populate the batch number to the parameter set file at the start of the batch.
• Designed the migration process for OSU Environment to merge with existing 50 Instances of Autosys.
• Responsible to moving more than 7,000 hundred Autosys jobs into the existing OSU Environment.

·         Planned and performed a rollout of Autosys 11.3.5 to the enterprise, encompassing two environments and 200 users, and managed the migration from Autosys 4.5.1 to Autosys 11.3.5.

• Installed, Configuring and Troubleshooter of Unicenter Autosys scheduling server/clients on Windows NT/ 2000/ 2003/ XP, Sun Solaris, AIX and HP-UNIX. Linux.
• Involved in pivotal role of an Autosys design and DevOps specialist for an Autosys R11 Upgrade (from Autosys 4.5) for corresponding PeopleSoft 9.2(from Peoplesoft 8.9) upgrade in the Ohio State University.
• Re-designed Autosys flows according to Business need and followed OSU Standards.
• Responsible for insertion of JIL into the database and troubleshooting the JIL’s in case if it is wrong. This involves troubleshooting, in depth analysis, customizing, debugging and various other aspects of integration with other Products.
• This complex project with interlinked job connectivity is developed using Autosys JIL Scripting, Unix Korn Shell Scripting, and Unix Perl Scripting with the back-end that connects to PeopleSoft database via Oracle. Primarily involved in HR and Student Information Systems (SIS) upgrade.
• Involved in the gathering, design, development and support of DWH jobs, Cross Dependency jobs from 4.5 to R11, retrofit from previous version to the current, delete the older and obsolete versions etc.
• Creating Remedy tickets to keep a track of the Incidents that happened during migration process.
• Querying the Autosys Database and generating the reports to management as per the request.
• Configured and documented the migrations steps for Unicenter Autosys Jobs management for OSU Environment and uploaded the same in the Share point site for Global users.
• Helped clients in implementing, designing and troubleshooting all the above mentioned. This includes Performance tuning, Application tuning, according to the OSU standards and procedures
• Responsible for resolving the data issues, TNS issue, Not Enough space, and Resource busy.
• Used Director to run the jobs, monitor the logs and scheduling the jobs.
• Extensively worked in the performance tuning of the jobs, ETL Procedures and processes.
• Documented all the jobs and stages involved in ETL process.

·         Designed and Developed Server jobs to extract, clean, load and transform data using Datastage from heterogeneous systems to Oracle

·         Assisted in understanding/finalizing the infrastructure requirements at offshore including sizing; played key role in smooth operation of development environment

·         Assisted Mapping team to transform the business requirements into ETL specific mapping rules.

·         Conducted training sessions for other ETL developers on the best practices as well as performance improvement techniques

• Involved in the production support and monitoring the datastage jobs.
• Responsible for testing of business intelligence reporting solutions

·         Develop and maintain the manual and automated test scripts, functions and SQL code

 

 

TIAA–CREF Sec17a3 (Security Exchange Scheme), Charlotte, NC

September 2011 to May 2012

 

 

Environment: Autosys R11.0.1, Autosys4.5, WCC Automation, Data Stage 8.1, SIEBEL, HP-QC, CA 7 Scheduling, Oracle 11g, MS Visio, MS Office Suite, Windows XP, Flat Files, SQL Developer, Unix Shell Scripting, Borland Star team version management.

 

Role: Autosys Developer with BI Skills

 

Responsibilities:

• Design and development for allocation of work, monitoring of day-to-day task and making sure deliverable deadlines are as per plan.
• Single point of contact for co-ordination with Onsite to gather information necessary for development.
• Designed and implemented migration process and migration of 350 applications in Autosys 4.5.
• Insertion of JIL into the database and troubleshooting the JIL in case if it is wrong.
• Advising the user on the JIL’s. Uploading the Daily data feed to respective Departments and applying and update the patches in the weekends.
• Re-designed more that 300 Autosys flows TIAA–CREF environment needs.
• Experience in using Autosys 4.5 Web Interface for creating and analyzing the Autosys job flow.
• Querying the Autosys database as well as using the Toad, JAWS Tool for pulling the reports as per the management request
• Creating Autosys Calendars and migrating those calendars from one environment to another environment.
• Testing the Job Flow before in UA and in Test Environment before they are put on Production.
• This involves troubleshooting, in depth analysis, customizing, debugging and various other aspects of integration with other Unicenter Products by logging in remotely into their servers.
• Monitored the different Autosys Server Instances and escalated the critical Job failures to the respective department and analyzed the reasons for the job failure prepared the detail summary and reported the cause of failure.
• On Call support for Autosys 4.5 and was First point of contact when batch Job fails.
• Implementing the JIL according to SOX Compliance and retrieving the reports as per SOX policies.
• Provided Autosys support via writing training manuals to Operations for transitioning monitoring functions of Autosys.
• Responsible for the data conversation using datastage.
• Responsible for the IBM Infosphere.
• Responsible for data analysis, requirements gathering, report analysis, source-to-target mapping, frequency analysis, process flow diagrams, and documentation.
• Responsible for preparing Physical/logical data models.
• Responsible for generation of table statements which are executed for database creation.
• Responsible for preparing adhoc reports.
• Translated business rules and functionality requirements into ETL procedures.
• Import/Export DataStage jobs for code migration.

·         Designed and Developed Test Scripts, Test Cases to perform Unit testing, System Testing.

• Created various active and passive stages like Sort, Lookup, Filter, Join, Transformer, ChangeCapture, Sequential file, DataSets, RDBMS stages and standard/reusable jobs using DataStage.
• Responsible for ETL testing using SQL server integration services.
• Execute test scripts and plan for unit, integration and UAT testing process.
• Extensively worked in the performance tuning of the jobs, ETL Procedures and processes.
• Documented all the jobs and stages involved in ETL process.
• Worked with Developers to troubleshoot and resolve job logic as well as performance issues.
• Responsible to tune ETL procedures to optimize load and query performance.

 

 

Novo Nordisk, PDR Master Data Support, New Jersey, Princeton Junction.

January 2010 – September 2011

 

Environment: IBM Info Sphere Data Stage 8.1, MDM, Sipearian, Oracle 10g, MS Office Suite, Windows XP, Toad, Unix Shell Scripting.

 

Role: ETL Datastage Developer

 

Responsibilities:

·         Provided Technical support to the team as the ETL developer. Addressed best practices and

Productivity enhancing issues

·         Developed the data conversation using datastage.

·         Involved in IBM Infosphere and developed the various projects.

·         Involved in designing and developing data masking techniques to mask sensitive information when working from offshore

·         Used Datastage Administrator to create repository, user groups, and managed users by setting up their privileges and profile.

·         Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.

·         Identified source systems, their connectivity, related tables and fields and ensured data consistency for mapping.

·         Created source table definitions in the DataStage repository by studying the data sources.

·         Imported and exported repositories across projects.

·         Created error files and log tables containing data with discrepancies to analyze and re-process the data.

·         Created job schedules to automate the ETL process.

·         Used the Data stage Manager to import, export jobs and routines.

·         Written various Triggers, Stored Procedures to perform or automate many of the tasks.

 

 

 

GM Onstar, Reporting Data Store, Chennai, India

March 2008 – September 2009

 

Environment: Data Stage 7.5.3 (Manager, Designer, Director), Toad, Oracle 10g, Cognos, Autosys, And Unix

 

Responsibilities:

·         Monitored the ReDS application production cycle 24x7 processes.

·         Worked implementation upgrade of Autosys and JAWS, troubleshoot errors and documentation/procedures.

·         Migrating jobs into production.

·         Monitor Production Jobs to ensure successful execution.

·         Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.

·         Actively finding the issues and fixing the issue to provide the business solutions.

·         Daily Production Support recurring tasks and monitoring of the tickets queue, assign tickets, resolve tickets and update the root cause and remediation.

·         Provide technical expertise to the team members.

·         Analyze the production issues regularly and bug fixing.

·         Resolving the production issues within the time period.

·         Simultaneously working on change requests.

·         Designing the jobs based on the business requirements

·         Developing the jobs.

·         Participated in the review of Technical, Business Transformation Requirements Document

·         Coordinated with the QA and Testing Teams to fix the gaps between business, development and implementation phases for all Source Systems

·         Prepared documentation to describe program development, logic, coding, testing, changes and corrections.

·         Performed Unit Testing, System Integration Testing and User acceptance testing

·         Deploying the jobs in production environment at appropriate time interval. 

 

 

GM WWP MaRS, Chennai, India

September 2007 – March 2008

 

Environment: IBM Ascential DataStage 7.5.2, Cognos7.3, MS Visio, MS Project, MS Office Suite, Windows 2000/XP, HP Quality Center, TOAD 9.2, Flat Files, Unix Shell Scripting

 

Role: ETL Datastage Developer

 

Responsibilities:

·         Successfully implemented the new code to transfer the data that eliminated the data anomalies.

·         Provided Technical support to the team as an ETL developer. Addressed best practices and productivity enhancing issues.

·         Involved in ongoing production support and process improvements; Ran the DataStage jobs through third party schedulers.

·         Created common components to be used across different streams and standardized the code implementation.

·         Created different components like Email Notification component to capture error at loading tables and components to FTP the output files.

 

Business Data Unit, Chennai, India

May 2006 – August 2007