SAI PAVAN MEDAM
Email ID: abl8k2@r.postjobfree.com, Ph: 248-***-****
Overview:
Having experience for 7+ years in IT ranging from Analysis, Design,
Development and Implementation of major software Applications in different
environments.
An Oracle Certified Associate (OCA) with excellent experience in most of the
RDBMS including Oracle 7.3/8x/9i/10g/11g, SQL Server 2000/2005 & Teradata
V12
Expertise in PL/SQL, SQL*PLUS, SQL, SQL *Loader and SQL Navigator and
developed Database Packages, Stored Procedures, Functions, Views, Triggers
and Oracle Forms & Reports(10g and previous versions)
Worked extensively with ODI 10g for composing the corporate Warehouse
systems, as well as composed experience with OWB 10g, Informatica
Powercenter 7.x/8.x series, IBM Ascential Datastage 7.0/6.0
Strong Experience going through the complete SDLC with OBIEE/Siebel
Analytics, Cognos 8.x/ReportNet/7.x series specifically dealing with its
design, development and testing, as also good amount of exposure to Business
Objects XiR2/6.5 in developing BI tasks for Analysis, Reporting and
Dashboards, worked extensively with Essbase Cubes
Comprehensive experience into Design, Development, Testing and
Implementation with applications on the Lombardi Teamworks/Blueprint V
6.2/5.5 platform
Proficient in Java Technologies which include Core Java, Advanced Java, J2EE
integrated into Oracle ADF, extensively worked on JDeveloper and Eclipse
Substantial experience in working on Java technologies including JSP,
Servlets, J2EE, HTML and Java Script, on JSF, Struts, ADF and Spring
frameworks
Worked in performance oriented environment dealing with Oracle e-Business
suite Applications in doing the functional and technical work within its
various modules such as the Accounts Receivable(AR), Accounts Payable(AP),
Supply Chain Management(SCM), Order Management(OM/OE/ONT), General
Ledger(GL) & Customer Relationship Management(CRM)
Exposure in Server Installation, Upgrades, Database Creation, Database
Parameters Setting, Tablespace, Tables, Indexes, Partition, Storage, Roles,
Users Setup and Security.
Proficiency in using Erwin tool for Data Modeling and Designing, as well
application development with TOAD, PL/SQL Developer and in using SQL
Navigator
Work experience in Oracle Real Application Clusters(RAC), RMAN and Dataguard
Very good T-SQL programming skills, dealing with Query Optimization and
Performance tuning using SQL Profiler, Index Tuning Wizard, Execution Plan,
Windows Performance Monitor and DBCC commands; DB2 8.0/9.0, Hyperion
Essbase, Hyperion Financial Management
Configured and managed applications on UNIX, Linux, Windows NT/2000/XP/Vista
platforms
Good programming experience in C, C++, Pro*C, Microsoft Visual Basic
5.0/6.0, Perl
Good experience and exposure using Java Scripting in the web, reporting
environment and designing Web pages using Cascading Style Sheets
Excellent communication and interpersonal skills, as well abilities in
managing changing responsibilities and delivering time critical projects on
schedule
AREAS OF EXPERTISE
RDBMS Oracle 11i/10g/9.x/8i/7.x, SQL Server 2000/2005, MS
Access 7.0, DB2 8.0, Hyperion Planning, Essbase,
Financial Management, SAP ABAP
ETL Tools Oracle Data Integrator 10.1.3.x, Oracle Streams 9i,
Oracle Warehouse Builder 10g, Ascential Datastage
7.5.2/7.0/6.0, Informatica 6.x/7.x
OLAP OBIEE 10.1.3.x, Cognos 7.x, 8.x, ReportNet, Business
Objects 6.5/XiR2
Operating System MS-DOS, Linux, UNIX, Windows Vista/XP/ NT/2000/ME
Data Modeling Erwin 3.5.2/4.0
Languages/Utiliti C, C++, Pro*C, Java, J2EE, XML, XSL, SQL, PL/SQL, SQL
es *Plus, Navigator, PERL, COBOL, VB, ASP.NET, C#, Java
Script
GUI Tools Developer 2000 (Oracle Forms & Reports 6i, 9i, 10g) and
Visual Basic 5.0/6.0/.Net
Web Technologies HTML, DHTML, CSS, MS FrontPage
Other Software JDeveloper, Eclipse, TOAD, SPSS, ClearCase
INDUSTRY DOMAIN: Financial, Health Care, Telecommunications, Manufacturing
&
Distribution, Energy, Engineering &
Construction
Chronological Summary of Experience
Client: BNY Mellon(Wipro Implementation), Pittsburgh, Pennsylvania
Sept' 09 - Till Date
Sr. Application Consultant
"WebSTP" application workflows are used by hMellon transaction processing
teams for tracking the instructions sent by clients and advisors on fax
lines allocated to a particular processing team. The project development
incorporates the complete functionality from the point a fax item is
received in processing team's worklist to the point it is archived, on the
Lombardi Teamworks V 6.2/5.5 supported by the Oracle DB and IBM Mainframe
system, where in working with ODI on various sources automating the
complete DWH implementation.
Responsibilities:
. Collaborated with business users in chalking the requirements, there
by defining and designing the process flows
. Orchestrated business processes and workflows using Teamworks Process
Modeler
. Developed coaches for providing user interfaces to present information
to process participants
. Designed services in representing the data models, as along with its
implementation
. Utilized various palette functionality in integrating the corporate
requirements
. Prepared test plans and test cases in managing the UAT cycle
. Performed Data Analysis creating use cases and activity diagrams using
Rational Rose UML
. Developed PL/SQL procedures, packages, objects, triggers for
inserting, updating, retrieving and validating of data, worked on
applications with SQL Developer and coded performance tuning scripts
. Performed Data Modeling using the subject component tool
ERWIN3.5.2/4.0
. Implemented Oracle Data Integrator 10.1.3.5 in composing the Data
Warehouse System, supporting BI within Oracle Portals and using
Metadata Navigator
. Configured Apache Tomcat application server in implementing and
executing ODI functionality as a web service, as well incorporated the
subject in Oracle Workflow
. Extensively worked with Business Rules, in chalking the requirements
right, getting the physical and logical design documents,
implementation, testing and production releases
. Imported Knowledge Modules in the working environment for the Oracle
10g target, aiding the support of Reverse Engineering, Journalizing,
Loading, Checking, Integration and Service KM's for Oracle, JDE
Enterprise One, Teradata, Hyperion Essbase and MS Excel sources
. Provided for Data Models and Data maps of the Data Marts and the
feeder systems in this aggregation effort
. Scheduled ODI Packages and Scenarios for production and maintained the
appropriate versions and solutions as per the requisite enhancements
. Established the complete reporting environment, connected to
repositories and created interactive dashboards, as well ad hoc
queries with Oracle Business Intelligence Answers
. Worked with OBIEE result sets in development, QA and production, where
in designed the reporting structures as per the client and business
user specifications, as well worked on enhancements
. Built meta data models(.rpd), Business Physical Layer, Business Model
and Mapping layer using Oracle BI Administration
. Designed and tested OBIEE Dashboards, as well established its security
. Technical administration with Oracle Business Intelligence Publisher
administrators, report authors and end users
. Involved in developing, testing and releasing complex dashboards, and
later worked for enhancements and maintenance
. Executed and accumulated resources for development, testing and
production jobs using UNIX Shell Scripts and in the Data Warehousing
scenario monitored and regulated them using Autosys 4.0
. Involved in documenting the production releases and updating the
updating the data model changes
Environment: Oracle 11i, SQL, PL/SQL, Forms & Reports, ODI 10.1.3.x, OBIEE,
Lombardi Teamworks 6.2/7.0, Oracle CRM, Javascript, Java, J2EE, SQL*loader,
SQL Developer, PL/SQL Developer, UNIX Shell Scripts, Autosys 4.0, RUP, UML
Client: Restat Inc, Milwaukee, Wisconsin
Jan' 09 - Aug' 09
Sr. Oracle/Java Consultant
"AlignIT" is a corporate intensive application dealing with the company
pharmacies and customers, as well with the internal maintenance of the
complete process. It comprehensively utilized the Oracle Fusion Middleware
services, along side with the Oracle Database Management, Application
Development and Business Intelligence.
Responsibilities:
. Developed PL/SQL procedures, packages, objects, triggers for
inserting, updating, retrieving and validating of data, worked on
applications with TOAD
. Performed Data Modeling using the subject component tool
ERWIN3.5.2/4.0
. Dealt with various Oracle supplied packages such as DBMS_SQL,
DBMS_UTILITY etc and various custom packages in working out required
corporate applications
. Utilized the services of Oracle inbuilt applications such as EXPLAIN
Plan, AUTOTRACE etc, as also active with the System testing and User
Acceptance testing of the developed database functionality
. Implemented ODI 10.1.3.5 Data Warehouse application, along side
exclusive sessions on Business Rules, chalking requirements, physical
and logical design documents and unit testing
. Imported Knowledge Modules in the working environment for the Oracle
10g target, aiding the support of Reverse Engineering, Journalizing,
Loading, Checking, Integration and Service KM's for Oracle, Teradata,
Hyperion Essbase and MS Excel sources
. Provided for Data Models and Data maps of the Data Marts and the
feeder systems in this aggregation effort
. Configured Apache Tomcat application server in implementing and
executing ODI functionality as a web service, as well incorporated the
subject in Oracle Workflow
. Administered the topology, managed work and master repositories,
created users, profiles, security policies using Security Manager
. Designed and developed Align components using Lombardi Teamworks 5.5,
and generating the process as well as service level implementation
. Utilization of all Lombardi components in the complete code of the
application especially with the server side scripts, UCA's and event
modeling
. Executed work environment through JSP, Struts, JDBC, Web Services and
Axis in developing Interfaces and Web Services
. Integrated OID with WebLogic 10g application server, and also
configured Oracle Enterprise Manager in administration and deployment
of applications
. Administered OBIEE physical/logical/presentation layers and created
required calculation and time dependant measures, initialization
blocks and repository variables
. Established the complete reporting environment, connected to
repositories and created interactive dashboards, as well ad hoc
queries with Oracle Business Intelligence Answers
. Worked with OBIEE result sets in development, QA and production, where
in designed the reporting structures as per the client and business
user specifications, as well worked on enhancements
. Designed and tested OBIEE Dashboards, as well established its security
. Executed and accumulated resources for development, testing and
production jobs using UNIX Shell Scripts and in the Data Warehousing
scenario monitored and regulated them using Autosys 4.0
. Involved in documenting the production releases and updating the
updating the data model changes
Environment: Oracle 11i, SQL, PL/SQL, Forms & Reports, ADF, Lombardi
Teamworks 5.5, OBIEE 10.1.3.x, Javascript, Java, J2EE, OEM, WebLogic 10g,
RMAN, ERWIN 7, SQL*Loader, TOAD, SQL*Plus, UNIX Shell Scripts, Windows
Server 2008, Autosys 4.0
Client: Verizon Data Services, Temple Terrace, Florida
Mar' 08 - Dec' 08
Sr. Data Warehouse Developer
"iConsole" Data Warehouse application serves for the company BI in
analyzing and learning the company fixed assets, work requests, customer,
sales and financial data as well in catering to Data Mining. It delivers a
complete range of integrated functionality in managing the total HR and
Employee costs, revenue generation, service enhancements and value
addition.
Responsibilities:
. Developed PL/SQL procedures, packages, objects, triggers for
inserting, updating, retrieving and validating of data, worked on
applications with TOAD
. Dealt with various Oracle supplied packages such as DBMS_SQL,
DBMS_UTILITY etc and various custom packages in working out required
corporate applications, along side Oracle inbuilt applications such as
EXPLAIN PLAN, AUTOTRACE etc
. Executed SQL *Loader, BCP and Data Pump in performing direct and piped
loading from external tables
. Extensively worked with Business Rules, in chalking the requirements
right, getting the physical and logical design documents,
implementation, testing and production releases
. Implemented Oracle Data Integrator 10.1.3.5 in composing the Data
Warehouse System, supporting BI within Oracle Portals and using
Metadata Navigator
. Established the Data Servers and engineered the data models in
coordinating the operational sources
. Worked with varied sources in implementing ODI, ranging from Oracle,
SQL Server, DB2, Hyperion Planning, Essbase, Financial Management, SAP
R/3 and SAP ABAP
. Engineered the application using the modules Designer, Operator and
Topology Manager in composing the structured models and project, as
well as security on the target database
. Checked for data quality, performed replication and data
transformations and executed data profiling using ODI custom tools,
along side Trillium software
. Provided for Data Models and Data maps of the Data Marts and the
feeder systems in this aggregation effort
. Configured Apache Tomcat application server in implementing and
executing ODI functionality as a web service, as well incorporated the
subject in Oracle Workflow
. Analyzing and forecasting the reporting requirements, as well a
necessary resource in collecting the requisite credentials
. Collaborated with Business Analysts in elaborating use cases, defining
interfaces as well as web service specifications
. Executed work environment through JSP, Struts, Hibernate, JDBC, Web
Services and Axis in developing Interfaces and Web Services
. Established socket communications invoking requisite domains using
Java API's for processing XML data with Struts framework on
JDeveloper, and executed migration to Oracle ADF
. Worked on gathering business requirements, analysis, data modeling and
development of corporate reports using Oracle BI Apps
. Developed business reports and alerts using Oracle BI Server, Oracle
BI Administrator, Oracle BI Answers, Oracle BI Delivers and Oracle BI
Publisher
. Developed complex reports and interactive Dashboards on the OBIEE
platform
. Executed and accumulated resources for development, testing and
production jobs using UNIX Shell Scripts and in the Data Warehousing
scenario monitored and regulated them using Autosys 4.0
. Involved in documenting production releases and updating the data
model changes
Environment: Oracle 9i/10g, SQL, PL/SQL, Forms & Reports 6i, ADF, ODI 10g,
Workflow, OBIEE 10g, Javascript, RAC, RMAN, ERWIN 7, SQL*loader, TOAD,
SQL*plus, UNIX Shell Scripts, Autosys 4.0, RUP, UML, Clearcase
Client: Robert BOSCH Corporation, West Memphis, Arkansas
Sept' 06 - Feb' 08
Sr. Oracle/BI Consultant
This project deals with processing and coordinating all the ground level
transactional databases in different models, to their DLX(Digital Logistex)
which is the company warehouse management system, sufficed using Oracle
Data Integrator. Dashboard reports and analysis are developed using
Business Objects which mainly address the key performance indicators, and
serve all root cause analysis.
Responsibilities:
. Interacted extensively with users in gathering and documenting the
requirements, analyzing, designing, developing and implementing the
systems, as well consulting with technical and functional teams in
resolving through requisite solutions
. Developed PL/SQL procedures, packages, objects, triggers for inserting,
updating, retrieving and validating of data, worked on applications with
TOAD
. Developed the workflow management system using Oracle Workflow in aiding
the understanding and composition of business processes
. Worked on Oracle Data Integrator 10.1.3.4 in composing the Warehouse
Management System in accordance with the business rules supporting BI
within Oracle Portals and using Metadata Navigator
. Engineered the data models using ODI for composing the DLX systems, in
coordinating all applications as well as operational databases
. Worked with varied sources in implementing ODI, ranging from Oracle, SQL
Server, DB2, Hyperion Planning, Essbase, Financial Management, SAP R/3
and SAP ABAP
. Worked with the Designer, Operator and Topology Manager in composing the
structured models and project, as well as security on the target database
. Engineered the complete topology, managed work and master repositories,
created users, profiles and administered rights going on the lines of
security policies using Security Manager in ODI
. Written stored procedures and functions using PL/SQL and also worked and
utilized the services offered by SQL Navigator
. Dealt with various Oracle supplied packages such as DBMS_SQL,
DBMS_UTILITY etc and various custom packages in working out required
corporate applications, exposed to inbuilt functions for monitoring
performance
. Executed SQL *Loader, BCP and Data Pump in performing direct and piped
loading from external tables
. Implemented OA Framework, worked in various corporate systematic projects
in Oracle Applications in OM, GL, AR, AP & CRM
. Designed the front office web application for Order Management using Java
Servlets, JSP, JSTL and Java Script in coordination with Oracle Database
. Designed and generated database objects and Oracle Forms, Reports and
Libraries through Oracle Designer
. Gathered requirements, completed proof of concept and developed the
physical, business and presentation layers in the OBIEE environment
. Developed complex OBIEE reports and dashboards as per the business user
requirements into HR, Financial and Distribution analysis
. Configured OBIEE modules and security as per the company specifications
. Executed PHP scripts for designing the interface for OM and Supply Chain
DB front end
. Extensively worked with UNIX shell scripting, batch scripting as well in
modifying existing UNIX shell scripts accordingly, also worked in
scheduling jobs with Autosys, implemented Oracle Projects in executing
the entire scenario
. Involved in building Unit Test Cases for the above application, as well
in fixing bugs during system testing
. Created and used views for different business needs and also solved
performance tuning issues
. Involved in preparing the documentation for the releases
Environment: Oracle 9i/10g, SQL, PL/SQL, Forms & Reports 6i, ODI 10.1.3.4,
Oracle Apps, OBIEE 10g,Java, J2EE, ERWIN 7, SQL*loader, TOAD, UNIX
Scripting, Autosys 3.0
Client: KeySpan Energy, Brooklyn, NY
Jan' 06 - Aug' 06
Oracle PL/SQL Developer
The Revenue and Statistics project replaced the legacy system that had been
in existence for many years. Phase II was an expansion of the 1st phase and
leveraged dimensional modeling and focused on providing analysis plus
extensive reporting of Customer Usage and Billing information.
Responsibilities:
* Involved in design of MAPS system using ERWIN designer tool, for
Oracle 9i on UNIX, as also creating table components
* Created PL/SQL Procedures, Functions, Packages and Triggers for data
validation, data updating and retrieving of data from data-mart based
on specifications given by the accounting team.
* Involved in database tuning using Oracle Hints, Optimizers and Indexes
for better query performance.
* Created Views and Materialized Views on the tables for data extraction
and restricting the users from entire data access.
* Used Unix KORN Shell Scripting for running nightly and monthly jobs.
* Majorly used utility package for moving the data from tables into flat
files and also many Oracle supplied packages in working out related
functionalities
* Worked in a Java Application development environment in coding the
front end, developed and integrated the web and business components
using EJB, JNDI, Servlets, JSP and JBuilder
* Used Datastage Designer for developing various jobs to extract,
cleansing, transforming, integrating and loading data into RS Data
Warehouse
* Used Datastage Director to schedule running the server jobs,
monitoring scheduling and validating its components
* Used Datastage Manager for managing in editing the repository, as well
defining custom routines and transforms, import and export items
between different datastage systems and exchanging metadata with other
data warehousing tools
* Utilzed Cognos ReportNet as a BI reporting tool in catering to various
corporate wide reports in analyzing and improving performance, sales
and related statistical metrics
* Chalked out the requisite corporate metadata models using the Cognos
Framework Manager, as well worked extensively with Query Studio,
Analysis Studio and Report Studio
* Migrated from Cognos series 7 to Cognos ReportNet using the standard
techniques, and utilized complex Cognos functionality in catering to
the requirements
Environment: Oracle 9i/10g, SQL, SQL*Plus, PL/SQL, Oracle Forms & Reports,
Datastage 7.0, Cognos ReportNet, UNIX, Windows Server 2003, Java, J2EE,
TOAD, SQL Loader
Client: Larsen & Toubro Infotech Ltd, Chennai, India
Nov' 03 - Dec' 04
Software Engineer, Oracle Developer
In part of the BI team, providing corporate business analysis and
enterprise reports integrating operational sales, marketing, customer,
inventory and materials in the process. Oracle development and Cognos being
the subject in getting to solution oriented analysis and performance
metrics.
Responsibilities:
. Extensive interaction with the functional databases
. Involved in the monitoring as well as the maintenance of the company
data
. Responsible for writing PL/SQL packages for dealing corporate tasks
. Developed PL/SQL procedures, packages, objects, triggers for
inserting, updating, retrieving and validating of data.
. Developed Pro*C front end programs in incorporating Oracle Program
units
. Developed control scripts using SQL *Loader for populating functional
databases
. Creation of Catalogs & Complex Cognos Impromptu & IWR Reports using
JavaScript
Environment: Oracle 8i/9i, SQL, PL/SQL, Pro*C, SQL *Loader, TOAD, Cognos
Series 7 Version 3, Cognos Impromptu, Cognos PowerPlay
Client : Zen Securities Ltd, Hyderabad, India
Apr '03 - Nov' 03
Oracle Programmer
Zen Securities Ltd is one of the leading stock broking company with an
extensive network of over 100 trading terminals. ZSL provides a wide range
of financial/stock market services to their clients.
Responsibilities:
. Collecting the data from clients who are investing the money in shares
through the ZSL and upload the data into the database.
. Installation of oracle 8i/9i on windows 2000 Server/NT and supporting
back office software's.
. Regulating tradable limits of the clients based on the margin and
ledger balances.
. Created Logins, Users, permissions and managed Security issues of the
Server and Databases
. Maintain the trading terminal and providing online backup for all
terminal transactions.
. Verifying the client financial statements, holding share details using
the SQL based Centura Software
. Provide day-to-day maintenance/support for application software's, as
also preparing daily and weekly reports to the top management
Environment: Oracle 7/8.x, SQL, XML, Windows 2000 server, MS-Excel, MS
Office, TCP/IP
EducatioN/ Certifications:
. Masters of Sciences, Business Administration, University of Memphis.
. Bachelor of Technology with specialization in Electronics &
Communications, Jawaharlal Nehru Technological University, India.
. Certifications: Oracle Certified Associate(version 9i)
. IT Work Shop at IIIT, Hyderabad, in which courses covered were
Microsoft Word, Microsoft Excel, Microsoft Power Point, Business Plan
Basics, Computer Hardware & Linux Work Shop, and Object Oriented
Programming with C++.