Docstoc

Resume

Document Sample
Resume Powered By Docstoc
					                                                         1125 Route 22 West, Bridgewater, NJ 08807
                                                     Phone (908) 429-8008 Ext 392, Fax (908) 429-8005
                                                                Email: Pankaj.Shah@cyberthink.com
                                                                          Contact: Pankaj Shah
                                                                               www.cyberthink.com
                                               Resume

SUMMARY OF QUALIFICATIONS:
 Over SIX Years of experience in the field of Information Technology with an emphasis on Business
  Intelligence tools using Business Objects 5.1 (Supervisor, Designer, Reporter, Broadcast/Agent, Data
  Miner) BOSDK, WebIntelligence2.6, WEBI SDK, Reporting tools and Business objects
  6.0(Application Foundation, Acta’s Data Integrator, Web Intelligence Dash Boards) and web,
  Performance analysis and Application Programming.
 Extensive experience on Business Objects 5.1/6.0 including associated Server Products (Web
  Intelligence, Broadcast Server etc.) with Data warehouse.
 Experience in designing and developing the “Universe” (business view of the database), developing
  canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO
  activities.
 Experienced all the Products of Micro Strategy Product Suite namely Micro strategy Intelligence
  server, Micro Strategy Architect, Micro strategy Administrator, Micro strategy Agent, Micro strategy
  Web, Micro strategy Narrowcast Server and Micro strategy Transactor.
 Handled responsibilities of design, creation and maintenance of databases for Data Warehouse projects.
 Extensive experience in Visual Basic and writing Addins/Macros using VBA.
 Experience in integration of various data sources like SQL Server, Oracle, Sybase, MS access and Flat
  files into the staging area.
 Extensive experience in integration of Target Data sources like Red brick, Teradata, Oracle, and DB2
  UDB etc.
 Worked with Business Users to analyze the business process and made necessary changes to schema
  objects to cater their reporting needs.
 Expertise on MS Windows NT 4.0/3.51, MS Windows 95/98/2000/XP, SQL, PL /SQL, T-SQL,
  OLTP, OLAP, Visual Basic 6.0, Java 1.2, ASP, SQL Profiler, ODBC, OLEDB, Windows NT
  Server, Unix/Linux, Shell Scripting, Erwin, ER Studio, Microsoft Internet Information Server
  (IIS) 5.0, Exchange Server 5.0, Microsoft Site Server 3.0/4.0 Commerce Edition, Microsoft
  Transaction Server (MTS) 2.0, MS Word 2000, MS Excel 97/2000 and MS Access 97/2000.
 Microsoft Certified professional in Visual Basic and SQL Server.

TECHNICAL SKILLS:
Databases:        Oracle 9i/8i/8.0/7.x, MS SQL Server 2000/7.0, MS Access, Sybase SQL Server,
                  DB2 UDB, Teradata.
OLAP & Reporting: Business Objects 5.1(BO SDK, WISDK, Web Intelligence 2.5/2.6).
                  Business Objects 6.0(Application Foundation, Acta’s Data Integrator, Web
                  Intelligence, Dash boards).
Languages:        Visual Basic 5.0/6.0, ASP, Java, Jsp, C, C++, SQL, PL/SQL, T-SQL, HTML, XML,
                  XSLT, Java Script.
Data warehousing: Informatica 5.1.
Data modelling:   Erwin.
Other Software:   MS Word 97/2000, MS Excel 97/2000, MS Access 97/2000, TCP/IP.
Environment:      MS Windows 2000/NT/98/XP, UNIX, MSDOS.

PROFESSIONAL EXPERIENCE:
Jul ‘03 - Present                                                                      AutoDesk Inc
Sr.Business Objects Developer                                                          Manchester, NH

                                              Pages 1 of 7
Responsibilities as a developer understand the database structure. Developed many standard reports using
Business Objects and Web intelligence. This application (reports) is accessed by all users of AutoDesk in
USA and through out the World through Web and Business Objects Client. Data is loaded to a central
database from existing operational databases. Was involved in all the phase of developing universes within
the organization.

Responsibilities:
 Interacted with the Users and Business Analysts to find the requirements. Involved in Installation and
   Configuration of all Components of Business Objects.
 Involved in setting privileges to different User Groups Coordinating with Supervisor and DBA using
   Supervisor Module.
 Designed new Universes and modified the existing Universes based on the report requirements.
 Use of Designer Module to implement Universe, Joining the Tables, Create Prompts and queries,
   Parsing the Objects, apply Contexts and Alias Tables to remove cyclic dependencies.
 Used Store Procedure as Data provider to retrieve data from scheduled tables and complex queries.
 Tuned the queries to improve the Performance of the existing reports for various functional areas.
 Used VBA Procedure as Data provider to prompt the user to enter values and send it as input to Store
   Procedure.
 Analyzed reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail. Creating the reports
   from Excel files using Business Objects thru Personal data files.
 Converted the reports to Text File format as per the User requirement Using Business Objects 5.1
   Version.
 Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the
   reports using complex queries.
 Generated the Business Objects Reports using the universe as the main Data providers and writing the
   complex queries including Sub queries, Unions, Intersect and Aliases.
 Created User Objects including Dimensions, Details and Measures. Brought data from a personal data
   file into BO and combine it with data from a BO Universe query.
 Created reports on web using Info View Portal and Web Intelligence, distributed the reports to different
   users.
 Developed web application interface with WebI SDK, JSP.
 Created Dashboards and Scorecards using framework of application Foundation. Used Broadcast Agent
   for scheduling and distributing the documents.

Environment: Business Objects5, Business Objects 6.0(Supervisor, Designer, Broadcast Agent, Web
             Intelligence, Info view, Web Intelligence 6.0), SQLServer, MS Excel, SQL, PLSQL,
             Windows NT/2000,Solaris.

Jan ‘03 - Jun ‘03                                                                            Hotwire.com
Data ware housing consultant (Developer)                                                     CA

Description:Hotwire.com provides services in the areas of domestic/international flights, hotels and rental
cars. A Data Warehouse is built on Oracle using ETL tool Informatica5.1. Reports are generated using
Business objects, Web Intelligence. Hot wire’s e-marketing solutions allow e-businesses to build customer
relationships using a wide spectrum of touch points - email, website, web store and other online and
traditional media. With Hotwire, e-marketers can now easily create and manage e-marketing campaigns and
personalize every customer interaction. The Project involved creating a Data Mart for the Business in order
to provide the Business users with the above answers. Also the project included the Web reporting against
the Hotwire Data Mart developed using Informatica. Flat files were transformed according to the Data
Model of Hotwire Data Mart using ETL tool Informatica and loaded into relational tables.

                                               Pages 2 of 6
Responsibilities:
 Generating the Data Model for the Hotwire Data Mart using Erwin.
 Designing the ETL process using Informatica in order to populate the Hotwire Data Mart using the
   Db2UDB and flat files to Oracle database.
 Created different source definitions to extract data from flat files and relational tables for Hotwire Data
   mart.
 Created different target definitions. Created, modified, deployed, optimized, and maintained Business
   Objects Universes using Designer.
 Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in
   the universe. Setup user profiles, created BCAs for groups, Categories and Channels using Supervisor.
 Configured Client Configuration Assistant to connect to the repository Oracle.
 Created sophisticated Drill Reports and Slice and Dice reports. Configured the Business Objects tools
   for enterprise-wide deployment.
 Developed web application interface with WebI SDK, JSP.
 Scheduled pre-canned reports through Broad Cast Agent Server for distribution and printing. Provided
   training to end users to use various functionalities of Business Objects Documented report parameters,
   fields, and logic used for developing of reports and universe in a word document. Responsible for
   installation of ZABO to the Clients from the server (via) WebI.
 Provided technical assistance/support to analysts, business community and respond to inquiries
   regarding errors, problems, or questions with programs/interfaces. Involved in Designing Star Schemas.

Environment: Oracle8i, SQL Server, PL/SQL, Business Objects5.1, Windows server2000, Db2udb, Sql
             server, WebISDK, Info view, Web Intelligence, Broadcast Agent, Informatica, Erwin, JSP,
             windows2000, Solaris.

Aug ‘02 - Dec ‘02                                                                  Enter   Prise   Banking
Inc
Data ware housing consultant (Developer)                                           MO

Responsibilities as a developer is understanding the database structure and understanding the existing
project workflow. Involving and motivating the team to work together and with in the time frame. Planning
and sharing the work on each team member. This project is a web based marketing tool that allows the
various users to run online reports and research .The existing data on the company Warehouse to improve
their Marketing techniques and to propose new marketing things. This project has four modules 1.Online
Banking 2.Personal Banking 3.Commercial Banking and 4.Mortgage services. I involved in the Mortgage
Services module to build the following reports. Mortgage Qualifier, Mortgage Refinance Analysis,
Mortgage Points, Mortgage APR, Mortgage Loan, and Rent Vs Buy, Mortgage payoff. Used Business
Objects, a reporting tool and Web Intelligence, a web application that is a part of business objects to
accomplish these tasks.

Responsibilities:
 Gathered the requirements from users. Involved Installation and configure the Business Objects
   components on DB2 UDB.
 Designed and Created Universe, Classes and Objects for management system.
 Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
 Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) to overcome the
   problems with database when integrating with BO.
 Development and Deployment of Complex Reports. Used multiple data providers, Union, Intersection,
   minus and Master/Detail, cross tab, Charts.

                                                Pages 3 of 6
   Created Report level variables. Created Templates for standardizing the Structure of our Corporate
    Documents.
   Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Query
    Prompt and Drill filters.
   Secured the data by using Report Bursting. Analyzed the reports using the Drill Through, Slice and
    Dice.
   Created reports on web using Info View Portal and ZABO, distributed the reports to different users.
   Used Broadcast Agent for scheduling and distributing the documents. Trained end users in the
    functionality of the software.

Environment: Business objects 5i, Web intelligence 2.6, DB2UDB, Info view, Windows NT.

Sep ‘01 - Jul ‘02                                                                 National Telematics Inc
Systems Analyst/ Data Warehouse Consultant                                        Woodland Hills CA

Involved in a project to support the Business Objects applications that are in production, administering the
BO activities, and granting the necessary DB access rights and privileges for the BO users. Also, necessary
training is provided to the users in creating the BO reports. BO software upgrading from Version 4.1 to
5.1/WebIntelligence 2.6 was also done successfully as part of the project. Flat files were transformed to
Oracle using the ETL designer tool and loaded into relational tables.

Responsibilities:
 Building the dimensional Model using ERWIN. Involved in Full life cycle design and development of
   Business Objects reporting Applications. Installation of Business Objects and repository Creation.
 Installation of web Intelligence and Broadcast Agent server. Installation of ETL and configuration of the
   Global repository and the local repository.
 Worked heavily with various transformations to solve the slowly changing dimensional Problems.
 Worked closely with the Sales team and gathering the functional requirements and working with the
   project manager to give a high level design and the cost associated with the project.
 Involved in developing Reports using BusinessObjects 5.1.
 Generated the Business Objects Reports using the universe as the main Data providers and writing the
   complex queries including Sub queries, Unions, Intersect and Aliases.
 Created User Objects including Dimensions, Details and Measures.
 Brought data from a personal data file into BO and combine it with data from a BO Universe query.
 Reports were formatted to the users according to the user requirements using Business Objects features
   like Slice and Dice, Drill Down, and Formulas etc.
 Created Master/Detail and Cross Tab reports to view the data in an analyzed way. Scheduled Reports
   using Broadcast Agent and used the Business Objects Server Administration Tool.

Environment: Business Object5, Business Objects Supervisor, Designer, Broadcast Agent, Web
             Intelligence, ETL, Teradata, Oracle8, Oracle 9i, Windows NT/2000, Ervin.

Dec ‘00 - Aug ‘01                                                                            Nike Inc
Data Warehouse Consultant/Developer                                                          Portland, OR

Developed many standard reports using Business Objects, which includes drill down, Full Client and Web,
reports using the ranking, alerter, hierarchies etc., This application (reports) is accessed by all users of
Autonomy in USA through Web and Business Objects Client. Data is loaded to a central database from
existing operational databases. Was involved in all the phase of developing universes within the
organization.

                                               Pages 4 of 6
Responsibilities:
 Installation of Business objects 5.1 and installation of Web Intelligence server version 2.6. Involved in
   Creating Repository, Creating Users and User Groups.
 Designing and developing Universe for reports generation. Created over 80 Classes and more than 300
   objects using inner/outer joins based on user requirement.
 Resolved the loops, cardinalities by contexts and aliases and checked the Integrity of the Universe.
 Exporting the universe to the Repository to make resources available to the users. Created the Reports
   using the universes as the main Data providers and writing the complex queries including Sub Queries,
   Unions.
 Created user objects including Dimensions, Details and Measures. Formatting the Reports to the Users
   requirements using all the requirements in Business objects like Slice and Dice, Drill Down,
   @Functions and Formulas etc.
 Created Master Detail and Cross Tab reports to view the data in an analyzed way. Used the Doc Agent
   server to Schedule and Monitoring the Reports. Involved in 8x5 production Support and gave training to
   the users.
 Extensively involved in writing PL/SQL stored procedures, database triggers. Also carried out
   performance tuning and optimization of critical queries using Explain Plans, Analyze etc.

Environment: Business Objects5.1, Business Objects Supervisor, Designer, Broadcast Agent, Web
             Intelligence, Oracle8.

Feb ‘00 - Nov ‘00                                                                           General Motors
Programmer/System Analyst, GMAC Commercial Mortgage                                         PA

GMACCM is the package developed for the General Motors Commercial Mortgage Corp. The package is to
be deployed within the company Internet site (www.gmaccm.com) and hence would be accessible to the
customers to view their account information over the Internet. The same would also be available on the
company Intranet and the employees can get various reports besides being able to add, modify and delete
information about various customers and accounts.

Responsibilities:
 System Study and Analysis of the existing 2-tier model. Design and development for the n-tier web
   Architecture model. Database design and development.
 Development of GUI using HTML and Visual InterDev 6.0. Developed Scripts using ASP, VBScript
   and JavaScript.
 Development of various COM Components for business logic using Visual Basic.
 Installation, configuration & administration of IIS, MTS, deployed COM components on MTS.
 Used XML parsing for retrieving the data from the COM Objects.
 Designed and Developed reports using VB / Crystal Reports. Implementation, Maintenance and
   testing.

Environment: Visual Basic 6.0, XML, ASP, COM, VBScript, JavaScript, Visual InterDev 6.0, Crystal
             Reports 7.0, HTML, IIS 4.0, MTS, TSQL, Oracle 8.0, Windows 2000, Windows NT.

May ‘99 - Jan ‘00                                                                Fidelity          Finance
Limited
Programmer, Systems Analyst Integrated Financial Services System                         Madras



                                               Pages 5 of 6
This is a client server based Enterprise Resources Solution for the merchant banking industry. The system
consists of over 10 modules covering the various operational areas of a merchant bank. Developed and
Implemented this software product for one of the largest Merchant banking companies in India .I was
involved in development, administration and implementation of different modules like Lease Financing,
Bills Discounting and marketing.

Responsibilities:
 Fine tuning Stored Procedures / Triggers to improve performance which was achieved by removing
   unnecessary temporary tables. Monitoring the usage of Index & Joins in the SQL statements. Also took
   care of Transaction Log Management and Backing up the Databases, adding users, Granting
   permissions, creating databases.

Environment: Oracle7.0, Visual Basic, Windows NT.

Mar ‘98 - Apr ‘99                                                               Global Trust Bank Limited
Programmer, Loan Against Demat Shares (LADS)                                    India

Part of this project is a Multi-tier Intranet application intended to function as a layer over Global Trust
Bank's existing computer-based depository system, BIRDS. LADS have been developed to support the Loan
Advancement and Monitoring operations of the bank with respect to loans advanced against Demat shares. It
includes automating the loan account creation process, maintaining client details (with respect to their
depository accounts, guarantors, other relationships with the bank), details of joint holders, maintenance of
loan accounts, closure of accounts, portfolio evaluation and determination of loan eligibility at the initial
loan request, continued evaluation of portfolio, maintenance of book margins after pledging of securities,
import of loan details from the banking operations system (Bancs2000), export of loan eligibility to
Bancs2000, interface with BIRDS for holdings details, maintenance of scheme parameters, approved
securities lists, and import of daily NSE prices for the purpose of evaluation. Crystal Report Writer was used
for generating reports for MIS.

Responsibilities:
 Involved in requirement analysis, and feasibility study.
 Involved in designing front-end screens using DHTML, JavaScript, database design and Data
   Modeling involved in table design and index creation.
 Involved in designing database interface using JDBC, SQLNET.
 Involved in design and development of Servlets. Used EJB Technology for the Data Servers.
 Used Crystal Reports to generate reports for MIS. Testing and implementation.

Environment: Java Servlets, Applets, EJB, CORBA, JSP, Visual Basic 6.0, Oracle 7.x, Crystal Reports4.6,
             ADO, Netscape Enterprise Server 3.0, Windows NT Server 4.0, Win 98, UNIX - Sun
             Solaris 5.8.

Apr ‘96 - Feb ‘98                                                               Global Trust Bank Limited
Programmer, Fixed Asset Reporting and Managing Systems (FARMS)                  India

FARMS – This is an Internet-based application. Fixed Asset Reporting and Management System handle all
the details of the Assets purchased for the Bank throughout the Country. This project primarily handles the
reports, which are used at Corporate Office. There are various reports like Purchase Orders Capitalized,
Total Capitalization Report, Cost Apportionment Report, Depreciation Report, Statement of Enhancements
and Reductions and many more Reports used by departments such as, Planning and Finance, Corporate
Affairs and Information Technology were generated.

                                                Pages 6 of 6
Responsibilities:
 Involved in requirement analysis, and feasibility study. Involved in designing front-end screens using
   DHTML, JavaScript, database design and Data Modeling involved in table design and index
   creation.
 Involved in designing database interface using JDBC, SQLNET. Involved in design and development
   of Servlets. Used EJB Technology for the Data Servers.
 Used Crystal Reports to generate reports for MIS. Testing and implementation

Environment: Java Servlets, Applets, EJB, CORBA, JSP, Visual Basic 6.0, Oracle 7.x, Crystal Reports 4.6,
              ADO, Netscape Enterprise Server 3.0, Windows NT Server 4.0, Win 98, UNIX - Sun
              Solaris 5.8.

EDUCATION:
Master Degree in Computer Applications.




                                              Pages 7 of 6

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:345
posted:3/23/2010
language:English
pages:7