SUMMARY:

Senior IT professional with well - rounded experience on Application Re-platforming, Master Data merging, Re-platforming, B2B and Corporate merger related integrations. Worked with legacy as well as for Unix/Linux Cloud based apps. High-Impact UX coach for online access and real-time reporting that needs “one version of truth”. Setting up PMO governance and QA methods. At ease with common EDI and non-EDI B2B integration methods featuring automated data sync, load-balancing and recovery. Successfully led cloud-mode Oracle app development on Unix/Java and Hadoop/PIG platforms. Big Data experience on customer and competition price data. Managed high-visibility corporate M&A projects with stellar records for on-time delivery. Handled vendor SOW negotiations, software acquisition, offshore transition for 7x24 L2/L3 support .

EXPERTISE AREA:

• Legacy Modernization and app portfolio updates
• Mediating 24x7 Support using BestShore model
• SPOC for B2B and Hosted App Vendor Integrations
• Integrations for Legacy app, EDI & B2B Apps
• SQL Performance and Database Schema Optimization
• Business knowledge for Sourcing, Logistics, Inventory
• Data Warehouse to Data Lake transformation
• Stabilizing support issues, coach L2/L3 teams.
• Global Supply Chain (Import/Export/Customs)
• Traditional and RF-based Inventory tracking

TECHNICAL SKILLS:

Programming Languages: C, Shell, Java, PL/SQL, PIG, COBOL, PROGRESS 4GL.

Hardware Platforms: Unix/linux, Wintel, Hadoop-mode, Also familiar with legacy integration.

Software Applications: Global Supply Chain Apps: Import2000. Manugistics. Peoplesoft, Siebel CRM

Databases: Oracle, DB2, DMSII, Progress RDMBS (4GL), Confidential Teradata, MySQL

Software Tools: Naca, CDC, Oracle forms, Teradata Util, Hadoop: Sqoop, Hive, PIG, BaSh.

ETL tools: DMX, AbInitio, EA tools: TOGAF, Zachman, Confidential LINC 4GL

Additional software: Microsoft Office, Visio, PowerPoint, Publisher, Jira, Enterprise Architect 10.0

PROFESSIONAL EXPERIENCE:

Sr Project Manager

Confidential

Responsibilities:

• Managing project intake side (requirement and priority setting) in constant consultation with business managers leading the preparation steps and triage planning for Confidential ’s merger with Rite-Aid group of stores.
• The idea is that Confidential HR applications will have data loaded for the entire chain, with daily sync with Rite-Aid site, but control the feeds so that Confidential side payroll process in not affected.
• Project work included the usual issue management and backlog maintenance, plus design verification and SDLC adherence with onsite and offshore teams of Confidential .
• The complexity of the project came from so-called ring-fencing rules - who can or cannot be transferred from what format stores to what stores in what stage of the merger, and the likely requirement that some of the excess stores will be handed over with initial software support assistance to Freds and other likely buyers.

Sr Project Manager

Confidential

Responsibilities:

• SAP Hana and GreenPlum are being used for the new data lake ‘consumption zone’ whereas DB2 and Teradata still the database of choice for the operational data and system of records.
• Current in-work interface thru Confidential is for Salesforce CRM where the sales data are analyzed for member retention and incentive programs, plus cust acquisition work.
• The financial data for goods-for-sale and goods-not-for-resale(consumables) from SAP acct are analyzed for trend and moreover vendors and approvers are matched to see any anti-corruption angle on the special one-off requests.
• A notable enhancement in this phase is also the including the social media and secondary source data like weather patterns to help in better forecasting and statistical analysis.
• Also responsible for business development and new projects proposal building such as an exports area integration.

Technical Project Manager

Confidential

Responsibilities:

• Product Manager and Integration Specialist for an inventory application in Agile mode rapid feature enhancements and already installed at various customers' installations world-wide.
• The app is well-integrated with B2B EDI interface for inbound supply chain track&trace and traditional inside-4-walls functionality with RFID mode tracking high-value and sensitive date-expiring merchandise, and my role is to look for features and functionality to add to make it more valuable to our current and prospective customers, while maintaining a reasonable development time table and cost. Planning business expansion with Warehouse mode use for Distributor and staged expansion to get end to end tracking for blood bank processes
• Secondary responsibility to plan and delivery ERP integration for SAP, Lawson etc for those clients who want to integrate lab orders to vendor invoicing and tracking cost per reportable.
• My job was to work with customer’s IT to select optimal workflow and integrate our app to their ERP and corporate BI with batch transactions feeds (ETL) to ensure sync of operational and master data. Reporting with matrix type responsibility to service org, R&D and marketing directors. This app was sold world-wide with 15+ installed sites at that time.

Confidential

Responsibilities:

• Earlier assigned to IMS team as its ERP integration project lead/manager to make the app progressively better with Radio Frequency mode for core lab needs of the customer base and retain the best in class lead over competition.
• The app is fully integrated for supplier EDI transactions as well as for the back end of corporate legacy applications (SAP, Lawson) that customer sites have.
• The app works in traditional windows as well as cloud mode implementations of SQL servers in US and overseas customer sites, and I am responsible for post-sales application support of ERP module as well.

MAINFRAME ELIMINATION ARCHITECT

Confidential

Platform: MF DB2/COBOL to Unix/Oracle/java

Responsibilities:

• My official title was Consultant/Architect, and the duties include best-practice guidance and enforcer of standards, and lending a hand to the onsite vendor teams on day to day chores as software tools selection, integration planning, shell framework, Teradata performance & throughput assurance plans, plus handing the usual program level issue escalations.
• Architected a phased plan to copy terabytes worth of corporate reports from mainframe ctl-D to unix pdf, as part of the mainframe to cloud transformation of the app, with full support for the customs compliance rules as well as legal audit needs for the older reports history versions.

Confidential, Hoffman Estates, C hicago

Responsibilities:

• Managed multiple projects in technical role in various corporate high-priority initiatives in this Confidential company.
• Confidential is now #3 US retailer with a strong online presence and uses innovative logistics flows.

Confidential

Responsibilities:

• Monitored Social Media postings and created weekly reports for CEO/CIO level, comprising of a one-page executive summary on program status, budget burn rate and top issues (usually dealt at director level).
• Trained offshore team that developed Intellectual Property in several areas (6 patents in process) with immediate use for FOCUS and Assembly to C conversion tools. Created with them wiki site from grounds up.
• Integrate Kmart Peoplesoft accounting use with Confidential / Confidential for Sears and tool the app from legacy to unix mode.
• Major saving of IT processing (and paper wastage reduction) by doing a first-ever complete inventory of each and every report (60,000+) in the company, Sears and Kmart combined, then ramping down to only the essential, saving not only on space, MIPS (reduced processing), but eventually costs less to re-platform these.

Confidential

Responsibilities:

• Our team was the first to merge Sears and Kmart sides on the same application platform, which was delivered on time with phased implementations for softline & hardline much ahead of the merger of domestic side apps.
• Architected by myself an unified system of ASN (Advanced Ship Notices) using a new EDI 945 protocol, saving more than $500K per year from the 3rd party logistics facility fees, because this new home-grown integration allowed new decon provider to fulfill both Sears & Kmart mdse flows with exact same process.
• Created unique replenishment integration with Manugistics with first database-to-database interconnections. Later that successful pattern was used for many other interfaces like SAS and OTM ( Confidential ) for carrier feeds.

Confidential, Troy, MI

IT Senior Systems Analyst

Responsibilities:

• Upgraded and rolled-out 200+ online user screens from old character mode to web-based Oracle forms (11g).
• Provided in-house support and development for a mission critical Import application handling 17% of the whole company’s volume. Added customized modules and integrated with other major supply chain systems to extend life of the application. Also reduced problem tickets and abends by 90%, saving contractor OT costs.
• Full accounting interface with Peoplesoft ERP. Functional use of replenishment using Inforem and Manugistics. It had 3 level replenishment of store demand, then DC demand rolling up to corporate level PO.
• Realized savings of $1.5+ million annually in trucking cost by re-architecting to eliminate DC ‘stops’ and send seasonal high-demand merchandise direct to mainland stores from first touch point (deconsolidation) in USA.
• Supported mission critical warehouse interface application called Black Box that processed store demand and inbound mdse from distribution center to Store, optimizing the usual apparel flows even for low-volume but high-margin products. Provided quick turn around on analytics needed on gun control and loss-prevention.
• Created home-grown tools to monitor the app 24x7, eliminating 30% overtime needed in prior manual process.
• Saved millions on GE EDI costs by taking out majority of the EDI file feeds to non-EDI format. Worked with data communication teams to roll out an equally reliable AS2 based data exchange system, which was far more scalable than EDI, and ran double the volume at no additional cost during merger.
• Architected dozens of smaller front-end online special-purpose Java apps such as PO approval, transit, claims that run in Sears own private cloud infrastructure with all transactions logged to common Oracle databases for legacy sync thru batch and real-time updates. Some of these apps had DB2 and Teradata also as data source.
• Interfaced with Confidential designed Teradata Data Warehouse so that vendors can run workbench reports from outside firewall as part of Collaborative Manufacturing, giving vendors rule-based visibility to item specs, on-order (dates and qty needed), receipts and miss-shipped cases. Near real-time reporting in Terabyte scale.
• Claims refund processing using sister company concept: best of class integration of return goods to Peoplesoft.
• Architected a best-in-the-class 7501 related integration for Confidential that still stands as the best hosted model.

Confidential, Troy, MI

Responsibilities:

• I took it from “Ideate” level to design, coded most of it myself, make it market-able with pilot runs in furrier conferences, and then assisted sales team to actually start selling it. First few copies sold in the next 6 months I was there.
• Development was done on unix, with regression testing to see every part work also on Wintel. We made it scalable from single-PC for a small client to networked wintel platform for medium size, and we sold the package even to a large furrier who implemented it on their bigger Confidential U6000 unix hardware. The package was easily configurable to work with a variety of POS and had friendly user-settable billing & accounts payable interface.
• T&M contract obligations for Confidential sites, including 18 months in Radnor conversion center for Shop Floor pilot apps and 6 months in Mission Viejo CA mainframe system software factory. Personally coded the RPG compiler part of the RAMP platform designed to replicate IBM system 34/36 boxes by Confidential hardware costing only 60% of IBM, in order to grab the market share from IBM forcing clients to upgrade to AS400s.
• Supported smaller Confidential clients who sometimes needed L3/L4 level help with their own applications based on Oracle, Ingress or Progress RDBMS, specially for the transitions needed after they bought new hardware, or upgraded database. Assisted customers to migrate their legacy history data to Oracle in an automated way.