System Analyst Developer Resume Profile
PROFESSIONAL SUMMARY
A professional and conscientious application and database developer, System Analyst, Customer Support Consultant and Software Engineer with vast experience. Ability to adapt to Business Change by applying dynamic techniques.
Skills/Experience:
- Strong background in databases - DB2, Oracle9/10, Informix, Sybase.
- Extensive experience SQL, SQLPLUS, SQL/PLSQL, SQL Loader, SQL and PL/SQL tuning.
- Extensive experience in Procedure, function, trigger, package, Backup/Recovery.
- Strong background OO development and design Years of experience in C/C , Pro C/ESQL.
- Also experienced in .Net C .
- Extensive experience on debugging, dynamic memory allocation, troubleshooting for exceptions and make files. Extensive experience in Windows, AIX and Linux, shell and other tools. Expert in Software
- Quality Assurance. Experienced in VB, Delphi.
- Experienced with data transfer tools, protocols ftp, etc Excellent ability to work either individually or as a team member Strong in Problem analysis and problem resolution Strong communication skills verbal and written Strong in customer support.
- Experienced in Requirements, Analysis, and Spec. Writing and design .
- Experienced in Call center, CRM, Tax, Billing, Warehouse, Transportation, Retail, Inventory, Wave .
- Order and supply, Sales, credit card, Package mailing, financial applications. Exposed to Perl.
TECHNICAL EXPERIENCE
- Programming Languages: C, C , Pro C, C , ASP.Net, ADO.net, HTML, XML, DHTML
- Software/Databases: MS Office, MS Word, MS Excel, MS Power Point, MS Access, MS Outlook,, Clear case, Oracle11g, CVS, SQL, PL/SQL, Unix, DSD, Bash shell
- Operating Systems: MS Windows 2000, XP, Vista, 7, UNIX, LINUX
- Methodologies: Distribution Management, Retail Business Management
PROFESSIONAL EXPERIENCE
Confidential
Senior programmer Analyst
- Designed, coded, analyzed, evaluated, tested, debugged, complex backend servers,
- Monitored server systems for expected performance
- Performed analysis on production issues
- Researched and analyzed data processing functions, methods and procedures
- XML data analysis and data validation in log files
- Unit testing, Reporting, Documentation, Shell scripting
- Technologies: Pro C/C, SQL, PL/SQL, POS, BEA Messaging, Oracle, UNIX, SQL Developer, XML Processing, Accurev, Shell
Confidential
System Analyst Developer
- Involved in development, support and deployment in Balance Manager Billing System AT T ,
- Defect analysis and providing solutions
- System support, data analysis and data verification
Technologies: Oracle RAC , SQL Developer, SQL, PL/SQL, UNIX, DSD, Bash shell
Confidential
System Analyst and Developer
- Development in State Health care System, Assignment Estimation based on requirements,
- Technical Design, Documentation, Unit testing, Analysis, System and Data migration,
- Production Support, Customer Support, Defect Analysis and fixing.
- Data Analysis and providing reports, Complicated SQL tuning
- Monitoring production issues and finding solutions.
Technologies: C/Pro C, Autosys, Clear case, Oracle 10/11g, PL/SQL, SQL, SQL Tuning, Procedures, functions, Packages, Unix/Solaris, Linux, Korn shell, Bash shell, Vctl, SQL Developer, Toad, Excel.SQL Loader, SQLPLUS, GDB, Solaris Workshop, DBX, iTrace, other UNIX utilities.
Confidential
- Development on C/C , .net C , SQL, PL/SQL, Pro C, System Designing, Reporting.
- SQL tuning, shell scripting, Backup and Recovery, Enterprise Manager/Oracle11g, Apex, Toad
Technologies: C/C , .net C , SQL, PL/SQL, Pro C, Oracle11g
Confidential
Senior System Analyst Database Developer
- Provided System and data analysis.
- Developed C and Pro C/ESQL applications.
- Worked on Oracle, SQL Server, ODBC and used related database tools, provided support by dealing system problems at production level Developed shell script tool.
- Extensive debugging with GDB/DBX.
- Troubleshooting on memory violations. Platforms include UNIX/Linux and Windows.
Technologies: SQL, PL/SQL, SQL, Procedures, Functions, Tuning. Used CVS. Provided development in Tax Compliance Payment system, Tax Reporting systems and printer applications running on UNIX and Windows
Confidential
System Analyst Database Developer.
- Worked on System and Financial data analyst
- Developed .Net C Multithread, Delphi and C applications.
- Developed Store Procedure, Functions using SQL, PL/SQL Developer in Oracle 10g. Worked on ADO. Net, SQL Loader, XML, Informatica ETL, Debugged C DLL, C applications, Fixed memory leaks. Provided Data Mapping. Backup Supported production systems by analyzing data related problems.
Technologies: SQL, PL/SQL, ETL, ADO. Net, SQL
Confidential
System Analyst Database Developer
- Worked on system and data analysis,
- Developed applications, Screens, Help file using SQL, Cursor, PL/SQL, Sybase/Oracle, C, Pro C/ESQL, SQL/T-SQL Tuning, Embedded SQL, Packages, Triggers, Functions, Stored Procedures and other schemas.
- Worked on data loading, Backup, Recovery Used Unix/AIX, UNIX tools, DBX/GDB, SCCS and report tool.
- Troubleshooting on core dumps, Creating make files, Developed shell scripts, Perl scripts, software Specifications, Test Plans, Provided System Test, Unit Test, regression test.
- Worked on customer requirements and business laws, Documentation.
- Provided support on on line/on call Distribution Management and Transportation systems, Workflow/Web Applications by analyzing production problems.
- Provided solutions for change requests and trouble tickets in Remedy, Developed Supply Chain Distribution Management systems, Transportation Systems, Retail Business Management systems, Warehouse Database applications.
Confidential
Worked as a consultant on software development and analysis
Technologies: C, C , PL/SQL, Pro C, Oracle
Confidential
System Analyst App. Developer
- Analyzed, developed, maintained and worked on parallel data processing system written in Korn/Ash Shell, C, C , SQL, and Tuning under Unix/AIX, DB2 and Oracle environment.
- Used PVCS source version control system, Web tools.
- Processed data files containing millions of credit records.
- Developed and created Oracle 10g database tables and indexes.
- Data loading using Oracle data loader ETL .
- Worked on database performance analysis tools.
- Analyzed credit files processing system.
- Supported production activities daily basis Worked with AIX and LINUX utility tools.
- Exposed to Perl.
Technologies: C, C , SQL, ETL, Oracle 10g, Unix/AIX, Perl, AIX, LINUX
Confidential
Sr. System Analyst
- Worked on CRM Production Support applications Telecom Billing, Order Promotion using systems based on Oracle Databases, UNIX, Web applications and other tools, Provided System Analysis.
- Developed Oracle SQL, PL/SQL, Procedures, Functions, Triggers. Worked on data manipulation using Cursor and embedded SQL.
- Developed C applications. Involved in production activities and troubleshooting.
Technologies: Oracle, Informix, C/C
Confidential
IT Specialist
Consulting and development on C/C and database applications using Oracle and Informix.
Technologies: Oracle, Informix, C/C
Confidential
System and Database Developer
- Developed security system applications using C/C , CURSOR, Embedded SQL, PL/SQL, and SQL Tuning on AIX platform and implemented successfully.
- Provided Data Modeling.
- Developed and maintained data conversion applications ETL working on data extracts from multisystem platforms using C/C and DB2 SQL to support Dataguide and meta data, Warehouse blueprint on NT, DB2, AS/400, MQ Series and AIX/Unix environment.
- Developed Pro C applications on DB2/Unix.
- Developed Shell scripts.
- Designed and developed front end user interfaces with Visual Basic.
- Analyzed, debugged C/C and DBA SQL Code in the worldwide Training Administrator systems used by thousands of users all over the world to support Unicode enablement testing and develop HTML/XML technical documentation.
- Analyzed AIX Jobs to avoid overhead processing.
- Worked as a Lead developer.
- Developed, analyzed and maintained Production Application Systems supporting IBM external corporate customers.
- Analyzed customer requirements Developed applications to implement business rules and provided interface functionality in CRM and Sales and Orders production systems supporting IBM partners and customers for business success using VISUAL BASIC, Source Safe, INFORMIX and Informix- GL on the AIX platform.
- Supported ongoing customers' business requirements. Worked on Visual C applications. Worked on Database Schema and other schema objects like tables, Views, Indexes and Synonyms, Procedures, Functions, Packages. Backup, Recovery, Data Loading, Export, Import. Supported ongoing customers' business requirements.
- Developed Database, UML modeling and User interface Mapping. Provided business data entitlement and data extract support to customers using a database warehouse, which was a repository of reformatted business data at the back end on Unix/AIX platform.
- Developed Java applications, Java stored procedures and Swing user interfaces.
- Developed technical documentation.
Technologies: C/C , CURSOR, on NT, DB2, AS/400, HTML/XML
Confidential
Software Consultant/Engineer, Contract
- Developed Lotus Notes and C applications, Provided extensive GUI standard verification.
- Provided fault analysis on audiovisual sales, Client-Server and Telephony applications.
- Analyzed test requirements and developed test cases. Used case analysis.
- Provided automation using ATF, Test Director, Win Runner and other tools.
- Provided problem tracking and reporting support,
- Team and project coordination.
- Developed user applications using C, Oracle/SQL and Rexx.
Technologies: C, Oracle/SQL, Rexx
Confidential
Programmer Analyst
Designed and developed applications in C and Paradox/Pal. Designed and developed SQL Forms, Pro C applications using Oracle 6.0/SQL 3.0, PL/SQL in Bill of Materials system.
Technologies: Oracle 6.0/SQL 3.0, PL/SQL