About Me
Having experience in Database development and Production Support
Worked in Enterprise product implementation and configured LDAP,SSO and ETL
Certified in ITIL V3(F)
... Show MoreSkills
Programming Language
Development Tools
Software Engineering
Database
Web Development
Others
Positions
Portfolio Projects
Company
Enterprise Performance Management(EPM)/BI software Implementation
Description
1. Balanced Score Card(BSC), Dashboard, Enterprise Performance Management(EPM)/BI software Implementation
2. Performing QA/QC on dashboard parameter by verifying Expressions, Formula’s and Business Logic's shared by client.
3. Responsible for developing technical specifications from business requirements.
4. Monitoring the Database performance and take necessary action to optimize the database performance
5. Developed SQL and PL/SQL scripts for Data loading from different source system’s (Oracle, MS SQL Server, Excel files) to Target EPM system.
6. Worked in Data Migration using Informatica Power Center 9.x, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Target/Dimensional Databases.
7. Handled Incident and problem management related to SQL production support.
Show More Show LessTools
Power BI SQL DeveloperCompany
PRODUCT LIFECYCLE MANAGEMENT IMPLEMENTATION
Role
Analysts (Non programmer role)
Description
1. Coded and maintained PL/SQL Packages, Stored Procedures and Database Triggers.
2. Loaded the data into database tables using SQL*loader from text and excel files.
3. Designed/developed tables, views, various SQL queries, stored procedures, function and various Database Change Request’s as part of enhancements.
4. Extensively used FOR ALL and BULK COLLECT to fetch large volumes of data from table.
5. Prepared estimates for Change requests raised by the client
6. Involved in Production Support to resolve production issues in a timely and efficient manner which was assigned to support using BMC Remedy tool.
Show More Show LessSkills
SQLTools
SQL DeveloperCompany
Business Application Support
Role
Analysts (Non programmer role)
Description
1. Requirements Analysis and providing estimates for the Changes Request/Requirements
2. Creating unit test plans and Unit test cases and generating regular status reports
3. Designed/developed tables, views, various SQL queries, stored procedures, function and various CR’s as part of enhancements.
4. Involved in Production Support to resolve production issues in a timely and efficient manner which was assigned to our group through HP service desk.
5. Involved in the deployment of code into QA and Production environment.
6. Involved in Code review before dropping into QA/UAT environments.
7. Analyzing of work request/client requirement, planning and estimating efforts for work request.
8. Providing deliverable's with zero defects and guided in the Implementation phase of the project.
9. Involved in Software Quality Assurance activities
Show More Show LessTools
SQL DeveloperCompany
ERP DEVELOPMENT USING VB6.0 AND ORACLE 9i
Role
Backend Developer
Description
1. Interacting with the representatives of the Design Department for mapping their requirements and specification.
2. Worked in User Interface and Database schema Design.
3. Prepared Data Dictionary with the list of tables, fields, and data types, Keys, Index and Constraints.
4. Created Procedures, Functions and Trigger’s for executing Business logic with Transactions
5. Documented business rules, functional and technical designs, test cases, and user guides.
6. Troubleshooting performance issues and bugs within SQL scripts.
7. Analyzing of work request/client requirement, planning and estimating efforts for work request
Show More Show LessSkills
SQL Visual Basic