Developer Sql
Resume:
Curriculum Vitae
Rini Choudhary
Bachelor of Technology (Electronics and Communication)
Mob: 860-***-****
Email: ************@*****.***
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