Sr. Programmer Analyst Resume

SUMMARY:

Sixteen years of IT experience with technical lead & managerial experience in data warehouse Projects
Experience in project management skills including team mentoring, team managing, effort estimation, resource breakdown structure creation, screen resumes and conduct interviews for new team member hiring
Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing and project management skills
Experienced in various verticals- banking, manufacturing and hospitality management
Experience in various technologies - In depth experience with Oracle SQL, PLSQL, Informatica, Cognos, Jasper and OBIEE
Exposure in BigData - Hadoop and Python

TECHNICAL SKILLS:

Data warehousing: Informatica, Cognos 8/10, Jasper Soft Studio 6.3.1 and OBIEE 11.1.1

Database: Oracle 9i/10g/11g/12c, MS SQL Server 2000 Database and MS Access 2007

Languages/Scripting: Oracle Mod-PLSQL, PL/SQL, Visual Basic-6.0, Shell Scripting (Unix), Python 3, HTML, Java Script, JQuery

Software: APTANA Studio 3, CAST, Toad Code analyzer, PLSQL Developer, Toad, Putty, SQL Management Studio, MS Visual Studio and MS Office

Configuration Tools: Git,Tortoise Repository/SVN and MS Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Programmer Analyst

Responsibilities:

Environment: Oracle Mod-Plsql, JavaScript, JQuery, Informatica 9.6.1, Jasper Studio 6.3.1, Python 3

Confidential

Senior Oracle and Cognos Developer

Responsibilities:

Development and technical support for all Cognos BI Reports
Produced project status reports, managed the team and resolved day-to-day issues

Environment: Oracle11g SQL, PL/SQL, Cognos10 iGate Global Solutions Ltd (Manager - Projects)

Confidential

Project Manager and Project Lead

Responsibilities:

Coordinate and facilitate discussions with the Users, Business Intelligence Leader, and the Process the required time period
Leads to clarify their requirements and gather additional information for developing their needs in Analysis and Development of Cognos Dashboards, Report Studio Reports and Query Studio Reports for Finance, Sales etc.
Development of Cubes for Finance and Sales Domain providing business an easy way to slice and dice data
Responsible for: 24/5 production support for Data monitoring and data availability in Production for
Estimation preparation for development & delivery for each PCR.
Responsible for Resource allocation on project task on daily basis. Onsite & Customer Co-ordination on daily business activities
Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
New development\Enhancement for ETL, Reports and Dashboards

Environment: Informatica8.1\9.1, Oracle9i SQL, PL/SQL, JD EdwardsCognos 8.4\10, Noetix (Jaros), OBIEE 11.1.1

Confidential

Technical Lead

Responsibilities:

Responsible for daily data load activity ensuring that the jobs have been run on time and providing business solutions without breakage
Defect Tracking and Maintenance
Preparation and Reporting of Project status and defect Metrics, using iQuest tool
Chaired weekly status meetings on project progress
Representing Project Status Review meetings
Onsite Co-ordination on daily business activities
Involved inAnalysis, Design, Coding, Unit Testing and Batch Job monitoring.
Involved in Oracle PL/SQL performance tuning.

Environment: JDK 1.3, J2EE 1.3, Servlet 2.3, JSP 1.2, EJB 2.0, Web Sphere Application server 5.x, Oracle 10g/ PLSQL, ERWIN

Confidential

Developer

Responsibilities:

Responsible for daily data load activity ensuring that the jobs have been run on time and providing business solutions without breakage
Testing and Implementation.
Server and Database Migration activities.
Involved inAnalysis, Design, Coding, Unit Testing and Batch Job monitoring.
Involved in Oracle PL/SQL performance tuning.
Representing Project Status Review meetings
Onsite Co-ordination on daily business activities

Environment: Oracle 9i, PL/SQL, UNIX, Shell Scripting, Pro*C

Confidential

Developer

Environment: Oracle 8.1.7,PL/SQL,UNIX,JAVA, VB 6 and SQL Server 2000

Responsibilities:

Analysis, Design, Coding, Performance tuning, Testing and Implementation.
Implementation and Support
Finacle implementation in different Banks (Punjab National Bank, Development Credit Bank Ltd. )
Involved all projects from Requirement analysis to implementation support level