We provide IT Staff Augmentation Services!

Powerbuilder Developer Resume Profile

5.00/5 (Submit Your Rating)

Experience Highlights

  • Over 18 years of Industry experience in software development, Data warehouse, Architecture, Technology Leadership, and Project management.
  • Responsible to develop, maintain and manage the application development process.
  • Established and managed Data Integration COE and Shared Services.
  • Lead strategic Data Warehouse, Business Intelligence, and Development projects. Coordinated project status meetings, and resources planning, in all phases of data warehouses and SDLC.
  • Experience in solutions practice using Kimball, Inman, and hybrid architecture, Transactional and Dimensional data modeling OLTP, ETL, BI, Star Schema, and Snowflake schema.
  • Good understanding of the Financial Services Industry
  • Makes project related decisions and provides input into decisions impacting the broader team.
  • Subject matter expert across multiple technologies, architectures, and business applications with special emphasis on application/systems inter-dependencies.
  • Business/Application Knowledge demonstrates deep knowledge/expertise in multiple and inter-dependent business applications and processes.
  • Partner with development teams and clients and provide leadership in matrixed environment.
  • Expert in vendor relationship management.

Areas of Expertise

  • ETL Tools - Informatica PowerCenter 9.1, PowerEcxhange DB2-Zos, Oracle, MS SQL Server, MQ, JMS , Data Transformation, MetaData Manager
  • Big Data - Hortonworks Data Platform 2.0, 1.2, Hadoop, Hive, Pig, Sqoop
  • Pentaho Pentaho Data Integration 4.4, Business Analytics
  • Data Virtualization Composite 3.1
  • EAI - Tibco Business Works 5.0
  • Data Quality Trillium 9
  • Metadata manager MetaIntegration 5.1
  • BI Business Objects, Cognos
  • Databases - Oracle 11G, Exadata, Sybase ASE 4.9-12.5, MS SQL Server, DB2 UDB, DB2 Zos
  • Power Builder, DB Artisan, ER Studio, ERWin
  • Unix Solaris/AIX/HP-UX , C, Unix shell script, Perl, Autosys, Harvest, VSS
  • Java, XML ,HTML, VB 4.0-6.0, ASP, .net, Power Builder, Gupta SQL
  • EAGLE PACE, EAGLE Performance

Professional Experience

Confidential

Technology Manager Managing Director

  • Managed global team of resources/developers both onsite and off-shore.
  • Implemented multitenant model for the Hadoop Eco system across the Enterprise.
  • In-depth knowledge in Big Data solutions and Hadoop ecosystem.
  • Architected and executed the successful completion of the FX execution Quality Analysis to identify various Trade patterns and performed comparative analysis against various Tick level data.
  • Led the Global Markets - FX Valuation Rate Analysis to provide a self-serve ad-hoc tool to slice and dice the FX data which provides various insights such as Net profit/loss, Total volume, Rates comparison etc.
  • Documented various Architectural Design Patterns.
  • Evaluated various technologies and conducted POC in the Big Data space.
  • Established a strategy for data archival leveraging Big Data ecosystem.
  • Designed the Data Lake Architecture as a centralized Data Hub to deliver data on demand to downstream applications. This is very effective in terms of storage cost and data access.
  • Implemented Data Governance Strategy for the Data Lake.
  • Currently executing Information Security Analytics initiative to detect anomalies, to get insight into various logs such as Proxy, Active Directory, Email etc.
  • Partnered with the Senior Business leaders in successfully executing strategic initiatives.
  • Worked directly with the Business stakeholders to address various ad hoc requests and to get more insights in the transactional trade data etc.
  • Mentored various members of my team, cross-team mentoring and college interns.
  • Environment: Hortoworks Data Platform 1.2/2.1.2, Hadoop, HDFS, Sqoop, Hive, HBase, Flume, Talend, 5.4, Teradata, Vertica, Infobright, Informatica PowerCenter 9.5, Tableau, Pentaho Kettle, Platfora, Splunk, Kafka, Storm, Python

Confidential

Technology Manager

  • Received the best implementation award for Custody information warehouse.
  • Managed a highly performing team, attracted top talent, and actively supported innovative, faster and cost effective solutions.
  • Expert in vendor management.
  • Worked as a Lead liaison between business and IT.
  • Managed a team of resources/developers both onsite and off-shore.
  • Provided Architecture guidance built the body of knowledge around PowerCenter, PowerExchange Oracle, DB2 zos , Data Transformation B2BDT .
  • Designed and Implemented Enterprise Shared Services and Center of Excellence for Data Integration from scratch.
  • Reviewed BRD's, HLD LLD designs documents, tracking of issues, staffing assignments and coordination of the team.
  • Created and evaluated critical information from multiple sources ODS , reconcile conflicts, decompose information into Star Schema details for Informatica ETL solutions practice.
  • Researched Emerging technologies in the Data Integration domain to address various Business needs within the Enterprise.
  • Developed and promoted various reusable components.
  • Promoted ETL shared service for various projects within the Enterprise.
  • Built ETL Governance framework with prescriptive guidance best practices for standardized repeatable enterprise data integration patterns.
  • Evaluated and Implemented Pentaho Data Integration Shared service and COE as an alternate ETL solution to reduce cost for Tier 2 applications.
  • Provided Architecture Guidance, Technology Leadership, best practices, High Level Design, Detailed Design, Led development efforts, SWAT support , COE services and successfully implemented the below Projects
  • CIW Custody Information Warehouse
  • Project L Bridgewater Back office Integration Project
  • GLS Global Liquidity System
  • GCX Global Class Action
  • AARC Annual Accounting Reporting Conversion
  • EB - Election Banking Reporting Engine
  • YS - Dreyfus Dealer Analytics
  • ERI Enterprise Risk Initiative
  • FedTic Worked closely with the FedTic development team to resolve various challenges and promoted the feeds to production.

Environment: Unix , ORACLE 11G, Exadata, Sybase, Informatica - Powercenter 9.1, 8.6.1, 8.1.1, Shell scripts, Hummingbird, Data Transformation 8.6, PWX for DB2 Zos, PWX for Oracle, JMS, MQ, Pentaho Kettle, Carte, Business Objects

Confidential

Technology Manager and Data Integration Architect

  • Developed a migration strategy and successfully implemented the java to informatica conversion project and achieved excellent performance for loading the Data warehouse.
  • Implemented Restart strategy and recoverability for the ETL loads to the Data warehouse.
  • Implemented Transaction Strategy, reusable Error handling Strategy and captured load statistics for the data warehouse load process.
  • Involved in requirements gathering, analysis, design and implementation of various feed load process to the central data warehouse using star schema.
  • Lead a team of developers, Designed, implemented and managed centralized ETL Architecture for the Enterprise ETL shared service Informatica .
  • CAI Data warehouse sources feeds from 12 different investor servicing centers which has hundreds of Hedge Fund products to the central Data warehouse. This system provides reports using Business Objects for the Finance dept. and the Senior management.
  • Created Data Mapping and Transformations from ODS between source and data warehouse, further refined the star schema for Transactional, using Informatica as an ETL tool.
  • Guided the developers in tuning the mappings and the jobs to achieve best performance.
  • Carried out technical enhancements of varying size and complexity: gather requirements, size deliverables, estimate dates, architect solution, design, develop, plan QA phase and delivery strategy. Investigate and prototype new technologies evaluate how they can be applied to enhance infrastructure.
  • Evangelized the ETL Shared Service across CAI to reduce cost by leveraging for multiple applications.
  • Setting up the standards and best practices for the ETL developers.
  • Set the standards and policies for the division in consultation with overall organization, maintain and support the data warehouse. The responsibilities also include, create and implement disaster recovery strategies and testing, operational support strategies etc.

Environment: Unix Solaris 10, ORACLE 9i, SQL Plus, PL/SQL, Sybase, Informatica - Powercenter 8.1.1, 7.1.3, Shell scripts, Hummingbird, SQL Loader, Business Objects 11

Confidential

Data Integration Architect

  • Was involved in the design of the centralized ETL Architecture as a shared service for the entire firm globally using Informatica.
  • Designed the scalable ETL Architecture using Virtual IP and Global Dispatcher instead of Grid.
  • Setting up the standards and best practices for the ETL developers.
  • Team Lead of developers on tuning the mappings and the jobs to achieve best performance.
  • Hands on experience in installing the Repository Server, Power Center servers on Both Linux and windows environments.
  • Was involved in the development of mappings with all the transformations.
  • Analyzed sources, developed re-usable mapplets in Informatica Maplet Designer.
  • Extracted Data from various sources including Oracle, Flat files and loaded data into the Data warehousing database using Informatica.
  • Worked as an administrator for the ETL farm and also provided a stable environment.
  • Received best implementation award from Informatica.
  • Provided generic scripts for the ETL developers to run their jobs.
  • Designed the centralized EAI Tibco Business Works / EII Composite , Metadata Management Shared Service Architecture for the entire firm globally.
  • Setting up the standards and best practices for the EAI / EII developers.
  • Implemented the Metadata Manager and put together governance model

Environment: Linux, Windows NT, ORACLE 9i, SQL Plus, PL/SQL, DB2 8.2, Sybase, Informatica - Powercenter 7.1.3, Shell scripts, Hummingbird, SQL Loader, Tibco Business Works 5.2 EAI , JMS/Tibco Messaging, Composite 3.2 EII , MetaIntegration for Metadata Management

Confidential

Data Integration Developer

  • Risk Management Data warehouse for Alliant Data SCORE - Data
  • A 7 Terabyte large data warehouse, consisting of data from 8 different Clients. This system is used to analyze credit background of customers of the direct marketing companies and provide them with promotional offers to the potential customers. Used Trillium for data cleansing, standardization and matching names and address.
  • Was involved in the implementation of Data loading using ETL tool - Informatica, PL/SQL,
  • Stored procedures, triggers, SQL Loader. Designed and implemented ETL code necessary
  • to integrate the data from various systems, flat files to the staging area and loading into the target
  • database by using Informatica, PL/SQL scripts Unix shell scripting.
  • Designed the Data warehouse using Kimball's Star Schema methodology.
  • Analyzed sources, developed simple and re-usable transformation mappings in Informatica Designer.
  • Analyzed sources, developed simple and re-usable mapplets in Informatica Mapplet Designer.
  • Designed and developed mapping using Source Qualifiers, Expressions, Routers, Sorter,
  • Aggregator, Normalizer, Filters, Stored procedures, functions and Update strategies.
  • Performed server-side activities including creation of database client connections, and
  • designing Informatica batches and sessions to load data into target tables.
  • Extracted Data from various sources including Cobol files, Flat files and loaded data into the
  • Data warehousing database using Informatica.
  • Worked on STRIVA DETAIL Power Connect for Mainframe to load EBCDIC files.
  • Performed Unit Tests.
  • Extensively worked on Trillium to standardize Matching Names and address and cleanse data.
  • Worked on SAS 9 to generate reports and data Analysis.

Environment: Unix, Windows NT, ORACLE 9i, SQL Plus, PL/SQL, DB2 8.1, Informatica - Powercenter 6.2, TOAD, Unix Shell scripts, Hummingbird, SQL Loader, ERWIN, Trillium 6 for Data Quality Name and Address Standardization, Detail, SAS 9

Confidential

PowerBuilder Lead Developer

Key Projects

  • Training Enrollment System TES Confidential
  • The Scope of this system is to provide the users, screens to maintain the enrollment of students from different Dealers for training from various departments like Technical, Sales and Service. This
  • system also has a Billing Module to bill the dealers for the training they had at Mercedes. This
  • system has the feature of faxing documents directly to various dealers using Right Fax. This
  • system generates various reports for Technical training Confirmation using RTE data window.
  • Involved in the full life-cycle development of the project. Was involved extensively in writing
  • stored procedures for Sybase. Involved in optimization of the queries to improve performance. Involved in business process analysis, Program specifications, development, testing and
  • Subsequent implementation. Worked on PowerBuilder Foundation Class Library, Non-Visual
  • User Object, and Datastore, Rich Text Edit Controls in PowerBuilder. Extensively used object inheritance and other concepts of object oriented programming.

ENVIRONMENT: Windows 2000, Sun Solaris, Sybase SQL Server 11.5.1, PowerBuilder 8.0, 7.0.2, SQL, Unix

Campaign Cost Analysis

Confidential

  • The Scope of this system is to provide the users with the tools to create the campaign mail piece and its associative cost data within the Marketing Information System MIS Application. This system allows the Marketing Dept. to create the Campaign Drops and for Operations Dept. to price the package components that make up the Campaign Drop's Mail Piece. Once the mail piece is priced, the Campaign's Matrix can be viewed and approved along with each Mail Piece Component. Campaign Costing is an Operations function and the Marketing group will only be able to create campaign drops. Operations and Marketing put together the concept requirements for each Campaign Drop, and Operations assigns the package components to those concepts thus creating the mail piece.
  • Involved in writing stored procedures, Packages and Triggers in Oracle. Involved in the optimization of the queries to improve performance. Involved in business process analysis, Program specifications, development using PowerBuilder and subsequent implementation of Executable Packages, testing plans and testing of the system. Was involved extensively with requirements gathering, and solutions design and preparing documents for the system. Worked on PowerBuilder Foundation Class Library, Non-Visual User Object, and Datastore. Extensively used object inheritance and other concepts of object oriented programming.

ENVIRONMENT: Windows NT 4.0, HP - UX 10.0.2, Oracle 8i, PL/SQL, SQL Plus, SQL Loader, PowerBuilder 6.5, PVCS

Banking Information Public Service System

Confidential

  • The Scope of BIPSS is to track information to support the staff and business areas within the Department of Banking. The Department is responsible for monitoring various Financial Institutions in the state like Banks, Credit Unions and other lending institutes. Users will have on-line access to BIPSS through their PC. The enterprise wide systems will allow users to query or raise complaints, credit inquiries, to enforce actions, examinations, licensing, registration, etc. pertaining to regulated entities and individuals to assist In making case decisions.
  • Involved in business process analysis, plan and document program specifications, development, testing, and subsequent implementation of Executable Packages. Was involved extensively with requirements gathering, and solutions design. Worked on PowerBuilder Foundation Class Library, Non-Visual User Object, and Datastore. Extensively used object inheritance and other concepts of object oriented programming. Was also involved in writing stored procedures and triggers for Sybase back-end.

ENVIRONMENT: Windows NT 4.0, HP - UX 10.0.2, Sybase SQL Server 11.0.2,

PowerBuilder 5.0/6.0/6.5,7.0, PFC Powerbuilder Foundation Classes , PVCS

Confidential

PowerBuilder Developer

Confidential

  • Worked on Account Receivables module in Finance System. The AR module was designed to help capture, maintain and monitor the amount receivable from debtors. AR consisted of CRVs Check Receipt Voucher issued, payment received from customers, allocation/de-allocation of payments, passing adjustment Entries through debit/credit notes, verification of customer commission etc. The AR module was also designed to generate crucial management reports like aging analysis - salesperson / customer-wise, statement of accounts, credit limit expiration report, average collection period, etc.
  • Was involved in writing stored procedures, Packages and Triggers in Oracle. Was involved in business process analysis, preparing and documenting program specifications, development using PowerBuilder and testing. Worked on PowerSoft Foundation Class Library, NonVisual User Object, Datastore, and was involved in writing error-trapping functions.

ENVIRONMENT: Windows 95, Oracle 7, PL/SQL, SQL Plus, SQL Loader and PowerBuilder 5.0, PFC, PVCS

Confidential

PowerBuilder Consultant

  • Worked on Members Accounting And Trade Confirmation MAATC . MAATC was made of three modules: Order placing, Account, and Objection. This system was designed for the primary brokers of National Stock Exchange for selling and buying shares. The package was designed to keep track of slab brokerage for the shares sold or bought with their clients. The clients were able to place orders, Modify orders, cancel orders, etc. It also provided contract notes and daily reports.
  • Was involved in writing stored procedures and Triggers in Oracle. Was involved in developing the module. Extensively used object inheritance and related concepts of object-oriented programming using PowerBuilder

ENVIRONMENT: Windows NT 3.5, Oracle 7, PL/SQL, SQL Plus, SQL Loader, PowerBuilder 4.0

Confidential

PowerBuilder Consultant

  • Worked on settlement system of the Bombay stock exchange. This system was kept track of the shares at the time of pay-in, balancing, and pay-out. It also maintained records for rejection of shares and shares that are sent for auction. The package also had several management reports to report on the transactions.
  • Was involved in writing stored procedures and Triggers in Oracle. Business Process Analysis, System Design Development using PowerBuilder, and subsequent testing.
  • Worked on depository system of the Bombay Stock Exchange. The system was developed to maintain the amount of shares for each investor, transaction of shares, Vyaj badla shares and updating of ledger folio. It provided facilities for transferring shares to investor's own account. The system generated reports for all transactions.
  • Was involved in systems study, preparing program specifications, development using PowerBuilder, and testing. Was involved in writing stored procedures and Triggers in Oracle. Written Shell Programming for the batches in Unix k Shell .

ENVIRONMENT: Windows 95, Unix SVR4, Oracle 7, PL/SQL, SQL Plus, SQL Loader and PowerBuilder 3.0, Microsoft Access

We'd love your feedback!