SUMMARY

• Over 16 years’ experience Proven senior Technology professional with rich and varied experience in Domain, Application Design and Development. Employs highly analytical thinking, self - motivation, and an energetic approach with collaborative team skills and leadership skills that gain the trust of management and deliver results.
• Expert experience as a Oracle SQL, PL/SQL, Performance Tuning, ETL and reporting.
• Expertise in Software Development Life Cycle(SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g/9i/8i database.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, sql trace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production. Worked on automating data loading, extraction, reports generation.
• Knowledge of standard data modeling patterns and practices, e.g. 3NF, dimensional models, and the ability to produce logical and physical models using Visio.
• Experience working in Agile Scrum model and Waterfall model life cycles.
• Well versed in utilizing JIRA as Ticketing Tool. TFS/SVN for Promoting (Check-in) the code to higher environment and to maintain in the repository.
• Working Experience in Data extraction, Transmission and Loading (ETL).
• Extensively used ETL methodologies for supporting dataExtraction, Transformation and Loading (ETL)process in a corporate-wide-ETL solution using Informatica Power Center.
• Worked extensively on various Informatica Data Integration components - Repository Manager, Designer and Workflow Manager/Monitor.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Worked with Business Managers, Analysts, and end users to correlate Business Logic and Specifications for ETL Development.
• Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/00/XP/10, Linux

Databases: Oracle 8i/9i/10g/11g/12c, MS SQL Server & Teradata12

Programming Languages: Oracle SQL, PLSQL, Oracle REST Data Services, Python

ETL/BI tools: Informatica, Snowflake Cloud, Tableau, Cognos, TIBCO Jaspersoft.

Database tools and Utilities: SQL * Loader, Toad 13.1, SQL developer, PL/SQL developer

Version Control: VSTS, TFS, SVN

Issue tracking tools: TFS, JIRA, Remedy tool, Confluence

Enterprise Scheduling Tools: CONTROL-M

Modeling Tools: Erwin, MS Visio.

Exposure: Linux Shell Script, Javascript, Hadoop concepts, HIVE and Impala, PostgreSQL, MangoDB.

CI and CD: Jenkins, Docker.

PROFESSIONAL EXPERIENCE

Confidential - Redwoodcity, CA

Senior Software Engineer

Responsibilities:

• Requirements gathering, create product functional design documents, technical design documents and test usecases.
• Development using oracle advance PL/SQL bulk collections, Analytical Functions, Triggers, Procedures, Functions, Packages.
• Design the overall Data warehouse data model of the core revenue recognition product and ETL implementation by using advance PLSQL from the ground up.
• Design and implementation of Data Export Services.
• Design and implemetaion of product Insights business Intelligence using Tableau from the ground up.
• Plan and coordinate with a diversified geographical team(california/Poland/India) of 10+ to develop the product, implement end to end test scenarios, methodologies, documentation protocols, and process improvements to ensure end-to-end coverage.
• Tuned the overall product to the best performance from inbound to outbound(~15 to 20 different processes) with complex ruleset on AWS cloud Oracle 12c single instance multi tenants with a limited budget to serve various customers. Used EXPLAIN PLANs, SQL Trace, TKPROF and AWR reports to tune the overall product performance.
• Helped various customers to recast their historical data to ASC 606 successfully within targetted timelines.
• Plan and exection of Continuous Integration, Testing and Deployment by using Jenkins/Docker to QA, SANDBOX and PRODUCTION environments.
• Provided Production Support to cutomers thru JIRA service desk tracking system.
• Helped customers who implemented the product on premises on Oracle 12c EE and tuned to utilize the best features from the enterprise edition.
• Part of core team to analyze the customer issues to classify as a defect or feature enhancement or new product feature.
• Addressed various performance issues like bind variable peeking, histograms, locking/unlocking, restructuring/denormalizing tables, in memory calculations.
• Mentoring team members on product functionality, technical implementation and product support.
• Part of a successful startup product company to generate more than $10M sales thru ~15 customers.

Software & Tools: Oracle Apex 18.2, Oracle 12c standard/Enterprise Edition on AWS cloud,Oracle SQL, PL/SQL, Javascript, Tableau, Informatica, Unix Shell Script, SVN, Jenkins, Docker, JIRA, TOAD, SQL Developer, AWS DMS, AWS S3, JIRA, Confluence, JSON, Python3.0 and Snowflake cloud.

Confidential

Application Mgmt. Sr. Advisor/Software Dev Advisor/Sr. Software Dev Engineer/ Software Dev Engineer

Responsibilities:

• Responsible for managing critical projects, customer engagements and business processes across multiple applications PLAN, PROCURE and SNOP on entire GLOVIA ERP.
• Design and Development of applications, based on interpretation and analysis that improve business performance and contribute to corporate goals and strategic intent.
• Managing overall PRODUCTION environment for ~20 applications and their database health checks, MQs and INNOVIS.
• Critical responsibility is to make sure all Class 1 applications up and running for 24X7 hours.
• Technical Design & software developement, stabilization support and user documentation.
• Implementing application changes to relevant environments DIT/SIT/PROD.
• Quarterly DR Tests for production systems to switchover/stay-over to DC.
• Data warehouse modeling, ETL by Informatica and BI reports by BO and custom build D3 Reporting tool..
• Effort estimations, project planning to till end of execution.
• DB build automation and and source code version control.
• Part of interview panel for new hires.
• Mentoring new team members for the domain and technology.
• Conduct user training sessions to the business users.

Software & Tools: MQ, INNOVIS and Oracle 9i/10g/11g/12c database, SQL, PLSQL, TFS, Remedy, MS Visio, Informatica Powercenter 9.x, CONTROL-M, COGNOS, Teradata 12(BTEQ, FASTLOAD, FASTEXPORT, MULTI LOAD), JSON, XML, UNIX Shell Scripting.