PROFESSIONAL SUMMARY:

• 10 years of IT experience in software development life cycle (SDLC) involving multi - tiered, client-server, scalable web-based projects
• In depth knowledge of Agile, TDD, Continuous integration, Unit & Integration testing.
• Excellent experience in Data Modeling, Advanced PL/SQL scripting and SQL performance & tuning, Data Warehousing, Exposure of Java.
• Experience with LINUX/UNIX Shell, PIG, Perl scripting.
• Proficient in COBOL I/II, JCLS, VSAM, MVS, CICS, batch jobs and IBM utilities.
• Passionate problem solver, analytical and leadership skills with extensive experience in analysis, design interfacing and database application development.
• Collaborative, flexible and capable of wearing multiple hats like Lead, Developer, Scrum-master, Project Coordinator, Analyst and Admin.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux Enterprise (3-6), UNIX, Solaris, IBM OS/390, Windows (Vista, XP, NT, 95, 98, 2000), MS DOS

RDBMS: Oracle (8i, 9i, 10g, 11g), DB2 OS/390, SQL Server 2000 (DTS Packages), MS Access

Programming Language: PL/SQL, MySQL, DB2 SQL, JAVA, Visual Basic 6.0, 7.x, IBM Mainframe: COBOL I/II, CICS, TSO/ISPF, VSAM, MVS

Scripting: PERL, Unix Shell Scripts, PIG

CRM: Siebel (6,7.x, 8.0, HTIM), Siebel Tools Configuration, EIM, Siebel Scripting, Server Administration, Business Services, Siebel Workflow, Integration Objects, Siebel Analytics, Clarify

Development Environment: Eclipse, Net Beans, Maven

Tools/Utilities: DB2 Command Center, TOAD and SQL Developer, SQL PLUS, Bugzilla, Quest, Test Manager, Hudson/Jenkins

Version Control Tools: CVS, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Senor Technical

Responsibilities:

• Applied Agile/Scrum practice in our team
• Functioned as DB SME.
• Coordinated POW data warehouse decommission among all Display Consumers and managed communication, planning and execution of the retirement initiative.
• Acted as technical support of SOO team for US Display consumers during SOO Adoption project.
• Developed, refactored and maintained different Ad Latency scripts (written in PERL, SHELL, SQL and PIG) to measure latency of delivering Ads in Confidential mail home page and generate reports to users for data analysis and measurement.
• Investigated production issues and worked with other teams in fixing and resolving issues.
• Functioned as Team Lead for DBQA team.
• Managed test plans and test cases coding and execution, ticket verifications, team coordination and support on different APT application releases.
• Detected and reported critical bugs during development and testing phase.
• Supported Change Management Requests (CMRs), dry runs, and Production Launches (APT RELEASES 1.7/1.8/1.9/2.0 )
• Performed smoke, functional, integration, regression and end-to-end testing of different DB builds on all build run way: testing, integration, staging and production environments.
• Improved database testing by automating all manual database verification including smoke, regression and integration tests in HUDSON build farm.
• Trained newly-hired colleagues for knowledge sharing

Platform: Oracle 10g/11g, SQL Plus, TOAD, SQL Developer, Hadoop, Linux, Win XP

Confidential

Siebel Technical Consultant

Responsibilities:

• Established measurable performance requirements
• Designed sub-system components: screens, views, applets, business components and business objects, and fields.
• Identified architecture, major sub-system and interfaces
• Incorporated requirements for legacy systems integration and security requirements into design
• Analyzed requirements and define scope of work
• Created testing prototypes
• Provided technical assistance and support to users during user testing and after production implementation phases.

Platform: Siebel 7.5.2 /8.0 (Tools/Client), Siebel Partner Portal, Clarify, Oracle 8i/9i, SQL Plus, Win XP

Confidential

Siebel Technical Consultant

Responsibilities:

• Worked with business people and technical group for data and functionality quality assurance
• Configured Assignment Manager, Workflows, configuration files (EIM and AICD), views and applets, fields and pre-built queries.
• Developed Assignment Rules, and Workflow policies as per business requirement document
• Performed Data Administration task: data set up and data definition in Siebel
• Migrated large number of data from legacy application to Siebel
• Set up test scripts and test cases
• Provided technical support on production implementation

Platform: Siebel 7.5.2 /8.0 (Tools/Client), Siebel Partner Portal, Clarify, Oracle 8i/9i, SQL Plus, Win XP

Confidential

Siebel Technical Team Lead, Analyst, Developer

Responsibilities:

• Handled Siebel and COBOL DB2 programmers.
• Worked with business people for project analysis and requirement preparation.
• Engaged in data analysis and wrote program specifications.
• Developed COBOL DB2 batch programs for ETL (Extraction, Transformation and Load of DATA).
• Developed JCLs, procedures, parameters and data flow.
• Revised existing COBOL DB2 batch programs ETL.
• Involved in data modeling tasks.
• Configured Siebel objects using Siebel tools.
• Developed SQL scripts for data extraction, analysis, transformation and loading.
• Performed system unit testing, problem investigation and program debugging.
• Coordinated with users, auditors, production engineers and computer operations personnel regarding the project's implementation.
• Provided support during the production implementation.