Senior Software Developer / Analyst
Silvertech ME
Total des années d'expérience :21 years, 9 Mois
1. Worked closely with business and technical team for streamlining & getting actionable insight into Business process
2. Involved in all stages of SDLC from requirement gathering till deployment
3. Handled multiple applications and develop, test and implement different requirments on HRMS, Procurement management and Timesheet Management.
4. Define appropriate joins, calculations, dimensions and measures in the repository.
5. Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters)
6. Configured different reports for management purposes to calculate the progress of the project
7. Day to day business support, Log the system issues, prioritize them and track the tasks using TFS, Test the enhancements before implementation
1. 1. Worked closely with business and technical team for streamlining & getting actionable insight into BI Dashboard process,
2. Involved in data modeling using concepts like Dimensional Data Modeling, Star Schema modeling, Analyzed and used various data sources - Oracle, Excel, and Web Services.
3. Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
4. Define appropriate joins, calculations, dimensions and measures in the repository.
5. Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics.
6. Configured OBIEE Agents/Alerts to deliver Analytics content based on schedule, automated Alert queries to obtain daily and weekly reports.
7. Day to day business support using TSRM tool., Log the system issues, prioritize them and track the tasks using TFS, Test the enhancements before implementation..
8.Configuring the project as per the Client requirement.
9. Conducting Training for the new project users.
• Maintain close working relationships with team members and infrastructure groups to ensure broad awareness of program status and issues.
• Generated Reports using procedures and views for faster execution based on the users requirement, created parameter driven reports to restrict the volume of data.
• Created nested, conditional groups and formatting features in reports.
• Generated Statistical reports and updated the clients on regular basis (weekly, monthly & yearly reports)
• Deployment of the reports into the production environment.
Environment: MS Excel, VBA, Sybase, MS Access and Crystal Reports, Windows server 2008
• Analyzing the new requirement in the HR, examination wing and configures the new modules.
• Designed and documented process flows.
• Involved in Database Administration, Design, development and maintaining backups.
• Developing Analytical Reports using Charts and Graphs for HR and Examination wing.
• Unit and module level Testing and deployment.