Programmer Analyst
sitel
Total years of experience :15 years, 2 Months
Got Promoted as Programmer analyst from operations reporting analyst
Possess knowledge of BPO. operations and HR analytics
Translate Business Requirements into Technical Specifications in a Decision Support System environment
Using SAP BO XI r3, WebI and SAP Dashboard designer
SME for HR Data in Datawarehouse.
Mentor for Programmer Analysts on the team for both code review and teaching new functionality
Develop user/client requirements and document business and technical implementation plan related to Business Intelligence, Data Warehousing, ETL, OLAP, OLTP.
Analyze the impact of front-end changes/enhancements on reports and the underlying application data.
Provide management and users with ongoing project status and issues resolution.
Test and review the quality of developed programs and the over-all system.
Assure quality and integrity of final production implementation-compliance and committed functions, data integrity and performance.
Act as a lead analyst for local system components during Distributed System implementations
Monitor 24x7 processes that load data from source systems into the Global Data warehouse at ½ hour intervals and ensure timely resolution if any issues arise
Create XCelsius Dashboard for Regional VP and Above
Mange entire Global HR reporting and Security Compliance reporting.
Adhere to timelines for report delivery and scheduling the reports to be delivered through Scheduler service.
Software Engineer
Client: Raiffeisen bank(Czech republic)
Project details: Customization and migration of existing modules in their Core Banking solution Software (Finacle) and designing Report template using Jasper reports
Environment: UNIX Server(IBM AIX, HP-UX) (using putty), Oracle 10g, Jasper Reports, Maha Report Template, Finacle scripting, Pl/SQL, SQL
Accomplishments:
Customization of Menu and fields in Front End
Validation in Front end and Back end level
Creating Report template based on requirement, using procedures and packages
Adding or changing the front end pages, and its Functionality
Requirement Gathering
Onsite to SOuth africa
Designing Forms, Constructions/Coding & Integration of Form Level Validation.
Developing transaction module for quotations, starting from template form till deploying it on the live server with complete functionalities
Handling of main modules independently which includes in creating of contracts, invoices and matching of purchase contracts with the sales contracts.
Based on the customer requirements and the business logic, I have made the screen design and subsequent organization of blocks, canvas and windows
Writing various form triggers, front end program units and DB program units to realize the business requirements. Made the entire frame work related configurations necessary for that module
Enhancement on main modules was also done
Handling of DBA activities like creating/dropping the DB user, granting permission to the new user.
Installation of Database and Application Server and setting up the environment
Bugs/issues reported by the client are simulated and localized in the local environment.
Fixing the bug reported by the client.
Unit level testing and final level testing been done on project.
Direct interaction with the client regarding the issues and clarification
Knowledge in working with mainframes, Java, C++ Technologies
Undergone training in various technologies for 5 months
I sumesh k.s holds a Bachelors in technology(bioinformatics) from SRM university