Requirement Analysis Analytical Skills Client Interaction Technical Support Agile Methodology Planning & Execution People Management Stakeholder Management Troubleshooting Team Management PROFILE A competent professional over 8 years' experience in database application development in Oracle SQL and PLSQL, solution architecture, design, solution engineering, service delivery plus support and implementation Has recently worked as Technical Leader in Production support for a Wealth Management Firm Unique blend of managerial, technical, functional and qualitative skills with ability in all aspects of architecting, maintenance and troubleshooting Demonstrated skills in mapping client's needs and conducting gap analysis to devise cost effective end-to-end IT solutions to maximize customer value perception A keen strategist with acumen in providing effective business solution and technical architecture to leverage technology in creating revenue opportunities Exceptional dedication to grow with cutting-edge technologies and seeking to achieve beyond expectation in every endeavor
Windows Family, Unix 6.0
Oracle 9i,10g,11g (SQL & PL/SQL)
PLSQL Developer, TOAD, SQL Navigator, SQL Developer, SQL Server 2012, SQL * Plus Tool, Data Stage 9.1, Geneva - Advent Software, TLM Tool, Crystal Reports.
Web Sphere, Eclipse, ERWIN (Data Modeling Tool), Microsoft Visual Studio 6.0, HTML, MS XML, MS Soap 2.0, JIRA Bug Reporting System, Autosys Job Scheduler / IBM Job Scheduling Console (Tivoli), CVS, IBM Clear case, TortoiseSVN. Technical Production Level Support & Issue Fixing plus enhancements
Client: Wellington Management Company, USA; Languages: Java; Operating Systems : Unix; Database : Oracle 11g Organization: Cognizant Technologies; Location : Pune , India; Duration: Sep 2013 - Mar 2015
Role: PLSQL Developer; Client: Warner Brothers US; Operating Systems: Windows XP; Database: Oracle 9i; Duration: Feb 2007-Aug 2008
COGNIZANT TECHNOLOGY SOLUTIONS09/2010 to 03/2015
ORACLE FINANCIAL SERVICES SOFTWARE LTDAssociate Consultant08/2008 to 08/2010
SOPHOI TECHNOLOGIES PVT LTDTechnical Analyst02/2007 to 08/2008
Extensive creation of packages, procedures, functions, Triggers, etc.) Also, Responsible for building SQL queries, Oracle Scripts, Views, Materialized views and their unit testing.
Successfully developed various modules of Retail Banking and Investment Banking for integrating it with front ends like Java & Visual Basic in PLSQL and SQL 10g, 11g.
Reviewed code changes, test procedure, test plans & other deliverables.
Conducted impact analysis for enhancements & database level changes/patches.
Updated Data Model for the concerned database using ERWIN (Data Modeling Tool).
Carried out activities on JIRA as Bug Reporting System and Autosys Job Scheduling Tool.
Responsible for designing and developing, maintaining and scheduling packages, Report Queries for migrating application code from Microsoft SQL server 2012 to Oracle 10g.
Designed the code with the latest version of Oracle & conducted Unit Testing of migrated code on Oracle database involving fixing the data issues & performance issues during migration.
Used PLSQL collections, types & temporary tables and Responsible for designing and developing, testing, debugging and troubleshooting real time reporting using JXLS reporting and Crystal Reporting.
Responsible for overseeing the procedures tuning including SQL tuning, SQL indexes.
Maintaining in depth interaction with the client across various functional areas to comprehend and implement the delivery framework for optimization of the delivery Responsible for coordinating on various projects simultaneously with contributions in project planning, budgeting, resources deployment/utilization, risk identification & mitigation and project tracking Responsible for providing L2 Level & end-users technical support during the real time technical breakdown in the production Environment.
Designing and introducing timely but minor improvements in materials, components, systems & software by taking remedial actions for unplanned product deficiencies.
Conducting Root Cause Analysis of the major issues using Pareto charts and high impact analysis for production releases Developing knowledge repository that allows Production issues to be resolved faster by leveraging findings from previous resolutions.
Documenting issues using issue-tracking systems and creating reports regarding IT issues by users.
Bachelor of Engineering:Electronics-Electrical2005Raisoni College, Nagpur UniversityIndiaElectronics-Electrical
OCA in PL/SQL(Developer) Oracle 9i
Agile, Banking, budgeting, charts, Credit, Crystal, Crystal Reports, Client, CVS, Data Modeling, Database, Data Stage 9.1, debugging, Dec, delivery, Designing, Eclipse, ERWIN, XML, functional, Geneva, HTML, IBM, Web Sphere, Intellectual Property, Investment Banking, Java, materials, Windows, Windows XP, Migration, Navigator, Operating Systems, optimization, Oracle 9, Oracle, Oracle database, Developer, Oracle Financial, PLSQL, PL/SQL, project planning, real time, reporting, Retail, Scheduling, Scripts, Soap 2.0, Microsoft SQL server, SQL, SQL Server, tables, technical support, Tivoli, TOAD, troubleshooting, Unix 6.0, Unix, Utilities, Visual Basic, Microsoft Visual Studio 6.0