Experience Summary

• Over 8 years of result driven and proven track record in the analysis, design, development, implementation and management of full life cycle commercial applications in USA, UK and INDIA.
• Worked as Project Lead, Technical Lead, Programmer Analyst and Software Engineer.
• Involved in utilizing programming and logical skills in software development of Multi-tier applications, Client Server Applications, Enterprise Applications using Unix and technologies like Informatica, Data stage, Business objects and Unix platform.
• Extensive knowledge and work experience in C, C++, Pro*C, Pro*C++, Oracle 9i/10g, PL/SQL, SQL Server, HTML, XML, Netezza and UNIX
• Well Versed in Object Oriented Programming (OOP) concepts.
• Proficient with using Erwin Data modeler (Data modeling tool).
• Experience in writing and implementation of Batch Scripts, Report Generation, and scheduling process using Shell Programming.
• Experience in Requirement gathering from Business Users, Customer interaction, design, development, configuration, Testing, and installation of business application and product using core technologies C++, C and Oracle on Linux.
• Good Knowledge of design patterns, templates and reports customization in Business Objects.
• Experience in the Object Oriented Analysis and Design, strong in Data Structures.
• Knowledge of source control tools such as VSS, CVS.
• Conversant with all aspects of Netezza loading NZLOAD and NZSQL, Netezza architecture, database design and Netezza Performance Tuning skills.
• Demonstrate knowledge of plans, join processing, Netezza optimization techniques, Netezza specific best practices and solid understanding of Distribution, Zone maps, MVIEWS and be able to use them appropriately.
• Knowledge of enterprise quality tools such as Mercury Quality Center, Test Director.
• Complete understanding of software development lifecycle (SDLC).
• Highly skilled at building teams, designing, developing software products and deploying it to the customers satisfaction.
• Good organizational and time management.
• Deep exposure in data warehouse MPP appliance processing.
• Industry focus includes Telecommunication, Retail, Financial and Life sciences.
• Demonstrated success many times under aggressive project schedules and deadlines. Flexible result-oriented and adapt to the environment quickly to meet the goals of the product and the organization.

Certifications

• Oracle Certified Associate – 9i DBA (OCA)
• Introduction to Oracle 9i: SQL
• Oracle9i Database: Administration and Architecture
• Business Objects Certification XIR2
• Netezza Bronze Certification(4.6)
• Informatica Certified Developer (Mar 2011)
• Brain bench certifications
• Customer Requirements Analysis
• Project Management (2005)
• Business Communication
• Telephone Etiquette

Education:

Bachelor of Engineering (Computer Science)

Programming Languages:

C++, C, SQL, PL/SQL.

Operating System:

UNIX, Linux, Solaris, AIX, Macintosh, Windows 95/98/NT/XP

Scripting Language :

Perl, Shell

Databases :

Oracle 8i ,Oracle9i,DB2,Netezza 4.6,Netezza Twinfin ,Teradata

Development Methodologies:

OOPS, OOAD, Rational Unified Process, n-Tier
Client Server

Design Tool & Language :

Rational Rose Enterprise Edition (OOA/OOD), UML

Version Control System :

Perforce, CVS, VSS.

ETL tools:

Data Stage, Informatica.

Reporting tools:

Business Objects5.6,6.5,XI ,Cognos

Web server:

IIS Web Server, Apache Web Server

Database tools:

Toad, WinSQL , Oracle SQL Developer

Employment History (responsibility wise):

Confidential, May 12 to Till date
Consultant

Based at NJ, designated as Consultant, and responsible for the following:

• Help with Retail EDW Data loads.
• Implement build, operate and run models.
• Knowledge of Netezza specific best practices
• Review Business requirements and advice technical feasibility.
• Provide operational support for business reports enable to gain in performance benefits of Netezza Appliance.
• Workload Management and capacity planning for Netezza system.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Have solid understanding of Distribution, Zone maps, MVIEWS and be able to use them appropriately
• Performance tuning of Netezza Sql queries and improve performance of the queries.
• Bulk insert data into Netezza using nzload interface.
• Effective use of optimizer settings in Netezza to bring in Optimum performance.
• Preparation of High level design document.

Environment:
OS: Unix, Windows
Platform: NPS 10200 series, Twinfin.

Confidential, Astra Zeneca, Inc. Sep 11 to Apr 12
Consultant

Based at Wilmington, DE, designated as Consultant, and responsible for the following:

• Help with Astra Zeneca EDW for interaction, Data loads.
• Create ETL workflows to load data into oracle from oracle environments.
• Develop outline prototypes for dashboards, propose architectural solution and create ARB deliverables.
• Provide operational support for business reports enable to gain in performance benefits of Netezza Appliance.
• Workload Management and capacity planning for Netezza system.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Performance tuning of Netezza Sql queries and improve performance of the queries.
• Bulk insert data into Netezza using nzload interface.
• Effective use of optimizer settings in Netezza to bring in Optimum performance.
• Preparation of High level design document.

As part of the Harmony Mobile POC project, Astra Zeneca, Inc. want to implement mobility of sales dashboard to PSS and DSM .PSS and DSM will be able to retrieve the call made by them and DSM can monitor the PSS ‘s progress under him.

Environment:
OS: Unix, Windows
ETL tool: Informatica 8.0
Platform: NPS 10200 series, Twinfin.

Employment History (responsibility wise):
Confidential, MedImmune, Inc. Jan 11 to Sep 11
Consultant

Based at India, Gaithersburg, MD, designated as Consultant, and responsible for the following:

• To make MedImmune, Inc DW feasible with Astra Zeneca EDW for interaction
• Create ETL workflows to load data into new DW from oracle systems.
• Develop outline prototypes for dashboards, propose architectural solution and create ARB deliverables.
• Optimizing reports execution time, bring in performance benefits of Netezza Appliance.
• Designing and coding the existing application to work on Netezza 4.6.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Performance tuning of Netezza Sql queries.
• Porting the application.
• Preparation of High level design document.
• Documenting the work done and ensuring that the requirements in the SOW are met.

As part of the Aggregate Spend project, MedImmune, Inc. spends are aggregated and data is flown to Astra Zeneca system. NZ load the data from various systems into NZ DW and coordinate with reporting team to develop customized reports.

Environment:
OS: Unix, Oracle
ETL tool: Informatica 8.0
Platform: NPS 10200 series.

Confidential, Jun 10 to Dec 10
Senior Consultant

Based at India, designated as Senior Consultant, and am responsible for the following:

• To coordinate with Astra Zeneca and external data vendor teams to setup Data Integration layers.
• Develop outline prototypes for dashboards, propose architectural solution and create ARB deliverables.
• Optimizing reports execution time, bring in performance benefits of Netezza Appliance.
• Designing and coding the existing application to work on Netezza.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Porting the application.
• Preparation of High level design document.
• Documenting the work done and ensuring that the requirements in the SOW are met.

As part of the FATR program, Astra Zeneca intends to build capability for flexible alignment and targeting processing. AZ launched the FATR (Flexible Alignment Targeting & Reporting) program and identified three major requirements for this program namely Flexible Alignment, Flexible Targeting, Period-based Reporting (PBR)

Environment:
OS: Unix
ETL tool: Informatica 8.6
Platform: NPS 10200 series.

Confidential, Ims Nov 09 to Jun 10
Senior Consultant

Based at India, designated as Senior Consultant, and am responsible for the following:

• Designing and coding the existing application to work on Netezza 4.6.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Porting the application.
• Preparation of High level design document.
• Working with the client for the integration of the various assets of IMS software on different countries.
• Unit testing, Bug fixing, Client Implementation and Interaction.
• Documenting the work done and ensuring that the requirements in the SOW are met.

The main objective of this project is to migrate the current data warehouse which is implemented in oracle to Netezza and gain performance benefits while running reports. Each country contains 4 common assets and country specific assets. For UK we had UK Rx, Sell in, Pharma trend, Hospital

Environment:
OS: Unix
ETL tool: Abinito
Platform: NPS 10400 series, Twinfin.

Confidential, Sep 09 to Nov 09
IT Analyst
Bank of America, USA

Based at India (Chennai), designated as Project lead, and was responsible for the following:

• As a lead developer maintained team members for project development.
• Assisted the team in converting Sqls written in sql and pl/sql to suit to Netezza environment.
• Created data model using ERWIN data modeler for Mortgage loan processing.
• Database design was done for payments and ledger creations.
• Database interaction was developed in NZSQL.
• Planning and designing the backend process.

This project was developed for our esteemed client BOA for their mortgage loan processing system. A new robust data model for their mortgage loan processing was developed which will bring in decrease in cycle times an d improve performance. The Financial reports which were running for long hours have been brought under good response time.

Environment: Unix, Shell scripting, Oracle 9i, Netezza 4.6.

Confidential, (India, US) Jun 05 to July 09

Technical lead
Sysco Release Phase 2, SYSCO Corporation (Dec 08 to Jul 09)

This project involves development of new ETLs and reports which was developed in the SYSCO re-distribution centre. We were migrating from current sourceDB2 to Netezza for better performance:

• Business objects reports development, independent unit testing and code reviews.
• Unit and Integration testing.
• Assistance in system testing.
• Release Management Activities.
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Created migration scripts to populate default data in newly created Database table.

Environment: Mid-Range Computers, RS240 Server, Informatica 8.1,Netezza.

Senior developer
Confidential, Jun08 to Dec 08

• Designated as a Senior developer, was responsible for the following:
• Understanding the overall architecture
• Analyzing feature sheets and preparing requirements
• Designing of various modules and design documents and implementing the design
• Preparing of test plans as per requirements
• Preparing and executing test cases to ensure that all requirements and functional specifications are tested and fulfilled
• Documenting user manuals, configuration and deployment guides.

The project involves replacing the existing financial reporting processes/systems with business objects reports.

Environment: Mid-Range Computers, RS240 Server, Informatica 8.1,Netezza.

Software Engineer
Confidential, Jan 2008 To Jun 2008

Designated as a Software Engineer, was responsible for the following:

• Requirement analysis.
• Planning and designing the server and client end.
• Developing the client end.
• Unit testing the client end.
• Bug fixing and fine-tuning the application.
• Client interaction.
• Ensuring a smooth release from time to time.

Testing the unix scripts which go to the production.
Creating 1000’s of sample orders and to check the stability of the system.
Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
Coordinating with onsite for clarifications, status update, issues/concerns
Unit and Integration testing.
Assisting the team with in post implementation validation(PIV)

Environment: Windows Workstation, Unix,Quick test professional.

Offshore Track Lead
Confidential, Jun 2007 To Dec 2007

Designated as a Offshore Track Lead, was responsible for the following:

• Analyzing client requirements.
• Preparing prototypes to check the feasibility of the requirements.
• Designing of modules and preparing design documents.
• Preparing of test plans as per requirements.
• Carrying out the implementation of the design.
• Preparing user manuals and configuration guides.
• Preparing area wise sales report for every month for their regions Pacbell, Snet, Swbell, Ait, NVbell.
• Preparing Adhoc reports as per client request.
• Coordinating with onsite for clarifications, status update, issues/concerns.

Environment: Windows Workstation, Unix,Business objects 6.5,Teradata.

Security Administrator
Confidential, Apr 2007 To Jun 2007

Designated as a Security Administrator, was responsible for the following:

• Helping the onsite DBA team for performance related issues.
• Running STATS pack
• Query tuning.
• Creating users and handling security related issues.
• Assigning roles and granting privileges.
• Developing stored procedures and triggers.

Environment: Windows Workstation, Unix,Oracle 9i,Toad,unix,Teradata

Software Engineer
Confidential, UK Jan 2007 To Mar 2007

Designated as a Software Engineer, was responsible for the following:

• Responsible on the business side at London in developing the Chart of Accounts. Also understanding the legacy system to enable the migration of data from the legacy warehouse to new merged warehouse system.
• The work involved putting in place maps for each reporting system to see the same data flow from GL to data warehouse and then from the warehouse to the reporting system.

Citi is a financial Institution with Investment, Retail & Wealth management business spread all over the world. The assignment involved migration from the legacy data warehouse and implementation of a new data warehouse using the people soft EPM tool in South America region. The reports triggered would cater to the needs of the US GAAP & management requirements.

Environment: PeopleSoft HRMS 8.8, SQR, Unix and Oracle 9i

Offshore Track Lead
Confidential, Meijer(US) Oct 2006 To Jan 2007

Based at India (Hyderabad) designated as a Offshore Track Lead, was responsible for the following:
• Preparation of Technical Design Specifications for Interfaces.
• Developing Custom Components, Pages and other online objects as per the requirements under Interfaces.
• Developing SQR reports based on the requirements.
• Unit and Integration testing
• Assistance in system testing
• Release Management Activities
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Coordinating with onsite for clarifications, status update, issues/concerns
• Coordinating with CCD and project team for connectivity and system H/W & S/W Installation related issues.

Meijer is a retail super center offering a full Grocery department plus over 40 other departments including Fashion, Automotive, Home Decor, Health and Beauty Care, Pharmacy, Electronics, Pet and more!

Environment: Windows Workstation,PeopleSoft HRMS 8.8, People Tools 8.45, SQR, and Oracle 9i

Test Engineer
Confidential, Jun 2006 To Sep 2006

The project involves testing of online pages, components developed in PeopleSoft and testing the functionality whether all the modules are in coordination and fixing any issues encountered. For maintenance requests and minor enhancements, the project will be executed with a relatively shorter requirements and design phase followed by build, testing, implementation and support.

• Tested whether the developed online pages and components for the client is working flawlessly and effectively.
• Preparation Test cases and plans for checking the effectiveness of the programs designed.
• Unit and Integration testing
• Assistance in system testing
• Release Management Activities

Aetna, Inc is an American diversified health-care benefits company, providing a range of traditional and consumer directed health care insurance products and related services, including medical, pharmacy, dental, behavioral health, group life, long-term care, and disability plans, and medical management capabilities.

Environment: Windows Workstation,SQR, Oracle, Unix Shell Scripts.

Data warehousing Consultant
Confidential, Japan Feb 2006 To Jun 2006

This project involved analyzing the existing data warehouse architecture and creating new model which will cater to the needs of Adidas DW team. We developed Data marts which will pick up data from data warehouse and provide it to reporting needs. We maintained quicker response time.
Responsibility :
• Preparation of Technical Design Specifications for Interfaces.
• Developing of DTS Packages and Stored Procedures for the ETL load process.
• Testing of the Packages and the Stored Procedures developed and identifying the defects.
• Data modeling and creating Data marts.
• Unit and Integration testing.
• Assistance in system testing.

Environment: Windows Workstation, Data Stage, Erwin Data modeler, SQL SERVER

Software Engineer
Confidential, Jun 2005 To Jan 2006

This project was to develop an optimal DW which suits according to Capital One. We analyzed the existing system which includes analysis of existing Data warehouse and Source Systems. We came up with a framework to design a data warehouse which will work effectively and have quicker turn around time for queries and there by increase the overall performance of the system.
Responsibility :
• Preparation of Technical Design Specifications for Interfaces.
• Unit and Integration testing
• Assistance in system testing
• Release Management Activities
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Coordinating with onsite for clarifications, status update, issues/concerns
• Coordinating with CCD and project team for connectivity and system H/W & S/W Installation related issues.
• Fixed bug in various modules.

Environment: Windows Workstation, Data Stage, Erwin Data modeler.

Software Engineer
Confidential, Jun 2004 to Jun 2005
Responsible for the daily activities associated with the management and administration of all network servers, operating systems, PC applications, and desktop maintenance. IT monitoring tasks such as security scan, patch management, virus detection.

• Analyzed and resolved second and/or third level problems for all network components; implementing, maintaining, and administering LAN and/or WAN systems.
• Proactively responded to incidents and service requests to fulfill service requirements within Service Level Agreements Operational Level Agreements, and managing activities using a variety of tools and reporting systems.
• Recommended system upgrades, patches, and new applications and equipment.
• Responsible for incident classification, resolution and closure.
• Developed and maintained a database for known user problems and solutions.
• Participated in UAT to ensure user satisfaction.
• Responsible for implementing the workstation security tool to maintain standardization of the Business client on all platforms.