SUMMARY:

• Senior Software Engineering with nearly 13 + years of experience designing/developing innovative applications and achieving high client satisfaction .Solid understanding of key concepts, such as PL/SQL Triggers, Procedures, Functions, Cursors, Data pump jobs, DBMS schedulers to call shell scripts via oracle procedures, Pipe Row functions
• Worked as a Team/Technical Lead for 5 years.
• Performed performance tuning services for PL/SQL applications
• Fine - tuned long running pivot/un pivot queries (converted them into pipe row functions) to avoid huge temporary table space usage and fine-tuned long running merge queries & insert queries reduced timing from hours to minutes
• Experience in Reports Development and Data Migration from CSV to Oracle Database using SQL Loader through scheduled batch operations
• Deep knowledge of System and database architecture: design, modeling and implementation
• Experience in designing and developing Oracle PL SQL procedures, functions, packages, Visual Basic, UNIX shell scripting. Excellent communications and interpersonal skill.
• Understanding Internet, Intranet and Extranet Environment.
• Fully trained in the SIX SIGMA Methodology and Lean Sigma, tools and techniques. Equipped to lead a process improvement project
• Experience in SQL tuning of medium/large database environments.
• Implemented Unit Testing and Integration testing during the projects
• Hands on experience with Visual Source Safe and MS PowerPoint (include any source safe and design tools).
• Participated in all phases of the project life cycle ranging from analysis, design, development, production maintenance and operation support.
• An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities.
• Extensive SDLC experience including Requirement Analysis, Preparations of Technical Specifications Document, Design and Coding, Application Implementation, Unit testing and System Testing, Documentation, Production Support, Functional and Regression Testing.
• Was Working at client place in various roles, Hutchison 3G (Maidenhead)/ Ericsson (Reading), Confidential (Cardiff) United Kingdom for nearly Three Years.
• 1+ years of experience in Hadoop programming, creating hive and pig scripts for large sets of structured, semi-structured and unstructured data.
• Worked on using Sqoop import/export to load data from HDFS and Hive to Oracle tables, Teradata and vice versa.
• Extensive experiences in UNIX shell scripting and Hands on Python scripting.
• Provided 24x7 production support for troubleshooting mission critical applications.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12 C

Tools: and Utilities: Erwin Data Modeler 8.2, Toad 11.5,PL/SQL Developer 8, Oracle SQL Developer Confidential .1, DB Visualizer 8.0, SQL loader, Data pump, TKPROF, Import and Export, Statspack.

Internet: HTML, XML

Middleware: IIS 6.0/5.0

Operating Systems: Windows NT/’95/’98/XP/2000/2003/Vista/7 and Red Hat Enterprise Linux Server release 5.6 (Tikanga).

Programming Languages: VB 6.0, VB Macro (VBA 7.0)

Scripting Languages: Unix Shell Scripting, AutoSys 11.0

Design Tools: Microsoft Visio 2010

Version Control tools: Visual Source Safe 2010, Star Team 12.5, Sub Version 1.7, Clear Case 8.0, SCCS

Build Tool: TFS 2010, Answers Desktop, DB Look, Micro strategy 9. Confidential

Quality Tools: HP Quality Center 11.0, RTC

Reports: Business Objects v6.5, Business Objects Enterprise XI Release 2, Crystal Reports 9.0, OLAP cubes

Data Warehousing: Netezza (10k series, Twinfin)

PROFESSIONAL EXPERIENCE:

Confidential, Lincolnshire, IL

Senior Software Developer (Senior Oracle Database Pl/Sql Devloper)

Environment: Oracle 11g/10g, SQL Developer, TOAD, HADOOP SQL, PL/SQL, LINUX (RHE6. Confidential ), Python, Hadoop (Hive and Pig Scripts), JIRA, WinScp, CRON Scheduler, Putty

Responsibilities:

• Worked on Genesis ecommerce platform which hosts 15 web sites in 10 countries/languages. The Objective of Genesis Ecommerce service operation is to enhance customer experience, improve site stability, performance and increase business profitability.
• Created stored procedures and functions using PL/SQL for stream lining the current processes and for data transformations and Worked on Linux 6. Confidential to create shell scripts and to automate job processes on crontab.
• Involved in setting up data loads and jobs for customers, product, orders and email subject areas for 15 countries in Europe-Staples that includes loading the data from ERP systems into Data warehouse and BI data system for reporting.
• Converted huge data loads from Oracle to Hadoop.
• Involved in writing hive queries and pig to parse raw data, populate staging tables and export the data using Sqoop export and store the refined data in partitioned tables in BI data system.
• Worked on using python scripting to create dynamic scripts for automated data load processing.
• Involved in performance tuning for various jobs using tuning techniques like Explain Plan, Hints.
• Provided Production Support for running daily batch jobs and fixing job failures.
• Provided solutions to Production issues for fixing data issues and Involved in Migration of Oracle Sql scripts and UNIX Shell scripts,
• Worked on using SQL Loader to load flat files into Oracle database.
• Worked on Sql developer for writing complex SQL queries to provide data analysis reports between the current environment and upgraded environment to make sure there are no discrepancies in data.
• Worked on using WinSCP for transferring files between two environments(FTP)
• Worked with DBA’s for database upgrades and troubleshooting performance issues.
• Involved in team discussions and provided solutions when required and Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Performance tuning of PL/SQL procedures and SQL queries and Defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Involved in Designing schema and schema objects, coding in PL/SQL and Shell Scripting, Review of Test Cases and System Testing.
• Developed various Complex Queries, Views for Generating Reports and created dyanamic procedures for various process in the project to load different tables.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Re-org the large volume of tables to achieve better performance.
• Converted some of the intensive processes to Hadoop using Hive, Sqoop and Pig. Sqoop exported data from sql server to Hadoop for faster processing and sqoop back to oracle for reporting.
• Created shell scripts, UNIX function using VI editor. Hands on knowledge of utilities like find, grep, sed, etc. Followed agile methodology for development activity.

Confidential, Boston, MA

Senior Software Developer

Environment: Oracle 11g, PL/SQL, UNIX, Autosys

Responsibilities:

• Developed PL/SQL Packages, procedures and functions; Created views, database triggers for various functional requirements.
• Resolved day-to-day technical issues during development and testing phase.
• Interact with the requirements team during development and with users during implementation and analyze new business requirements or enhancements or change.
• Worked on the new change requests and implemented them successfully.
• Support for the client taking new change request and bug fixing after implementation stage.
• Involved in performance tuning. Converted all Delete/Insert statements to Merge/Delete for all fact tables as part of performance tuning.
• SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and creating the right data model.
• Performed Oracle DBA tasks such as monitoring the database, creating users, granting roles and grants, application build, run conversion scripts.
• Used development tools such as Toad and SQL Developer for writing code and executing the queries etc.

Confidential, Schaumburg, Illinois

Designer/Lead Developer

Environment: Oracle 11g, PL/SQL, Netezza, UNIX, Oracle APEX

Responsibilities:

• Involved in Data Modeling of designing tables for back end.
• Worked with Erwin for Data Modeling to create complex table structures.
• Interact with the requirements team during development and with users during implementation and analyze new business requirements or enhancements or change.
• Worked on the new change requests and implemented them successfully.
• Support for the client taking new change request and bug fixing after implementation stage.
• Used DBMS SCHEDULER to set batch jobs for processing large amount of data in parallel.
• Some data in the conversion process was provided by third party application in very large files. Used SQL Loader for loading these files in the database.
• Wrote UNIX scripts to automate the conversion process where various conversion processes were put together and called in an order. The process was monitored and it would provide online progress of the process.
• Parallel batch processing was used to drastically reduce processing time for loading millions of bank transaction records. Algorithms were written to split the records in various batches and processing them separately.
• SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and creating the right data model.
• Used development tools such as Toad and SQL Developer for writing code and executing the queries etc.
• Worked with the version control application Subversion, plugged in using Eclipse.

Confidential, Schaumburg, Illinois

Designer/Lead Developer

Environment: Oracle 11g, PL/SQL, UNIX,Netezza

Responsibilities:

• Directly engaged with different clients (Kimberley Clarke, Kraft, Schwan) and trying to understand their POS data
• Worked on Netezza to load data from Mainframe systems. Wrote Korn shell scripts to call PL/SQL procedures, functions, triggers.
• Wrote Autosys for the orchestration of the total workflow
• Worked on Data Analysis and Data Mining
• Understanding the systems behavior in analyzing the POS data at granular levels
• Able to deliver data in any desirable report format
• Involved in the review of Requirement document.
• Involved in the review of Functional specification documents and performing estimations.
• Team Lead for handling the production tickets and the change requests.
• Back-end application development using Oracle 11g PL/SQL. Develop stored packages, procedures, and functions; create tables, views, constraints, foreign keys and indexes.
• Created conversion scripts, and executing them over very large set of data. The amount of data ranged from 50 million customer accounts to 500 million transaction records. SQL tuning methods such as explain plan, correct Index creation and hints were used to option optimal performance.
• Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best performance. These were used in large data conversion scripts, to process records within a procedure or package before updating them to the database.
• Oracle data warehousing was used to analyze large amounts of data without affecting the production database. Materialized views were used to make a copy of transaction records from the production system daily, this was then used to analyze and generate reports for analysis.

Confidential

Programme Assurance Analyst

Environment: - MS Project Professional, MS Viso, EPM

Responsibilities:

• Team Lead for handling the production tickets and the change requests rose.
• Was instrumental in increased the team size from 5 people to 25 people.
• Was instrumental in getting EPM implementation project at client place for.
• Pivotal in the creation of a centralized PMO and PSO that has recognized value in supporting the strategic programs.
• Achieved budget by promoting goods receipting to ensure costs were accrued.
• Increased accuracy of supplier time recording from 46% to 100% providing financial control and improved cash flow.
• Implemented an improvement to the provision of project codes saving 2 man days effort per month.
• Supported the recruitment, and led the on boarding, training and development of new starters.
• Represented Program Office as business partner to Finance Department.
• Devised and delivered training catalog for the Program Office team including formal training, self-service “How to” guides and key stroke level work instructions.
• Developed PMO brand, intranet site - People, Process, Data, and Tools.
• Deputized for PMO Manager as required in all activities.
• Provided secretariat for investment board meetings.
• Enhanced the governance framework for programs and projects in order to improve time and cost metrics in delivery with a 10% saving year on year.
• Delivered a risk management process and tools enabling the business to manage and mitigate risks more effectively.
• Improved the adherence to process and quality of related artifacts for a portfolio of over 200 projects.
• Assisted in the set up and development of program office management processes, governance, assurance of standards, best practice (tools/methodologies/improvement initiatives).
• Provided the analytic and MI function within the PMO which generates over 40 reports on a weekly basis for stakeholders across the business.
• Developed a single source central data repository with “change management” process and audit accountability.
• Supported the evolution of the EPM tool set as SME.
• Developed and owned the business case template.
• Award for recognition - Exemplary H3G behaviors (Open and Honest, Keeping your word, Taking responsibility)

Confidential

Systems Change Analyst

Environment: MS Project Professional, MS Viso, EPM

Responsibilities:

• Defined, agreed and documented working practices between H3G and supplier ahead of schedule ensuring a seamless transition of responsibilities to Ericsson the new Managed Service Provider (MSP).
• Negotiated performance measures and targets for emergency and failed technical change implementation. Elevating non-contractual KPIs to contractual SLAs to drive the right behaviors promoting maximum levels of service and right first time delivery. During this time minimum service levels were not breached.
• Revised WLA to change outcome definitions to more accurately reflect the performance of change management from a service impact and customer experience perspective.
• Reviewed emergency change SLA to address inconsistencies in the reporting of late notice implementations.
• Identified misuse of the retrospective change process within the MSP. Addressed this by putting measures in place to ensure this process satisfied audit requirements and was used solely to support fault management processes.
• Worked with project teams to ensure effective operational support was in place before the launch of Mobile Broadband. An important strategic delivery for H3G.
• Worked with the supplier team to semi-automate reports eliminating administration errors and allowing more time to focus on the quality of data entered into the change management system.
• Worked with Orange (H3G national roaming partner) and MSP teams to develop processes to ensure changes on neighboring network elements are made in parallel. To minimize the impact to ISHO (Inter System Handover) ensuring service quality and continuity.
• In conjunction with our supplier developed a new WLA for the E2E implementation of SMS and MMS short codes. Ensuring timely delivery of supportable services which in turn drives revenues and increases the range of quality services to customers.

Confidential

Configuration Management Analyst

Responsibilities:

• Established the configuration management team processes and performance reports.
• Driving force behind the delivery of the CMDB (configuration management database) Liaising with key stakeholders to ensure requirements were met.
• Created and publicized E2E change and configuration management process to ensure CMDB maintained.
• Proactively drove post implementation feedback from <60% to 100%. Less than 100% feedback impacts the accuracy of a CMDB.
• Instrumental in the implementation of OCMS (operations change management system) and smooth transition from the paper based process - This reduced the administration effort required to run the change management function and enabled the set up of a stand alone configuration management team.
• Created and publicized training of the new system - on Go-Live over 400 users had accessed the training and were using OCMS.
• Developed KPIs and associated reporting processes. Transferred skills by training other team members.
• Involved in the development and promotion of change and configuration management processes surrounding ITIL best practice guidelines to all areas of the organization.
• Developed applications for probation, voluntary retirement, deputation and asset management system
• Understood the existing database model and designed the new database model based on it. Used Microsoft Visio for designing the database.

Confidential

Module Lead

Platform: Oracle 9i/8i/8.05, PL/SQL, Oracle SQL Loader

Responsibilities:

• Directly engaged with different clients and trying to understand their systems behavior
• Understanding the systems behavior in analyzing the data at granular levels and Understanding E2E Telecom system process
• Developed an online attendance system using Oracle 9i database with PL/SQL on the back-end
• Was involved in complete back-end development using Oracle PL/SQL. Created stored procedures, packages, functions, tables, constraints, foreign keys, views, indexed and triggers.
• Worked on uploading data present in test files using Oracle SQL Loader utility into the database. This data was the main source of input.
• Involved in the review of Functional specification documents and performing estimations.
• Wrote stored procedures, packages, functions, triggers and created tables, views, constraints, foreign keys, indexes to develop bill delivery management system, which keeps tracks of all the customer bills generated. This application keeps tracks of bills of 20+ million customer base.
• Was responsible for carrying out Database administration jobs such as backup and restore and database performance tuning or Oracle 8i and 9i databases.
• Used table partitioning and materialized views to create a billing data warehouse. This data warehouse provides billing details to other application without effecting performance of the production database.
• Worked on a large database of size in huge terabytes. The database has thousand of tables many of which contain 100s of millions of records.
• Uploaded large amount of records present in Excel file onto the database. The data was first converted to a csv file format and then loaded into database using Oracle SQL Loader facility.
• Installed and configured Oracle 9i/8i/8.05
• Involved in the design meeting for designing DB for the system
• Created Tables, Views, Constrains, Synonyms, Sequences and Materialized Views
• Created and used DB-Links to connect to other local & QA databases
• Built the QA environment for testing DS application and ensured that all the modules work as expected
• Created Word, Excel, Power-point, Paint objects from Lotus Notes using lotus script and OLE.
• Involved in the team that designing the Configuration Management System
• Involved in the team that defined GUI & Coding standards
• Developing tools for trouble shooting, verifying configuration
• Performed Unit Testing and Regression Testing

Confidential

Developer

Platform: Oracle 9i/8i/8.05, PL/SQL, Oracle SQL Loader

Responsibilities:

• Provided production support to the clients on Oracle 9i database administration aspects such as database backup using Oracle Export Utility and database crash recovery from the backup dumps and redo logs.
• Interacted with clients understanding the operational requirements, troubleshooting data and application issues, reporting bugs and following it up to resolution.
• Analysis and design the Migration Strategies with multiple transformations as per the business logic.
• Source data analysis, analyzing and Designing mappings for data extraction.
• Written Packages and Procedures for loading the data from staging tables to Target tables
• Completion of Conversion Building the Replication between OLTP and OLAP Servers.
• Refresh of Database Backup and Restore.
• Automating and maintaining the shell scripting Jobs.
• Writing Advanced Stored Procedure, Triggers and Script.
• Deploying the Data Modal Changes and Structure Changes
• Creating maintaining the Users, Roles and Linked Server
• Used Oracle SQL loader to load large group clients information provided in a formatted text file to the database.
• Created static and dynamic database jobs to process large end of day processes in batches. Using this parallel processing was implemented which drastically improved the performance of the application.
• Developed a user friendly application for the users to log issues using forms and PL/SQL and integrated this application to Domino mail server
• Solved implementation problems in PL/SQL and database related issues with ETA less than 30 minutes
• Involved in client acceptance testing and Provided hands on support to users.
• Developed new functionality to the existing application as part of change requests
• Developed a tool for configuring base data setup and access control levels in the system
• Documented the change requests and submitted to change control team
• Developed a tool in PL/SQL to load data in system for performance testing
• Involved in the Database Objects creation and normalization of tables
• Developed PL/SQL procedures for calculation of retirement and probation in the system
• Developed reusable components and rule based engines for improving productivity using PL/SQL
• Designed Generic Workflow, Organization Model using Domino Workflow.
• Involved in the team which developed Integrated Design Environment (IDE) for the development of applications.