We provide IT Staff Augmentation Services!

Technical Consultant Resume

Plano -, Texas

PROFESSIONAL SUMMARY:

  • Over 8+ years of IT experience in Application development, implementation of Merchandise & Finance Operation, Development, Production Support, Migration and Modernization in large scale projects hosted in IBM - Mainframes, HP Nonstop, ETL & PL/SQL.
  • Rich working experience as Business Analyst in Retail Merchandising, Assortment, Allocation, Planning and finance applications. Extensive hands on experience on IBM Mainframe Application programming.
  • Outstanding technical and analytical skills, with extensive knowledge of UNIX, ETL, Oracle DB, SQL, COBOL, JCL, CICS, DB2, EZTrieve, C# and IBM Mainframe Systems.
  • Led team across functional tracks for design, development and implementation of direct to customer retail solutions in a global delivery model.
  • Experience in automation and scheduling the events using OPS/REXX/ CA7- Schedule Manager.
  • Widespread knowledge in all Retail domain processes.
  • Experience working on the project builds using the Agile and waterfall methodology.
  • Expertise in ETL (Informatica) tool along with the widespread knowledge in IBM-DB2, IMS, SQL, Oracle PL/SQL and Teradata databases.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Led team across functional tracks for design, development and implementation of direct to customer retail solutions in a global delivery model
  • Strong Data Warehousing ETL experience of using Informatica 10.1/9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Experience with dimensional modelling using star schema and snowflake models.
  • Experience in using the COGNOS & SAS tools.
  • Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
  • Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
  • Involved in the estimate planning, design discussions and scrum meetings for the project.
  • Experience in J2EE, JAVA Scripts, SPRING MVC.
  • Familiar in XML, MQ, PL/SQL, HADOOP concepts.
  • Expertise in developing design documents, system integration documents. Well versed with specification and documentation reviews, issue identification and documentation, ensuring thorough design and execution from a technical and business perspective.
  • Expertise in test case design, test scripting and test execution using Quality Center for medium to large projects in all stages of product development.
  • Ability to prioritize along critical path and meet project milestones and aggressive deadlines.
  • Self-starter and can handle work pressure to meet deadlines.
  • Rich experience in requirement gathering, analysis and POC activities.
  • Proficiency in using HP ALM, JIRA, REMEDY tool for writing test cases, Executing, updating results, defect handling.
  • Strong written and oral communication skills

TECHNICAL SKILLS:

Platforms: IBM-Mainframes, OS/ 390, Z/OS, HP-Non-Stop, UNIX/LINUX, JAVA, J2EE, Win - 98/2000/XP/Vista, iOS/8, WAS, C#.NET

Packages: Basics of Oracle Business Intelligence Enterprise Edition (OBIEE 10g), Oracle RMS Suite, Oracle RPAS, COGNOS, SAS

Tools: /IDE s: Toad, SQL Developer and SQL*Loader, Eclipse, Teradata SQL Assistant, SVN, Splunk, Putty, Humming Bird, SOAP-UI, Informatica, ISPF, MQ Series, BMC, JCL, VSAM, SYNCSORT, Easytrieve, File Aid, Xpeditor, InterTest, SPUFI, VSAM, TSO, ISPF, CICS, Teradata, Endevor, NDT2, Connect Direct, Toad for DB2, Eclipse, MR WIN 6530, CA Tools, ESP Workstation, DYL-280, VisualStudio.NET 2003, FTP/SFTP

Database: IBM-DB2, IMS DB/DC, SQL, Basics of Teradata, MS-Access, HP- Nonstop SQL

Scripting and Languages: Java, JSP, JS, SQL, HTML, DHTML, XML, XSLT, XSD and Unix Shell Scripting, TACL, JCL, DYL280, JavaScript, AJAX and JQuery, Oracle PL/SQL

Ticket/Defect Tracking Tools: HP Quality Centre ALM, Remedy, JIRA, Quick Base

Application Servers: IBM Web Sphere, Oracle Web Logic, IBM ZOS, IIS, Apache

Web Service tool: Soap UI, REST, JSON

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Roles and Responsibilities

  • Analyse/review client business requirements and assist in mapping these requirements to the process within the product/package.
  • Lead the evolution of possible solution alternatives that factor in gap resolution taking into account impact on related functional areas, user acceptability, technical feasibility and efficiency.
  • Involved in production support activities. Ensured the batch cycle gets completed in time. Also, fixed the issues within the time mentioned in Service Level Agreements (SLA).
  • Work involves fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends .
  • Creating the PL/SQL Scripts using REF CURSOR,GLOBAL TEMPORARY TABLEs, BULK LOAD
  • Converting Mainframe jobs to ETL scripts for data pull/push.
  • Development of the new batch programs using COBOL, PL1, DB2, JCL, VSAM for store Ordering & forecasting process.
  • Created COBOL stored procedures for updates to the database.
  • Performing Legacy Cobol program Demystification, Integration Development, Environment Setup & Non RMS Remediation including changes to JCL/Cobol Modules/PL1 including VSAM & DB2 modes.
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge by using ETL batch jobs.
  • Created REST Web services using JSON integrated with Spring Hiberbnate.
  • Develop ETL mappings to extract the JCP data and load into oracle stage tables which will be used by PO processing.
  • Provide on call support for the problems in PROD .
  • Lead the onsite and offshore team and track deliverables.
  • Perform configuration, build the application/process solution and support resolution of any issues with requirements/solution design.

Confidential, Plano - Texas

Technical Consultant

Roles and Responsibilities

  • Analyse/review Integration requirements and assist in developing approach to drive the event with minimal impact to Business.
  • Multiple meetings and discussion with the business on this new process as it impacts customer directly.
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge.
  • Worked with DBA and Application partner team to mitigate the risks.
  • Lead the onsite and offshore team and track deliverables.
  • Provide project specific sessions to train cross functional teams on the solutions.
  • Coded COBOL load modules.
  • Giving permanent solutions for the scheduling issues to the jobs in all the tools, System health check-up.
  • Monitoring Remedy , Resolving the remedy tickets with in SLA.
  • Manage Batch production support cycle and co-ordinate the efforts of the same with offshore team.
  • Autonomous Transactions, Tuning of large Table joins, Views and various joins
  • Creation of Functional specification documents, Technical design document and Integration of mapping documents for this process.
  • Take new scheduling requests from programmers, set up CA-7 job definition, schedules, triggers and requirements .
  • Used Endeavor to create, stage, and deploy COBOL packages in to production site
  • Create and modify JCL jobs in production using Emergency CRQ’s
  • Coded COBOL, PL1 and COBOL DB2 programs and tested them thoroughly
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.
  • Performance Tuning, Capacity Planning on DB2 environment.
  • Used File Aid, Easy Trieve DYL scripts for interfacing the VSAM/Flat files.

Confidential, Plano - Texas

Support Lead

Roles and Responsibilities

  • Level 2 application support with major activities including Acknowledging tickets, priority assessment, analyzing the issue for the work around resolution.
  • Bi-weekly reporting on the list of open/repetitive incidents to the governance.
  • Daily SLA reporting on the Application stability.
  • Performing Incident & PBI Management.
  • Created the AIX/Linux ksh/bash scripts for the module installation & compilation.
  • Got involved in the discussion with business to analyse the best way to handle the BOP, Gross Demand, Inventory, Mark- Up/down % and its up/down streams systems.
  • Co-ordination with Integration systems to get the correct response/requests from our RMS application to ensure new items are handled without any issues in the Planning process.
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge.
  • Explored the idea of using the Dependency Lines for handling the mattress recycle fee.
  • Lead the onsite and offshore team and track deliverables.
  • Having HOTO (Hand Over/take over calls) with offshore team.

Confidential, Plano - Texas

Support Lead

Roles and Responsibilities

  • Involved in KT/KA sessions with Development team and prepared DoU’s and presented reverse KT.
  • Analyzed, troubleshoot and resolved complex production application defects.
  • Identified root cause as part of PBI’s and devised and implemented permanent solutions to recurring defects.
  • Being part of ETL upgrades & patches for the DB releases and made sure that the application availability is not impacted.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
  • Developed mapping parameters and variables to support SQL override.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • New interface with pricing systems for the Shipping free calculations.
  • Developed the new inventory interface for E-Comm items.
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential, Plano - Texas

Module Lead

Roles and Responsibilities

  • Collated with all the partner system in the ASM and involved in testing/validation for the new interfaces built.
  • Provided optimized solutions for complex production application defects.
  • Requirement gathering from the business to achieve the E-Com Purchase Ordering Analyse/review client business requirements and assist in mapping these requirements to the process within the product/package.
  • Co-ordination with Integration systems to get the correct response/requests from our sterling application.
  • To make sure the metrics and the inventory in the stores/warehouses are correctly reflected in the system
  • Monitor the batch jobs that process the data from different systems and address any failures immediately.
  • Develop programs using UNIX shell script, PL/SQL as per the coding standards and the security policies
  • Develop mappings and Workflows for data extraction, transformation and loading from other systems using INFORMATICA (ETL tool) & SAS framework
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge.
  • Lead the onsite and offshore team and track deliverables.
  • Provide project specific sessions to train cross functional teams on the solutions.
  • Interface discussions and design.
  • New interface with pricing systems for the Shipping free calculations.
  • Developed the new inventory interface for interface for E-Comm items. Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential, Plano - Texas

Module Lead

Roles and Responsibilities

  • Requirement gathering from the business to achieve the Merch. Hierarchy Changes, Liquidation systems needs analyse/review client business requirements and assist in mapping these requirements to the process within the product/package.
  • Co-ordination with Integration systems to get the correct response/requests from our sterling application.
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge.
  • Lead the onsite and offshore team and track deliverables.
  • Provide project specific sessions to train cross functional teams on the solutions.
  • Interface discussions and design.
  • New interface with pricing systems for the Shipping free calculations.
  • Developed the new inventory interface for interface for Liquidations items. Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential, Plano - Texas

Technical/Support Lead

Roles and Responsibilities

  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1
  • Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
  • Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
  • Created JAVA modules that interacts with Oracle DB using JDBC and connections established using JNDI
  • Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
  • Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
  • Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
  • Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential, Plano - Texas

Technical Lead

Roles and Responsibilities

  • Analyse/review client business requirements and assist in mapping these requirements to the process within the product/package.
  • Lead the evolution of possible solution alternatives that factor in gap resolution taking into account impact on related functional areas, user acceptability, technical feasibility and efficiency.
  • Interfaced App’s using the IBM MQ series for connection with TIBCO/MQ Wewbsphere
  • Analysed the Legacy Sources and re-wrote the legacy logic to ETL Mapping.
  • Developed new Mapplet, Workflow session & Mapping to fixture the new requirements on Item.
  • Provide support in problem definition and documentation.
  • Lead the onsite and offshore team and track deliverables.
  • Provide project specific sessions to train cross functional teams on the solutions.
  • Interface discussions and design.
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential, Plano - Texas

Technical and Functional Lead

Roles and Responsibilities

  • Schedule/Job - Monitoring Using ESP (Enterprise Scheduler) for IBM mainframes jobs on both test/Prod environments.
  • Researching Key attributes on Application migration, providing the 100% business continuity with no planned Outage.
  • Database Switches between the applications.
  • Working for limiting manual work and to achieve fully automated system.
  • Working with several Source systems for upgrade and Maintenance and Testing the prod systems after upgrade/maintenance
  • Development of enhancement release work. Guide offshore for the release work and review before implementation in production.
  • QA Migration and testing for new implementation using TCA and providing necessary support.
  • Analysis of long running process and planning for performance tuning.
  • Development and deployment of performance improvement work.
  • Investigation and solve production issue and bug fixing.
  • Schedule handling and co-ordination with other team in recovery situation.
  • Managing and planning the work assigned using IPMS/JIRA/REMEDY tools.
  • Working with DBA’s & Business to understand the Key requirements and adopting the changes to the new LPAR
  • Experience in using XEN, OpenStack, Hyper-V or VMWare ESX.
  • Creating documents, sharing the status reports to key stake holders on the Migration Activity.

Confidential

Technical Lead

Roles and Responsibilities

  • Schedule/Job - Monitoring Using ESP (Enterprise Scheduler) for IBM mainframes jobs and Using Batchom for job in HP-Nonstop. Also Monitoring all Pathcom server.
  • Working for limiting manual work and to achieve fully automated system.
  • Working on Issues with Payment Web Service. Restarting the JVM’s.
  • Analysis of long running process and planning for performance tuning.
  • Development and deployment of performance improvement work.
  • Investigation and solve production issue and bug fixing.
  • Schedule handling and co-ordination with other team in recovery situation.
  • Managing and planning the work assigned using IPMS
  • Attend training to enhance the expertise in data warehousing.
  • Used COGNOS reporting tool for exposing the sales data for the Safe pay Users.

Confidential

Sr. Developer

Roles and Responsibilities

  • I was involved in the many smaller project interfaces with order management and inventory management track.
  • Lead the team through post production support, product upgrade to Sterling version 9.2 and further enhancements to OMNI solution to support various new initiatives (e.g. expansion of fulfilment network, transportation lane changes, changes to promotions strategy each of which were executed as small overlapping projects).
  • Involved in the project of RLC fulfilment in Sterling for Legacy Interfaces.
  • Involved in the refining of Exception handling process.
  • Analyse and evaluate the as-is-process, identify the high level process/system changes, define and document the problem based on client inputs.
  • Mapping business requirements onto Sterling framework and defining the to-be-process.
  • Assessing implementation options / solution alternatives based on research and product capabilities and build proof-of-concepts.
  • Developing functional specification and solution design.
  • Interface applications using Mainframe Load modules & XML scripts.
  • Performed configuration, build the application/process solution and support resolution of any issues with requirements/solution design.
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.

Confidential

Sr. Developer

Roles and Responsibilities

  • Analyse/review client business requirements and assist in mapping these requirements to the process within the product/package.
  • Lead the evolution of possible solution alternatives that factor in gap resolution taking into account impact on related functional areas, user acceptability, technical feasibility and efficiency.
  • Lead the analysis of requirements to deliver solution alternatives, to-be design flows and detailed design artifacts by using process/solution/product knowledge.
  • Guide and plan configuration activities including third party Technical & functional team to ensure resolution of requirement and solution design issues/queries with support from product Vendors.
  • Involved in business requirements gathering and validation.
  • Provide support in problem definition and documentation.
  • Lead the onsite and offshore team and track deliverables.
  • Provide project specific sessions to train cross functional teams on the solutions.
  • Interface discussions and design.
  • Follow the deployment plan; resolve data migration issues, support other team members in deployment activities for a smooth go live.
  • Used SAS jobs to report the IOM Order data and reported the Brokerage information’s on COGNOS Reports for business validations.

Confidential

Production Support Engineer

Roles and Responsibilities

  • Level 2 application support with major activities including Acknowledging tickets, priority assessment, analyzing the issue for the work around resolution.
  • Bi-weekly reporting on the list of open/repetitive incidents to the governance.
  • Daily SLA reporting on the Application stability.
  • Performing Incident & PBI Management.
  • Support Critical/Non-Critical ZOS scripts/Jobs.
  • Core Application design, Development, Testing and Production support. Developed programs which deal with MQ’s, DB2 Stored Procedures.
  • Analysing the functional and Detailed Design specification
  • Design and development of programs and jobs using JCL, VS COBOL II, VSAM, DB2
  • Debugging and implementing the system.
  • Involved in production support activities. Ensured the batch cycle gets completed in time. Also, fixed the issues within the time mentioned in Service Level Agreements (SLA).
  • Work involves fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends.
  • Monitoring the Batch Cycles & Handling Ad-Hoc Requests.
  • Working on various ETL (informatica) changes based on the business requirements.
  • Developing programs using COBOL, COBOL85, DB2, Non-Stop SQL as per the coding standards and the security policies
  • Addressing Performance issues reported in the existing application by doing SQL tuning, re-org, index creation and collecting statistics on the tables used by the application.
  • Researching the incident with the system logs and errors reported by Users
  • Providing resolution if incidents are due to user errors and procedural errors
  • Fixing the defects if incidents are caused by code issues. Performing testing of the code and deploying in Production.

Confidential

Business Domain

Roles and Responsibilities

  • Learning TCS Processes and methodologies.
  • Learning and getting hands on in TCS proprietary tools.
  • Performing role plays to understand various TCS - Internal Processes and methodologies.
  • Developing Interpersonal communication skills.
  • Working on mini projects by implementing software development Life Cycle Process (SDLC)
  • Requirements Gathering.
  • Unit testing, system and Regression Testing Methodologies.
  • Developing applications using SAS, UNIX and Oracle

Hire Now