SUMMARY

• 7+ years of total IT experience in software development.
• Experience in full Software Development Life Cycle (SDLC) and methodologies, along with Quality Assurance (QA) processes and control.
• Extensive experience in analysis, developing and maintaining OLTP and OLAP applications.
• Substantial development experience in PL/SQL and optimizing and performance tuning of application code.
• Extensive experience in ETL development - Informatica and tuning existing mappings/sessions to achieve optimal efficiency and performance.
• Strong DW Concepts - Star & Snowflake Schema. Dimensional Modeling.
• Hands-on UNIX Shell Scripting Experience.
• Proficient in Agile and Waterfall Software Development methodologies.
• Experience in gathering user requirements, preparing and analyzing Business Requirement Documents (BRD), Functional Requirement Document (FRD), and propose changes as per various internal and external requirements gathered for process improvement.
• Able to build strong relationships with staff, clients and vendors given strong commitment, strong negotiation skills and meticulous planning.

TECHNICAL SKILLS

Platforms: Windows (98/2000/XP/VISTA), Mac, Solaris, Linux, UNIX

RDBMS: Oracle 11g, SQL Server 2012, Netezza

ETL Tool: Informatica 9.6

Programming Languages: PL/SQL, T-SQL, UNIX Shell Scripting, C, C++

Testing/Integration Tools: HP Quality Central, Microsoft- Team Foundation Server, Toad, Oracle SQL Developer

Other Tools: CVS(source control), Perforce, Autosys v8/v9/r11

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

ETL & DB Developer/Consultant

Responsibilities:

• Collaborate closely with business analyst and development manager to understand requirement, analyze source data and build source-target mapping document for new ETL development.
• Prepare business requirement, functional requirement & technical design documents, along with workflow documentation and user acceptance test plans.
• Use extensive transformations - Connected/Un-Connected Lookup; Aggregator; Expression; Router; Update Strategy; Filter; External Procedure; Joiner; Sorter; etc. and adhere to best practices to achieve optimal performance at source, target, mapping level.
• Build complex Informatica mappings ranging from high performance multi-threaded (pipeline) loads to custom business logic implementations (normalized load, slowly changing dimensions, etc.)
• Hands-on PL/SQL development for complex transformational logic - Package/Procedure/Functions, Cursors, Collections, Analytical Function, Partitioning, etc.
• Performances Tuning & recommending tuning strategies in Informatica Mappings, Sessions, Workflows and sending automated email on errors, failures, success of the sessions/workflows.
• Leverage Oracle PL/SQL wherever necessary to develop end to end extract & load mechanism and ensuring optimal performance is achieved.
• Schedule Batch jobs (Shell Scripts, Informatica Workflows and SQL Scripts) using Autosys Scheduling Tool.
• Create test cases, and work with QA Team to complete testing cycle. Review test results and assist in production deployment.
• Post go-live, work on development enhancement requests.

Technology - Informatica 9.6, Oracle 11, Oracle PL/SQL, UNIX Shell Scripting, Autosys r11

Confidential, Ridgefield, CT

ETL & DB Developer/Consultant

Responsibilities:

• Collaborate closely with business analyst and development manager to understand requirement, analyze source data and build source-target mapping document for new ETL development.
• Prepare business requirement, functional requirement & technical design documents, along with workflow documentation and user acceptance test plans.
• Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL processes, documentation.
• Build complex Informatica mappings ranging from high performance multi-threaded (pipeline) loads to custom business logic implementations (normalized load, slowly changing dimensions, etc.)
• Well conversed with using debugger and also investigating errors using Session/Workflow Logs, Reject Files, etc.
• Hands-on PL/SQL development for complex transformational logic - Package/Procedure/Functions, Cursors, Collections, Analytical Function, Partitioning, etc.
• Perform code reviews to validate business logic, use of best practices and ensure performance optimization techniques have been utilized.
• Use Shell Scripting to manipulate data files pre/post load, Informatica Parameter Files.
• Provide regular project updates and communicate issues, risks and concerns proactively to peers, development and project managers and QA support team.

Technology - Informatica 9.6, Oracle 11, Oracle PL/SQL, UNIX Shell Scripting

Confidential, NY, NY

ETL & DB Developer/Consultant

Responsibilities:

• Collaborate closely with business analyst and technical architects for new development and enhancement requirements.
• Prepare business requirement, functional requirement & technical design documents, along with workflow documentation and user acceptance test plans.
• Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL processes, documentation.
• Monitor ETL processes performance in data warehouse.
• Hands-on PL/SQL development for complex transformational logic - Package/Procedure/Functions, Cursors, Collections, Analytical Function, Partitioning, etc.
• Build Shell Scripts to execute Informatica workflow, run PL/SQL via Autosys and other job orchestrating purposes.
• Use Shell Scripting to manipulate data files pre/post load.
• Code review and deployment, and taking bottom line of offshore developed code.
• Provide regular project updates and communicate issues, risks and concerns proactively to Information Analysts and Architects

Technology - Informatica 9.1, Oracle 10/11, Oracle PL/SQL, UNIX Shell Scripting, Autosys

Confidential, Redmond, WA

Software Engineer

Responsibilities:

• Collaborate closely with onshore technical leads to gather new development and enhancement requirements.
• Prepare business requirement, functional requirement & technical design documents, along with workflow documentation and user acceptance test plans.
• Hands on C/C++ development to implement new features in Windows Mobile.
• Responsible for documenting Functional/Non-Functional testing requirements for QA team.
• Manage and stream line defect logging, analysis and resolution process in MS-TFS.
• Perform unit testing, integration testing and troubleshoot/analyze/resolve system bug identified by users and QA team.
• Provide technical support, solutions and guidance to team members.
• Assist offshore project manager to track work effort, delivery timelines, cost & resource utilization.

Technology - C/C++, WinCE, Agile Development, MS-Team Foundation Server

Confidential

Software Engineer

Responsibilities:

• Hands on C/C++ development.
• Perform unit testing, integration testing and troubleshoot/analyze/resolve system bug identified by users and QA team.
• Provide technical support, solutions and guidance to team members.

Technology - VC++, Xcode, OpenGL, C++, Objective-C, XSI, XSI sdk