Curriculum Vitae

Rini Choudhary

Bachelor of Technology (Electronics and Communication)

Mob: 860-***-****

Email: ac9sps@r.postjobfree.com

SUMMARY

TECHNICAL SKILLS

PROFESSIONAL

EXPERIENCE

Experienced Reporting Analyst and Data Analyst with 5+ years of professional experience.

Experienced utilizing various data analytics tools including Excel, Access, and SQL to create reports, run queries, and analyze data.

Excel in liaising between the business to merge customer and user needs with business requirements, budgetary restrictions and logistical considerations to meet project deliverables in relation to data analysis and report development.

Create and prepare automated reporting using business intelligent tools such as Alteryx on a daily basis.

An Assertive professional with 8+ years of IT experience handling all phases of SDLC - analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment

Professional in Business Objects Reporting tools – SAP WEBI and Crystals Reports

Proficient in Tableau Dashboards and Alteryx

Worked in Oracle, PL/SQL, TOAD

Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality

Experience in Design, Development, Implementation and Support of Oracle database and SQL database (PL/SQL,).

Experience in using Markit EDM (CADIS), SSIS

Working knowledge of SAS

Used client tools TOAD, SQL Navigator, PLSQL developer and FTP tools

Experience in Agile

Tools & Utilities

PL/SQL Developer, SQL Navigator, Visual Source Safe, Alteryx, Markit EDM, SVN, SAS EG

Reporting Tools

WEBI- Business Object SAP Reporting Tool, Dashboard - Excelcius, Tableau, Explorer, Alteryx

Technologies

Business Objects, SQL, Agile-Rally, Kanban Board, SAS

The Hartford Insurance (HIMCO), Hartford, CT Jan 2013 – June 2018

Application Development Specialist

Responsibilities

Worked on all the enhancements to implement functional and technical specs in the Business Object reports.

Created SQL queries, derived tables and procedures which were used by the universe.

Analysis and gathering of new business requirements from the business resources.

Modified the existing BO reports according to the new enhancements.

Responsible for making decisions on coding standards and documentation.

Coordinate with the front end design team to provide them with the necessary BO universe and reports and necessary insight into the data.

Provided trainings and demonstrations related to Business Objects to customers.

Direct work experience with internal customers in the company.

Modified various existing PL/SQL code with the help of DBA’s to improve query performance.

Generated SQL and PL/SQL scripts to create derived tables.

Extensively used Nested tables, PL/SQL tables.

Worked with DBAs to tune long running queries, used Explain plan and SQL trace to analyse query execution plan

Created Tableau Dashboards with workflows in Alteryx.

Worked on Markit EDM

Environment: SAP BO Reporting tools, SQL Navigator, SSMS, Windows XP, Tableau Dashboards, Alteryx, Markit EDM, SSIS

IBM India Pvt. Ltd, Gurgaon May 2011 – Jun 2012

PL/SQL Developer

Responsibilities

Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements of National Grid.

Analysis and gathering of new business requirements from the business resources.

Worked thoroughly on coding and debugging of stored procedures, functions to implement Business Rules.

Wrote PL/SQL Database triggers to implement the business rules in the application.

Modified the existing procedures according to the new enhancements.

Responsible for making decisions on coding standards and documentation.

Loading data from flat files into database tables using SQL* Loader

Modified various existing Pl/Sql code.

Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.

Extensively used Nested tables, PL/SQL tables to code Procedures and Functions.

Worked with DBAs to tune long running queries, used Explain plan and SQL trace to analyse query execution plan

Environment: Oracle 11g, TOAD 10.1, MS VSS, C++, SAS, Windows XP

Wipro Technologies, Kolkata May 2010 – May 2011

PL/SQL Developer

Responsibilities

Worked on the application layer (HMIL_Media) to send API’s through the DBUS interface to the Middleware.

Analysis of the existing API’s system to understand existing functionality

Prepared High level and Detail design documents according to Business Requirement Document.

Involved in the creation and modification of oracle Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes

Optimized SQL queries used in Reports and Files to improve performance drastically.

Designed Database Tables (oracle) used in the Application.

Data Migration using PL/SQL stored Procedures.

Developed BO reports.

Involved in cleaning and maintaining migrated data.

PL/SQL Collections were extensively used for high performance of stored procedures.

Some critical jobs that I have undertaken were related to the creation and modifications of UNIX shell scripts which includes calls to various business processes that are executed using Oracle stored procedures, functions, triggers, packages and DML operations

Performed extensive unit and component testing for PL/SQL packages

Working with business users for providing data for data analysis and business reports

Environment: Oracle 10g/9i, C++, TOAD, import/export, UNIX (AIX 5.2), Windows XP professional

Aricent Technologies, Gurgaon May 2009 – May 2010

PL/SQL Developer

Responsibilities:

Involved in the complete life cycle of the product from requirements gathering to end of system testing

Used SQL* Loader to load data into different tables

Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers

Created Normal Views according to the requirement.

Developed, modified and optimized complex queries for data retrieval and modification.

Incorporated validation rules for promotion history table and updating tables

Participated in status meeting and walkthroughs.

Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 9i, SQL*Plus, PL/SQL, Toad, MS Windows 2000, C, C++

Contact this candidate