PROFESSIONAL SUMMARY:

• More than6years of experience in financial domain and designing, developing of complex PL/SQL objects in Oracle database and creation of OBIEE reports along with RPD development.
• Good experience in customer facing capabilities and have involved with brain storming sessions with the Business Analysts to get the best solutions which will help the clients to improve productivity of their day to day work effectively.
• Strong trouble shooting, installation and configuration skills. Ability to pick up and deliver new technology very quickly along with effective analytical, problem solving and debugging skills. My biggest strength has been my ability and quest to learn new technologies and keep myself abreast with the new technologies that are emerging.
• Experience in global delivery model (onsite offshore model) along with interaction with various teams.
• Expertise in all the phases of Software Development Life Cycle (SDLC) including requirements, analysis, design, implementation, integration and testing, deployment and maintenance.
• Acquaintance with Agile and waterfall Methodologies.
• Strong knowledge of RDBMS, experience developing database applications using Oracle 10g database.
• Knowledge on using SQL, PL/SQL, ORACLE Database, reporting tools using OBIEE, writing SQL queries for ETL processes.
• Expertise in SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Knowledge in writing Simple and Complex SQL queries(like having, group by joins), Constraints, Partitions, Indexes, Views, Materialized Views, Implicit and Explicit Cursors, Ref Cursors, Sub Queries, PL/SQL Functions and Procedures, Packages, Triggers.
• Experience in advanced PL/SQL concepts like Collections such as Associative arrays, Nested Tables, VArrays.
• Keen focus on performance tuning, testing, and quality assurance.
• Experience in developing RPD using OBIEE administration tool.
• Experience in creating OBIEE adhoc reports, customized reports, and dashboards with best suitable visualization (PI charts, horizontal graphs, vertical graphs, pivot table) in OBIEE 11g.
• Experience in scheduling OBIEE agents to send out alerts on a regular basis to dashboards alerts and user emails.
• Experience in writing Unix scripts to copy data from excel to tables
• Proficient in documentations and presentations and a good team player.
• Experience in preparing Estimation template for the project, defining coding standards, performing code reviews.

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL, UNIX, COBOL, JCL

Databases: Oracle 10g, PL/SQL., MySQL,DB2

Operating systems: Windows, Unix, Mainframes

IDE: Toad, Tectia, OBIEE 11g administration tool

Design Tools and Technologies: PL/SQL, Toad, Oracle SQL developer, Tectia, SQL PLUS*,CICS, File - Aid,CA7

ALM Tools: JIRA, HP Quality center, Changeman, XPIDITOR, Share Point

PROFESSIONAL EXPERIENCE:

Confidential

Sr.SQL Developer/BI developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Used Simple and Complex SQL queries(like having, group by, joins) and also Used Implicit and Explicit Cursors, Ref Cursors, Sub Queries, PL/SQL Functions and Procedures, Packages, Triggers.
• Used SQL queries and performed tuning by creating Indexes to improve the database performance and availability.
• Used Dynamic SQL to run the procedures for each data object.
• Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using OBIEE.
• Experience in developing RPD using OBIEE administration tool.
• Modified the stored procedures to get the new functionality depending on the business requirement.
• Created ad-hoc reporting, regular reporting, Custom Reporting, power view reports, power pivots, and graphical reporting using OBIEE11g.
• Used OBIEE agents to send out alerts on a regular basis to dashboards alerts and user emails.
• Used UNIX scripts to copy the data from excel to database and also dump/export data from ORACLE to CVS file
• Excellent analytical, communication and interpersonal skills.
• Proficient in technical writing and presentations and a good team player.
• Coordinated with offshore and onsite by providing in-detail analysis and explanation like KT, shadowing and reverse shadowing tasks.
• Delivered project needs on time and within the agreed acceptance Agile Methodology.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, TOAD, Windows, Agile, UNIX, MS Excel, OBIEE 11g, RPD, CVS, Share Point, Onsite and Offshore

Confidential

Sr.SQL Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Used SQL procedures to load the data from other sources like mainframes to ORACLE database.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules
• Used SQL queries for ETL processes.
• Created Views to facilitate easy user interface implementation, Triggers were developed to handle the Parent-Child relationship of data objects and also solved the issues that occurred during Insert, Updates or Deletes.
• Experience in using PL/SQL collectables such as Associative arrays, Nested Tables, Varrays.
• Worked on performance tuning, testing, and quality assurance.
• Created Views required for the front end team to display the specific columns that were needed to be shown to the end user.
• Worked on various ADHOC reports request and generated results on Excel and CSV file Reports.
• Worked in logging to track the status of the events like error raise, task fail so on, provided support by troubleshooting and solving the issues.
• Actively participated in review team meetings with Manager to ensure that the development of projects meet business and system requirements and worked on waterfall SDCL model.
• Worked on Financial Domains.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, TOAD, UNIX, Windows,Tectia, Waterfall, MS-Excel, CVS, Performance Tuning, Mainframes

Confidential

SQL Developer

Responsibilities:

• Analyzing the tables that have sensitive data.
• Used SQL queries and Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Developed triggers and PL/SQL procedures for automation of jobs scheduling
• Code-reviewed in Oracle PL/SQL procedures, functions and triggers
• Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.
• Experience in preparing Estimation template for the project, defining coding standards.
• Setting up the error logs to track the errors raised.

Environment: Oracle, SQL, PL/SQL, SQL Developer, TOAD, Windows.

Confidential

Mainframe Developer

Responsibilities:

• Involved in full project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases.
• Involved in preparing the technical design documents and carrying out walkthrough meeting with the IT & Business managers.
• Modified and tested COBOL and CICS programs and JCL codes per the requests of business departments.
• Take new scheduling requests from programmers, set up CA-7 job definition, schedules, triggers and requirements.
• Monitor and ABEND resolution of MVS CA-7 batch processing.
• Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.
• Extensive coding using COBOL, JCL and VSAMs.
• Preparing System test cases and performing UAT activities.
• Gathering Signoffs from Business.
• Preparing End of schedule report and carrying out minutes of meeting with the team. (Both offshore and onsite) at the end of the schedule.
• Use SQL (complex queries) to query the database.

Environment: COBOL, JCL, VSAM, SQL, CICS, CA-7, XPEDITER, ABEND-AID, FILE-AID, CHANGEMAN