IT - BI Technical Project Lead

Mahesh Dani

Contact No.: +1-973-***-****

E-Mail: acf7l4@r.postjobfree.com

Targeting assignments in BI Technical Lead with an organization of repute

Location - US-TX-Houston (will consider relocating)

? Hands on BI Technical Lead with nearly 8.5 years of innovation in the

software and hardware development arena in leading business and

technology strategy, directing, team leadership and mentoring. Architect

and builder of solutions, skilled at innovating new business models and

applying technological solutions in cost effective and timely manner.

Intimate understanding of small and startup businesses and how to

maximize effectiveness of teams and budget.

? Project Management - Proven ability to lead project teams to deliver

multiple, simultaneous projects that span across several business or

technology areas. Effectively manages resources, schedule and quality of

deliverables through the full project life cycle (discovery, analysis,

design, construction, test and implementation).

? Development - A technically proficient proven team player/builder with

an extensive technical skill set. Diverse experience developing

collaborative solutions with internal teams, vendors, and outsourcers --

building enterprise-level solutions for Fortune 100, global commercial

and Manufacturing clients. Recent successes include the use of

Agile/SCRUM methodologies in a dispersed development environment,

implementation of application lifecycle management (ALM) processes and

the deployment of automated build solutions/processes in a global team

development environment.

? Brings strong technical and multiple domain knowledge as well as

consultation background to successfully drive software development,

integration, infrastructure, architecture, and operations

? Worked as Project Module Lead in Agile project development team at

MphasiS - an HP company providing IT Solutions across various domains.

? Involved in Gap Analysis and Business Requirement Gathering and has

interfaced with business and technology teams for Projects and "Proof of

Concepts".

? Involved in SIT and UAT followed by implementation of Defects/CRs during

production support.

? Expertise in Agile scrum development model.

EDUCATION

Masters of Information Technology (MIT) - 2002 - ICFAI,Hyderabad .

Post Graduation Diploma in Computer Applications (PGDCA) - 2003 - IGNOU,

Hyderabad

Bachelor of Computer Science (B.Sc Computers), 2000 - Osmania University,

Hyderabad .

PROFESSIONAL CERTIFICATE

IBM Certified Designer - Cognos 10 BI Reports

IBM Certified Designer - Cognos 8 BI Reports

EMPLOYMENT HISTORY

Name of the Designation Location From To Duration(Year

Company of s)

employer

MphasiS an HP Module Leader Bangalore Jul 02, Till Date 7 Years

Company. 2007

Tech Mahindra Senior Pune Sep Jun20, 9 Months

Software 18,2006 2007

Engineer

Keane Software Noida Jan 02, Sep 9 Months

Engineer 2006 15,2006

TECHNICAL SKILLS

- IBM Cognos Impromptu, 7x, 8x and 10x series - Administrator, Developer.

- ETL - Informatica - Data warehousing - Strategy, Analysis, Operations.

- Business Objects, Hyperion, Crystal Reports, IBM Cubes, - Business

Analytic, Dashboard, Multi Dynamics.

- IT service Management, Citrix, Share point drive.

- Qlik View - have knowledge

- Databases: Oracle 8i/9i/10g,PL/SQL,SQL Server 2000/5.0, DB2.

- Operating Systems: Windows 2003 Enterprise Server, XP, Windows 2000,

UNIX

AREAS OF EXPERTISE

Architect Cognos, Business Objects, ORACLE, SQL, - Insurance,Banking.

Technical Project Leader Cognos, Informatica, Oracle - Insurance,Banking

Lead Developer Cognos, Cubes, Crystal reports, Business Objects, Cubes,

Oracle - BFSI

Instructor Business Objects, Cognos - Insurance

Highlights

1. Received Excellent Contributor in Tech Mahindra for the year 2007

from client

2. Received spot award several times from MphasiS an HP.

3. Excellent decision-making and problem solving skills developed while

meeting the challenge of constantly fluctuating environments.

CAREER CONTOUR

Current Employer: Mphasis Corporation

Current Role: BI Module Lead

Working as a BI Technical Lead / PM in Agile project development team where

the responsibilities include proposing tailor made BI solutions fitting the

clients need helping them to create reports and dashboards in BI reporting

tools.

? Involved in Client meeting for gathering requirements from the client to

offer a proper solution by understanding the total business logic.

? Built strong relationships with clients and partnerships with team

members.

? Interacted with the Business users and documented their Query, Business

and Reporting needs and Analyzed the data and Business logic underlying

the requirement.

? Created database layer by defining appropriate relationship between

query subjects and Logical layer, DMR layer and business layer in

Framework Manager.

? Created Dashboard and portal using HTML for easily access of reports,

cubes, adhoc report (created by Business users and client).

? Created oracle packages and imported into Framework Manager as a stored

procedure query subjects with multiple parameters.

? Implemented Framework manager security for Data access, Object level

access and Package access based on the Organization Level.

? Developed various Complex report types ranging from simple Lists, Cross-

tabs, Charts by using different Functionalities like drill-through,

Master-detail, conditional formatting, Multiple Prompts, Cascading

Prompts, Conditional blocks Filters, multi-page, multi-query reports,

Multi-tab reports using Java scripts, Dashboards, Drill up/Drill down,

Report Bursting.

? Deployed Reports, Packages Folders and Cubes from DEV to UAT and from

UAT to PROD Environments and Tested and Validated Reports for different

test cases

? Involved in the integrating Cognos reports to Client website using Java

Application.

? Performance tuning by analyzing and comparing the turnaround times

between SQL and Cognos.

? Scheduled and Distributed Reports through Schedule Management in Cognos

Connection

? Good Experience with Customized Reports using HTML and JAVA SCRIPTS.

? Designed models by mapping business needs using Transformer and created

multi-dimensional cubes, cube groups, Power Play reports..

? Trained the end users effectively to use the reporting tool, to build

and customize their ad-hoc reports.

? Expertise in Oracle 9i/10g/11g and in writing PL/SQL stored procedures,

functions, packages triggers and materialized views using PL/SQL

developer.

Projects Undertaken

Project # 5

Project Title BIR (Business Intelligence

Reports)

Client AIG

Role Module Lead

Duration Jul 2013 - Till Date

Project Description:

AIG has a number of different booking and processing systems worldwide to

support the business. Its Home Office management receives premium & loss

information through the only consistent method of collecting detail data on

a worldwide basis, the Overseas General Insurance System (OGIS).

Global Portfolio Management (GPM) System also known as OGIS-EIS

(Overseas General Insurance System - Executive Information System) is a new

analytical reporting tool. The information is viewed in different formats

such as Cubes, Dashboards and Reports. Users can generate required reports

using different dimensions or measures. Users can also drill up/down on

Cubes, Dashboards and Reports to areas / sections such as Region/ Country

wise, Year/Quarter/Month-wise, Division/Profit Centre wise etc. This helps

business management to manage portfolios effectively.

Responsibilities:

Working closely with Business Analyst and business users in requirement

gathering, creation of FSD and TSD.

Effectively prioritize the tasks and assigning to the team members in a

high-pressure business environment to

meet tight deadlines expectations .

Task management, coordinating with QA for testing activities, Co

coordinating with users for UAT and other teams like Admin, Database.

Weekly status calls with Client and forecast analysis for future project

tasks.

Lead the Cognos Framework Design, Development and Review of New and would-

be development.

Develop and continuously improve BI practices within the organization.

Train members and business users related Cognos.

Review architecture and come up with solution for any performance/technical

concerns.

Serve as SME (Subject Matter Expert) for technical issues on Cognos BI

Platform.

Setting up user access on data and user group within Cognos environment.

Collected and Managed Business Requirements for creating the Cognos reports

& cubes.

Worked extensively on Dashboards and portals.

Documentation of development and enhancement activities in functional and

technical perspective.

Preparing analysis documents and submitting to client for code change.

Project # 4

Project Title American International

Underwriters (AIU)

Client AIG

Role Module Lead

Duration Aug 2011 - Jun 2013

Project Description:

American International Underwriters has a number of different reporting

systems worldwide to support the business. AIU data is spread over a

wide range of applications and databases, with similar data being held in

different formats. The current Management Reporting System application on

Mainframe will be replaced by Chartis Management Reporting Cognos

application to generate the Accounting and Management reports.

Responsibilities:

Analyze business needs and translate them into technical specs and maintain

the information flow in the team.

Working closely with Business Analyst in requirement gathering, creation of

FSD and TSD.

Reviewing the code and giving coding guidelines .

Loading data into Database using SSIS tool.

Extensively worked on Framework manager.

Effectively prioritize the tasks and assigning to the team members in a

high-pressure business environment to

meet tight deadlines.

Task management, coordinating with QA for testing activities, Co

coordinating with users for UAT and other teams like Admin, Database.

Weekly status calls with Client and forecast analysis for future project

tasks.

Documentation of development and enhancement activities in functional and

technical perspective.

Trained Fresher's on Cognos Tool.

Environment: Cognos 8.2/8.4, SSIS, SQL,Java

Project :3

Project Title VCPS(Vehicle Content and Price

System)

Client General Motors(GM)

Role Sr. Cognos Developer

Duration Nov 2010 - July 2011

Project Description:

VCPS(Vehicle Content and Price System) is a global, cross functional tool

with requirements to support Marketing, Order Fulfillment and Finance. The

application allows users to create Market offers for different region,

validate these Market Offers and analyze these details by generating

various reports.

Roles :

1. Analyze business needs and translate them into technical specs and

maintain the information flow in the team.

2. Deployment of Reports and Package from one environment to other

environment.

3. Worked closely with Team members in resolving Issues.

4. Working closely with Business Analyst in requirement gathering,

creation of FSD and TSD.

5. Effectively prioritize the tasks and assigning to the team members in a

high-pressure business environment to meet tight deadlines.

6. Task management, coordinating with QA for testing activities, Co

coordinating with users for UAT and other teams like Admin, Database.

7. Daily status call with Client and forecast analysis for future project

tasks.

8. Working closely with Change Control management/ Release management

activities and post release activities.

9. Documentation of development and enhancement activities in functional

and technical perspective.

Environment: Cognos 8.2, SQL,Java

Project :2

Project Title IFC (International Finance

Corporation)

Client World Bank

Role Sr. Cognos Developer

Duration May 2008 - Oct 2010

Project Description:

IFC (International Finance Corporation), a member of the World Bank Group,

is a global investor and advisor committed to promoting sustainable

projects in its developing member countries that are economically

beneficial, financially and commercially sound, and environmentally and

socially sustainable. Provide advice and technical assistance to businesses

and governments.

This project contains more than 10 Application in Cognos which are

widely divided into MIS and Non-MIS.I am the primary SPOC for Non-MIS

applications like FMS(Fund Management System), TAAS (Technical Assistance

and Advisory Services), AS (Advisory Systems),AML(Anti Money Laundering).

Responsibilities:

1. Used Framework Manager, Report Studio, Query Studio for Report design in

Cognos BI version 8.2/8.4.

2. Expertise with Framework Manager in building models and publishing

packages and reporting.

3. Expertise in implementing durable Layered Structure of the model taking

Data Layer, Model Layer and Presentation Layer, and Implemented the

changes made to the database into the Layered structure of the model by

re importing query subjects in the Data Layer and remapping query

subjects in the presentation layer.

4. Performed update object on the model query subjects for every change

made to the entities in the database and remapped Query items and verify

model functionalities.

5. Created packages combining data from multiple data sources using

Framework Manager.

6. Synchronized objects based on the previously saved model and implement

the newly added features to the model

Development of filters, calculations, prompts, conditions, created

various reports such as Simple List, Cross Tab, and Charts using Cognos

Report Studio.

7. Responsible for the delivery of solution-oriented complex reports using

Cognos* Report Studio.

8. Extensively used cascading prompts, drill-through, sub-reports,

summaries, master detail reports, conditional formats, grouping and

association features to generate efficient Crosstab and List reports

reports.

9. Added JavaScript actionable items and HTML items on the reports.

10. Involved in the Cognos Administration using Cognos Connection for Data

source creation, security implementation, scheduling and distributing

reports and performance tuning.

? Validating/Testing of the reports against database .

? Addressing user queries/Issues and production issues. Work closely with

other teams to get the information and resolve any issues reported.

Environment: Cognos 8.2 / 8.4,Toad, Windows Vista,Remedy,JIRA

Project :1

Project Title Tyco Managed Maintenance

Client Type Electronics

Role Sr. Cognos Developer

Duration July 2007 - April 2008

Project Description:

The Information Delivery Systems team develops, maintains, and supports

Business Intelligence reporting and content driven solutions. These

Business Intelligence Solutions summarize the transactional level

information which is sent to the Data Warehouse (e.g., Sales, Purchasing,

Inventory, Accounts Receivable), and combines it with Master data, to

provide a view of the information that is meaningful and relevant to our

business users.

This information is then made available via a set of Business Intelligence

tools:

1. Analytical reporting via Cognos Analysis Studio

2. Standard batch reporting via Cognos Impromptu Web Reports (IWR)

3. Adhoc reporting via Cognos Impromptu.

Responsibilities:

11. Publishing reports to Upfront.

12. Manually running of IWR Reports in IWR Production .

13. Editing Catalogs like adding Columns, adding Folders as per the

Business User Requirement.

14. Migration from Cognos 7.3 to Cognos 7.4.

15. Giving access to users for accessing the IWR reports.

16. Supporting for Business End Users in Cognos Impromptu (Upfront).

Environment: Cognos Impromptu 7.4, TWS, Toad, Windows 2000.

Employer: Tech Mahindra, Pune

Role: Software Engineer

Project:1

Project Title Compucom

Client Compucom

Role Developer

Duration Sep 2006 - June 2007

Project Description:

CompuCom Systems is a leading IT managed services provider that helps

organizations maximize resources and achieve continuous improvement. Our

unique Integrated Infrastructure Management TM (IIM) solution, coupled with

our consulting and application services, enables clients to advance the

effectiveness of their technology infrastructures, while driving down

costs, improving quality, and expanding the e business value they derive

from IT.

Responsibilities:

17. Analysis of the specifications provided by the clients.

18. Involved in client interaction to analyze the problems and to rectify

them.

19. Created multidimensional models from multiple data sources using

Transformer.

20. Imported the 'IQD' files provided by the client created in FM into

Transformer to construct a power cube.

21. Defined, created, published and maintained cubes using Powerplay

Transformer.

22. Created reports in Powerplay.

23. Involved in Created FM Models.

24. Published Packages.

25. Involved in Created Reports in Report Studio using various prompts &

condition blocks.

Environment: Cognos Impromptu7.3, Power play Transformer, Power play,

Report Net 1.1, Cognos8, Brio, Win 2000,

Toad.

Employer: Keane, Noida

Project:2

Project Title Schneider Electrics North

America (SENA)

Client Schneider Electrics

Role Developer

Duration May 2006 - Sep 2006

Project Description:

Schneider Electric is a world-leading provider of innovative solutions for

electrical distribution, industrial control and automation. For over 160

years, Schneider has successfully met many challenges through bold

innovations and strategic business decisions. Schneider Electric's unique

history delivers the power of the Modicon, Square D, Telemecanique and

Merlin Gerin brands. These brands are responsible for innovations that

include Square D's invention of the safety switch in 1915, Telemecanique's

invention of the electrical

contractor in 1924, Modicon's invention of the PLC in 1969 and Merlin

Gerin's invention of the

Multi-Nine circuit breaker in 1970. Today, Schneider's history of

innovation continues. In This project we have given the North American

Region .Hence, we have named it as SENA (Schneider Electric North

America).

Responsibilities:

26. Creation of reports according to client requirement.

27. Involved in Loading reports to Upfront.

28. Monthly and Weekly cube build.

29. Doing Production Support for Cognos..

Environment: Cognos Impromptu, Powerplay Transformer, Powerplay, Brio, Win

2000, Toad.

Project:1

Project Title BESTWESTERN INTERNATIONAL

Client BESTWESTERN INTERNATIONAL

Role Developer

Duration Jan 2006 - April 2006

Project Description:

Based in Phoenix, Arizona, BWI is organized as a not-for-profit

association. Unlike other hotel brands, BWI operates on a membership

basis, with more than 4,100 independently owned and operated member hotels.

Responsibilities:

30. As a Team member

31. Creation of Reports in Cognos according to the client requirement.

32. Creation of Reports in SQR according to client requirement

33. Created List Reports, Group Reports and Cross Tab Reports with Drill

Through and Drill Down functionalities.

34. Created Cubes using Powerplay Transformer for multidimensional (IQD)

reports.

35. Communication with Client for knowing their Problems.

36. I had the responsibility of technical communication with the client

includes, team skill and knowledge sharing.

Environment: Cognos Impromptu,PowerPlay Transformer,PowerPlay,Win XP,Oracle

8i .

Contact this candidate