SUMMARY

• Over 6 years of experience in Analysis, Design, Development, Testing and Implementation of Business Applications and Client/Server applications.
• Strong Business Analysis experience onDataAnalysis, Business Requirement Documents,Data Migration Documents, User Requirement Gathering, User Requirement Analysis,Data Cleansing,DataTransformations & Impact Analysis.
• Proficient in Oracle 12c/11g/10g/9i/8i, PL/SQL Developer, MySQL and Shell Scripting.
• Strong Experience in data warehouse Building, OLAP and OLTP systems, Maintenance and Support which uses ORACLE 8i/9i/10g/11g/12c Databases, MySQL, SQL, PL/SQL and Business Objects.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling.
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas using ERWIN, Fact and Dimension Tables, De - normalization, Normalization, Logical & Physical Data Modeling.
• Expertise in Tuning of Procedures, Packages, SQL.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors, Dynamic SQL, Oracle Analytical Functions, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Strong knowledge in Oracle utilities SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, TKProf.
• Experience in Data Migration.
• Strong knowledge in version control tools like TFS, Serena dimensions and SVN repository.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning.
• Extensive knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Experience in creating rich visualizations in dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Well versed in creating canned and ad-hoc reports in Tableau Desktop.
• Excellent analytical and problem solving skills.
• Quick learner with ability to master new concepts and applications.
• Experience in MS PowerPoint presentations for end users and in MS Access and MS Excel.
• Excellent ability to work independently and as a part of a multi-functional, geographically diverse team.

TECHNICAL SKILLS

Operating Systems: Windows, Windows XP Professional, Windows NT, UNIX

Programming languages: PL/SQL programming,SQL, C, C++,HTML

Scripting Languages: Shell scripting, JIL script

Tools: Toad, PL/SQL developer, SQL developer, putty, SSH tectia, Business Objects, Tableau, Visual Studio.

Database: Oracle 12c/11g/10G/9i/8i/8, MySQL, MS Access 2000

Office tools: MS Word, PowerPoint, Excel, MS Access

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr.PL/SQL Developer

Responsibilities:

• Assisted the client with thorough analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with users, gathered information for project development.
• Prepared the program specification and design document for the development of the CART Application.
• Created multiple customized PL/SQL Procedures & Packages for various businesses’ needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, sequences, triggers, functions, procedures, cursors and packages.
• Performed the export/import of huge tables by using the oracle data pump utility EXPDP/IMPDP.
• Increased the speed of the data loads by optimizing the SQL* loader control file.
• Performed partitions on very large tables by using list, range and hash partitions.
• Created Sequences for automatic generation of voucher numbers.
• Conducted the unit testing, monitored the production deployment and resolved post implementation issues.
• Assisted the QA teams for bug testing, user acceptance testing (UAT) and system integration testing.
• Used SUBSTR, REGEXP, NVL, INSTR, PIVOT, UNPIVOT and many functions in Oracle 11G to transform complex source data.
• Extensively used Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL for plsql programming.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance of existing procedures.
• Ability to reliably confirm results of ad hoc processes viadataanalysis utilizing SQL queries.
• Lead and coordinated the work with the offshore team .
• Experienced in handling large volumes of data.
• Used Exception Handling to handle runtime & user defined exceptions.
• Have worked in fast pace agile environment and attended daily scrum meetings.
• Worked extensively on version control tools like serena dimensions and TFS.
• Developed Unix Shell scripts to automate repetitive database tasks.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Wrote JIL scripts to automate the jobs through autosys.

Environment: Oracle 12c, 11.0.2, Oracle 10G, PL/SQL, SQL*Loader, Toad, PLSQL Developer, Windows Server 2008, Tableau 8.X.

Confidential, New York, NY

Sr.PL/SQL Developer

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Design and provide Database service call contracts to Java/UI team
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
• Extensively used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Wrote complex stored procedures and packages.
• Extensively used Execute Immediate for dynamic sql.
• Extensively used Analytical functions Rank, Dense Rank for complex reporting purposes and hierarchical data
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Modified existing Shell Scripts and created new Shell Scripts.
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
• Plan production deployment activities, raise RFCs and coordinate with various teams like DBAs, Unix Admins.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data.
• Develop ETL strategies for integrating data from multiple sources into data warehouse.
• Understand and complete necessary documentation for the application/infrastructure change control process.
• Employed rich Tableau features using action filters, parameters, calculated fields, drill downs and sets giving the user a friendly navigation option through all the views in the dashboard.
• Created Tableau dashboards using bar-in-bar graphs, line charts, filled maps, dual axis charts, bubble charts and Gantt charts.
• Effectively useddatajoining ordatablending features for building an integrated view of multiple tables ordatasources.
• Development of dashboard reports for key performance indicators for the top management.
• Create new Tableau dashboard and adhoc reports as per the user requirements.
• Created reports by developing, disseminating and administering high quality dashboards in tableau.
• Tested dashboards to ensuredatawas matching as per the business requirements and if there were any changes in underlyingdata.
• Create data extracts for Tableau.

Environment: Oracle 11.0.2, Oracle 10G, PL/SQL, Rapid SQL 7.6, PLSQL Developer, Windows Server 2008, Tableau 8.

Confidential, Newyork NY

PL/SQL Developer

Responsibilities:

• Analyze the functional & technical requirements of project.
• Involved in Logical and physical modeling.
• Designed and developed ETL process from scratch for this new system using Oracle, PL/SQL and Unix.
• Designed Fact and dimension tables and handled slowly changing dimensions.
• Participated in software quality assurance activities, including code reviews, and unit, system, integration, regression, and performing testing.
• Determine and capture metadata and business rules in coordination with other data architecture team members.
• Create new Tables, Indexes, Views, Materialized Views, and Table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE.
• Wrote complex stored procedures and packages.
• Create new Structures, Input/output Events, and Sources in RDJ for new rules.
• Validate, extract and send the rules to File Manager, compile and move them to production.
• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema using SQLLDR, Export/Import.
• Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.
• Extensively used hints to tune & optimize queries using DB links.
• Used DRIVING SITE, HASH, INDEX, NO USE NL, etc. hints to optimize queries.
• Wrote complex shell scripts for processing of rules.
• Used $UNIVERSE scheduler to schedule ORACLE & non oracle jobs.
• Created Test scripts and involved in Unit, Integration and System testing.
• Wrote FTP scripts for transferring files between different machines, FTP checks to ensure complete file transfers, new Daily backup scripts to copy last 5 days of files to disaster recovery (DR) system.
• Used PUTTY & Reflections to connect to UNIX machines.
• Used Rapid SQL & SQL Developer to access DB, write packages, procedures & functions.
• Guide/help team members in resolving technical issues.
• Created Test scripts and involved in Unit, Integration and System testing.
• Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Published Reports, workbooks & data source to server and exported the reports in different Formats.
• Create adhoc reports using Tableau, for Finance users.
• Created reports by developing, disseminating and administering high quality dashboards in tableau.
• Design of dashboards with various reporting objects like hierarchies, filters, calculated fields, sets, groups, parameters etc. in Tableau.
• Provide 24/7 oncall production support, resolve P1, P2 issues immediately

Environment: Oracle 9i(9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL, Rapid SQL 7.6, SQL Developer, UNIX, SH, Windows NT, Reflection for UNIX, RDJ 8.3.2/9, Oracle Apps 11.5, Tableau 7.

Confidential

Oracle PL/SQL Database Developer

Responsibilities:

• Performed design, coding, implementation and support.
• Wrote Stored Procedure, Package and Triggers for back end validations.
• Wrote Procedures using Oracle supplied Packages.
• Designed Front-end interfaces and created reports as per the requirements using Forms/Reports 6i.
• Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting, and logic that processes logistical data for optimizing selecting a particular product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.
• Wrote complex SQL queries using joins and correlated sub queries.
• Validations have done in front-end and as will in backend using triggers.
• Analyzing the tables.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Oracle 8i, Oracle Forms/Reports 6i, (SQL*Plus, PL/SQL Developer), Windows XP Pro, MS Office (Excel, Word), UNIX