Srawan Kumar Srimant .PMP

TECHNICAL LEAD

MOBILE NO: +1-857-***-**** E-MAIL: acb84s@r.postjobfree.com

ADDRESS: QUINCY MA

BUSINESS INTELLIGENCE DEVELOPMENT

SOLUTIONS-ORIENTED AND HIGHLY ANALYTICAL CANDIDATE WITH AN EXTENSIVE

EXPERIENCE OF 8.6 YEARS IN ANALYSIS, DESIGN, DEVELOPMENT AND MANAGEMENT OF

BI APPLICATION IMPLEMENTED COMPLICATED DASHBOARDS AND REPORTS USING BI

TOOLS LIKE QLIKVIEW AND WEBFOCUS. LOOKING FOR A CHALLENGING CARRIER IN

BUSINESS INTELLIGENCE.

TOOLS : QLIKVIEW 10,TABLEAU,WEB FOCUS 7.1.4 AND 7.6.9,

Report Center, Oracle SQL Developer, Toad, Quality Centre,

Rational Clear Quest,

Operating Systems : Windows 9x/2000/XP/2003 SERVER

Languages : FOCUS, Mainframe FOCUS, Java Script, .HTML, SQL&PL/SQL,

JCL, MS-Office, C#

Databases : Oracle 9i/10g

Professional Experience Summary

. Experience in complete project life cycle including documentation,

analysis, and development and testing.

. Plan and execute the projects within Triple constraints.

. Proficient in Dashboard by using QlikView 10 and Web FOCUS reporting

tool.

. Proficient in different kinds of Reports (Excel,PDF,HTML) generation

using QlikView 10 and Web FOCUS.

. Dimensional data modeling using Star Schema for the various metrics

related reports.

. Applying Security and developing Set analysis for QlikView

applications.

. Developed Data Marts in Mainframes and exported them to Web FOCUS to

create reports .

. Reports Scheduling using Report Bursting Techniques.

. Always worked in close association with customers and a single point

of contact for many major implementation projects.

. IT industry experience in Insurance, Security, Manufacturing, Retail,Asset Management.

Companies and Projects Involved

Wipro Technologies (June 2010 till Date.)

Technical Lead

Insurance Claim Dashboard:

This Dashboard helps in detailed study of the Insurance products. It

helps in the trend analysis as per the Claims made. Dashboard helps in

decision making as to which of the Insurance Scheme is better for

which Age Group.

Security details Dashboard.

Security Detailed dashboard presents the detailed performance of the

Security in the current market. It provides the Holding, Asset and

NAV information of the securities .It helps in comparing the different

Securities and choosing the best security from the investment point of

view. The results can be analyzed at different region as well date

parameter wise like Monthly, Quarterly as well as Yearly.

Roles and Responsibilities:-

. Creating and Managing QlikView Reports & Dashboards.

. Developed complex QlikView scripts to build model, to support various

KPIs and time comparison.

. Creating a Data and Presentation layer.

. Designing Data Modelling using Star Schema and Snow Flake Schema.

. Implemented best practises in Data Modelling (Link tables,

dimensionless facts and Factless Dimension ).

. Developing Set Analysis to provide the custom functionality in

QlikView Applications.

. Involved in Extracting, Transforming and Loading data from different

data source.

. Implemented Security for QlikView applications.

. Implemented Best Practises with respect to Frontend,Data Modeling

and

Scripting.

Field Operation Reports: Field Operation Report is a dashboard being

developed using Web FOCUS 7.6.9 used to measure key metrics like %RT

Target, Guaranteed time within LST, First Time Fixed Rate, Remotely Solved

Tickets % .This dashboard includes Gauge Graph, Line Graph EXCEL and HTML

reports powered by report bursting and three levels of drill down.

Automation for Monthly Tickets Metrics produced by Change Manager:

Minimize the errors as well as the manual effort by automating the

Monthly Ticket Metrics by the help of graph using Web FOCUS.

Roles and Responsibilities:-

. Created HLD,Technical Design Document as per the Requirement doc.

. Estimation, Development, Unit Testing and Post Production Support.

. Developed User Interface with Java Script validation.

. Developed Communication management plan for updating Status to all the

Stake Holders.

. Implemented Gauge Graph for performance measurement of the field

person followed by two levels of drill downs monthly and the daily

level.

. Implemented Styling features by the help of CSS and STY files.

. Migrated all the existing applications from Web FOCUS 7.4.1 to Web

FOCUS 7.6.9.

Target Corporations India Limited (April 2008 -May 2010)

Lead Developer Business Intelligence:

Projects:

Interactive Target Assortment Optimizer (ITAO): ITAO gives Business

Analysts the ability to see historical sales data (total sale, total

units sold, total weeks of sale, etc), store ship pack, and order

frequency at store as well as the MSC level. This report assists in

placing sufficient stocks on the planograms and avoids replenishment

from store rooms frequently. ITAO helps to save approximately 5

million dollar per year.

Roles and Responsibilities:-

. Requirement Gathering, Analysis, Report development, testing.

. Launch Page development through .HTML layout painter.

. Implementation of Java Script validation.

. Scheduling through Report Caster.

. Master file and Data Adapters creation.

. .FEX files creation at Web FOCUS as well as MAINFRAME.

. JCL creation.

. Implementation of styling through .STY and .CSS style sheets.

. Report Scheduling through Report Casters and Report Bursting.

. Supporting dashboard

. Maintaining project metrics.

. Training new team members.

Planogram Capacity and Sales

This report is used to identify the high performing DPCI whose per day sale

is more than MAX_FACING both at the Store as well as the company level for

the selected time period. This report provides optimum use of space within

the target stores giving more space to the items that's per day unit sale

is more than its MAX_FACING.

Ness Technologies (India) Ltd (April 2005 to March 2008)

Senior Quality Assurance Engineer.

BANNER CIS

BANNER CIS asset management suite which provides comprehensive customer

accounting facilities for the city's water and sewer services. It also

maintains premises, services, accounts, meter readings, inventory, etc and

provides the means to record and bill for services in a cost-effective,

efficient, and manageable way.

Roles and Responsibilities:-

. Designed and developed Test Cases as per the functional documents.

. Write and maintain test cases

. Create and maintain test data

. Test Case execution and Bug Reporting

. Clearly document and re-verify all defects

. Document test results

. Involved in Functional and Regression Testing

. Review functional specifications and detailed design documents

Certifications:-

Project Management Professional (PMP)

Oracle Certified Associate (OCA).

Visa Details:-

Valid H1B visa valid till Sep 2015

Educational Qualifications:-

B.E computer Science

Contact this candidate