Lana Leyderman

Summary

Information technology Technical Lead and Software developer with over 20 years of experience in Business Enterprise systems. Dedicated to Full Development Systems Life Cycle. Requirement definitions, Analysis, System design, coding, testing, Implementing. Effective Team leader who can promote best practices and focus on strong collaboration through cross functional teams. Educational background and substantial experience allow sureness to understand different fronts of business processes, while excelling in multiple roles during my career as a Team Leader and Programmer/Analyst Software Developer. Leading team of software developers, working with stakeholders, prioritizing, estimating and delegating work. In my current projects I was involved in billing software updates UI front end and back-end, batch and online enterprise system, invoicing and financial reporting. Database loads and extracts for new pricing and VAT tax are examples of latest projects. Working with internal and external auditors, making sure that there is no revenue leakage in the billing and financial systems.

Technical and Project management skills

Programming Languages:

COBOL, COBOL ILE, JCL, CICS, FOCUS, SAS, SQL, XML, VBScript, Visual Basic, JAVA, .NET

Operating Systems:

MVS, TSO, OS/390, Z/OS, JEZ2, UNIX, AS/400, Windows Server 2012 / 2010 / 2008 / 2003

Development tools/Utilities:

Synon, FileAid, INSYNC, ENDEVOR, PANVALET, XPEDITER,

SYNCSORT utilities, File manager, DBUTILITY, CONTROL M, CONTROL D

IDCAMS, CA-IDEAL, CA-DATACOM/DB, OMEGAMON, SPUFI, CA7,CLIENT SERVER MANAGER, ETL,

FOCUS, RPG, VSAM, GDG, CAGen, OMEGAMON, Spoofi, QMF, APPEON PowerBuilder 17,

CAB approval/implementation process,

SharePoint

MS Office, Fore Help, Lotus Suite,

Visual InterDev 6.0,

Crystal Enterprise 11 / 10;

Database:

DB2 12, IMS DB,

SQL Server 2014 / 2012 / 2008 / 2005, Data Warehouse, SQL Server Business Intelligence: Reporting, Analysis

Project Management:

Agile environment with SCRUM team focusing on sprint by sprint deliveries, Waterfall, Business Analysis, UI/Interactive Design, Usability Testing, Process Design, Roadmap Planning-Commerce Migrations. Using JIRA, Service NOW, AHA, handle CAB approvals and meetings

Experience

December 2000 to present

• Travelport

2010-present - Sr Technical Lead Software Developer

Major Strategic Projects 2015-2021

1.Worldspan Merger - Adding new core to processing due to merger with Worldspan, in addition to Apollo 1V and Galileo1G added new core 1W. This project was around 5000 hours and included a variety of various teams working jointly together. My role was a key developer in billing and invoicing systems. I created new COBOL programs that take Worldspan data, validate, enrich, and convert it to the Travelport layout for further downstream processing of pricing and invoicing. Schedules were updated and most DB2 tables were affected. I created new reports as well as dashboards for the new core. Current and existing jobs/programs were expanded and modified to accommodate the new data. Cobol/DB2/SQL Server/FOCUS.

2.Pricing projects – Adding new pricing structures and introducing new products to be billed for our vendors. These projects were one of the most important initiatives in our billing and invoicing systems. Projects were typically initiated in September/October and were implemented for a late Q4 or early Q1 deployment. Most product and pricing modules were modified and enhanced with new functionality. These projects were rigorously tested. Expanded test cases were created while regression, parallel, and user acceptance tests were run to ensure that invoices were produced and accurately included the new product pricing structure for particular vendors/countries and other system indicators. I played a major role with the management, development, and deployment of these key initiatives. IMB mainframe enterprise and SQL Server – SQL Server, COBOL, JCL, DB2, CICS, FOCUS

3.SOX audit project - Managed and was part of the team that created a parallel branch to our system that ensured that there are not gaps or disconnects in our production process. I coordinated status meetings and all code walk-thru for our new processes. I wrote a portfolio of new reports for all tables/files were updated by users and/or batch jobs. These Audit reports provided user engagement and notification to ensure that updates were performed correctly and accurately per their instructions. FOCUS, JCL, new CA7 schedules.

4.PowerBuilder upgrade from version 9 to version 17 – Responsible for this upgrade. I worked closely with a contractor for 3 months to make sure that all necessary modules are updated according to new version and all licenses are current and deployed to the servers. While managing the upgrade I also coded and developed along with a contractor. The upgrade also included upgrading DB2/Connect to a more current version. I worked closely with DBA team to ensure that the connection to the DB2 tables was setup properly. I created new executables for users in the new version and performed extensive testing for the upgraded system prior to deployment to our QA area.

PowerBuilder API, scripting language, SQL Server, GitHuB.

5.VAT charges for customer invoices (Several Projects) –I managed all these projects from requirements to implementation which included adding a new VAT tax to specific countries based on legal requirements. I worked on design, estimations, delegating tasks, coding, and implementation. Facilitated status meetings and peer reviews, code walk-thru, and coordinated user acceptance testing. COBOL, CICS, JCL, FOCUS, RPG.

South Africa VAT - 2018

Malaysia VAT- 2018

Russia VAT - 2019

Mexico VAT – 2020 – this was to fully automate VAT tax process, so if any other countries would be charging VAT tax then users just need to go and update table via UI screen to set it up.

6.Migration project – Replacement of non-air processing from mainframe to BRM (oracle). My role was to coordinate development efforts across the Business and Technical teams of legacy billing, BRM, EDW, and FA. I focused on design, estimate delegation of tasks, testing cases, and implementation/deployment. Non-air billing and invoicing system was revamped, and process was moved to BRM, mainframe jobs were converted to BRM process in oracle, however some pre-bill pieces were modified and kept in MVS. Pricing and invoicing are processed now in BRM. Receiving data back from into legacy system for match-back. COBOL, JCL, DB2, SQL Server, SSIS packages.

7.Data Warehouse Integration - Handoff of segment/ticket data to EDW data warehouse. I was involved in the transfer non billable data, daily and monthly files to the EDW team for reporting of the SQL Server, (Cognos, BI). Extraction of non-billable data from DB2 database – including more extraction criteria selecting active, non-bill, tickets segments, for certain cores. Data extracted into CSV format and stored in AWS S3 bucket then formatted and validated and loaded to SQL server EDW.

Tactical Day to day activities

1.Monitoring the billing process to ensure it completes and meets the SLA – daily /weekly/monthly/Quarterly. Daily process starts in the evening and continues through early morning. Final product for daily process is revenue reports.

2.Produce estimates and technical designs for new projects and major enhancements to billing systems, work with business – on understanding requirements and identifying functional changes and new development.

3.Bi/Weekly meetings with RUN (prod support) and Build (new dev) teams, going over all the requests for enhancements, incidents, and projects. Using JIRA and Service now. Making sure that teams are meeting deadlines and there are no roadblocks. Ensure testing and approvals are lined up while identifying issues and risks.

4.Leading project meetings typically once a week with all players involved.

5.Typically work on projects myself as well, coding, testing and implementation. I need to assist the team as resources are engaged and deadlines are tight.

6.Setting up code walk thru and peer reviews prior to project implementations.

7.Work closely with the Change Management Teams – Pre-CAB and CAB meetings, once projects are ready to be implemented. Making sure that all approvals are received for QA, architecture and user acceptance teams, peer review codes, documentation.

8.Report back to my managers on main accomplishments and statuses for key projects.

9.Enhancements to UI PowerBuilder system, new screens for new tables and add new fields as part of enhancement, my last screen was for TAX VAT table, so users can add new VAT tax for vendor country and that would flow to add VAT tax for invoices in those countries.

10.Approve timesheet and time off for my team, making sure that hours added in a proper bucket and allocated to the correct projects while keeping in budget.

Deliverables as a Developer

New updated UI screens in Appeon PowerBuilder 17. Git. GitHub.

New data that is being concatenated to existing process and needs to be billed.

New pricing structure or products that would result in changes to vendor invoices.

Create or update existing code that would handle new pricing logic. SQL Server, IBM Mainframe/Cobol/DB2, JCL, FOCUS reports, RPG reports.

New reports for revenue groups, financial data, sliced by country/vendor/core/products/territory and more criteria. Focus and Tableau.

On-demand SQL updates to SQL Server database or DB2, even if we have UI. Write SQL queries/inserts to load the large data, to avoid user data entry errors.

Various updates to invoices, tax information, credits, manual invoices, and manual credit. IBM Mainframe CICS/DB2/Cobol.

Deliverables as a Technical Lead.

Create and design projects and large enhancements based on user requirements.

Create estimates and detail break-down for project.

Delegate work to my team to meet project deadlines while aligning skills.

Track project status. Facilitate status meetings for projects and day-to-day work. Using JIRA and ServiceNow.

Coordinate work/receiving new data/sending data to other teams for further processing.

Sending key accomplishment and status report to management.

Update system documentation, adding/removing functionality, modules, files and more using Visio.

As a Sr Technical Lead, I manage a team of local and offshore software developers. Effectively coordinate work with stakeholders and technical team ensuring successful implementation of numerous projects and meeting SLA.

Successfully work across time zones, most business users are in UK, several teams are in Atlanta and Denver.

Partner across the organization to build comprehensive solutions to fit emerging business requirements.

Leading team of software developers, guiding them to deliver quality product, code, ensuring projects are completed on time and budget.

Communicate, both verbally and in writing, to explain how the various technical pieces fit together. Support the definition and enforcement of data governance policies.

Provide functional and technical subject matter expertise in various data management, warehousing, and Business Intelligence and Big Data solutions across multiple platforms.

Ability to gather, document, and execute detailed specifications from high-level requirements with little supervision.

Create deliverables according to the Software Development Lifecycle such as functional and technical specifications, use cases, test cases, and system documentation. End to end delivery of projects. Financial reporting and invoices are produced daily/weekly and monthly with very rigorous SLA.

Define, design, and develop system functionality to meet business requirements.

Create test cases, execute tests and resolve defects.

CI/CD delivery model.

Apply project management standards and concepts, Agile methodology, prepare work estimates and work schedules; update project plans; identify issues and risks.

Excelled in guiding the work of technical teams. Managed and articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones

Travelport

Jan 2010 – Jan 2015 Sr Software Developer

Hands on working with a full stack mainframe enterprise as well as UI in PowerBuilder, TABLEAU for reporting.

Key contributor to number of projects and enhancements in financial billing systems. Worked on a new process in billing systems from an idea to implementation, added new core for Axess – Japan Airlines and expanded billing from monthly to weekly process. Both projects included big changes to database new tables and new modules, schedules, new data feeds to downline data warehouse team and more. Both these projects involved working across multiple teams and stakeholders/business units.

Yearly pricing projects in Billing systems, created new process utilizing COBOL, JCL, FOCUS

Travelport

December 2000-December 2010 - Software Developer

Started with Travelport as a Sr Developer working on projects and enhancements in Billing Invoicing financial enterprise utilizing DB2/SQL/ mainframe Cobol and JavaScript/Java skills, BI tools Crystal reports, Focus, Ezitrieve, PGR reports.

Supported non-air billing systems Leisure Shopper, Car and Hotel.

Wrote reports for non-air application in RPG, FOCUS and Crystal Reports.

Production support for non-air and air billing process, on-call duties.

Managed offshore team, provided them with functional design and delegated work, code walk-through and acceptance testing.

Nov 1997 –Oct 2000

Software Developer • Harco Insurance

Y2K conversion

Worked on Credit card management system, Vision Plus

Participated in conversion, redesign, implementation and maintenance of packaged AS/400 application (PMSC)

Worked as member of a group responsible for developing new intranet web site from existing application. Functionality allows for searching from different threads, implements file locks for reading and incrementing page counts, implements class level locks for creating of statistics.

Created and designed data structure and stored procedures.

Create application development plans across multiple projects and revises as appropriate to meet changing needs and requirements.

Developed GUI for entry and description of support claims with outlining features and navigation using PowerBuilder.

Education

Graduated in 1997

DeVry University, Chicago, IL

Bachelor of Science (B.S.). Computer Information systems

Contact this candidate