Sivakumar Ramasamy
addfqu@r.postjobfree.com
Experience Summary
●17 years of experience in the IT services industry.
●SAS certified base and advanced programmer.
●Worked in USA for 6 years.
●Have extensive experience in
Developing Data Warehouse and Data Mart applications using ETL in SAS EG and Informatica Power center 9.5
Developing applications in SAS EG / SAS VA, Informatica, SAS, COBOL, DB2, CICS, IMS DB/DC, and FOCUS
Project Management and Technical Leadership
●Played various customer facing roles such as Consultant, Onsite Coordinator and Technical Liaison.
●Extensive business knowledge in Manufacturing, US Healthcare, Retail, Oil & Gas and US Retirement.
●Actively involved in project proposals, POCs, evaluating tasks, analyzing risk, providing estimations and scheduling.
●Led service delivery/operations both from onsite as well as offshore with a team size of maximum of 10 members. Involved in all phases of the project management lifecycle starting from effort estimation, staffing models, requirements management, system specifications, offshoring, QA/testing, implementation and change management.
●Excellent experience in complete software development life cycle (SDLC) including analysis, design (System/Database), development, testing, documentation, implementation & maintenance of mainframe applications.
●Possess strong ability to quickly adapt to new applications, platforms and technologies.
Certifications
Certified Scrum Master
SAS Certified Advanced programmer for SAS9
SAS Certified Base Programmer for SAS9
Technical Skills
Platform
IBM OS/390, Z/OS, WINDOWS, Unix and Linux
Languages
SAS/Base, SAS/Advanced, SAS/Macro, COBOL and Python
Databases
DB2, VSAM, IDMS-DB, Netezza, MS Access, Oracle, HDFS and LASR
Statistical software
SAS/Base, SAS VA, SAS/Advanced, SAS/SQL, SAS/MACRO, SAS/EG, PC SAS, SAS Stored Process and SAS Procedures.
Front end/OLTP
IMS-DC and CICS
Tools and Utilities
ETL: Informatica Power center 9.5, BO
Configuration management: ENDEVOR, CHANGEMAN, LIBRARIAN, SCLM, and PANVALET
Job Scheduler: ESP, ZEKE Scheduler, JHS, CA7 and Crontab
Transmission: EDI, GENTRAN, NDM, FTP, and CONNECT-DIRECT.
Toad for DB2, ISPF/TSO, IBM Utilities, Quick Job, SPUFI, QMF, FILE-AID, File Management, File-Manager, VSAM, MFSGEN, $AVRS, MOBIUS, SAR, ACF2/ISPF Support, JCL Tools, Abend-aid, and Visual-age Generator, HYPERSTATION, FileZilla, PuTTY and Oracle SQL Developer.
Reporting: SAP BO XI, SAS Visual Analytics (7.3), Tableau
MS Office Products.
Testing environment
XPEDITOR, and BTS
Domain Knowledge
Manufacturing, US Healthcare, Retail, Oil & Gas and US Retirement
Key Engagements
Photon Interactive Private Ltd Apr 2017 – Current
Technical Lead III
Client: Fidelity Investments, Texas, USA
Industry: US Retirement
Environment: SAS/Base (V9.4), SAS EG on Linux and Mainframe
Project Portfolio
DC Plan is a retirement plan sponsored by the employer for its employees and is designed to replace employment income upon retirement. An employer can sponsor more than one DC plan at a time.
A DC Plan can either be a Qualified plan or a Non-Qualified Plan.
Applications: Workplace Investing (WI) Defined Contribution (DC)
Responsibilities:
●Managing team of 3 from Offshore.
●Development, Maintenance and Enhancement for Data Conversion and Implementation, using ETL in SAS/Base (V9.4), SAS/Macros, SAS Advanced and SAS/SQL.
●Interact with business on requirements gathering, high-level designing of the conversions.
●Involved in SAS Migration from Mainframe to Linux.
●Involved in SAS part for Beacon application development which is built by using Java, Angular and Oracle.
●Completed the On-Boarding of SAS team members.
●Responsible for overall delivery from Offshore.
Wise Men Consulting Services India Private Ltd Apr 2016 – June 2017
Associate Project Manager
Client: Schlumberger, Houston, USA
Industry: Oil and Gas
Environment: SAS VA, SAS/Base (V9.4), SAS/Macros, SAS/Advanced, SAS/SQL, SAS/PROC, SAS/EG, SAS Stored Process, HDFS, LASR, SAS Management Console and SQL Server
Project Portfolio
Schlumberger is the world's leading provider of technology for reservoir characterization, drilling, production, and processing to the oil and gas industry. Working in more than 85 countries and employing approximately 113,000 people who represent over 140 nationalities, Schlumberger supplies the industry's most comprehensive range of products and services, from exploration through production and integrated pore-to-pipeline solutions for hydrocarbon recovery that optimize reservoir performance.
Applications: Product Optimizer (CoE), BOR, MI- Product Segment
Responsibilities:
●Managed team of 10 from Offshore.
●Development, Maintenance and Enhancement for Product Optimizer, MI- Product segment using ETL in SAS/Base (V9.4), SAS/Macros, SAS Stored Process, SAS Advanced, SAS/SQL, SQL Server and SAS VA.
●Interacted with business on requirements gathering, high-level designing of the interfaces and screens.
●Created dashboards in SAS Visual Analytics as per business needs.
●Responsible for overall delivery from Offshore.
●Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
●Analysis, Design, Coding, and Testing for the enhancements of the existing applications being supported.
●Experience in Ad-hoc programming in SAS to correct the data in warehouse, Data Mart application and to generate the reports for business.
●Involved in POCs and presented to client.
●Involved in RFP’s response and estimations.
Tekseed Solutions LLC (formerly Inine Technologies Inc.) Aug 2009 – Aug 2015
Technical Lead
Client: John Deere, Moline, IL, USA (Client Site Aug 2009 – Nov 2009 and Dec 2012 – May 2015)
Industry: Manufacturing
Environment: Informatica Power center, ETL, Netezza, SAS/Base (V9.1.3), PC SAS, SAS/Macros, SAS/Advanced, SAS/SQL, SAS/PROC, SAS/EG, DB2, SQL, Data Workhouse, Mainframes, ESP, QMF, SPUFI, COBOL, IMS DB, JCL and Java.
Project Portfolio
John Deere is the world's leading manufacturer of farm equipment and forestry equipment consisting of three major business segments (agriculture and turf, construction and forestry, and credit). Those segments, along with the support operations of parts and power systems, are focused on helping customers be more productive as they help to improve the quality of life for people around the world. The company's products and services are primarily sold and serviced through John Deere's dealer network.
Applications:
Complete Goods Reporting (CGR), Enterprise Data warranty warehouse (EDW), and Warranty
Responsibilities:
●Development, maintenance and enhancement of Enterprise Data Warehouse (EDW), Warranty Warehouse, DataMart applications AWAD, AWAC, and WSR using ETL in Informatica, SAS/Base (V9.1.3), SAS/Macros, SAS Advanced, SAS/SQL, DB2, Informatica, Mainframe, COBOL, IMS DB and JCL.
●Ability to write some common macros that are useful across multiple applications (reading SYSPARM and count number of observations in a dataset etc.).
●Played scrum master role for CGR application.
●Optimized performance using data validation and data cleansing using statistical procedures like PROC FREQ, PROC MEANS and PROC SUMMARY.
●Experience in SAS to read the data from other sources (like flat files, VSAM, MS Excel, text, DB2 IMS-DB Databases etc.).
●Converted the programs from different technologies to SAS programs (like CRISP programs).
●Experience in Ad-hoc programming in SAS to correct the data in warehouse, DataMart application and generating reports for business.
●Created multiple DataMart applications from warehouse using SAS/Base, SAS/Macro, SAS/SQL, and SAS advanced programs.
●Created various scorecards for warranty analyses using SAS programs.
●Extensive use of MS Excel to validate the data (using VLOOKUP, PIVOT table, etc.)
●Coordinated with TCI (John Deere Technology Center, India) Java team members.
●Interacted with business on gathering requirements, high-level designing of the interfaces, screens.
●Application production and customer support (24/7).
●Prepare test cases for application regression testing.
Lion Bridge Technologies Inc. Oct 2006 - Aug 2009
Senior System Analyst
Client: Golden Living, Fort smith, AR, USA (Client Site Oct 2006 – Apr 2009)
Industry: US Healthcare
Environment: Mainframe SAS/Base, SAS/Macros, SAS/Advanced, COBOL, CICS, DB2, VSAM, JCL, SPUFI, QMF, NDM, FTP, CONNECT: DIRECT and Java.
Project Portfolio
Golden Living is well known skilled nursing home that provides care for people across the county for more than 40 years, who may not require hospitalization but cannot be cared for at home.
Resident Accounting is an automated process used at Beverly, which not only takes billing requirement in far superior manner, but concentrate on workflow, admission, patient history, charge history. The Resident Accounting process is made up of Accounts Receivable and its subsystems i.e. Accounts Payable, General Ledger Credit & Collection, Medicare Billing, Medicaid Billing and Ancillary Charge System.
Applications: Accounts Receivable/Billing System
Responsibilities:
●Completed the On-Boarding.
●Extensive use of PROC SQL to perform queries and join tables.
●Experience in Ad-hoc programming in SAS to generate the reports for business.
●Converted the programs from COBOL to SAS programs.
●Experience in SAS to read the data from other sources (flat files, VSAM, MS EXCEL, text, and DB2)
●Interacted with client on gathering requirements, high-level designing of the interfaces, screens.
●Coordination with onsite / offshore team members.
●Responsible for the deliverables from offshore.
●Resource allocation for different project based on priority.
Satyam Computer Services Ltd Nov 2002-Oct 2006
Senior Software Engineer
Client: Tyson Foods Inc., Springdale, AR, USA (Client Site Mar 2006 - Oct 2006)
Industry: Retail
Environment: Mainframe COBOL, DB2, VSAM, JCL, SPUFI
Project Portfolio
Tyson Foods is the largest provider of protein products on the planet, the world leader in producing and marketing beef, pork, and chicken. Tyson Foods has achieved notable brand equity, with a top-of-mind consumer awareness comparable to the most visible brands in the world.
Responsibilities:
●Meeting the business and participate in the requirements gathering.
●Coordinating with the design, development, QA and training team to execute the project.
●Working with the development team to estimate and define timelines.
●Conducting daily status/stand up meetings.
●Managing issues/escalations.
●Making recommendations & working out mitigation plans.
●Responsible for overall delivery including new builds, defect management, and new releases.
Client: Hartford, Connecticut, USA (Client Site Jul 2004 - Feb 2005)
Blue Cross Blue Shield LA, Blue Cross of California and Cigna,
Industry: US healthcare
Environment: Mainframe COBOL, DB2, JCL, CICS, IMS-DB, IMS DC and FOCUS
Project Portfolio
Blue Cross Blue Shield of Louisiana (BCBSLA) is the largest private Health Insurance Company in Baton Rouge, USA in terms of revenue, according to the greater Baton Rouge Business report, and among the largest companies in the state.
This assignment was to provide maintenance and production support services to the Electronic Data Interchange (EDI) mainframe applications at Blue Cross of California (BCCA) Insurance Company. These applications handled electronic data transfers between the central mainframe system and other subsystems and external entities using FTP, Network Data Mover (NDM) and Mailbox.
Applications: Billing, Claim Adjudication, EDI (Electronic Data Interchange)
Responsibilities:
●Analyzing of specifications provided by the clients.
●Preparing code and document standards that comply with the client standards.
●Unit and integration testing of the proposed changes.
●Fixing production bugs.
●Making recommendations & working out mitigation plans.
Work Summary
Photon Interactive Private Ltd (Jun 2017 – Current)
Wise Men Consulting Services India Private Ltd (Apr 2016 – Jun 2017)
Tekseed Solutions LLC (formerly Inine Technologies Inc.) (Aug 2009 – Aug 2015)
Lion Bridge Technologies Inc. (Oct 2006-Aug 2009)
Satyam Computer Services Ltd (Nov 2002-Oct 2006)
Education – Bachelor of Engineering in Electronics and Instrumentation (2000) – Government College of Technology, Coimbatore Tamil Nadu.