Professional Summary

• Around 7 years of experience as Technology Analyst with experience in different domains like Insurance, Banking, Telecom, Healthcare.
• Have worked on MIS projects in India, UK and USA.
• Have knowledge of Oracle PL/SQL, SQL Server 2000 Enterprise edition, SQL Server 2005 (which majorly includes ETL process in DTS packages, Query optimization and Performance Tuning), ASP.Net and C#.
• Have good knowledge of new features of Oracle 11g i.e. Follow trigger, use of sequence variables directly in the PL/SQL block, Continue statement.
• Running SQL Reporting Services Report from SSIS.
• Experience in SQL server 20005 and 2008.
• Hands on experience in writing, testing and implementation of the Triggers, Procedures, Functions at Database level using PL/SQL
• Monitored Indexes and analyzed their status for performance tuning and query optimizations.
• Good Understanding and working knowledge with SQL Trace and TKPROF.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Interacted with users to understand the business requirement.
• Experience in creating different kinds of partitions on tables and indexes for managing large tables.
• Query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Expert in Managing and optimizing Oracle Database in OLTP environments.
• Tuning and optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes and creation of views
• Used SQL*Loader for data uploading from flat files
• PL/SQL Coding and SQL tuning throughout the development wherever needed
• Created technical documents, program specifications and participated in client/user groups interactions
• Good verbal and excellent written communication skills, able to relay technical information to non-technical staff and fellow developer
• Possess strong interpersonal, problem solving and analytical skills.

TECHNICAL SKILLS:

Databases -

Oracle 10g, Oracle 9i, PL/SQL, SQL*Loader, Developer 2000 , SQL Server 2000 Enterprise edition ,SQL Server 2005 (which majorly includes ETL process in DTS packages, Query optimization and Performance Tuning), ASP.Net and C#.

Reporting-

Crystal reports ,Universe Developer, SQL, PL/SQL, SQL*Plus

Environment-

UNIX (Sun Solaris, HP-UX, AIX), Windows 2003/2000/XP/98

Others-

MS Office, Adobe Acrobat Reader/Writer.

Languages-

SQL, PL/SQL,SQL Server, Microsoft .NET,HTML,CSS,Javascript

Tools -

Oracle Enterprise Manager, TOAD, PL/SQL Developer, SQL Developer, Putty, SQL Navigator, Erwin 4.0

Operating Systems-

UNIX, Sun Solaris 5.8, 5.9 Windows NT, Windows 95/98/2000, Windows XP, Windows Server 2003

Certifications :

• Basic telecom and Datacom certification
• Basic OSS/BSS certification
• .NET Foundation certification
• .NET Basic programming Certification
• Infosys quality certification
• ITSM certification for Remedy

Achievements :

• Cleared Infosys Foundation Level Training in .NET.
• Obtained a Consolidated Relative Ranking 1 (highest) for the year 2007-08 and 2008-09.
• Received “Infosys Bravo Award” for excellent work.
• Received “Platina Team Award” for timely delivery and customer delight.
• Winner of Infosys AWARD for EXCELLENCE year 2009 for excellence in project execution in Net view Maintenance and Support for British Telecom.

PROFESSIONAL EXPERIENCE:

Company Name: Confidential, Lexington, MA
Designation: Sr. Oracle Developer
Duration: SEP2012 –Till Date

Establishment Data System:

Project Description: 
The Occupational Safety and Health Administration is responsible for planning, developing and implementing and extensive statistical program that includes the collection, processing, analysis and interpretation of information needed to support planning and management functions of OSHA. As part of its mission OSHA has developed and implemented a system to collect, compile and integrate data on occupational injuries, illness and fatalities for establishment in high risk, private sector industries.

EDS provides access to the data from the OSHA Data Initiative (ODI), to inspect reports from the OSHA Integrated Management Information System and Industry based data from the Bureau of Labor Statistics. EDS offers compliance officers to retrieve sort and analyze these data to assist them in:

• Performing technical support and compliance assistance duties.
• Tracking individual employers in their jurisdiction with ongoing safety and health problems.
• Identify hazards and documenting deficiencies in the workplace.

Roles and Responsibilities:

• Requirement analysis and database design.
• Assisted in designing the system flow.
• Managed the different life cycles of the project and controlling the cost.
• Documented business rules, functional and technical designs, test cases, and user guides
• Developed various complex business processes using procedures, functions and packages.
• Used Pipeline functions
• Responsible for different deployment and loading member and billing data.
• Managed and resolved design issues during different phases of Project.
• Extracting data from the Customer Interaction Center and creating a ‘,‘ separated file (flat file) by writing SQL queries
• Have done end to end mapping from legacy database to Current Database.
• Worked on Database Design.
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
• Creating and working with GTT (Global Temporary Table)
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done
• Development of the system based on HTML,CSS and Javascript
• Created and maintained HTML/CSS web pages
• Analyzed provided HTML assets and revise code
• Understood the implications of their actions.
• Collaborated with developer team members on best practices.
• Created user friendly, standards compliant, cross browser HTML and CSS designs.
• Defined, maintained, implemented and enforced style guides and standards. 
  Optimized performance of client side code

Environment: Oracle 10g/11g, Windows, PL/SQL, SQL Loader, Batch Scripting, PL/SQL Developer.

Company Name: Confidential, SouthBorough, MA
Designation: Sr. Oracle Developer
Duration: NOV 2011 – AUG 2012

Project: Confidential is a fully Web-based platform for all line of individual, employer-sponsored, Medicare and Medicaid business that allows healthcare payers to transform the way they do business. Solutions offered for payers in different areas like Sales, Claims, Billings, CMS Gateway, Disease Management, Data warehouse and Analytics: Profile, UA, P4P and Health Risk Questionnaire etc.

• Responsible for Data Modeling, Development and Support of Enterprise Database, Data Warehouse and standardizing of practice to support new sets of Application and Business intelligence solutions.
• Write specifications and perform loading/extraction of data from/to transactional processing systems to support Vendors, different Interfaces or Data warehouse through the different process using SQL and PL/SQL.
• Created Custom Stored Procedures, Functions, Packages and SQL Scripts.
• Work closely with Business Analyst to fully understand business requirements.
• Involved in Data loads and Conversion of data from Legacy system to Oracle Applications and Oracle Data warehouse with the use of SQL Loader and bulk load process using PL/SQL procedures.
• Scheduling the jobs and defining the dependencies using Control-M Scheduler.
• Responsible in code promotion/deployment from one environment to another i.e., Development, UAT and Production upon approvals from supervisor and Business users through tools like VSS and Control-M.
• Design and Code data load process using SQL Loader, Customize packages and procedure.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle database.
• Involved in the integration testing of the product.
• Involved in Data Migration, Database Deployment from one environment to another.
• Documenting to describe program development, logic, coding, testing, changes and corrections.
• Working with Business Analysts and Implementations team to define Project development timelines.
• Assigning tasks to team members.
• Involved in Project and Process documentations.

Environment:Oracle 9i/10g/11g, PL/SQL, Batch Script, TOAD, PL/SQL Developer, VSS, ASP.NET3.5

Company Name: Confidential
Designation: Technology Analyst 
Duration: Sep’2010 to Oct’2011

Project Description: SMIT SLA Management Open reaches (UK)

Confidential is solution developed for Open Reach using Digital Fuel\'s SLA management product - Service Flow. Feeds from third party system are input to the system and data is processed via service flows and various business rules attached. The solution is deployed on Unix OS. Different kinds of reports are built on processed data such as MIS report, Summary and volume report per product , CPIS report and SAR reports etc. Data and payment validation is another important aspect of solution which provides users, a facility to validate the records. Solution also has provision to maintain repository of various service offerings, metric, business rules attached, dimensions and Service level agreements per customer.

Roles and Responsibilities:

• Coding enhancements of flows based on SQL. Coding changes are also done for various bug fix requests as well. Coding involves changes in User interface and Business Logic.
• Have used Service Flow, Toad and Putty for day to day work. Testing of the Flows created.Analysis of Bug fixes assigned &scheduling the batch runs in planned manner.
• Creation of new reports and maintenance/enhancement of already existing reports which needs Oracle expertise.
• Helps in guiding the team mates and Suggests solutions for performance tuning in oracle and SQL.
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating Database Links.
• Discussion on issue in Standup call with team members and made them agree to do the same changes for other products in Digital Fuel Service Flow SLA Management Application and got signoff from customer for the bug fixes.
• Daily in Worked with the UML diagrams in different tools. Well versed with the Strom concepts, how to manage stories (acceptance criteria, Integration testing). Has knowledge of BT Operating Model e.g. how we manage our end-to-end process – from how we engage with the customer, to how we launch our products and services – and everything in between.
• Have performed the role of a Configuration Controller for the project .Also worked as a DP anchor of the team, was responsible for conducting the DP meets and tracking the defects to their resolutions.

Highlights:

• Handled team of junior engineers reporting, involved in management activities and estimations.
• Single point of contact in designing solution for one of critical requirement from client.

Environment: Oracle 9i/10g, Windows, PL/SQL, SQL Loader, Batch Scripting, PL/SQL Developer, Digital Fuel Tool

Company Name: Confidential
Designation: Technology Analyst 
Duration: Sep’2006 to Sep’2010

Projects Handled:

• Project: Net view Wholesale Management System

Client:British Telecom

Project Description:

It was an MIS (Management Information System) application representing the performance and the customer export in the form of reports. The front end was in VB.Net with back end as Oracle and Microsoft SQL Server 2000 (now migrated to SQL 2005) .The team was responsible for the end to end activities related to the maintenance, which involves performing the ETL (Extract, Transport and Load) processes for data landing, writing business logic in DTS (data transformation services), creating customized reports (using front end tool called management console) and testing.

Roles and Responsibilities:

• Worked as a Technology Analyst, responsible for resolving queries related to the business logic embedded in PL/SQL.
• Responsible for interacting with the customer, and implementation.
• Held bottom line responsibility for landing of data coming from different OSS systems using job scheduler which further runs different DTSs (Data Transformation Services).
• Held bottom line responsibility for SQL related issues occurring in the execution of different DTSs (Data Transformation Services).
• Have performed the role of a Configuration Controller for the project (used VSS for this task).Also worked as a DP anchor of the team, was responsible for conducting the DP meets and tracking the defects to their resolutions.
• Created Cursors and Refcursors as a part of the procedure to retrieve the selected data
• Created stored programs in the form of PL/SQL Packages, Procedures and Functions
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL.
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
• Creating and working with GTT (Global Temporary Table)
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient.
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Worked with performance tuning tools like explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQLplus and TOAD to develop database applications
• Documentation of the technical work done
• Have worked on SSIS ans SSRS on SQL server 2005.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in ETL processes involving migrations and in sync processes between two databases.

Highlights:

• Single point of contact at onsite (UK for 1 month).
• Received awards for contribution to the project.
• Team received Award for the excellence in performance.
• Project has been rated at CMMi Level 5
• Project received magical ELF (Customer Engagement Level Feedback) of 7/7 on all parameters
• Project performance and delivery resulted in repeat business and expansion.

Environment: Oracle 9i/10g, Windows, PL/SQL, SQL Loader, BatchScripting, PL/SQL Developer, SQL Server 2000 Enterprise edition, SQL Server 2005 and 2008 Business intelligent Studio, Microsoft Visual Studio 2005 and 2008, WCF,WPF.

Educational Qualifications:

• B.Tech in Computer Science