SUMMARY:

• 5+ years of IT industry experience in implementing all phases of the System Development Life Cycle (SDLC), including Business requirements gathering, Design, Development, Testing, and Implementation.
• Experience with Ad hoc reporting and standard reporting environment.
• Solid understanding in Meta Data Strategies, Warehouse Standards.
• Experience in latest BI Tools Microstrategy, Tableau and Qlikview Dashboards Design.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques.
• Created Data Mart Reports using Complex Filters and Compound Metrics
• Extensively worked in creating and integrating reports and objects (Attributes, Facts, Metrics, Filters, and Prompts) with the data warehouse.
• Designed and Developed Dashboards and Scorecards using Report Services Documents
• Proficient in Analysis, Design and Development of applications using Oracle, SQL Server, Teradata and MS Access .
• Worked on the ETL mappings Design, Analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets
• Design of system requirements, specifications, and design documents of large systems using Object Oriented Modeling Techniques .
• Design and build integration logic and components to support source to target mapping, edit rules and validation, transformations, and business rules
• Good analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation
• Aptitude for problem solving and making critical decisions on a short time frame.
• Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS:

BI &Reporting: MicroStrategy, Tableau, Qilkview,Crystal Reports, MS Access Reports

OS: WINDOWS 95/98/NT/2000, UNIX & MAC 7.x

Databases: Oracle, MS SQL Server, Teradata, Db2, MS Access

Internet skills: HTML, DHTML, XML, ASP.net, C#.net and VBScript

Languages: C, C++, SQL, PL/SQL

Web & Application: IIS, SMTP, Apache, BEA Web Logic Servers

PROFESSIONAL EXPERIENCE:

Confidential, CA

BI Microstrategy Analyst

Responsibilities:

• Worked with Business users and was involved in requirements gathering, design /development life cycle, user interaction and report design and development
• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
• Worked with MicroStrategy Architect to build Attributes, Facts, Hierarchies and Relationships between various attributes and developed perfect logical models for reporting environment.
• Created dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Designed and Developed Ad hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations.
• Designed and Developed Dashboards and Scorecards using Report Services Documents.
• Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Created Transformations for using in comparative reports like this year to last year (year to date and month to date).
• Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Built SQL scripts and queries for data analysis and extraction.
• Involved in Testing and Tuning of Reports and Objects.
• Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.

Confidential, CA

Business Analyst

Responsibilities:

• Involved in requirements gathering from the Business users, design /development life cycle, user interaction and report design and development.
• Build Attributes, Facts, Hierarchies and Relationships between various attributes and developed perfect logical models for reporting environment.
• Identify Source tables and columns required to create Schema Objects.
• Created dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Designed and Developed Ad hoc reports using Templates, Metrics, Filters, Prompts, and Transformations.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Designed and Developed Dashboards and Scorecards using Report Services Documents
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Used Auto prompt filter features.
• Created source and target definitions, mappings and transformation rules.
• Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
• Involved in creating user groups and security filters for users and assign privileges.

Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web

Confidential, CA

BI Analyst

Responsibilities:

• Identify Source tables and columns required to create a MicroStrategy project.
• Configured reports for end users in Desktop, MicroStrategy Web.
• Employed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Designed and Developed Dashboards and Scorecards using Report Services Documents
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Used Auto prompt filter features.
• Created source and target definitions, mappings and transformation rules..
• Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
• Provide End user training by giving Demos/Presentations.
• Involved in creating user groups and security filters for users and assign privileges.

Confidential, CA

BI Developer

Responsibilities:

• Involved in requirements gathering from the Business users, design /development life cycle, user interaction and report design and development.
• Extensively worked and developed Ad hoc reports and standard reports.
• Developed filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
• Developed Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created and implemented Consolidations and Custom Groups to better accommodate user requirements.
• Created Transformations for using in comparative reports like this year to last year (year to date and month to date).
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
• Involved in creating user groups and security filters for users and assign privileges