Amaresh Kumar Email & Phone Number

Software Professional with 8+ years of experience in development, testing and implementation. Good Knowledge of Oracle PL/SQL and Reporting, Data warehousing concepts, Actuate ,BIRT and SSRS. Familiarity with Agile development methodologies, standards and procedures. In-depth knowledge of fundamental data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas, modeling data marts, Fact & Dimensional Tables. In depth Knowledge of PL-SQL Programming and Tuning the queries . Design, developing, deploying, maintaining and integrating complex SSRS , dashboards and Visualizations. Good knowledge on performance tuning complex sqls, understanding explain plan and Autotraces. Design, developing, deploying, maintaining and integrating complex Actuate and Birt Reports , dashboards and Visualizations. Having Sound Knowledge and in-depth Analysis in writing Packages, Stored Procedures, Functions Database Triggers, Cursors and Exception, Db Links Developed executive dashboards in SSRS delivered through the web, enabling to measure the performance of the business with analytical capabilities. Extensively worked with Ranks, alerts, filters, prompts, variables and calculation contexts . Strong development and analytical skills, proficiency in root cause data analysis, and ability to problem solve. Ability to work independently with minimal supervision and effectively meet project deliverables on time. Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.In depth knowledge in Jira processes and pac 2000 tool and alm tool and git hub ..