OBJECTIVE

• To pursue a career as a Senior IT executive based on 12 years of experience in the field of I.T. in a growth oriented organization that will offer career development and advancement opportunities utilizing my strong technical skills.

SUMMARY

• Experience leading team for process on critical projects with tight deadlines. Have a successful track record of delivering high quality deliverables.
• Strong Project management, Release Management, ETL, Database Development, Data Warehousing and Software Engineering background.
• Strong development and testing skills especially in Pentaho Data Integrator( kettle) Informatica, Oracle, SQL Server database, Sybase, shell scripting, perl scripting and backend objects.
• Extensively worked on software agile technology.
• 12 Years of IT experience in management and development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica PowerCenter 8.1/7.1/6.2..
• Proven track record in planning, building, and managing successful large - scale Data Warehouse and decision support systems. Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Extensively worked on databases like Oracle 10g/9i/8i, Sybase, DB-2.
• Proficient in coding using SQL, PL/SQL, iSQPlus, TOAD, Rapid SQL procedures/functions, packages, triggers, Explain Plan, Constraints, Triggers, Indexes, Views, Inline Views, Database Links, Export/Import Utilities.
• Experience working with XML schema.
• Experience in writing UNIX shell scripts and PERL scripts to support and automate the ETL process.
• Experience scheduling jobs using Autosys, Control M and informatica.
• Profound Knowledge of SDLC and STLC. ( Agile, Waterfall) Experience in developing Test cases, developing Test scripts and analyzing bugs. Knowledge in Manual, Black Box Testing.
• Experience on automation builds using Rational Build Forge, Anthill Pro, Udeploy, Hudson, Jenkins, ANT and GANT.
• Good communication, client interaction, problem solving and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.1/7.1 (Repository Manager, Designer, Workflow Monitor, Workflow Manager, Power Mart 5.x, Star & Snowflake Schema, Pentaho Data Integrator( PDI, Kettle 3.5).

Databases: Oracle 10g, Oracle 9i/8i, Sybase, MS SQL Server 2000/7.0., Microsoft SQL Server 2005/ 2008/2015

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.0/3.5.2/2. x. OLAP

Miscellaneous Tools: TOAD, Rapid SQL,SQL*Plus, SQL Server Query Analyzer, SQL Server Enterprise Manager, Autosys, Asset control Desktop 3.1,Quality Center, Humming Bird, Alarm Point, Service Center, Pace, Result Space, Scopemeter, RTC, Control M, MS Visio, MS Project, Microsoft SQL Server Studio

General Software & Programming: C, C++, JAVA, Unix, Shell scripting, perl, SQL, PL/SQL, Excel, Word, PowerPoint, Microsoft Project, Microsoft Visio, HTML, TCP/IP, Networking

Operating Systems: Windows 7, 2000/98/XP/NT, UNIX (SUN SOLARIS and AIX), LINUX

Build/Release management software: IBM Rational Clear case, IBM Rational Software Build Forge, Ant and Gant, GITHUB, Hudson, Jenkins, Anthill Pro, Udeploy

PROFESSIONAL EXPERIENCE

Confidential

Technical Implementation Manager

RESPONSIBILITIES:

• Manage a small team of developers
• Participate in all aspects of the software life-cycle, including: definition, design, implementation, testing and delivery.
• Contribute to the design and approach for solving challenging problems aligned with HA/DR set up and implement automated build and deploy process
• Extensively worked on leading, Design and architect kettle (Pantaho Data Integrator) based projects.
• Delivered initiatives on-time and within budget using an agile development methodology and Managed project change control process
• Designed Build and Release Management strategy for interface team.
• Designed and developed multiple interfaces for client.
• Analyzed and Requested hardware required for project.
• Work with Client directly to collect project requirement.
• Created ETL loader using Perl, kettle (PDI) and SQL Server database.

Environment: SQL Server 2008, Kettle (PDI) 3.5, Windows batch scripts

Confidential, Merrimack, NH

System Project Manager

RESPONSIBILITIES:

• Delivered initiatives on-time and within budget using an agile development methodology
• Managed project change control process
• Developed strong, collaborative relationships with key IT and business partners
• Prepared for, facilitated, executed, and followed through on various project meetings
• Designed Environment Strategy for SMSV projects.
• Designed and Developed Polar lake loader to load Bloomberg and vendors.
• Designed Release Management Strategy for SMSV project.
• Analyzed and Requested hardware required for project.
• Work with Business Analyst to collect project requirement.
• Created loaders using Informatica and Polar Lake.

Environment: PolarLake, Java, Spring Batch, TCS, Oracle, XML, UNIX, Informatica 9.1, Oracle 11.2

Confidential, Merrimack, NH

Senior Software Engineer/Release Manager

RESPONSIBILITIES:

• Lead and managed Infrastructure team.
• Developed strong, collaborative relationships with key IT and business partners major and minor releases, patches and/or critical fixes (including versioning and code deployment)
• Plans for external release, identifying key activities leading up to, during and after releases to higher environments
• Responsible for writing, maintaining or testing deployment scripts and/or installation and configuration processes
• Optimizes deployment processes to minimize manual intervention, minimizing deployment risks and timeframes
• Developed an automated, continuous, build process that reviews the source code, identifies build errors and notifies appropriate development team to expedite/facilitate synchronization to the latest positive build.
• Responsible for assisting development team to prototype build and release automation tools.
• Developed Data Acquisition loaders using Polar Lake Framework.
• Extensively worked on XML schema.
• Developed Informatica loaders to load Bloomberg vendors.
• Designed loaders for Markit, PDS, GICS and ratings vendors.

Environment: PolarLake, Java, Spring Batch, TCS, Oracle, XML, UNIX, Informatica 9.1, Oracle 11.2

Confidential, Merrimack, NH

Senior Database Developer

RESPONSIBILITIES:

• Worked with BA to analyze business requirements.
• Created architectural design for applications.
• Lead and managed project team.
• Worked with GIM (GLOBAL INVESTOR MANAGEMENT) team for understanding GIM product.
• Analyze PENSETS - grouping of logical transaction used by GIM product.
• Used transformation server to track real time trading data.
• Extensively worked on infomatica to implement business logic for Holdings Hub.
• Studied the existing OLTP system(s) and Created dimensions and star schema representation for the data mart.
• Analyzed and created Facts, Dimension tables.
• Extensively worked on the Database partition for warehouse schema, Cursors, Triggers, Functions and Database Constraints.
• Developed PL/SQL code using the Business specifications.
• Worked with QA team and Business team in functional testing.
• Provided on call support for application.

Environment: Informatica, Oracle, Perl Script, Shell Script, Autosys, Informatica 8.1, Oracle 10g

Confidential, Merrimack, NH

Senior Database Developer

Responsibilities:

• Single point of contact for design and development for IDW.
• Involved in creating technical documentation for the project.
• Designed procedures for getting data from multiple systems to Data Warehousing system. The data was standardized to accommodate new pyramis trading data.
• Used transformation server to track real time trading data.
• Designed stored procedures for loading data from transformation server to investor data warehouse. Extensively worked on the Database Cursors, Triggers, Functions and Database Constraints.
• Analyzed existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.
• Used Sybase stored procedures extraction, transformation and loading data from heterogeneous source systems
• Designed logic for roll marker to load all trades to ware house before deleting any trade for that business day.
• Designed PERL scripts to call Sybase database stored procedures.
• Designed, Developed, Reengineered and fine-tuned Sybase Stored Procedures and triggers.

Environment: Informatica 8.1, Sybase, Perl Script, Shell Script, Autosys

Confidential, Merrimack, NH

Senior Database Developer

Responsibilities:

• Involved in requirements gathering.
• Design Informatica mappings and workflow for projects and PL/SQL stored procedures.
• Provided QA support and bug fixes.
• Worked on install script for database objects, shell scripts, informatica and autosys.

Environment: Informatica 7.1, Oracle 10g, Shell Script, Autosys

Confidential

Lecturer/Developer

Responsibilities:

• Hands on lab and project experience for Database SQL and PL/SQL, Programming C, C++ and Java.
• Implementing University research projects
• Actively leading class discussions and encouraging debate.
• Responsible for preparing learning material for courses and devising relevant practical activities.

Environment: s: Oracle 9i, Informatica 7.1