SUMMARY:

• Highly motivated and ambitious professional with over 13 years of experience in data analytics.
• Implemented and delivered multiple Business Intelligence solutions using MicroStrategy Product suite which provided various insights.
• Coordinated management activities of various projects to obtain strategic objectives.
• Strong experience in converting business requirements into analytical solutions by working with various cross departmental teams.
• Experienced in environments that have high data volumes on very large databases like Oracle, Teradata and SQL Server.
• Expert in building MicroStrategy based reports and dashboards with visualizations that are very intuitive.
• Highly experienced in using Tools such as TOAD, SQL assistant and Excel.
• Expert level experience with MicroStrategy BI Tool suite.
• Very strong experience in working with databases such as Oracle, Teradata and SQL Server.
• Highly proficient with SQL.
• Experienced in building semantic layer by using data extraction and transformations.
• Self - starter and Proactive learner with analytical mindset.
• Understands industry trends, emerging technologies and standards and keep up to date
• Excellent communication and interpersonal skills.
• Good team player with proven problem solving skills.

TECHNICAL SKILLS:

BI Tools: MicroStrategy Product Suite

Databases: Oracle, Teradata and SQL Server

Database Query Tools: TOAD, SQL Assistant, SQL Server Enterprise Manager

Microsoft Tools: MS office Suite

PROFESSIONAL EXPERIENCE:

Confidential

Advisor/ Lead Applications Architect

Responsibilities:

• Leading the IT team to support the Extra care Vendor Portal Application which is used by multiple vendors. Play the role of acquiring requirements from both External Vendors and Business partners to implement various solutions that helped increase revenue from the portal.
• Worked through several acquisitions - Eckerd, Albertsons, Longs and Navarro in designing and developing several reports to better understand the sales trends of acquired stores.
• Designed and developed Seasonal reports that are currently used by Category Management group to better understand the trends of Seasonal events during In Season, End of Season and Post seasons.
• Setup the current process of sending reports to the Field Management including stores.
• Designed and developed the Daily Flash sales reports that are viewed by Corporate users including the President of the company, Field Users to get visibility of Store sales every day.
• Designed and developed the Category Sales reports that provide Sales trends by Category and TY/LY comparison by Category and a list of over performing and underperforming Store Brand Categories on a Monthly basis. These reports are used by Field Users and stores to analyze Category trends at the stores.
• Developed the Weekly FS and RX Inventory Productivity reports as part of the Inventory Optimization initiative.
• Worked on design efforts related to Retail to Cost Accounting project.
• Setup multiple reports for the Promo Planning team
• Designed and developed the RDW setup including reporting to support Loss Prevention team when Photo Touch Program was introduced at Confidential .
• Setup the Weekly and Monthly Category Sales and Scan Margin reports that are used by VPMMs, CMs and multiple other Business users.
• Gather Business Requirements and translate them into Reporting solutions.
• Worked with several Business teams- Extracare, Merchandising, Finance, Loss Prevention, DSD, Store Operations, Promo Planning, Seasonal Planning, Advertising to convert their Business needs into usable reports.
• Work closely with Application Manager to drive the IT Roadmap, simplify architectures, improve operational stability, decision making, technical documentation and ensure ample risk mitigation.
• Monitor software development efforts and proactively identify opportunities that will ensure end product is delivered on time, within budget and meets product requirements.
• Ensure coherent system designs that use the most effective methods, build scalable Software architectures that meet performance expectations while delivering quality and consistent Information to the business on time.
• Used MicroStrategy tool suite to design and implement numerous Business Intelligence applications.
• Develop Static and Dynamic interactive Dashboards in the Flash mode using different kinds of widgets.
• Implemented self-subscription for users through Narrowcast Server and Distribution Services.
• Subject Matter Expert for all the BI projects.
• Published the reports to the business users by email through Narrowcast server and Distribution Services.
• Developed complex Excel VBA macros to handle functionality that was outside the native MicroStrategy system.
• Developed command manager scripts to invoke intelligence server and narrowcast server jobs.
• Implemented caching and intelligent cubes to improve performance on Dashboards.
• Implemented multiple levels of security for users both at Database and Microstrategy levels using Security filters and Teradata queries.
• Developed numerous report service documents.
• Designed data models for different MicroStrategy Projects.
• Coordinate the design and development activities of other data warehousing applications.
• Responsible for estimating the level of effort required for accomplishing different projects.

Environment: MicroStrategy Tool Suite, Oracle, Teradata, SQL Server

Confidential, San Francisco CA

Microstrategy/BI Consultant

Responsibilities:

• Interacted with the business users to gather requirements and designed the data model.
• Created various reports using Business intelligence tool suite MicroStrategy.
• Involved in Architecting project by creating facts, attributes, hierarchies and transformations
• Designed and developed both canned and ad-hoc reports.
• Created various application objects such as metrics, prompts, filters and custom groups.
• Used the Narrowcast server for Content Management, Alerting, personalize the report delivery and for Profile management.
• Involved in configuring the Intelligence Server and pointing the database instances in both development and production environments.
• Involved in different administration tasks such as creating users, security roles and assigning different access rights to the users.
• Involved in Unit, system and Integration testing of various projects.
• Performed data imports and exports using the SQL Loader and developed online screens.
• Involved in Performance monitoring and tuning of database servers, identified integrity constraints and developed database triggers.
• Performed Backup and restoration of system and user databases and involved in scheduling the backups

Environment: MicroStrategy Tool Suite, Teradata.