SUMMARY

• Over 17 years of extensive IT experience in all aspects of System Development and complete Project Life Cycle in Software analysis, Design, Development, Testing and Implementation in Data warehousing.
• Good knowledge in Project Management, Data analysis and Business Analysis.
• Extensively worked in Client - Server application development using SQL Server, Oracle 8.0/8i, 9i, 10g,11g,12c,19c PL/SQL and SQL *PLUS, Tableau, OBIEE Reports and SQL*Net.
• Solid experience in writing SQL queries, PL/SQL programming and Query Level tuning.
• Extensively worked in writing stored procedures, clusters, database triggers, exception handlers, cursors, cursor variables.
• Worked on AWS cloud Environment, moved legacy applications on to AWS Cloud.
• Knowledge in AWS services like S3 Buckets, EC2, Lambda functions, Cloud watch events etc.
• Extensively Worked on Oracle Database creation, Tablespace management, (Export & Import) Backup and Recovery, Performance tuning.
• Created database links and snapshots for distributed network databases.
• Mentored and provided oversight and backup for the production Databases.
• Very good knowledge in oracle 12c/19c wif DBA skills on NT/Solaris and visual basic 6.0, PL/SQL, SQL Trace, TK-Prof, Explain Plan, Pro*C, SQL Loader.
• Working experience wif SQL, PL/SQL, OBIEE, DataStage and Toad & other tools like Gentran, Autosys, MovieIt, ADT and TWS.
• Exposure in using CASE tools like ERWIN for data warehousing and Rational Rose for object-oriented modeling and system specifications.
• Extensive Knowledge in Data warehousing concepts and Business Intelligence tools.
• Exposure in scripting development using UNIX, Shell Scripts.
• Experience in Windows 95/98/2000/NT/7/10, UNIX, Solaris and Shell environments.
• Very good Experience and exposure to version control tools like TFS, StarTeam and Git applications.
• Sound knowledge in understanding the use cases and co.
• Good knowledge in working wif FTP.
• Excellent Communication and Interpersonal skills.

TECHNICAL SKILLS

Software’s & Languages: C, C++, JAVA, VB6.0, C#, SQL, PL/SQL

Database Systems: ORACLE 9i/10g/11g/12c/19c, SQL Server, DynamoDB.

Tools: /Utilities: SqlLoader, Dataguard, STATAPACK, TKPROOF, Replication, export, import, AutoSys Scheduling tool, Datapump, Transportable tablespaces, SQL Tuning Advisor and Toad, IBM Rational Tools ClearCase, ClearQuest., Toad, WinSCP, TWS, MoveIt, Jira, StarTeam, Git application, Confluence etc.

Oracle Application Systems: Oracle Applications 11i E-Business suite, OBIEE

Scripting Languages: Shell scripting, Perl and Python 3.8

Case & Reporting Tools: Erwin, Designer 2000, OBIEE Reports, Tableau Reports, Developer 2000 (Forms 4.5/5.0/6i/, Reports 2.5/3.0/6i), MS Access Reports, Crystal Reports 7.x/6.x/5.x.

Web Languages: HTML, XML.

Web Servers: AWS Cloud Services, Apache.

Operating Systems: WINDOWS 7/10, HP UNIX, Red hat Linux, IBM AIX & Sun Solaris

Hardware: Sun Sparc Servers, Intel Servers, HP Servers, IBM servers and PC’s, CISCO 2500 Routers, CISCO and Dlink Hubs.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

AVP, Lead

Responsibilities:

• Worked as lead in Cloud migration projects and has experience in working AWS Cloud environment to move legacy applications in to Cloud using AWS services like S3 Buckets, Lambda functions, EC2 and CloudWatch events.
• Developed Python scripts to load CSV files in DynamoDB in AWS using Boto3.
• Developed tables wif partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas in EAGLEPACE Database.
• Worked as Technical lead for different projects which involves creation of new databases and also created scripts to load the data into staging tables from other database using DBlinks.
• Guided the team in development of functions to check the validity of data before loading into staging tables.
• Developed many packages, stored procedures and functions for general and segregated accounts.
• Used enhanced PL/SQL features like collections, cursors, refcursors in code design.
• Worked wif Eagle exporters and uploaders to load the data in to tables.
• Created Eagle schema/ Pace events in EagleStar to automate the procedures created for load data.
• Worked as lead in projects involved Datastage and PL/SQL also develop packages, stored procedures, functions and database triggers.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Created stored procedures wif cursors to load the data from staging to analysis tables.
• Worked wif various complex queries wif joins, sub-queries, and nested queries in SQL queries
• Involved in implementing the technical and functional aspects of project.
• Developed UNIX shell script to automate monitoring and notification emails, to the users when a process fails in production.
• Worked wif SQL loader and control files to load the data in different schema tables.
• Knowledge of Gentran and Autosys to check the status of various jobs, modify job parameters, restart jobs and handle exceptions.
• Worked on Tableau and OBIEE reports for different broker and commission reports to satisfy user requirements.
• Created many jobs in MoveIt and TWS for weekly and daily batch loads in Charles River applications.
• Developed many shell scripts and created daily and weekly UNIX jobs to load the data into tables
• Worked wif OnBase application to enter the new requests/incidents and access the existing incidents and track the progress of task.
• Worked wif TFS, StarTeam to maintain the version control by checking in and checking out the scripts.
• Developed various Reports for the end user as per the requirement and also created many reports to suit the pre-printed format of the company.
• Worked in Identifying and analyzing client needs, defining requirements and developing the code, adapting solutions to the client, writing detailed definition documents, monitoring solution development.

Environment: AWS Cloud environment, Oracle 10g/11g,12c/19c Reports Erwin, Visual studio, TOAD, SQL Navigator, Microsoft Visual studio 2017, Microsoft SQL Server 2017, WinSCP, Gentran, Autosys, UNIX, Windows NT, Windows 7, Windows 10, MS Outlook 2016,MS Office 2016, OBIEE reports, Tableau Reports, MoveIt, TWS, Jira, StarTeam, Git, Autosys, EagleStar, EaglePace.

Confidential, New York, NY

Developer/Analyst

Responsibilities:

• Involved in design, development and documentation depending on client’s requirements.
• Involved in analysis and designing a data model through Erwin from requirements specification for FAS Datawarehouse
• Developed Brand new claims segregated module for distribution of money and surplus notes for all the trustees.
• Developed many packages, stored procedures and functions for claims module for general and segregated accounts.
• Used enhanced PL/SQL features like collections, cursors, refcursors in code design and for earned premiums for periodic and upfront policies.
• Created data base triggers on tables to populate the columns when the claims are entered into the core system
• Created tables, indexes, views, synonyms in the support of reinsurance module and created new database links to access the tables, tablespaces in other databases.
• Worked wif Oracle export and import utilities like data pump to load the data in to tables in different schemas.
• Performance tuned the existing queries by enforcing hints and optimizing the through put of jobs in production and QA environment.
• Worked wif performance tools like TKproof and Explain plan for improving performance of many queries used in developing portfolio and data warehousing report requests.
• Worked wif complex queries and joins and developed generic routines and anonymous blocks to create monthly, quarterly reports for stat and Gaap UPR.
• Created many jobs in job queue entry to avoid mutating errors in triggers.
• Developed many shell scripts and created daily and weekly UNIX jobs to load the data into Datawarehouse tables
• Worked wif SQL Loader for data extraction and transformation in to tables in different schemas.
• Worked wif MS access and Excel to validate the report results wif Crystal report results
• Developed back end for user interface screens, Master detail relations and Report screens.
• Worked wif OnBase application to enter the new requests and access the existing requests to track the progress of task.
• Worked wif visual source safe (VSS) to maintain the version control by checking in and checking out the scripts.
• Developed various Reports for the end user as per the requirement and also created many reports to suit the pre-printed format of the company.
• Conducted training sessions for the new and existing users for new claims module created.

Environment: Oracle 7.x/8.x/8i/9i/10g/11g, Reports 6i, Forms6i, Cognos 8.4 Erwin, Visual studio, TOAD for MySQL, TOAD, SQL Navigator, Microsoft Visual studio 2008, Micro soft SQL Server 2008, UNIX, OnBase 9.2.1.67, Windows NT, Windows 2000, MS Outlook 98, MS Office 2007, MS Access 2007.

Confidential, New York, NY

Developer/DBA

Responsibilities:

• Reviewed and approvedDatabase Architecture, Database Design, and Database scripts that are deployed to production for the CityTime application
• Worked in System Analysis, Design, Coding, Testing, Development and Documentation.
• Gatheird the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in Data analysis and creation of a logical model and validated the model against the reporting requirements.
• Created a physical data model through Erwin for data warehousing needs.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Designed and developed various complex reports for payroll purposes using PL/SQL Programming.
• Developed tables wif partitions and also created indexes, views, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Developed many new Stored procedures, Functions, Packages wif cursors and also modified existing packages to improve the performance in RAC environment.
• Developed and tested advanced SQL and PL/SQL based code in support of Reports for different agencies like HRA, NYPD, FDNY and DOC etc.
• Involved in developing many Timesheet, Leave and Payroll Reports using Cognos 8.
• Developed Export and Text IO packages and written many Stored Procedures in many Reports.
• Created indexes on tables and used hints to Optimize performance of stored procedure queries.
• Monitored performance and improved the performance through Database tuning and performance optimization techniques.
• Knowledge in using Explain plan and Tkproof utility to optimize the performance of queries.
• Investigated and resolved production problems and reviewed production deployment queries.
• Written SQL Loader Scripts for data extraction and transformation.
• Written Korn Shell scripts for automating the process of data loading.
• Strong Knowledge in shell scripting and developed scripts for reconciliation of data.
• Knowledge in working wif UML model diagrams.
• Experience in working wif Rational tools like ClearCase and ClearQuest for change management to view and track the activities and also used to maintain version control.
• Developed queries for various departments in ClearQuest to check the status and worked on those releases.

Environment: Oracle 7.x/8.x/8i/9i/10g/11g, Reports 6i, Forms6i, Cognos 8.4 Erwin, Visual studio, TOAD for MySQL, TOAD, Mainframes, SQL Server 2005, UNIX, IBM Rational ClearQuest 7.0.1, ClearCase 7.0.1.2, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98,MS Office 2007.

Confidential, NY

Oracle Developer/DBA

Responsibilities:

• Identified and analyzed client needs, defined requirements and developed the code, adapted solutions to the client, written detailed definition documents, monitored solution development.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Extracted and loaded data between the schemas in database using oracle Export and Import(datapump) utilities.
• Created scripts to load the data into staging tables from another database using DBlinks.
• Developed functions to check the validity of data before loading into staging tables.
• Created stored procedures wif cursors to load the data from staging to analysis tables.
• Worked wif various complex queries involving joins, sub-queries, and nested queries in SQL queries.
• Involved in developing and implementing the technical and functional aspects of project.
• Tuned SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Created Views for hiding of actual Tables and Queries for data security.
• Worked wif UNIX shell scripts to load different Actimize instruments data in to analysis tables.
• Developed UNIX shell script to automate notification of emails, to the users when a process fails in production.
• Worked wif SQL loader and control files to load the data in different schema tables.
• Knowledge in creation of Dblinks to load data from other databases for reporting purpose.
• Knowledge of control M to check the status of various jobs, modify job parameters, restart jobs and handle exceptions.
• Involved in the DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Involved in production support by timely debugging the production issues.
• Knowledge of working wif various version control tools like WinCvs source forge and VSS.
• Involved in Testing, Integration System test, Implementation in production and documented the entire project.
• Involved in the direct interaction wif the end users and implemented reviews of the application.

Environment: Oracle 7.x/8.x/8i/9i/10g, Reports 6i, Forms6i, Erwin, TOAD for MySQL, TOAD, Control M 6.2.01, CVS Pro*C, Mainframes, SQL Server, UNIX, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98,MS Office 2000.

Confidential, Manhattan, NY

Oracle Developer/Analyst

Responsibilities:

• Worked on data analysis and design of the business requirement document, developed the code for the requirement
• Developed and implemented different physical and logical data models and BPMN models for both OLTP and OLAP database used for marketing and reporting purposes.
• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD, MySQL.
• Worked in debugging the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.
• Strong knowledge in UNIX shell scripts to generate daily and weekly reports.
• Developed shell scripts to rebuild indexes on tables in different databases
• Worked wif various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files for reporting needs.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages wif cursors.
• Developed many sales and marketing reports from enterprise OLAP database using Oracle Discoverer.
• Knowledge in data warehousing analysis and ETL concepts, responsible for creating mapping documents.
• Involved in developing stored procedures for handling loads in dimensional tables and type2 dimensions in data warehouse.
• Knowledge in understanding already existed packages, and worked wif them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked wif advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensive knowledge in performance tuning the queries and development using explain plan and TKPROF, built indexes as part of tuning and optimization.
• Involved in Partitioning (Range, Hash and Composite) tables for optimal performance and management of data segments
• Worked wif dynamic SQL, developed many procedures and function wif dynamic SQL.

Environment: Oracle 7.x/8.x/8i/9i/10g, Reports 6i, Forms6i, Discoverer 9.0.2, Erwin, TOAD for MySQL, TOAD, Pro*C, Mainframes, UNIX, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98, MS Office 2000.

Confidential, Holmdel, NJ

Oracle Developer/Analyst

Responsibilities:

• Worked in System Analysis, Design, Coding, Testing, Development and Documentation.
• Worked in validating and developing the physical and logical phase of the requirement
• Extensively worked in developing many packages wif procedures, functions wif cursors and refcursors
• Worked wif PL/SQL advanced features like collections and records and PL/SQL objects types, involved in performance tuning and development
• Worked in writing many stored procedures, various functions, triggers and developed monthly and weekly reports.
• Created views, materialized views and indexes on tables as a matter of performance improvement and optimization.
• Worked wif Native dynamic SQL in various stored procedures and functions.
• Developed systems for handling and reporting data quality related issues in data warehouse by detecting errors using business rules.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully in data warehouse.
• Worked wif UNIX shell scripts and PERL scripts to generate daily reports.
• Written Korn Shell scripts for mounting database and create SQL*Plus session.
• Worked on tables in various databases by linking the databases.
• Tuning of the SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Worked in data transfer and retrieval through various schemas used TOAD and MySQL.
• Worked wif many complex SQL/T-SQL queries wif joins, date functions, inline functions, sub queries to generate reports.
• Written many database triggers for automatic updating the tables.
• Transferred data from different database to oracle database using SQL*Loader.
• Involved in Monitoring and usage of the databases and perform database tuning.
• Worked in developing Matrix Reports Using Oracle Reports.
• Worked wif complex reports, forms and menus wif PL/SQL programming.
• Export and Text IO packages and Written many Stored Procedures and in many Forms and Reports.

Environment: Oracle 7.x/8.x/8i/9i, Reports 6i, Forms6i, Erwin, TOAD for MySQL, TOAD, Pro*C, UNIX, SQL server 2005, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98,MS Office 2000.