C Shripathy Email & Phone Number

Bengaluru, Karnataka, India

Fort Myers, Florida

In order for Chico's to be compliant with the Personal Information Protection Act, the Database development team has to make this their main priority to protect the data and so Chico's is not in jeopardy of falling out of compliance and losing thousands of dollars. As project lead, i had to coordinate, design the compliance for SQL and oracle DB instances used by web application(B2C application built on Oracle ATG commerce) which caters to retail business. The project is successfully completed well ahead of timeline (August 2016) and saved hundreds of dollars for Chico's.

Chicago, Illinois

• Experience in Analyzing, Designing, Testing, Documenting Database systems and Business applications.• Experience on all stages of the project - Planning, Analysis, Design, Development, Testing, Enhancement, Maintenance & Support of Software Applications, Estimation, Scheduling, Metrics, Progress & Status Reporting, Tracking.• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.• Knowledge of BI (Business Intelligence) reports with Crystal Reports Business Objects X1 (BOXI)• Good business intelligence skills to evaluate business problems and apply applications knowledge to identify appropriate solutions.• Lead project meetings, test strategy review and testing triage calls.• Experience in writing Oracle PL/SQL Packages, Procedures, Functions, Database Triggers, Views, Cursors, Exception Handling and SQL queries• Experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, Merge, Global Temporary tables, advanced replication• Implement various Development methodologies - Agile, Waterfall - Based on requirements• Deploy various tools, Change orders through the SDLC of a project• Develop and maintain scripts/tools to support and improve Production support, Build & Release processes• Demonstrated leadership, management, team building and mentoring, analytical, communication & interpersonal skills.• Elicit client requirements by conducting interviews, workshops, process descriptions and document analysis. • Training, UAT, Quality Control, delivering and present walkthrough obtain Sign off from stakeholders.• Experience in Onsite-Offshore project management, managing client expectation, client deliverables.• Exposure to Multiple geographies, global applications.• Experience as a member of PMO and extensive involvement in budgeting and staffing profile and resource allocation.

• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.• Creating the design document for the entire process identifying issues, providing solutions, logical & physical table structures• Analyzing mapping documents and accommodating necessary changes to the coding logic as per requirements• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.• Involved in the data analysis for source and target systems• Participating in user acceptance testing (UATs), making necessary adjustments to coding structures based on user recommendations• Performed optimization of long running queries by using several optimization techniques. • Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL• Generating SQL reports – comma delimited reports – attach them to PL/SQL email routines and send to management• Automating processes triggering events on scheduled days & times as defined by management using DBMS_JOB• Tuning of the SQL queries, which takes long time to process the request using Explain Plan to reduce the response time.• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions. • Worked closely with the DBA for the performance tuning and incorporated table-partitioning concepts to improve the performance. • Monitored the Prod Tickets, Change Control tickets through Sharepoint system. • Implementation of Bind variables across all stored procedures to enhance performance of the web applications during retrieval of information.• Effectively employed general coding standards/best practices• Experience with dynamic SQL, cursors and collections. Used EXECUTE IMMEDIATE to execute dynamic SQL.