LAKSHMI KORAPATI

816-***-****

ac3081@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ****** ** ********** in all phases of the System Development Life Cycle with major focus around Data warehousing.

Over 1.8 Years of strong experience using MicroStrategy Suite (Desktop, Web, Architect, Object Manager).

Have knowledge on Tableau creating Dashboards.

Extensively worked on creating and integrating MicroStrategy reports, Dashboards and objects (Attributes, Filters, Metrics, and Prompts) with the data warehouse.

Created user Hierarchies which allow users to browse the data and Drill as required by business needs.

Experience in Creation and scheduling of Intelligent Cubes

Experience performing Administration tasks like Creating New Users, Object Manager, and Command Manager.

Extensive experience in designing and developing interactive Dynamic Dashboards using Report Services objects like Heat Maps, Gauge Widgets, Panels, Selectors and Grid/Graph combinations.

Used free form SQL editor for complex report creation.

Very proficient in working with large Databases in SQL Server.

Experience in dealing with a variety of Relational Databases like SSIS.

Exposure working directly with Clients using Agile Methodology

Excellent problem solving skills with strong technical background and good interpersonal skills.

Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

OLAP Tools

MicroStrategy9.4.X,10.X (MicroStrategy Desktop & Web, 9.4.1-Administrator, Object Manager)

RDBMS

SSIS

Languages

SQL, C, C#, R

CERTIFICATIONS

Certified report Developer on 9.4.1 MicroStrategy Version.

Certified Project Designer on 9.4.1 MicroStrategy Version.

EDUCATION

Master of Technology (MS):

Major: Computer Science, University of Central Missouri, Warrensburg, Missouri, GPA: 3.66

Bachelor of Technology (B.Tech):

Major: Electrical Engineering, Narayana Engineering College (JNTUA), India.

PROFESSIONAL EXPERIENCE AUG 14 to AUG 16

MicroStrategy Developer having over 1.8 years of experience in design and development of Data warehouse reporting.

Worked as Software Engineer at ACCENTURE Solutions Private Limited.

Company: Accenture

Client: Bank of America, USA SEP 14 to AUG 16

Team: Qmt(Quality Measurement Tool)

Role: MicroStrategy Developer

Description:

Qmt (Quality measurement Tool) is an application under Testing Quality Measurement Services (TQMS) of Bank of America, we maintain the data of various Applications. Evaluate the number of defects found in different applications. Raised by different phases (SIT, UAT, PROD) related with Line of business, portfolios and release wise. These defects are taken from multiple sources like (Share point,QC). Evaluate the number of defects found through Automation such as (Automation Scripts, Automation Defects etc.). Evaluate resources Data such as their Role, Billability, Location Status etc.

Roles & Responsibilities:

Development and deployment attributes, facts, hierarchies and transformation objects

Design and development of Prompts, Filters, and Metrics

Report development both on Ad hoc and Planned basis, including free form reports

Developed Dashboards that provide users a highly graphical, summary view of key metrics.

Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (Graph Matrix) both in flash modes.

Have created Dashboards in both the Interactive, Presentation & flash mode.

Have used several Widgets for Dashboard reporting.

Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.

Worked on creation and scheduling of Intelligent Cubes & Reports

Played a key role in User Acceptance Testing of the reports.

Rigorous environment to environment testing was done by using the Integrity manager

Tested all the reports by running queries against the warehouse-using SQL Developer.

Extensively used Distribution Services to deliver reports directly to business users through Email & History List.

Extensively used Report Services to generate Documents for exporting to Excel & PDF.

Worked extensively on Transaction services for Creating Insert, Update & Delete Transactions.

Environment:

MicroStrategy9.4.1,10.1,10.2 (Administrator, Command Manager, Object Manager-9.4.1, Architect, Desktop, Web), SQLServer2012, SSIS.

Contact this candidate