SUMMARY:

• 10+ years experience in Information Technology.
• Expert in Application designing and development.
• Expert in Database design and development.
• Expert in ETL designing and development.
• Expert in modeling Data mart and Data warehouse
• Experience in application installation, upgrading, and maintenance.
• Extensive experience on interaction with system users on gathering business requirements and involved in developing project use cases in various projects.
• Experienced in full life cycle of project development especially with SDLC (System Development Life Cycle) methodology.
• Experience in Scrum & Agile and waterfalls Methodologies.
• Experience working in a team or individual.
• Excellent communication skills.
• Ability to work in more than one project.

TECHNICAL SKILLS:

Programming: Advanced PL/SQL, Java, HTML/JavaScript, XML, C/C++, Pro*C, Visual Basic.Net, C#, SQL, Perl, and UNIX Shell script.

Networking: TCP/IP, VPN, LAN/WAN

Platforms: Windows, AS400, and UNIX (Linux, Solaris, and SCO).

Databases: Oracle (8i/9i/10g/11g/12c), MS SQL Server and MS Access.

Applications: Microsoft Office Suite, MS Visio, MS Project, Microsoft Outlook and Novell GroupWise

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Application Engineer

Responsibilities:

• Development and administration of Oracle Business Intelligence Enterprise Edition (OBIEE) reporting and analytics solutions within Corporate Finance Technology Group.
• Lead Business Intelligence Supply Chain application development.
• Gathering technical requirements design and develop business analytical solutions, testing and implementing of Business Intelligence requirements.
• Analyzes business requirements, designs and writes technical specifications to design or redesign computer solutions
• Design Data model (Star Schema with Hierarchy) and develop ER diagrams.
• Develop OBIEE Repository (Physical Layer, Business Logic and Presentation Layer).
• Provide technical support to develop reports and dashboards.
• Use Linux shell scripts to create scheduled jobs and maintenance.
• Install OBIEE in Unix and Windows platforms.
• Implement security models in OBIEE platform (Authentication and Authorization).
• Develops original and/or complex code or provides coding guidance to less experienced staff.
• Leads and/or performs modeling, simulations and analysis efforts.
• Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.
• Participates in overall systems testing.
• Leads the migration of applications to production.
• Develops new documentation, participates in the development of department technical procedures and designs user guides.
• Leads projects, including assignment of tasks, and provides direction and guidance to less experienced staff.
• Implementing BI Publisher reporting using bursting technology.
• Perform training to other developers.
• Work as Business Continuity Administrator (BCA) for BI Supply Chain application Business Continuity Plan (BCP).
• Work as Access Certification Tool Administrator (ACT) for BI Supply Chain application. ACT is an enterprise solution used by managers and their delegates to facilitate timely review and certification of user access to application, shared drives and SharePoint sites, system account, user profile, and access to facilities.

Environmen t: Oracle Database 10g/11g, PL/SQL, SQL *Plus, Microsoft Visual SourceSafe, ToadV10, Oracle SQL Developer, Autosys, XML, HTML, ASP, JavaScript, Perl, JSP, HP Application Lifecycle Management, Microsoft SharePoint, Visual Source Safe, MS Project, OBIEE 10/11g/12c, DataStage, uDeploy, Tableau, and BI Publisher 11g/12c.

Confidential, Albany, NY

System Analyst/Senior OBIEE Developer

Responsibilities:

• Participated in implementation of the OBIEE, BI Publisher and WebCenter applications.
• Created Physical Layer and Business Model creation and build the presentation layer.
• Developed analytics and dashboards in OBIEE based on user specifications
• Designed and developed data model and BI Publisher reports.
• Defined security model for OBIEE, BI Publisher and WebCenter applications.
• Designed and developed Analytical, Operational and Transactional reports.
• Administered Web Logic server and BI Server.
• Wrote and modified Oracle PL/SQL, SQL statements procedures and functions that are used in Crystal Reports.
• Created the extract, transform and load (ETL) architecture to move the source data into an Oracle Data Warehouse data model using Informatica.
• Involved in the development of crystal reports.
• Created and modified database objects like tables, table partitions, views, functions, procedures, synonyms, and triggers.
• Performed SQL Tuning for various module and created indexes to improve the performance.
• Rewrite SQL queries to improve the performance of the application.
• Integrated crystal reports using JAVA, JavaScript, Visual Basic 6.0 and Visual Basic .Net.
• Created Test cases for various modules.
• Responsible in unit testing and documentation.
• Performed the back - end and front of CAIRS application.
• Responsible for documentation of business and technical architecture for reference.

Environment: Oracle Database 10g/11g, PL/SQL, SQL *Plus, Crystal Reports 9.0, Visual Studio 6.0 and Visual Basic 6.0, Visual Studio .Net and Visual Basic .Net, Microsoft Visual SourceSafe, ToadV10, Oracle Developer Reports, Oracle Developer, XML, Informatica, Oracle Portal, JDeveloper, OBIEE Analytics 10/11g, BI Publisher 11g, WebCenter 11g, Scrum Methodology, and SQL *Loader

Confidential, Portland, OR

PL/SQL Developer

Responsibilities:

• Wrote and modified Oracle PL/SQL, SQL statements, stored procedures and functions.
• Creating and managing schema objects like tables, indexes, views, synonyms, clusters, etc.
• Used Dynamic SQL for DDL commands in PL/SQL.
• Migrated data to the new business retirement plan using PL/SQL procedures with TOAD.
• Fine-tuned and re wrote existing packages to improve performance and to meet new business requirements.
• Created 20 tables, Views, Synonyms, Packages, Triggers, and Procedures.
• Developed database triggers to maintain audit tables.
• Performed SQL Tuning using Explain Plan.
• Created Advanced ETL
• Documented business and technical architecture for reference.

Environment: Oracle 10i, Toad V10, Oracle Developer Suite, UNIX, Sun Solaris 9, XML, JSP, Java, C++, JDBC, SQL loader and PVCS

Confidential, New York, NY

Oracle Report/Forms Developer

Responsibilities:

• Responsible for designing, developing, reviewing, implementing, testing of different modules.
• Wrote and modified Oracle PL/SQL, SQL statements procedures and functions that are used in Oracle Forms and Reports.
• Involved in the development of custom forms and reports.
• Created and modified database objects like tables, views, functions, procedures, synonyms, and triggers.
• Performed SQL Tuning for various module and created indexes to improve the performance.
• Rewrite SQL queries to improve the performance of the application.
• Prepared Test Plans for various modules.
• Responsible in testing and documentation.
• Tested the CONFirm application on Oracle 9.2.0.8.0 database
• Documented business and technical architecture for reference.

Environment: Oracle 9i (9.2.0.8.0), PL/SQL, SQL *Plus, Oracle Developer Forms, Oracle Developer Reports, Oracle Developer, XML, and SQL *Loader.

Confidential, Mount Vernon, NY

System Administrator

Responsibilities:

• Configuring and Administrating Windows 2000/2003 Servers, MS Exchange Servers, SCO Servers, Internet Routers, and AS 400 Server.
• Installing Software and Hardware troubleshooting.
• Preparing special reports using Crystal Report Software or other applications.
• Involved in the development of custom forms and reports.
• Using SQL to create reports.

Environment: Windows XP, Windows 2000 & 2003 servers, UNIX (SCO), IBM AS400, MS Exchange, Microsoft Office Suite, and Crystal Report.