PROFILE:

• Software Engineer with 17 years of application development experience using PL/SQL (7 years), INFORMATICA (5 years), COGNOS (2 years), SQL (10 years), UNIX (10 years), Oracle Forms (3 years), Pro*C (5 years) and C++ (5 years)
• Worked as a Database Developer on various UNIX and Windows platforms. Includes Design, Data Modeling, Development, Data Conversion, Testing and implementation on large and complex Oracle (9i/10g) databases
• Strong skills in PL/SQL Packages, Functions, Stored Procedures and Database Triggers
• Knowledge of working with tools like Toad, SQL Developer, SQL Loader
• Expertise in using Oracle 9i, 10g and 11g databases
• Extensive experience in writing setup scripts to create Tables, Indexes, Views, Constraints, Packages, Procedures, Function and other database objects on production databases
• Extensive experience in developing Complex SQL Queries, Sub Queries, Nested /correlated sub queries
• Extensive experience in writing dynamic SQL statements using EXECUTE IMMEDIATE
• Good Experience in Analysis, Designing and Normalization of databases
• Extensive experience in software development and maintenance using ORACLE, SYBASE and INFORMIX
• Experience with design/development of Web and Windows Applications using ASP.NET, C#.NET, VB.NET
• Extensive knowledge in RDBMS using ADO.NET, ADO, T - SQL and PL/SQL
• Hands on experience on star schema modeling, snow-flake modeling, fact and dimensions tables, physical and logical data modeling using Erwin 3.5.2 and Erwin 4.1.2
• Implemented the RALPH KIMBALL design strategies on metadata
• On hands experience in System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System
• Utilized Informatica PowerCenter in monitoring ETL processes
• Strong interface Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Administrator functions of Repository Manager
• Strong team player with excellent interpersonal communication skills

SOFTWARE SKILLS:

LANGUAGES: SSIS, Hadoop, Python, PL/SQL, SQL, C, C++, UNIX Shell Scripting, QuickC, JavaFortran, Pascal, Pro*C, C#, Perl, J2EE, Visual Basic

RDBMS: INFORMIX, ORACLE, SQL SERVER, INGRES, DB2, SYBASE, TERADATA

DATABASE TOOLS: SQL*PLUS, SQL*Loader, TOAD, Crystal Reports, Oracle Forms, Informatica

HARDWARE/SYSTEMS: SUN/SPARC, IBM-PC, TEKTRONIX, MACINTOSH, UNIX, Cognos, AUTOSYS

SUN OS 4.1, SCO: UNIX, SOLARIS, MS-WINDOWS, AIX

WEB DEVELOPMENT: HTML, Java Script, XML, ASP.NET, VBScript 5

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Developer

Responsibilities:

• Loaded data from several sources into target tables using Informatica
• Generated ASCII files from tables using Informatica for the purpose of analysis
• Used Workflow Manager/Monitor for creating and monitoring workflows and worklets
• Improved the session performance by pipeline partitioning
• Extensively used mapping parameters, mapping variables and parameter files
• Used debugger to test the mapping and fixed the bugs
• Gathered requirements and designed Informatica data warehouse
• Used ZENA for scheduling of processes

Environment: Teradata SQL Assistant, SQL Developer, ORACLE 11g, AIX, Informatica Power Center 9.0, ZENA

Sr. Developer

Confidential

Responsibilities:

• Analyzed, designed and developed PL/SQL code
• Development/review of Database Design and objects (Functions, Procedures, Packages, Triggers etc.)
• Loaded data from several sources into target tables using Informatica
• Designed and validated ETL processes in Informatica
• Used transformations like Aggregators, Sorter, lookups to load data from SQL Server into Oracle
• Performed maintenance for applications in JSP and Servlets
• Improved the session performance by pipeline partitioning
• Loaded csv files from HDFS into SPARK system
• Extensive experience in Hive, Impala, SPARK, Scala and Python

Environment: SQL*Plus, SQL*Loader, PL/SQL, SQL Developer, ORACLE 11g, SunOS, Informatica PowerCenter 9.5.1, Crystal Reports (SAP Business Objects), Hadoop

Confidential

Sr. Application Software Developer

Responsibilities:

• Analyzed, designed and developed PL/SQL code
• Created SQL*Loader and SHELL Scripts
• Created data feeds to generate reports and send them to end clients
• Designing and developing Schemas using Entity Relationships, Normalizing the relations, creating Tables, Views, Indexes and Sequences and coding
• Optimized the queries and database using SQL Hints and Explain Plan
• Loaded data from several sources into target tables using Informatica
• Designed and validated ETL processes in Informatica
• Used debugger to test the mapping and fixed the bugs
• Generated reports using Query studio, Report studio, Transformer, Framework Manager and Analysis Studio

Environment: SQL*Plus, SQL*Loader, PL/SQL, Toad, ORACLE, HP-UX, Oracle Forms Developer, Informatica PowerCenter 9, Cognos

Sr. Software Engineer

Confidential

Responsibilities:

• Developed several packages, standalone stored procedures and functions for various requirements from business.
• Analyzed use cases, created design and implemented in PL/SQL
• Unit Testing of PL/SQL Code. Involved in Writing the Test plan
• Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control
• Development and review of Database Design and objects (Functions, Procedures, Packages, Triggers etc.)
• Extracted data from flat files and loaded into Oracle database using mappings and workflow manager
• Performance tuning of mapping and ETL processes, as required
• Gathered requirements and designed Informatica data warehouse
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task.

Environment: PL/SQL, ORACLE 10g, Toad, ASP, VBScript, WINDOWS XP, Pro*C, XML, VB, AIX, SQL*PLUS, HTML, Perl, Informatica PowerCenter 8, SSIS, SSRS

Developer

Confidential

Responsibilities:

• The task involved was performing development and maintenance for a similar system in ‘ C++ ’
• Extensive coding done in ESQL/C
• Review, test, debug and fix Pro*C programs
• Performed enhancements for applications in ‘C’ and message queues