Project Developer

Lakshminarayanan

Email: ******@*****.***

Phone: +1-830-***-****

Experience Summary

> Over 6+ years of experience in all phases of Software Development Life

Cycle (SDLC) that includes Requirement Gathering, Analysis and

Documentation, Design and Development, Integration, Deployment and

Testing, maintenance.

> Extensive knowledge in analysis design and development of database

applications in Client/Server application using Oracle 11g/10g/9i/8i,

SQL, PL/SQL and SQL*Loader.

> Extensive knowledge in analysis, design and development of Business

Objects Reports using SAP Business Objects XI R4.0, XI R3.1, XI R2

> Experience in leading and excellent management of team of two at

onsite and five at offshore.

> Experience in Unix Shell Scripting for automation process when needed.

> Experienced in design and building data marts

> Proficient in PL/SQL Programming - Stored Procedures, Functions,

Packages, Bulk Operations, SQL Optimization & tuning, Debugging,

Autonomous & Distributed Transactions, advanced PL/SQL concepts such

as ref cursors, row types, bulk operations, collections, Creation of

Oracle Objects - Tables, Views, Scheduled Materialized Views,

Triggers, Debugging skills,

> Proficient in SQL - Creating Synonyms, Database Links, Hints,

Performance Optimization, Debugging

> Proficiency in Oracle User Management - Create, Manage or delete user,

Create roles and assign role privileges

> Designed database schemas using the Entity Relationship Concept with

ER Diagrams and Normalization principles.

> Understanding on Oracle Data Dictionary, RDBMS Concepts and

Normalization & Optimization techniques

> Experience in Development, UAT and Production environment migration

and handling

> Strong interpersonal skills, excellent communication and presentation

skills, adaptable to various environments and a very good team player.

> Strong leadership skills in bringing team towards deliverable goals

and creating cohesive environment in order to work with various teams.

Technical Expertise

Reporting Tools SAP Business Objects XI R3.1/ R2, Universe Design Tool, WebI,

DeskI, Crystal Reports

Databases Oracle 11g/10g/9i/8i

Languages PL/SQL, SQL, Unix Shell Scripting

Operating Windows 7/Vista/XP, Sun Solaris, MS Share point

Environment

Versioning Tools Subversion (for code), VSS (for documents)

Development Tools Oracle PL/SQL Developer, PL/SQL Developer, Toad, MS Office

products

Education Summary

Bachelor of Technology in Information Technology

Amrita University, Coimbatore, India

Professional Experience

The Hartford Insurance Group, CT Apr 2014 to date

Database Administrator/Developer

The Hartford Insurance Group is one the oldest insurance company providing

auto, property and other commercial insurance to its customers.

Solution Environment:- Oracle 10g, MS .NET, MS Share point 2010

Project: ADAPT

Project is to create a common underwriter environment and connect various

tools used by underwriters to improve the efficiency of underwriters and

field agents.

Accomplishment: Implemented Major performance improvement strategies

targeting user reporting environment. Improved performance of existing

PL/SQL objects.

Responsibilities:

> Leading a team of two associates from onshore and five offshore.

> Involved in requirements gathering and documentation and other SDLC

process

> Participated in database design process and created tables, views and

materialized views needed by application.

> Created new packages having multiple functions and procedures to

support applications using advanced PL/SQL concepts such as Ref

Cursors, Collections, Nested Tables and User Defined Exceptions.

> Tuned or redesigned sql queries used in reports to improve response

time.

> Data model design discussions to identify new usage requirement.

> Identify database bottlenecks and designing improvement strategies

involving partitioning tables, modifying indexes, modifying table

spaces.

> Data model & Database version control, user control.

> Experience in Database analysis, backup and recovery process

> Worked in semi-agile environment.

> Strong knowledge in Database and ETL process

USAA, TX Nov - 12 to Mar - 14

BO Developer

USAA is the leading insurance and banking services provider to veterans of

United States of America.

Solution Environment: - SAP Business Objects XI R3.1/R4.0, DB2, MS Share

point 2010

Project: MSRP

Project is to create new application for monitoring and improving member

service representative (MSR) productivity.

Accomplishment: Created well optimized report with short response time

Responsibilities:

> Working in Modified Agile Environment

> Closely work with Business Team and User to gather requirements for

new reports

> Created Proof of Concepts or Prototypes for user presentation

> Designed BO universe using BO Universe Designer tool. Created

Hierarchies, complex objects using @Functions and Aggregates.

> Extensively worked on Web Intelligence Report Development. Used

multiple data sources, complex queries, conditional formatting.

> Applied filters in report to implement business logic.

> Involved in design and implement new reports with optimized

performance objectives.

> Report scheduling and monitoring. Report maintenance activities.

> Work with architect and provide data mart specific needs.

> Leading a team of two associates from onshore

> Adherence to delivery timelines and needs.

> Work with migration team on migration of reports to UAT & Production

environment

> Unit testing of reports after migration

> Providing data and queries details to users as an additional UAT

testing input.

System engineer - Tata Consultancy Services Ltd, India

Oct 2008 to Oct 2012

AOL Time Warner Bros. Jun - 10 to Oct - 12

PL/SQL Developer/BO Reports Developer

AOL Time Warner is one of the major Media Industry leader involving various

media services from Preproduction to Post Production.

Solution Environment: - SAP Business Objects Reporting, Oracle 10g, Siebel,

Teradata (Querying)

Project: Siebel Presidium

Project is to create new reports displaying executive summary of

promotional performance and designing database procedures needed to support

Siebel environment for achieving the goal.

Accomplishment: Designed optimized executive reports for senior management

combining heterogeneous data marts.

Responsibilities involved:

> Gather requirements from business users on new reports.

> Perform feasibility analysis on report design.

> Create prototype design of reports for user visualisation and

presentation.

> Create oracle procedures or functions to support Siebel environment

changes

> Prepare schedule for development and testing.

> Document requirements and create UAT test scenarios

> Perform unit testing and performance testing. Prepare environment for

UAT.

> Support UAT timeline with issue resolution

> Scheduling reports to run on daily or weekly or monthly basis.

> Migrate reports to production environment. Test report after

production move.

> Strategically tracking all job performance and creating weekly

reports.

AMG Media Groups May - 10 to May - 10

Database Designer

Client is providing solutions to media domain for content management and

authorization.

Solution Environment: - MySQL 5.1, Java

Project: AMG Portal

Project is focused migrating production data to intranet systems on daily

basis. Providing Intranet users with new application and improve production

application performance.

Accomplishment: Involved in design and implementation of database changes.

Implemented efficient data transfer strategy.

Responsibilities involved:

> Coordinating with onsite team with the database design requirements

and changes.

> Develop/design approaches to provide optimal performance for data

migration,

> Create new table design as per star schema.

> Create procedures for monthly statistics reporting.

> Developed scheduling procedures.

> Install database

> Rollout new database schema with necessary privileged users

> Support document for backup & restore process.

Boeing Feb - 09 to Apr - 10

Oracle PL/SQL Developer

Boeing is one of the largest commercial and military aircraft producer.

Solution Environment: - Oracle 10g, Java, Crystal Reports

Project Description: Project is focused on applying various system

enhancements, fixes, new features to existing system. Front end Java

application manages certain parts data handling and Oracle packages are

used to apply data transformations to improve system performance.

Responsibilities involved:

> Analysis of the specifications / requirements provided by the business

team.

> Provide estimate and impact analysis details to business users.

> Created design document and unit testing results document.

> Development of Backend schema Objects (Packages and Procedures).

> Developed PL/SQL, Triggers and Functions for implementing business

logic rules using advanced concepts such as ref cursors, row type

variables.

> Designed partitioned tables and designed procedures load data on

schedule basis.

> Designed scripts to automatically analyse tables on schedule basis.

> Automation scripts for new functionality testing.

> Creating new UNIX scripts for remote FTP file transfer.

> Creating new UNIX scripts to check the error while loading new data

and triggering error in case of failure.

> Experience in writing complex PL/SQL packages, triggers, procedures

and functions

> Managing Crystal Reports Server for testing reports from development

environment.

Contact this candidate