Project Manager
Resume:
DARSHANA PATEL
Phone: 215-***-**** Email: **********@*******.***
KEY SUMMARY:
[pic]Solution oriented and well skilled IT professional with extensive
system analysis and team lead experience that includes leading cross
functional teams and coordinating multiple projects simultaneously.
CORE COMPENTACY:
[pic]
. Unique competency to capture, transcribe business requirement into IT
solution using system and business analysis and represent prototype
deliverables to key stakeholders.
. Ability to effectively prioritize and execute tasks in a high-pressure
environment.
. Ability to elicit cooperation from a wide variety of sources,
including upper management, clients, and other departments.
. Ability to effectively communicate project expectations to team
members and stakeholders in a timely and clear fashion.
. Experience at managing cross functional teams across the glob.
. Hands on experience in Requirements Analysis, Architecture Design,
Application Design, Development, testing in the
Manufacturing/Pharmaceutical/Higher Education/Telecommunication
industries.
TECHNICAL PROFICIENCY:
[pic]
OLAP Tools Cognos 8.4/8.2/CRN 1.1 (Framework Manager, Report studio, Query
studio, Analysis Studio, Metrics Studio, Metrics Designer,
Transformer)
BI SAP BI 7.0(DTP, DSO, Transfer rules, BEx Query Designer, BEx
Analyzer, ABAP routines, ECC 6.0)
ETL Tools Informatica V.7.1.2, SSIS Packages (SQL Server 2005), Oracle
warehouse builder 10g.
Databases Oracle 9i/10g and SQL Server 2000/2005, ERWIN 4.1
Languages Java Script, SQL, PL/SQL, TOAD, PL-SQL Developer 7.x
Business Analysis Microsoft office suite 2003(Word, Excel, Power
Point), MS Project 2007
Certifications
. Cognos ReportNet 1.1 Authoring I & II
. Cognos 8I Meta data Modeling I & II
. Oracle 8 DBA (OCP) and Oracle 9i OCA
PROFESSIONAL EXPERIENCE
[pic]
3CCompany, Inc. Sep-08 to Present
Sr. Cognos Developer/Architect
Client Name: Novartis Pharmaceuticals, Florharm Park, NJ
Project: Oncology-Clintelligence
Project Description: 3Ccompany has developed Clintelligence product which
is Cognos dashboard getting data from pharastore (It is
dimensional database with 3c company's ownership).
Clintelligence is Business Intelligence Portal that
specifically address the needs of Pharmaceuticals Clinical
Development. The scope of the project is on-going
support/new customization within dashboard and/or ETL
(Oracle stored procedures and Packages) to get newly
identified data from clients source data systems.
Application
Environment: Cognos 8.0/8.4, Oracle 10g
Responsibilities:
. Successfully implemented conversion project from Cognos 8.0 to
Cognos 8.4 for 96 reports and 10 dashboards.
. Owned external vendor's not functioning code (due to migration)
from 8.0 server and successfully migrated to 8.4 server.
. Participate in weekly status meetings with Project Manager and
communicate the deliverable status.
. Assisted Project Manger in developing a detailed project plan
that indicates the project's work plan, schedule, resources and
tasks level details for 8.4 migration project.
. Worked with developers in getting estimations to convert 96
reports and 10 dashboards.
. Successfully established code development process (design
review, code review and lesson leant session after each release)
for development team.
. Developed code migration process form DEV to QA to UAT and
ensured version control as client doent use version control
tool.
. Assist/Participate in requirement gathering sessions with
stakeholders along with Business Analyst and help in writing
functional specification(FRS).
. Initiate FRS review meetings between Business Analysts and
developer team.
. Communicate clearly feasibility analysis of the requirements to
development team and value their feedback.
. Facilitate communication gaps if any between QA and Development
team.
. Developed customized java scripts to create multi cascade
prompts.(more then four prompts as cascade to each other)
. Assisted database developers in creating materialized view with
pre-calculated measures from dimensional database, creating
procedure and importing it to framework manger approach and had
improved reports performance by 85%.
. Administer/Deploy different deliverables content from
development servers to QA servers.
. Worked extensively with BEx Analyzer 7.0 and analyzed query
behind the reports.
. Created framework model as per BEx queries.
. Created formatted reports using Cognos Report studio from
derived FM model
. Familiar with BEx Report Designer to create reports.
[pic]Wipro Technologies, Inc. Sep-07 to Sep-
08
Project Co-ordinator/BI Team Lead
Project Details:
Client Name: Laureate Inc (Marketing Group), Baltimore-MD
Duration: Jun-08 to Sep-08
Project: APRIMO-BI Reporting
Duration: Jun-08 to Sep-08
Project Description: Develop Scoreboards/Dashboards/Analytical Reports in
Cognos 8.2 which incorporates Marketing teams reporting
needs. APRIMO is application used by marketing group on
daily basis which is source system. The scope of the
project was getting familiarized with APRIMO
functionalities and database and come up with design plan
to develop customized dashboards and score card reports.
Application
Environment: Cognos 8.2(Report Studio, Framework Manager and Oracle
10g)
Responsibilities:
. Get familiarized with APRIMO reporting system and identified
source tables for newly required data.
. Analyzed FRS(Functional report specifications developed by
external vendor team) and developed design document for
reports.
. Developed/Updated framework manger as per new FRS.
. Co-ordinated with offshore developers to create report using
Report studio.
. Prepared training manuals for end users and conducted
training sessions to marketing user group.
[pic]
Client Name: Mac-Graw Hill (Higher Education)-New York-NY
Duration: Dec-07 to May-08
Project: nySTART (NYSED-New York School of Education
Department)
Project Description: Support/Develop reporting application using Cognos
8.2 for NYSED at District, State and Schools level data for
student enrollment and track their scores, study progress
at different grade levels. The primary scope of the project
was on-going support/new customization within dashboard.
The secondary scope was to migrate application to Congos
8.2
Application
Environment: Linux, Cognos CRN MR2, 8.2, Transformer, SQL Server
2005
Responsibilities:
. Participated in weekly status meetings with stake holders and
communicated the deliverable status.
. Participated in daily internal meetings with onsite/offshore
Cognos development teams and ensure deliverable timeline.
. Co-ordinated clearly and effectively with the development
teams (on-site/offshore), business users and management team
for their requirements and difficulties.
. Co-coordinated with Cognos Support team for unresolved
reporting issues identified by internal technical team and
created/managed/resolved open tickets.
. Identified GAPs in reporting structures, corrected few java
scripts, re-developed/modified 85 reports and successfully
migrated from CRN MR2 to 8.2 servers.
. Created four cubes using transformer 8.2.
. Developed on demand asymmetrical cross tab reports with
custom sort, user defined filters, filter values using
context functionalities in Analysis Studio for higher
management reporting needs.
. Developed drill up and drill down reports on same and
different dimensions.
. Developed DMR(Dimensionally modeled relational database) to
with customized Time Dimension.
. Updated SSIS(packages) to bring missing data for Charters
(one of the entity in NYSED) from source system to data
warehouse schema.
. Customized Cognos SDK to provide portal listings which has
java reports embedded within.
. Installed/Configured Cognos 8.2 in Linux environment.
. Administered Cognos servers(2 Development,2 QA serves).
. Managed scheduling of reports, distribution lists, users,
groups and roles using Cognos connection.
[pic]
Client Name: General Motors, Detroit-MI
Duration: Aug-07 to Dec-07
Project : Ocean Vehicle Visibility
Project Description: Design reporting portal using Cognos 8.2 for Ocean
Vehicle Visibility. Once vehicle has been manufactured in
Korea Plant,It would be dispatched in ocean for different
vendors across the glob. The primary scope of the project
was to design plan for the cognos reporting application
which will track shipments details.
Application Cognos 8.2(Report Studio, Analysis Studio and Framework
Manager),
Environment: Oracle 10g, ERWIN 4.1
Responsibilities:
. Interviewed business users and prepared concise functional
requirement specification document for reports.
. Prepared System Requirement Specification(SRS) which includes
Cognos Capacity Planning document.
. Leaded and managed offshore and onsite team to provide
report layouts and report design documentation for the
identified reports.
. Demonstrated final reports prototypes to stakeholders and got
successful signed off.
. Co-coordinated with offshore team for different project
deliverables.
. Participated in different data vendors call and prepared
master data dictionary for Legacy, GIF and Covisint systems.(
Wirpo was prime vendor and has active collaboration with next
prime vendor I-2 for the project.)
. Facilitated multiple vendors calls to identify data GAPS
within different source Systems.
. Prepared data mappings documents between client legacy
system, and I-2 new application.
. Analyzed and designed logical schema of ODS (Operational Data
Source) using Erwin.
. Analyzed and designed logical schema of DWH (Data Warehouse).
. Prepared transformation rules between DWH (Data Warehouse to
DM (Data Mart) Schemas.
Sungard Higher Education Inc, Jan-06 to Aug-07
BI Consultant
Project Details:
[pic]
Client Name: University of North Carolina-Pembroke-NC
Duration: Mar-07 to Aug-07
Project : SunGard ODS- Human Resource Reporting
Project Description: Design/Develop data mart/ODS data source using
Informatica(extract/load it from Legacy system to Banner)
to provide data for Human Resource reporting needs at
University-Pembroke.
Application Red Hut Linux 8.0, Oracle 10g, Informatica V.7.1.2
Environment:
Responsibilities:
. Performed data/code analysis (Database table and Cognos SQL
code) in client legacy system.
. Updated data model for ODS and Data warehouse (Star Schema)
database using Erwin to bring new data from source system.
. Designed/Developed detail ETL mapping specifications listing
the requirements and the transformations that would need to
be implemented during the development of modified ODS and
EDW.
. Developed/Executed ETL mappings and tested result sets.
Client Name: Wilkes University-Wilkes-Barre-PA
Duration: Sep-06 to Feb-07
Project : SunGard ODS- Finance Reporting
Project Description: Develop/Support reporting portal for Finance
department which has SunGard Banner as front end
application.
Application Oracle 10g,Cognos CRN MR4(Report Studio,Framwork
Environment Manager)
Responsibilities:
. Interviewed business users and documented business
requirements.
. Prepared meeting minute after web-ex meetings.
. Developed metadata model in Framework Manager for relational
database.
. Developed complex reports using different type of prompts
(Value, Text, search, cascade prompts etc.) in CRN 1.1 MR4.
. Developed complex drill through, master details, bursting,
cross tab and label reports in CRN 1.1 MR4.
. Written complex SQL queries and build tabular SQL reports in
CRN MR4
. Conducted user training sessions to educate end-users for
applications usability.
. Assisted end user in creating reports in Cognos.
[pic]
Client Name: Kent State University-Kent-OH
Duration: Jan-06 to Aug-06
Project : SunGard ODS- Finance Reporting project
Project Description: Develop/Support reporting infrastructure(Data source
and Repotting tool)to support reporting requirements for
Finance department which has SunGard Banner as front end
application.
Application UNIX, Oracle 10g,Cognos CRN MR2, Oracle warehouse
builder
Environment:
Responsibilities:
. Identified data elements as needed by the reporting teams to
support reporting business needs.
. Customized/Developed logical/physical schema of ODS
(Operational Data Source) using oracle warehouse builder(OWB)
. Created mapping using OWB
. Deployed mapping using OWB
. Developed/Updated meta data model using Framework Manager for
DMR (Dimensionally modeled Relational DB).
. Installed CRN 1.1MR2 using Linux 86.
. Maintained user accounts, mapping of security to groups,
roles and folders.
. Developed/tested 30 reports using CRN 1.1 MR2 which include
(repeter,list,crosstab,master details, bursting and complexes
Tabular SQL)
Fiber link Inc.-Blue Bell-PA May-05 to Nov-05
Reporting Analyst consultant
[pic]
Project : Data mart
Project Description: Design/Develop cube to analyze usage Vs user
community for different type of internet/mobile/telephone
services.
Application Oracle 9i
Environment:
Responsibilities:
. Analyzed and designed logical schema of DWH(Data
warehouse).
. Developed procedure, packages, functions and complex SQL
queries in oracle 9i.
IDS-Scheer-Philadelphia, PA May-04 to May-05
Data warehouse Developer
[pic]
Project : IDS Portal
Project Description: Design/Develop cube and provide reporting for
Customers usage for Business Processing tools across the
glob.
Application Oracle 9i,PL-SQL,Erwin 4.0
Environment:
Responsibilities:
. Designed logical data warehouse schema using Erwin 4.0.
. Extracted and transformed data from OLTP- relational
database to OLAP for business Intelligence requirements
using PL-SQL procedures in oracle 9i
. Worked extensively on the Triggers, Functions and Database
Constraints
. Created cube using procube 6.0.
. Performed system and unit testing to ensure and maintain
data integrity and quality control of data for reporting
applications.
Web Infosys -India, Aug-2000 to Dec-02
Data warehouse Developer /Technical Manager
[pic]
Project: Amul Diary
Position: Data warehouse Developer
Project Description: Design/Develop Websites for online shopping.
Application Oracle 8i,PL-SQL,HTML,ASP
Environment:
Responsibilities:
. Designed websites using HTML, Java Scripts, and Flash.
. Managed 4 developers and implemented more then 15 Websites
including online shopping application.
. Developed/Presented system design document to higher
management team.
Education:
Masters in Computer Science, Saint Joseph University, Philadelphia-
PA
Bachelors in Computer Engineering, Sardar Patel University, India
Contact this candidate