Project Manager
Resume:
Venu Vinod Arety
858-***-**** cell
858-***-**** evening
**********@*****.***
http://www.linkedin.com/in/venuarety
Professional Summary
. 10 years of extensive experience in software life cycles, including
system analysis design and testing with a Bachelor of Engineering Degree
in Computer Science.
. Seasoned in Business User Interaction, Business Process Analysis,
Requirements Gathering, Analysis and Feasibility Studies, with strong
focus on quality & customer satisfaction.
. Architect in designing and maintaining corporate data warehouse.
. Diverse expertise in different roles like Project Manager, Project Lead,
Tech Lead, Developer etc.
. Cognos Certified Professional in all levels of ReportNet & Cognos BI
Series Suite of tools.
. Successfully implemented Dashboard Projects for different modules &
business needs accessed by management users throughout the organization
in different time zones.
. Successfully dealt with complex business problems, that required in-depth
analysis of the problem and its impact on various systems and devising &
negotiating an agreed upon IT solution, across cross-functional teams.
. Extensive work experience on OLAP cubes creation, Data Modeling, Cognos 8
BI\ ReportNet reports and Centralized Portal administration.
. Worked extensively on Cognos Business Intelligence Tools for over 8
years. Implemented End to End Cognos Reporting Solutions for Fortune 500
clients.
. Experience in COGNOS BI Series 7 Tools using Cognos Impromptu
7.3/7.1/7.0/6.1, and Power Play 7.3/7.1/7.0/6.1.
. In depth knowledge of OLAP solutions and strong knowledge in RDBMS.
. Involved in a data migration and up gradations between different versions
of Cognos.
. Used best practices to support the reporting activities. Adept in using
performance tuning and optimization techniques such as load balancing and
partitioning.
. A highly motivated professional with excellent customer facing and
problem solving skills who is able to work on own initiative under
minimum guidance.
. Good communication skills with good team spirit.
Technical Expertise
BI Tools Cognos 8.3 BI, ReportNet 1.1MR3, Framework Manager,
Query Studio, Report Studio, Cognos Connection,
Impromptu 7.3/7.1/7.0/6.0, Impromptu Web Reports
7.1/7.0/6.0, Upfront, Notice Cast 7.0, Power Play
Transformer 7.3/7.1/7.0/6.0, Power Play Enterprise
Server, Access Manager, BusinessObjects XI R2/6.x,
Databases Oracle 10G\9x\8x\7x(Toad 8.0), SQL Server 2000, MS
Access, TERADATA, DB2
Operating Systems Windows NT,2000, Unix
Languages SQL, PL/SQL, COBOL, Visual Basic 6.0, Core Java, C,
C++
Certifications
. Cognos ReportNet Product User.
. Cognos ReportNet Product Professional - Reporting Track.
. Cognos ReportNet Product Professional - Modeling Track.
. Cognos ReportNet Product Professional - Administration Track.
. Access Manager Administration.
. Impromptu Reporting Product User & Professional.
. Cognos Web Administration training program Certification from Cognos
Corporation in UK.
. Certified DB2 database professional.
Education
Degree University Year of Passing
B.S Mumbai University (2000)
(Computer
Science)
VISA Status: EAD
Professional Experience:
1. Project Name : MDM - Master Data Management Reporting
Client EA(Electronic Arts)., Redwood City California U.S
Role BI Architect
Duration (06/2009) - Till Date
Environment Software Tools: Cognos BI 8.4, Teradata, Informatica (for
(with skill ETL).
versions) Database :TERADATA
O/s :Windows 2000, UNIX
1
Project Description
Electronic Arts Inc. (EA develops, markets, publishes and distributes video
game software and content that can be played by consumers on a variety of
platforms, including video game consoles, such as the PLAYSTATION 3,
Microsoft Xbox 360 and Nintendo Wii; personal computers (PCs), including
the Macintosh; handheld game players, such as the PlayStation Portable
(PSP) and Nintendo DS, and wireless devices, such as cellular phones and
smart phones, including the Apple iPhones.
Contribution/Role:
. Requirements gathering for complex MDM reports.
. Coordinate work assignments between onsite & offshore teams.
. Created technical specifications, design documents & test plans.
. Organize design review and UAT's
. Created Framework Data Models with business layer, for complex
reporting, with implementation of row level data security.
. Developed complex reports as per the Business specifications.
. Created user friendly ad hoc reporting packages for business user's ad
hoc querying capabilities.
. Conducted User training & UAT with business users.
2. Project Name : D&R - Blue Core Data & Reporting
Client BCBS(Blue Cross Blue Shield)., Quincy Massachusetts U.S
Role Tech lead
Duration (11/2008) - Till Date
Environment Software Tools: Cognos BI 8.3, DB2, Informatica (for
(with skill ETL).
versions) Database :DB2
O/s :Windows 2000, UNIX
1
Project Description
Blue Cross Blue Shield of Massachusetts, is a medical Insurance company in
the health care domain, the project needed Monitoring all code development
and creating system specifications frequently & development of critical
reports for their billing and enrollment domains for top management
decision making.
Contribution/Role:
. Requirements gathering for complex billing and enrollment reports.
. Created technical specifications, design documents & test plans.
. Created Framework Data Models with business layer, for complex
reporting.
. Developed complex reports as per the Business specifications.
. Onsite offshore QA team coordination.
. Created user friendly reporting packages for business users adhoc
querying capabilities.
. Conducted User training & UAT with business users.
6
3. Project Name : Orbit - Sony Direct Business Intelligence
(SDBI)
Client Sony Electronics., San Diego California U.S
Role Technical Architect
Duration (03/2008) - (11/2008)
Environment Software Tools: Cognos ReportNet 1.1 MR3, Power Play
(with skill Transformer 7.3, PPES, Cognos BI 8.2, Oracle
versions) 10G, Sql Server 2000, Share Point Repository,
Informatica (for ETL).
Database :Oracle 10G, Sql Server 2000
O/s :Windows 2000, UNIX
1
Project Description
Sony Electronics e-Solutions Company is the direct sales portal to end-user
customers through channels such as the Internet, contact centers, and
retail stores.
e-Solutions has the business need for a data aggregation and comparison
toolset that allows business groups to conduct analyses with a consistent
data set across the organization.
The purpose of the Sony Direct Business Intelligence (SDBI) project is to
create a world-class reporting environment that will enable Business Groups
to make better and faster decisions by supplying all e-Solutions Business
Groups with consistent, accurate, timely and complete transactional
business intelligence information.
Contribution/Role:
Gathering requirements from Business users for the development of
complex reports as well as adhoc reports based on the requirements.
. Created system requirements and design documentation.
. Installing cognos 8.1 on dev, Stage and QA servers.
. Configuring Power play Enterprise Server for cubes to be Integrating
within cognos 8.1 interface
. Creating Framework Data Models with business layer, for complex
reporting. Using all Data warehouse concepts, calculations and
security constraints with proper relationships and cardinality
established between the facts and dimensions.
. Created QA reports and complex queries for data validation and
reconciliation from different data sources.
. Created simple list prompted reports and complex reports with multiple
queries.
. Created dashboards with graphical representation of data aggregated
from different levels.
. Created Materialized views and partitioned aggregated facts for
performance tuning of complex reports.
. Creating complex cubes, for seeing business data, from different
perspectives by slicing and dicing the data.
. Creating cogons scripts using macros and SDK for automation of cube
builds, with incremental and full builds concepts.
. Upgraded cognos 8.1 to cognos 8.3 on development, Stage and production
servers.
. Follow quality standards and best practices for the development tasks.
. See to that we stick to delivery deadlines.
4. Project Name: Corporate Dashboards.
Client International Finance Corp., Washington DC U.S
Role Architect
Duration (11/2007) - (03/2008)
Environment Software Tools : Cognos Series 8.2, Power Play
(with skill Transformer 7.3, PPES,, Oracle 10G
versions) Repository: Informatica (for ETL).
Database :Oracle 10G
O/s :Windows 2000, UNIX
1
Project Description
IFC is a member of the World Bank Group. IFC provides loans, equity,
structured finance and risk management products, and advisory services to
build the private sector in developing & IDA countries.
With the introduction of new reporting software(Cognos 8) in IFC, Cubing &
reporting group created a POC to demonstrate the capabilities of the tool
with its graphical representations of IFC's key financials that most of the
business were very keen & interested and for them to make decisions.
4
Contribution/Role:
. Business Analyst in gathering requirements from Business users,
created function specifications and all necessary documents for the
development of Dashboards.
. Creating the prototype dashboards which include IDA Dashboard,
Operational Dashboard, Department dashboard & Country dashboard, this
has capabilities to drill through to get information at levels as low
as institution, project as well as tranche.
. Constantly guided the Operational Data Store team in creation of the
Star schema Dimensional model, with best practices
. Creating functional & technical specs for the Dashboards.
. Working closely with the data modelers and providing them with
queries, those are required to develop the facts & dimensions in the
data model.
. Creating test case documents to verify the correctness of the data as
per the business requirements.
. Defining the data refresh policy and how often the data in the data
mart & cubes needs to be refreshed.
. Creating the Framework business & Transformer models with proper
hierarchies, relationships and cardinality established between the
facts and dimensions, this model is the base for development tasks.
. Follow quality standards and best practices for the development tasks.
. Conducting peer review to maintain data accuracy & consistency.
. Creating checklist documents to be followed by all to maintain
consistency and follows corporate reporting standards.
. See to that we stick to delivery deadlines.
. Conducting UAT with Business users, for the sign off of the project
work completed.
. Conduct User training for hands on usage for the new reports & cubes
created for the users.
. Creating at a glance tip sheets for quick reference of the usage steps
for any users.
5. Project Name: IFRS-Internal Reporting.
Client International Finance Corp., Washington DC U.S
Role Project Manager
Duration (09/2007) - (03/2008)
Environment Software Tools : Cognos ReportNet 1.1 MR3, Power Play
(with skill Transformer 7.3, PPES, Cognos Series 8.3, Oracle
versions) 10G, SAP
Repository: Informatica (for ETL).
Database :Oracle 10G
O/s :Windows 2000, UNIX
1
Project Description
IFC is a member of the World Bank Group. IFC provides loans, equity,
structured finance and risk management products, and advisory services to
build the private sector in developing & IDA countries.
IFC currently complies with US Generally Accepted Accounting Principles (US
GAAP) and has chosen and committed to adopt the International Financial
Reporting Standards (IFRS) by FY09 with a target commencement in Quarter 1.
For publishing FY09 financial reports in IFRS format.
6
Contribution/Role:
8 Created assessment documents which identifying the impact due to the IFRS
changes.
9 Maintain the project plan and keep track of the estimated deadlines to
ensure prompt delivery of the project work.
10 Gathering requirements from Business users for the development of
complex reports as well as adhoc reports based on the requirements.
. Creating functional & technical specs for the new requirements &
enhancements.
. Working closely with the data modelers and providing them with
queries, those are required to develop the facts & dimensions in the
data model.
. Creating test case documents to verify the correctness of the data as
per the business requirements.
. Defining the data refresh policy and how often the data in the data
mart & cubes needs to be refreshed.
11 Creating the Framework business & Transformer models with proper
hierarchies, relationships and cardinality established between the
facts and dimensions, this model is the base for development tasks.
12 Developing & Assigning development and peer review tasks to offshore
team of developers and updating the status of the development to my
reporting manager on regular basis.
13 Follow quality standards and best practices for the development tasks.
. Conducting peer review to maintain data accuracy & consistency.
. Creating checklist documents to be followed by all to maintain
consistency and follows corporate reporting standards.
. Creating scripts for refreshing the cubes in production environment,
the scripts are driven by utility table, where the cycle time (i.e.
Monthly, Bi Monthly or daily) is defined, created separate scripts for
incremental cube builds, created batch files that trigger the cube
builds.
14 See to that we stick to delivery deadlines.
. Conducting UAT with Business users, for the sign off of the project
work completed.
. Conduct User training for hands on usage for the new reports & cubes
created for the users.
. Creating at a glance tip sheets for quick reference of the usage steps
for any users.
6. Project Name : MIS (Management Information Systems)
Client International Finance Corp., Washington DC U.S
Role Production Support Lead
Duration (12/2006) - (11/2007)
Environment Software Tools : Cognos ReportNet 1.1 MR3, Power Play
(with skill Transformer 7.3, PPES, Cognos Series 8.2, Oracle
versions) 10G
Repository: Informatica (for ETL).
Database :Oracle 9i
O/s :Windows 2000, UNIX
1
Project Description
IFC is a member of the World Bank Group. IFC provides loans, equity,
structured finance and risk management products, and advisory services to
build the private sector in developing countries
The Management Information System (MIS) is IFC's single authoritative
source for management information supporting decision making in IFC. It
provides IFC management and staff with reliable business information at
appropriate levels of detail. MIS allows tracking of IFC's business
activities by offering a mechanism for viewing key financial and
operational information and allowing access to a wide array of standard
reports, cubes and ad-hoc queries.
IFC Plans for the future are to convert all the existing reports to Cognos
8 and continue to develop new reports as requirements become clear and
maintain existing reports for currency and accuracy. Changing systems and
data regularly means reports require small changes and in some cases
redesign
Contribution/Role:
16 Created assessment documents which identifying the impact due to the
Migration.
17 Maintain the project plan and keep track of the estimated deadlines to
ensure prompt delivery of the project work.
. Running the migration utilities to convert the catalogs into FM
models.
. Documenting the Lessons learnt during the migration tasks.
. Creating test case documents to verify the correctness of the data as
per the business requirements & existing reports.
. Testing the pre and post migration performance of reports.
. Creating cases with Cognos support professionals to get key issues
resolved for the bugs that were encountered during migration.
18 Developing & Assigning development and peer review tasks to offshore
team of developers and updating the status of the development to my
reporting manager on regular basis.
19 Follow quality standards and best practices for the development tasks.
. Conducting peer review to maintain data accuracy & consistency.
. Creating checklist documents to be followed by all to maintain
consistency and follows corporate reporting standards.
20 See to that we stick to delivery deadlines.
. Conducting UAT with Business users, for the sign off of the project
work completed.
. Conduct User training for hands on usage for the new environment
reports & cubes created for the users
. Form the Support team that will take care of the post migration issues
and fixes that will be required.
. SLA's were defined for the issues based on the priorities and were
followed as per the plan.
7
7. Project Name : Orbit - Sony Direct Business Intelligence
(SDBI)
Client Sony Electronics., San Diego California U.S
Role Cognos BI Administrator
Duration (02/2006) - (12/2006)
Environment Software Tools: Cognos ReportNet 1.1 MR3, Power Play
(with skill Transformer 7.3, PPES, Cognos BI 8.2, Oracle
versions) 10G, Sql Server 2000, Share Point Repository,
Informatica (for ETL).
Database :Oracle 10G, Sql Server 2000
O/s :Windows 2000, UNIX
1
Project Description
Sony Electronics e-Solutions Company is the direct sales portal to end-user
customers through channels such as the Internet, contact centers, and
retail stores.
e-Solutions has the business need for a data aggregation and comparison
toolset that allows business groups to conduct analyses with a consistent
data set across the organization.
The purpose of the Sony Direct Business Intelligence (SDBI) project is to
create a world-class reporting environment that will enable Business Groups
to make better and faster decisions by supplying all e-Solutions Business
Groups with consistent, accurate, timely and complete transactional
business intelligence information.
Contribution/Role:
3 Giving estimates for the development and deployment of the deliverables
list for the applications undertaken by me for the development in an
Onsite Offshore model.
4 Enhancements of the existing Frame work model in the Cognos Frame work
manger with proper relationships and cardinality established between
the facts and dimensions, which would form the base for developing
the Business model.
5 Gathering requirements from Business users for the development of complex
reports as well as adhoc reports based on the requirements.
6 Assigning development tasks and, peer review tasks to offshore team of
developers and updating the status of the development to my
reporting manager on regular basis.
7 Follow quality standards and best practices for the development tasks.
8 See to that we stick to delivery deadlines.
8. Project Name : FIFAA (Financial Forecasting And Analysis
Application)
Client Citigroup., Dusseldorf Germany
Role Business Analyst
Duration (01/2006) - (02/2006)
Environment Software Tools: Cognos ReportNet 1.1 MR2, Power Play
(with skill Transformer 7.3, PPES, Upfront, Sql Server 2000.
versions)
Database : Sql Server 2000
O/s :Windows XP
1
Project Description
TI Fincon management of Citigroup is looking to improve the monthly
financial reporting system to provide the following benefits:
FIFAA Application is designed to enable the users to maintain Budget,
Midyear and rolling Forecast for TI Fincon. Sets of standard report are
part of FIFAA Application and have been designed for supporting users and
cost code managers mainly for the daily work and maintaining changes of
data and the Forecast processes.
During project initiation the original plan to run FIFAA on Cognos as a
platform was realized, the functionalities desired were
9 Multi dimensional cubes for flexible report generation with all available
report criteria provided by FIFAA database.
10 Platform for creating the Management Reporting Packs after significant
changes have been established in the database.
11 Drill down ability, starting from top level to lowest level available in
database (single record)
12 Easy creation of new resident Management Reporting Packs after TI
Management has decided to change existing report structures.
13 Tool for creation of ad-hoc reports (like Cognos Power Play)
14 Illustration of Management Structure in EMEA TI or other Businesses,
participating FIFAA
15 Combination of tabular report and three dimension diagrams for enhanced
reporting.
16 Easy download to different file formats like Excel, PDF, etc
Contribution/Role:
On the role of a Business Analyst, my primary goals were:-
. To understand the business requirements,
. Developed a prototype Model Cube based on the requirements gathered
form various users and super users of Citigroup.
. Gave presentations to the Users during different phases of the
prototype development, and gathered more enhancements and requirements
from the users.
. Prepared the BRD document, verified and approved by the business
users.
. Estimated the effort that will be required for the project completion.
8
9. Project Name : Supply Chain Data Warehouse Technical
Refresh (SCDW)
Client GlaxoSmithKline (GSK)., Boston Manor U.K
Role Tech Lead
Duration (06/2005) - (01/2006)
Environment Software Tools : Cognos ReportNet 1.1 MR2, Power Play
(with skill Transformer 7.3, PPES, Cognos Series 8 Beta
versions) Version, Microstrategy 7, Oracle 9i, Sql Server
2000, VSS Repository, Data Stage (for ETL).
Database :Oracle 9i, Sql Server 2000
O/s :Windows XP, UNIX
1
Project Description
GlaxoSmithKline (GSK) has a large Supply Chain environment with many OLTP
applications running for different subject areas like the SOLS (Stock Out
Low Stocks), TIMS (Third Party Contractor Information Management System),
INVENTORY Performance, PSR (Product Sourcing Requests), FORCASTING etc. The
scope of the existing project Supply Chain Data Warehouse Technical Refresh
(SCDW) involves the migration of the reporting platform from Microstrategy
to Cognos. Therefore the deployment considerations are as following:
. User training on Cognos platform.
. Changed user interface.
. Changed reporting functionality.
. Migration of ETL process from PL/SQL scripts to DataStage (ETL tool)
platform.
. Data model has to be re-modeled to be based on dimensional modeling
(this does not apply for applications running on SQL server)
Contribution/Role:
. Giving estimates for the development and deployment of the
deliverables list for the applications undertaken by me for the
development.
2 Develop the Frame work model in the Cognos Frame work manger with proper
relationships and cardinality established between the facts and
dimensions, which would form the base for developing the Business
model.
3 Develop the Business model by coordinating with the Business user for
understanding the business. This business model forms the base for
the development of complex reports as well as the business model is
published to the Business users for their adhoc reporting
requirements using the query studio.
4 Assigning development, peer review tasks to the developers and updating
the status of the development to my reporting manager on regular
basis.
5 Follow (IQMS), quality standards and best practices for the development
tasks.
6 See to that we stick to delivery deadlines.
10. Project Name : Procurement Data warehouse
Client Johnson & Johnson Ltd., New Jersey U.S
Role Developer
Duration (02/2005) - (06/2005)
Environment Software Tools :Cognos ReportNet 1.1, Oracle 9i, Novell
(with skill Netware, Designer 2k/6, Tivoli Server.
versions) Database :Oracle 9
O/s :Windows NT, UNIX
1
Project Description
Currently, Johnson & Johnson spends 50% (~$20 Billion) of its revenue with
external suppliers. Two-thirds of that is spent with non-stock suppliers
(~$12 Billion). The Procurement Global Data Warehouse (GDW) initiative is
a multi-generational project that will provide more complete access to
worldwide spend data. The project will provide a platform for Johnson and
Johnson's procurement and sourcing professionals to identify and develop
spend leveraging opportunities and sound sourcing strategies.
Long term, the creation of a data warehouse with standardized
data will enable the elimination of the Sourcing Reporting Tool
(SRT), EZ Report the North American Reporting database, and some
current Ariba reports.
Informatica 7.0 was used for as an ETL tool for the development
of the Oracle procurement Data warehouse and Cognos ReportNet 1.1
was used as reporting tool for generation of reports using the
Procurement Data warehouse.
5
Contribution/Role:
8 Analyzing the Business of the J&J based on the Procurement Data
warehouse, for the generation of reports that meet the specific
business requirements.
. Generation of report mockups based on the existing sample data
provided in the development server for the approval of the
mockups by the Business users and for going a head with the
development of the reports using Cognos Report net Version 1.1.
. Developing of the reports based on the specification and report mockup
documents and performing Unit testing of them before going to for peer
reviews.
. Talk to the Business users in teleconferences daily, to understand the
business related issues faced during the development of the reports
. Providing value added features in the reports like addition of the
optional fields into the reports based on the user selections,
suggesting useful tips to the users on request for addition
functionalities into the reports for the ease of access of the reports
to the business users
. Preparation of documents (Checklists for Peer reviews, UTP's etc
for maintaining quality.
11. Project Name : Data warehouse- Support & Enhancements
Client BUPA Ltd., Hounslow U.K.
Role Developer
Duration (07/2004) - (02/2005)
Environment Software Tools :Impromptu Web Reports, Power Play
(with skill Enterprise Server, Upfront Administration
versions) Server, Cognos Impromptu 7.1 MR3, Cognos Power-
Play/ Transformer 7.1 MR3, Oracle 9i, Novell
Netware, Designer 2k/6, Tivoli Server.
Database :Oracle 9
O/s :Windows NT, UNIX
Project Description
2
The client Bupa has an existing Data warehouse setup, there are
around 50 cubes, and around 1000 IWR and Power play reports
distributed over the web through upfront server with all the User
class security taken care with the help of Access Manager. This
project needs to support the existing cubes and reports, enhance
the existing cubes and reports and also develop new reports and
cubes based on the user requirements, project includes gathering
of data for the requirements from the users, explaining Business
users the features and benefits of using Cognos as their
reporting tool, and preparation of documents and user guides for
the ease of use of the existing and new developments in
upfront/Cognos environment, project also needs taking to the
potential customers of the reports and gather requirements for
new developments and implement them in the production
environment.
Contribution/Role:
6 Analyze the existing Data warehouse, cubes reports and Metadata available
for production support of the same.
7 Preparation of Metadata repository using Designer 6 and Designer 2000 and
use the repository to develop the Metadata catalog and Impromptu
reports for the better understanding of the existing data
warehouse for the Business users.
8 Handling the Production support issues logged in the Tivoli helpdesk and
meets the SLA for resolving the issues.
9 Talk to the potential customers using the Data warehouse and gather
requirements for the any new reports or cubes to be developed.
10 Educate the Business user about the potential use of the tool of Cognos
series 7.1 to gather more business.
11 Preparation of IWR and PPES Audit cubes to analyze the usage of the
reports and cubes and based on the analysis enhance the cubes
and reports by the statistics available.
12. Project Name : eFCS
Client MATTEL INC, Los Angeles California U.S.A
Role Team Lead
Duration (11/2003 to 07/2004)
Environment Software Database :Oracle 9, MS-Access
(with skill Tools : Cognos Impromptu 7.0, Cognos Power- Play
versions) 7.0, Informatica 5.0, Sybase OLTP data, Novell
Netware, J2EE.
O/s :Windows 2000
Project Description
This project needs to convert and enhance the existing FCS (Field Clearance
System) with the client (Mattel, Inc) to a web based eFCS system, using all
the latest technologies (J2EE front end, Oracle 9i back end, Informatica
used for ETL, Cognos for OLAP modeling and reporting).
FCS application tracks and analyses the product returns data and
facilitates generation of credit memos to the customers. In last 4-5 years,
this application has resulted in substantial savings to Mattel, Inc. by
reducing the quantity of product returns from the Customers. Credits to the
customer directly come out of the profits of the company and therefore
lesser returns have translated into higher profits for Mattel.
Contribution/Role:
13 Analyzing the existing FCS system, to come out with the business data
flow from the existing MS-Access and Sybase databases.
14 Preparation of the reusable complex transformations, using update
strategies, Expression, Aggregator, Filter, Joiner etc.. In
Informatica.
15 Creation of Mapplets for transferring data from sources to staging and
then from staging to Oracle database.
16 Creation of Staging tables according to the data warehouse architecture
of the client.
17 Preparation of catalogs, cubes for generation of reports.
18 Preparation of Impromptu reports existing and new reports based on the
input given from client.
13. Project Name: Cognos Report Generation
Client BASF CORPORATION, USA.
Role Developer
Duration (09/2002 to 11/2003)
Environment Software Database :Oracle 8, MS-Access
(with skill Tools : Cognos Impromptu, Cognos Power- Play,
versions) SAP OLTP data, Novell Netware
O/s :Windows 2000
Project description:
BASF Corporation, in the NAFTA (North American Free Trade Agreement)
region, currently has more than one database and multiple applications from
which it receives data, namely SAP, People Soft, MS Access and various
other applications. BASF has 4 schemas (CATR3, TSP, EDW, and CSIS) Project
is spanned across three phases. Preparing Report Specification
Documentation for Canned and Ad-Hoc Queries (Mostly from SAP systems).
Develop ETL Flow Documents (Extract Jobs from OLTP to Warehouse) for the
identified Jobs. Report development using Impromptu.
Role
19 Involved in replicating the database schemas, the view and table scripts
of the client database schemas for
20 Ease of development of the reports,
21 Preparing the catalogs with all the joins, calculations, folders and
security constraints.
22 Development and testing of reports on local machines, as well as on
remote machines thru Novell Netware and VPN connectivity.
23 Performance tuning in case of low-speed access of data from database.
24 Development of reports in Cognos impromptu, based on the specification
document, which are prepared after analyzing the reports either
canned or Ad-hoc Reports.
25 Analyzed the MS-Access reports and SAP reports.
26 Developed the Ad-hoc Online reports based on the SAP R/3 system by
connecting to the remote Business warehouse through VPN or Novell
Box Connectivity.
27 Creating complex reports in Impromptu using Grouping, Calculations,
Summaries, Filters, Picklists, Hot files, etc
28 Creating strategies for hot files and pick lists, implementing reusable
pick lists for set of reports.
29 Copying remote catalog and managing the catalogs.
30 Managing remote connections on Access Manager.
31 Testing as per client scripts.
32 Meeting the delivery deadlines.
33
14. Project Name: PayLink System.
Client BASF CORPORATION, USA.
Role Analyzer/Tester
Duration (06/2001 to 09/2002)
Environment Software Database :Oracle 9i
(with skill Tools : VB 6.0 /Cobol /Telon /JCL
versions) O/s :Windows 2000
Project description:
BASF Corporation has a legacy system for its timecard management, which is
running on mainframes. The mainframes application is used to enter and
store employees' timecard details and then use JCL programs to run batch
jobs and generate & submit reports (called ZT Cards and time and attendance
audit reports) via FTP to BASF's HR/Payroll vendor, Mellon HR Solutions.
The current mainframe application is used by approximately 20 BASF
locations, including Mt. Olive. Now in the proposed application, a
centralized database will host all this information and users at different
sites will use a GUI based desktop applications to furnish the
corresponding information.
Contribution/Role:
Analyzed the code in Cobol, JCL, Telon, for the development of the new GUI
project as per requirement, and documented the logic for the current system, prepared the normalized data model based on the existing VSAM files.
Finally tested the application to perfection.
15. Project Name: CUSTOMER REWORK SYSTEM
Client LARSEN & TOUBRO LIMITED
Duration (06/2000 to 06/2001)
Environment Software Database :Oracle 9i
(with skill Tools : VB 6.0.
versions) O/s :Windows 2000
Project description:
This project involved writing software for Different Departments, who deal
with the different stages of the rework which the customer has placed or
which the concerned inspecting engineer has found out while
Contribution/Role:
Developer working, mainly on production support issues.
[pic]
Contact this candidate