We provide IT Staff Augmentation Services!

Sr. Programmer Analyst, Resume

2.00/5 (Submit Your Rating)

Jericho, Ny

SUMMARY

  • Have extensive working experience in SQL, PL SQL programming and have used tools such as Toad, Oracle Developer, SQL Plus, Talend, Eclise, Jdeveloper, Benthic, Toad Data Model, and Erwin for SQL based data warehouses development and deployment.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Experienced in development of ETL mapping and scripts.
  • Experienced in software development life cycle (SDLC) and Agile SCRUM.
  • Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively.
  • Experience in developing PL/SQL, Stored Procedure and UNIX Scripting.
  • Experienced in Business Intelligence and Reporting
  • Ability to work independently as well as leading team members with various backgrounds on complex issues and have strong verbal and written communication skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g,10g,9i,8i, MS SQL SERVER, MySQL

Operating Systems: UNIX (Sun Solaris, AIX), Linux, Windows Server, Windows 7/XP

Languages: PL SQL, HTML, XML,Java, Java Script, JSP, C, C++,Pro C, ColdFusion

Version Control: PVCS, SVN, Sublime.

Tools: Business Objects XI, Tableau, Alteryx, Toad, SQL Developer, Benthic, SQL Loader, JDeveloper, Eclipse,CastIron,Tuxedo, Toad Modeler, Talend,Salesforce, Apex Dataloader, Kenan, NetrcrackerPROFESSIONAL EXPERIENCE

Sr. Programmer Analyst

Confidential, Jericho, NY,

Responsibilities:

  • Served as a data warehouse designer, ETL developer, BI report writer. Tasks included conducting requirement analysis, designing and developing of a data model (star schema), ETL coding in Talend, PL SQL, Java, and Unix shell scripts.
  • Designing /creating of Business Objects universes and reports . created of multiple star schemas in an Oracle database(Index, Tables, Views, etc.), database performance tuning and SQL statements, data extraction scripts, installation and configuration
  • Extensively worked on tuning of SQL query, batch jobs, optimizing batch process as well tuning various Talend,Java, database Packages ETL jobs.
  • Managed integration and stress testing of back end applications.
  • Research and evaluate alternatives software, and recommend solutions for business issues.
  • Adopted agile project management, played role of SCRUM master. Sprint based development and enhancement of new features and functionality on existing platform.

Environment: PL/SQL, Oracle 11g, Java Oracle 11g, TOAD, Toad Modeler SQL PLUS, PVCS, SVN, Oracle Designer, Eclipse, Core Java, JSP,HTML,XML, Jdeveloper, Oracle Develper, UNIX, Business Objects (BI) Designer and Infoview, Tableau, Talend, Salesforce, Apex Dataloader, Kenan, Netrcracker, Castiron, Remedy, Benthic

Programmer Analyst

Computer Sciences Corporations, NJ,

Responsibilities:

  • Developed a customer order data warehouse for AT&T to help strategy planning and opportunity evaluation. It provided an effective decision support.

Environment : PL/SQL, Oracle 8i,Web DB, Java, Unix Shell scrips, C++, Pro C, AWK,Tuxedo, Sublime.

Programmer Analyst

AT&T Piscataway, NJ

Responsibilities:

  • Provided development and maintenance support for proprietary Oracle - based Order Tracking systems.
  • Created C++, Pro C, Java processes to update databases; Developed UNIX shell scripts;
  • Created an online Web Portal for reporting.

Environment: PL/SQL, Oracle 8i,Web DB, Java, Unix Shell scrips, C++, Pro C, AWK, ColdFusion, Tuxedo, Sublime.

We'd love your feedback!