Sr. Programmer Analyst Resume Jericho, NY - Hire IT People

SUMMARY:

Over 15+ years of IT experience in applications and custom development, delivery solutions; covering all aspect of the software development life cycle.
Area of expertise includes Data Warehousing, Data Modeling (Star Schema), Data Mart, ETL, Data architecture, Data Governance, Business Intelligence and Ad - hoc reporting.
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 snow flake schema.
Experienced in development of ETL mapping and scripts.
Experienced in software development life cycle (SDLC) and Agile SCRUM.
Skilled Confidential 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, Netrcracker

WORK EXPERIENCE:

Sr. Programmer Analyst

Confidential, Jericho, NY

Responsibilities:

Designed and implemented data warehouse and business intelligence reporting solution for Sales and Marketing to assist them with self - help reporting capability, and data analytics in customer demographics and product analysis. This data warehouse supports the business decision and measurement of the effectiveness of marketing campaign.
Designed and developed an order, task, inventory and network capacity data warehouse for the Network Engineering Department. This assists the engineering department to track orders, equipment inventory, and forecast network usage/capacity.
Designed and developed a Key Operations Metrics data warehouse for Business Planning, which provided access to the current and historical customer, billing, and product information for decision making, budget planning, and revenue trending.
Created a Data Quality system to identify, clean, and resolve data issues in multiple data sources
Design and developed Confidential Customer Care Web Portal to allow customers to view their data/voice usage, and monthly invoices online. It also provided Customers options pay their bills online or via automated clearing house.
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

Confidential, NJ

Responsibilities:

Developed a customer order data warehouse for Confidential & Confidential 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

Confidential, 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 provide IT Staff Augmentation Services!

Sr. Programmer Analyst Resume

Jericho, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship