Microstrategy Developer Resume


Title
Microstrategy Developer


Primary Skills
Microstrategy, SQL, Tableau, Teradata, SQL Server


Location
US-CA-San Jose

Posted
Sep-18-13

RESUME DETAILS

Career Objective

Aspiring for a Microstrategy Developer role in an organization, to provide design & development solutions for Enterprise critical Data Requirement utilizing my expertise in Analysis, Design, Implementation, Mentoring & Management.

Employment Profile
 Worked as a Senior Software Engineer for Tesco from 2009 to 2013.

 Worked as a Senior Software Engineer for JP Morgan Chase from 2007 to 2009.

 Worked as an Application Developer for First Advantage ZAPAPP from 2005 to 2007.

Professional Summary
 With over 8+ years of IT experience involved in various stages of the Software Development Life Cycle (SDLC) from requirements gathering, analysis, modeling, design, development, enhancement, test and production.

 5+ years of experience in Data warehouse and OLAP applications.

 7+ years of experience with Business Intelligence tool MicroStrategy8i, 9i in Retail, HR, Banking, Health care & Insurance Domains.

 Excellent hands on work experience in building Canned/Ad-hoc/Analytical reports using ROLAP & MOLAP Business Intelligence reporting tools (MicroStrategy 8i & 9i), MicroStrategy Desktop, MicroStrategy Administration, MicroStrategy Web, and MicroStrategy Office, Object manager, Intelligent Cubes, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider and Data Mart.

 Extensive Experience in creating the Dynamic Dashboards & Scorecard reports using MicroStrategy 9.0.1

 Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.

 Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.

 Good exposure to BI reporting MicroStrategy 8i, 9i & Tableau & SQL programming.

 Sound knowledge of Databases (DB2, Oracle 9i, 10g & SQL Server 2008/2005/2000, Teradata), with more exposure towards query Performance Tuning.

 Good exposure to data query tools like TOAD and SQL Developer.

 Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.

 Experienced in preparing resource & effort estimations/forecasts, MicroStrategy Roadmap Creation for end-to-end BI projects.

 Extensive experience in onshore/offshore coordination and responsible for project deliverables.

 Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.

 Ensure the team follows the change control process when there is any request to change the agreed scope.



Technical Skills:
Business Intelligence Tools:
Microstrategy Desktop 7x/8x/9.0 (Microstrategy Desktop, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services, Documents, Dynamic Dashboards, Narrowcast Server & Enterprise Manager, TABLEAU

Databases: Oracle 8i/9i/10g, Teradata, MY SQL, MS SQL Server 2008/2005/2000, MS Access
Languages: SQL, PL/SQL, HTML and XML
Concepts: Data Warehousing, Business Intelligence
Platforms: Windows NT/95/98/2000/2003/2007/XP, Informatica, TOAD, PL/SQL Developer
Design Tools: MS Visio, Erwin, MS Excel, PowerPoint

Academic Certifications:
• Bachelors of Science, Information Technology
• Masters in Business Administration

Senior Software Engineer (Sr. Microstrategy Developer)

TESCO Fresh n Easy

Project II : Retail & HR Productivity Reports
Client : Tesco - Fresh n Easy
Location : El Segundo, CA
Role : Sr. Software Engineer
Environment : MicroStrategy 8i, 9.i, DB2, Windows XP, Teradata, SQL
Duration : Jan 2012 -- Aug 2013
Team size : 8

The objective of this project is to develop MicroStrategy Reports and Business Dashboards and Scorecards to showcase the company goals and achievements in areas of HR like Recruitment, Payroll Analysis, Benchmarking, Rewards & Benefits, Employee Relations, Helping hands, Grievances, KPI, Staff turnover, Time & attendance, Productivity reports for all Head office, Retail and Distribution staffs.

Roles and Responsibilities
As a Sr. Software Engineer, I am responsible for Analysis, design, development, testing and implementation of new set of reports and to create dashboards on Microstrategy tool based on the reports for the project. The project is dealing with interactive dashboards where the user can get the data upon their request in flash mode.

• Extensively worked with Metrics, Facts, Transformations, Custom Groups & Report Services.
• Responsible for creation of Canned/Ad-hoc Reports, Metrics with Public and Schema Objects for HR domain requirements.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Design and Development of Business Analysis Interactive Dashboards & Scorecards organizations HR's goals & KPI in Microstrategy Desktop and web.
• Once ETL is done and data gets loaded to Data warehouse, Defined and created MicroStrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.
• Conditional formatting on metric thresholds, limiting report data access using security filters.
• Created Ad-hoc reports with Dynamic prompt answers for the end users to generate.
• Improved report performance using VLDB properties, Caching.
• Strong in Narrowcast Server especially using Scheduling, Subscription and Event Base Alert Services.
• Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.

TESCO Ireland & UK

Headquartered in the UK, Tesco today is ranked as the world's third largest retailer. Tesco is involved in creating and executing strategic initiatives for Tesco retail stores worldwide. These strategic initiatives cover the IT, Business, Financial, Commercial and Property aspects, among others, of Tesco operations. The operations cover all internal and external platforms that drive Tesco's business, making it one of the world's most preferred retail stores. MicroStrategy reporting suites has been built on the Teradata Database and used for BI reporting needs.


Project I : HO & Stores - Sales & HRSS Reports
Client : Tesco UK & Ireland
Location : Dublin, Ireland | Bangalore, India
Role : Sr. Software Engineer
Environment : MicroStrategy 8i, 9.i, DB2, Windows XP, Teradata, Informatica
Duration : Mar 2009 -- Dec 2011
Team size : 14

The objective of this project is to develop various MicroStrategy reports and business documents/dashboards to showcase Sales, Invoice purchase order, Item Performance of Privilege card and club card members for Promotions modules. Creating Head office, Retail reports and dashboards for HR & Personnel - Recruitment, Compensation and Benefits, Employee Relations, Stores Performance, labor turnover, Time & attendance and KPIs across regions of Ireland and UK. Create interactive reports and dynamic dashboards.

Roles and Responsibilities
As a Sr. Software Engineer, I am responsible for Analysis, design, development, testing and implementation of new set of reports and to create dashboards on Microstrategy tool based on the reports for the project. The project is dealing with interactive dashboards where the user can get the data upon their request in flash mode.

• Responsible for creation of Canned/Ad-hoc Reports, Metrics with the other Public and Schema Objects.
• Design and Development of Business Analysis Interactive Dashboards & Scorecards on the Members card & HR Data reports according to design specifications.
• Interact with business analysts, business users and managers for Gathering, Analyzing, Documenting Business/Functional requirements and data specifications.
• Responsible for performing and advising on the MicroStrategy object moves across various Dev, Test, Stage, Prod environments using MicroStrategy Object Manager there by following the Application Lifecycle Management.
• Involve in Design, Data modeling meetings and perform feasibility study if required.
• Once ETL is done and data gets loaded to Data warehouse, Defined and created MicroStrategy objects including Attributes, Filters, Cubes, Nested Filters, Metrics, Hierarchies, Templates, Prompts & Nested Prompts.
• Interact with DBA and Data Modeler to build Dimensional Data Modeling (Star Schema and Snow-Flake Schema).
• Conditional formatting on metric thresholds, limiting report data access using security filters.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Derived Metrics, Custom groups and Consolidations for complex reports.
• Created Ad-hoc reports with dynamic prompt answers for the end users to generate.
• Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Worked on Performance tuning of Reports.
• Creating & scheduling reports to multiple users via Distribution Services & Data Driven E-mail Alerts.
• Utilize in-depth knowledge of functional and Technical experience in data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Senior Software Engineer (Sr. Microstrategy Developer)

JP MORGAN CHASE

J.P. Morgan Chase is a leader in financial services, offering solutions to clients in more than 100 countries with one of the most comprehensive global product platforms available. The company has been helping our clients to do business and manage their wealth for more than 200 years. The business has been built upon core principle of putting our clients' interests first.

Project : Chase Home Finance Reports
Client : Chase Bank
Location : Columbus Ohio,| Bangalore, India
Environment : MicroStrategy 8.1.0, SQL Server 2005, Windows XP, Autosys
Duration : Oct 2007 -- Feb 2009
Team size : 15

The object of the project is to help in creation and maintenance of the existing and new reports in a consistent manner with more data accuracy which showcases the Chase Home Finance's Prime and non-prime categories information of the US Mortgage Loan accounting.

Roles and Responsibilities
As a Sr. Software engineer, I am responsible for Analysis, design, development, testing and implementation of new set of reports and to create dashboards based on the reports for the project. The project is dealing with interactive dashboards where the user can get the data upon their request in flash mode.

• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Developed Customized and Ad-hoc reports in Grid & Graph mode using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations - The end-users were able to generate Ad-hoc Report by Drilling up, down, within and across dimension or anywhere.
• Execute periodic -- weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Moved Objects from one environment to other.
• Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
• Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
• Tracking enhancement projects to ensure the project delivery on time.
• Effectively manage Changes through Change management process.
• Created Summary and Drill down reports for various attributes based on their hierarchies.
• Efficiently handle and Manage production support activities through Incident Management.
• Project Metrics collection and reporting to senior management.
• Used free form SQL editor for complex report creation.
• Weekly status review with client.
• Identify potential development opportunities and propose innovative solutions.
• Making sure that always sticking with the SLA (Service Level Agreements) commitments and producing SLA report to client and management.

Application Developer

First Advantage ZAPAPP

The Client First American Title Insurance Company provides comprehensive title insurance protection and professional settlement services for homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers, title agencies and legal professionals to facilitate real estate purchases, construction, refinances or equity loans.

Project : Occupational Health & Vendor Reports
Client : First American Title,
Location : Los Angeles, CA| Bangalore, India
Role : Application Developer
Environment : Microstrategy 8.1(Administrator, Architect, Desktop, Narrowcast sever, Object Manager), Oracle 9i, SQL Server 2005.
Duration : Mar 2005 -- Sep 2007
Team size : 7
Supported for one of its software module developed using a combination of OLTP and OLAP environment. The objective of this project would be to create and maintain their staff's occupational health reconciliation reports & vendor performance.

Roles and Responsibilities
• Gather Business Requirements, Analyze data, and Build BI reports of employee's verification tests - BAT (Breath Alcohol Test) analysis, Donor Test (DOT) Analysis and Non Donor (Non DOT) analysis.
• Develop Reports, Dashboards and Scorecards.
• Created targeted application documents for specific Stake Holder needs using MS Word, MS Excel, MS Power Point.
• Designed Interactive Dashboards in Microstrategy Web to assess vendor's performance and monitored the overall goals of the business.
• Creating Periodic, quarterly and yearly Key Performance Indicator (KPI) Reports on key areas of business.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Microstrategy Desktop.
• Designed Freeform SQL reports for meeting specific needs.
• Production support, trouble-shooting and fixing of reports was done in record time
• Created Objects like Object Prompts, Documents & Reports.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Extensively used report services to create dashboards to create Summary level reports using multiple datasets.
• Involved in System Testing, User Acceptance Testing
• Defect Fixing during the SIT and UAT phase.

References:
Available upon Request


Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

Related: Programmer / Developer Resumes | IT Resumes in San Jose, CA | IT Resumes in California