DBA / PB Team Lead Resume

SUMMARY:

12+ years of extensive experience in System Analysis/Design, Coding, and Unit Testing, Integration, Implementation, Maintenance and enhancement of Software applications using PowerBuilder
Skilled in requirement gathering and analysis, developed and maintained applications and Prepared technical design documents, solutions and recommendations based on business requirements
Expert in PowerBuilder programming, PFC libraries, OOP, SOAP, WSDL web service, XML, DLLs
Proficient in developing and debugging complex IT systems and outstanding ability to translate business requirements into application solutions, assessing and evaluating alternative solutions
Maintains compliance with business rules, provide advice, solution and support to team with expertise
12+ years of experiences as an Oracle DBA under UNIX/Windows server, using Oracle 9i - 12c
Familiar with Java programming, Visual Studio and ASP.Net
Experienced in database design, reverse engineering, developing UNIX shell and SQL scripts
Strong Knowledge of Software Development lifecycle and methodologies like Agile, Scrum
Experienced in data / object modeling, data normalization, ETL process, application performance optimization in data discovery, conversion, mapping and migration
Statistical analysis, modeling, data collection, cleaning, visualization, regression, data mining, decision tree, cluster analysis, random forest, forecasting and reporting using SAS, Python and R
Strong communication, Presentation and analytical skills. Proven skills as an efficient Team Lead in System Analysis, Designing, Development, Customization, Migrating and technical Documentation
Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with stakeholders

TECHNICAL SKILLS:

Databases: Oracle 9i/11g/12c, MS SQL Server, Informix ids 7.3, MySQL

Database related Tools: Oracle Data Guard, Golden Gate, RAC, Oracle SQL Developer, Toad, ERWin, PowerDesigner, DBArtisan, SSIS

Operating Systems: AIX 7.1, HP Tru64 Unix 5.13, HP-UX and Windows Server 2003/08/12, Linux

Languages: PowerBuilder 9-12.5, Java, SQL, PL/SQL, SAS, Python, R, C/C++, Visual Studio 2010 and ASP.Net 4.0

Big Data Apps: Hadoop, MapReduce, HDFS, Hive, Pig, Spark, NoSQL, Hbase etc.

Reporting Tools: MS-Office (Excel Macro, VBA, PowerPoint), MS-Visio, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

DBA / PB Team Lead

Responsibilities:

Responsible for overall planning, organizing, and execution of IT functions, built new systems
Worked 30% on DBA, 40% on PowerBuilder application development and maintenance of 5+ core systems, documentations, lead a team of 2 PB developers and 2 hardware/network personnel
Designed, developed and deployed entire Money Exchange applications using Power Builder 9-12.5, including financial systems like General Ledger, Chart of accounts, Bank statements, daily reports
Extensively used PFC libraries, custom/user objects, data validation, testing, Data Windows, Menus
Expertise in debugging skills using PB trace files and Just in time Debugging, applying security
Maintains strict compliance with central bank’s policies (KYC & AML), applied business rules
Built a central c/s system, serving 3,000+ transactions/day, with 25 branches and 150 users
Maintained 25+ servers with O/S and Oracle 9i/11g database, local servers and test servers
Database design and modeling, data migration from Informix system to Oracle 9i /11g database
Installed Oracle & RAC under Unix cluster / Windows, regular backup & recovery, troubleshooting
Provided management decision support by analysis, complex queries, critical thinking and problem solving using large historical data processing, data warehouse and data mart
Implemented web service for online money transfer to a foreign bank under dedicated, secured link
Optimized business process to reduce downtime, cost and contributed to corporate profit by 40%

Confidential

Programmer Analyst

Responsibilities:

Data analysis, discovery and determined entity relationship, populated mapping tables using Informix
Wrote various summary and detail data conversion programs for GL, AP, AR, store transactions
Worked on Y2K project, migrated data into Y2K compliant Informix server 7.3 from earlier version using export, import and load utilities

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship