Arun - 09

ARUN AGGARWAL, PMP ****.********@*****.*** 949-***-****

What I’m looking for:

To obtain a senior Developer / team lead position that utilizes my hands on expertise in oracle databases and experience leading software development teams on software projects from conception through implementation and maintenance.

What I bring onboard:

• Expert in database technologies and solid hands-on with Oracle and SQL Server.

• Extensive hands-on coding expertise in SQL, PL/SQL

• Hand-on experience with Java, JDBC, XML technologies

• 12 years of experience with database design, administration and development.

• Experience managing and working with cross-technology teams with applications in ASP .NET / SQL Server and Java J2EE / Oracle environments.

• Experienced software development project manager skilled in gathering and documenting requirements, developing project plans, managing and tracking project execution, designing prototypes and assisting with usability testing, developing and executing test scenarios.

• Working with organizations and projects complying with regulatory requirements including the HIPPA, PCI and Sox

• Experience building, deploying and supporting applications in SaaS (software as a service) environment.

• Skilled in communicating with internal departments and senior management, assisting sales with pre-sales presentation and product demonstrations, and managing customer expectations.

• Experience managing departmental budgets, handling performance reviews and clients SLA’s

• Known for building strong business relationships with both clients and vendors.

• Ability to prioritize effectively, multi-task and achieve objectives within time and budget constraints

Education & Certifications:

• Masters in Computer Applications, 1997 (Maharishi Dayanand University, Rohtak, India)

• PMP - Project Manage Professional (Certification from PMI)

• Certificate Course in Business Intelligence & Data Warehousing, 2007 (University of California Irvine, CA)

• 7 Effective Habits of Good Manager – Franklin Covey

Skills & Knowledge:

• Programming / Scripting: SQL, PL/SQL, T-SQL, Linux Shell, Java / J2EE, JDBC, XML

• Databases: Oracle 8i, 9i, 10g, SQL Server 2000 & 2005, Sybase, DB2

• Middleware: Working Knowledge of Oracle Applications Server, Tomcat, Apache, JBOSS

• System Design / Development Methodologies: Extreme Programming (XP), Agile Development , Waterfall Model, OOAD, ER Modeling, Data Warehouse Design

• Design - Management Tools: ERWin, DBArtisan, TOAD

• Office / Project Software: Microsoft Office, Microsoft Project, Visio

Ambassadors LLC, Newport Beach, CA,

(August 2004 – December 2008)

Ambassadors: A Full-Service Solutions provider to organizations for Meetings and Incentives Travel, Housing, Registration & Event Management. Working for clients in technology, automotive and business consulting domains.

Providing logistics support for event registration and hotel block management, Ambassadors has a suite of applications that were used in-house as well as licensed to other companies.

Core of that suite were GEM – Global Events Management an event management tool that provided customized workflows for budget tracking, event registration, communication, venue scheduling. This application was developed in Java – J2EE, with hibernate and struts framework and using Oracle as the backend

Another important part of that suite was a hotel room block management application and a client facing customized web application where attendees can pick can book their hotel rooms. This application was developed using SQL Server, ASP .NET and Cold Fusion

Engineering Manager and Database Engineer (March 2007 – December 2008)

• Hands-On with Oracle and SQL Server databases, extensive programming in PL/SQL. Both the business logic and ETL coding

• XML data feeds management, working with web services and JDBC

• Data base modeling and design

• Managed teams working in .NET and Java development environments, based both on-site and in remote offices.

• Overseeing design, development and database modeling teams, change management, reporting progress to clients, and resolving issues to complete multiple projects on-time and on-budget.

• Responsible for all phases of technical consulting business operation. Developed and executed technical project plans for simultaneous client efforts.

• Strategic business planning, implementation and business management experience.

• Define SLA contracts and making sure the applications adhere to them

• Managing business operations including client management, budget responsibilities, expense tracking, recruiting, resource acquisition and complete program management activities while supporting multiple customers.

• Additional job responsibilities include conducting meetings with third party resource providers, understanding data capture and business processes, disaster recovery planning and implementation

• Other responsibilities include estimating project time on tasks, schedule and costs, measuring and monitoring results to deliverables, risk and issue identification, change management and providing training as well as documentation for end users.

Database Administrator & Architect (August 2004 – February 2007)

• Development and coding of core business logic in stored procedures and triggers using PL/SQL, TSQL and java stored procedures

• XML data feeds management, working with web services and JDBC

• Data base modeling and design

• Database administration duties for multiple applications / servers Worked with project manager and director to gather business and functional requirements to create a specification which defined how customers should interact with each component and how business units must support the workflows

• Working with Oracle and SQL Server databases

• Implemented a Cost effective Disaster Recovery plan for databases at a remote co-location

Keenan and Associates, Torrance, CA

(July 2002 – July 2004)

KA is one of the largest privately held third party insurance brokerage firm in USA, providing superior insurance products and services.

Sr. Software Engineer (July 2002 – July 2004)

• Development and coding of core business logic in stored procedures and triggers using PL/SQL.

• Project timeline and requirements management

• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.

• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).

• Created test cases and test scripts.

• Ensured all artifacts complied with corporate SDLC Policies and guidelines.

• Interaction with internal stakeholders

• Coding using various Oracle development tools (forms, reports)

• Performance review for team members

• Highlight Project - SERP (Supplemental Employee Retirement Plan), is a tool to help Keenan in generating proposals for school districts, that helps them decide and manage Employee Retirement

Aithent Inc., New Delhi, India

(November 1998 – April 2002)

Based in New York, NY, Aithent is a SEI CMM Level 5 software firm; that delivers innovative software solutions for complex business processes to leading organizations worldwide

Team Lead - Databases (November 1998 – May 2002)

• Manage Database team resource allocation to various projects

• Development and coding of core business logic in stored procedures and triggers using PL/SQL, TSQL and java stored procedures

• Provide 24 * 7 support whenever required by client deployments

• Act as Issue escalation point

• Participate in core design team meetings of application architecture

• Technical team leader for all issues related to various database platforms – Oracle , SQL Server, Sybase

• Supported high-profile client projects with multi-million dollar funding

• WMS (Workflow Management), is a tool developed by the Organization to manage automated workflows, where in activities are defined, workflows are set and then a constant monitoring is done and actions are performed

• LION (License Information Online) is a web-based application for NYSID, which is intended to provide online licensing services to the Insurance sector. It has various entities such as the insurance companies, the insurance agents, and schools providing insurance education.

Contact this candidate