SUMMARY

• 7 years of hands on experience in Business Intelligence and Data Warehousing projects, Information Management and Delivery involving Complete Life Cycle (Requirements Gathering, System Analysis, Design, Implementation, Testing and Migration)
• Extensive experience in Relational Databases (RDBMS) such as Oracle, SQL Server, Informix and Traditional OLAP/Relational OLAP databases using Micro Strategy 9/8.x/7.x.
• Actively involved in Business and Functional Analysis, Data Modeling, and Source System Analysis, Design, Reporting Architecture, development and implementation of BI Applications using MicroStrategy 7.2.4/8.0.1/8.0.3/8.1/9.0.1/9.0.2.
• Experience in installation and configuration of Oracle SQL Developer and SQL Server Management Studio to create views and execute SQL.
• Managed complete ETL and monitoring SQL Server Agent Jobs, mapping and extracting data, writing queries and clearing monthly data load logs.
• Designed Scorecards, Metrics Dashboards, Performance Summary Dashboards, and Dynamic Content Dashboards in DHTML modes, Dynamic Visualization Dashboards using Flash Widgets, Analytic Element Selectors and best design practices.
• Provided training to business users and dashboards presentations to higher management.
• Extensive Experience in MicroStrategy Desktop, Web, Architect, Administrator, Object Manager, Enterprise Manager, Command Manager, Integrity Manager, Project Merge, User Merge, Intelligence Server, Metadata Repository and Project Configuration.
• Managing MicroStrategy User Groups, Importing and deleting users and groups, linking Users to Windows Users, User Manager Integrity Checker and controlled access to database data.
• Comprehensively worked in creating complex reports (grid, freeform, drilldown, adhoc) and market measure documents in MicroStrategy in MicroStrategy Desktop and Web using features like Advanced Filters, Metrics, Templates, Prompts, Consolidations and Custom Groups.
• Implemented Intelligence Server Tuning, Configured Cache Encryption and SQL optimization techniques using VLDB Properties Editor and Aggregate Tables.
• Configured Distribution Services administered and monitored Schedules and Subscriptions in MicroStrategy Web.
• Configured Health Center Network, Diagnosed and fixed problems, Analyzed Log Files, and managed Change Journaling.
• Excellent Communication, Analytical and Problem solving abilities with excellent understanding of system development life cycle and proven project management skills.
• Exposure to Global Delivery Model on managing Onsite/Offshore projects and ability to quickly learn new domain, business and latest technologies.
• Created comprehensive Documentation and provided training as a final phase of turnover. Supported regulatory compliance Base II, Data Privacy Act, HIPPA, Sarbanes-Oxley Act.

SKILLS

OLAP Tools MicroStrategy 9.x/8.x/7.x (Desktop, Web, Architect , Administrator, Object Manager, Integrity Manager, Enterprise Manager, Command Manager, Intelligence Server, Report Services and Dash Boards)

Data Modeling Dimensional Data Modeling, Star Snow-Flake Schema Modeling, ROLAP DW Architecture, Physical and Logical Data Modeling, Object Oriented Analysis and Design, SDLC (Software Development Life Cycle) Methodologies, Informatica Power Center 8.6, Oracle SQL Developer 2.1, SQL Server 2005

RDBMS Oracle 11g/10g/9i/8i, SQL Server 2005/2008, MS Access

Programming C++, SQL Scripts, HTML, DHTML, Java scripts, UNIX Shell Scripts

Environment HP-UX, Sun Solaris, Informix 3.80, Windows 95/98/NT/2000/XP, MS DOS

WORK EXPERIENCE

Confidential Los Angeles, CA May 2011 – Present
Sr. BI/DW Specialist

ALL Management Corporation has provided a wide range of services for both government and private student loans. These services include loan originations, loan servicing, customer service, customer outreach, financial literacy, default prevention, and loan portfolio management and reporting. ALL primarily achieves this goal by offering federal student loans to students and parents with interest rates substantially better than the statutory maximums prescribed by federal law under the Higher Education Act. In order to raise capital to support such lending activities, ALL issues public debt securities, using a mix of financing structures to maximize the efficiency of such debt issuances.

Environment: MicroStrategy 9.0.2 (Desktop, Web, Architect, Administrator), SQL Server 2005 Management Studio

Responsibilities:

• Worked with the Finance, Marketing, Funding, Loan Trust and Accounting teams to gather business and functional requirements and scope definers.
• Designed fully functional MicroStrategy Project using MicroStrategy Administration, Configuration and MicroStrategy Desktop Architect.
• Designed, Created and managed data in the Metadata Repository, imported tables, dimensions and facts from the warehouse catalog and maintained referential integrity.
• Created Monthly, Quarterly, Rolling 8 Quarters, Portfolio Characteristics Reports, Servicer Transaction Detail, Activity Summary, Servicer Mapping, Roll Forward Validation, Funding Summary, Weekly Volume Reports, Market Measure, Corporate Summary and Financial Dashboards on Loan Applications and Disbursements information.
• Created user groups, security filters to authenticate users and groups and control data visibility in development and production environments.
• Worked on ROLAP architecture involving analysis directly on top of relational (Level 1) database with no predefined cubes resulting in improved performance of reports and more flexible reporting.
• Validated Principal Amounts and Principal Balance Outstanding for Loan Detail, Transaction data and Summary data to make sure that the monthly loaded data balance at ROLAP L0 and L1 data warehouse levels.
• Managed complete ETL and monitoring of SQL Server Agent Jobs for Servicer Accounting Data and mapping and extracting data and running queries to clear logs on a monthly basis.

Confidential Wilkes Barre, PA Jul 2010 – Apr 2011
Sr. BI/DW Consultant

As member of USPS Agile Methodology Development Team, worked to identify roles and tasks required to provide a smooth transition from their “End-of-Life” legacy applications to the new USPS.com website and served as a MicroStrategy Architect, Developer and Tester to all of their appropriate environments.

Environment: MicroStrategy 9.0.2 (Architect, Desktop, Web, Intelligence Server), Oracle SQL Developer 2.1, Borland Caliber 9.0

Responsibilities:

• Gather and document business and report requirements and create MicroStrategy Architecture Requirements Documentation and data model as part of the Analysis Phase.
• Extensively developed reports and corporate dashboards for Accounting/Finance, Reconciliation and Revenue Allocation, Fraud Detection and Prevention, Inventory/Fulfillment, Catalog Management, Decision Analysis and Cross-Functional Reports.
• Assisted Team to determine Security Requirements for access to the project, reports and data presented via the reports.
• Metadata Objects including Dimension Hierarchies, Advanced Prompts, Conditional Metrics, Transformation Metrics and Level Metrics.
• Performed Adhoc data analysis, Advanced Drill Maps, Prompts, Attributes and Metrics Filters on metadata to capture the information and created advanced grid reports.
• Conducted performance testing in QA and developed various steps to improve Query Performance in the reports by usage of Report Caching and Aggregate Tables and database specific optimization using the VLDB Properties Editor.
• Generated and Executed SQL Queries in Oracle SQL Developer to get the individual count of the variables in different schemas of the database in an environment and validating data model to ensure accurate results and good performance for reports that are adhoc in nature.
• Proactively involved in highlighting the Data Discrepancies on the Onsite Reporting Team and ETL team and evaluated tuning opportunities.
• Communicated Status, Milestones and Project Issues and risks internally and externally via Status Reports and Trackers as input to overall project plans for work scope.

Confidential Beaverton, OR Jan 2010 – Apr 2010
BI/DW Consultant

Intel’s Component Inventory Cost System (iCOST) is the cost calculation engine and manages the cost associated with over 80% of Intel’s inventory. The project involved external financial reporting to stakeholders and Sales Process Analysis. Reports were created using MicroStrategy on basis of Daily, Monthly, Quarterly and Yearly Global Sales data and Customer data from Data Warehouse providing a well-rounded conceptual view of calculating costs to continuously improve Intel’s business.

Environment: MicroStrategy 9.0 (Desktop, Web, Architect, Intelligence Server) SQL Server 2008, MS Office Suite, Windows XP

Responsibilities:

• Responsible for requirements gathering with Service Delivery Project Teams to capture customer needs, gather information, and understand client’s business drivers, definition of KPI’s and performance dashboards.
• Created Income Statement, Balance Sheet, Forecasting Dashboards and drill down Dashboards and reports on all financial KPI’s.
• Actively involved in Project Scheduling, planning and design preparation and review of report design and test cases.
• Performed Adhoc data analysis, Advanced Drill Maps, Prompts, Attributes and Metrics Filters on metadata to capture the information and created advanced grid reports.
• Developed various steps to improve Query Performance in the reports by usage of Caching and Aggregate Tables and database specific optimization using the VLDB Properties Editor.
• Generated and Executed SQL Queries to get the individual count of the variables in different schemas of the database in an environment and validating data model for reporting.
• Solving the issues (SIRS) with clients on a priority basis and maintained comprehensive Documentation.
• Part of Post Implementation process and enhancements to reports in different modules.

Confidential Mumbai, India Jun 2008 – Mar 2009
BI/DW Specialist

Start-up Software Development Company dedicated to developing the premier telecommunications cost management software application in the industry. The solutions incorporate the capabilities for end users to control and govern each aspect of the Telecom Lifecycle from procurement to payment. Supported the Service Delivery Project Teams to design and create sophisticated customer stewardship reports comprising five core areas of Telecom Lifecycle: Purchasing, Inventory, Invoicing, Chargeback and Analytics for analysis of business performance metrics using images and objects for high performance standards.

Environment: MicroStrategy 8 (Desktop, Web, Architect, Intelligence Server, Narrowcast Server) ICM Expense Management 8.0 Analytics, Oracle 10g

Responsibilities:

• Worked with the Analytics and Operations team to gather business and functional requirements and customer’s scope definers.
• Designed fully functional MS Desktop Schema using MicroStrategy Configuration Wizard and MicroStrategy Desktop Architect.
• Defined and created trend reports and complex customer reporting and Dashboards using the existing monthly reports and customer’s immediate needs as scope definers.
• Provided technical support, report troubleshooting and training to business users.
• Performed extensive testing and validated reports against the Data Warehouse.
• Created several reports and objects including Attributes, Facts, Functions and Operators, Hierarchies, Consolidations, Custom Groups, Filters, Metrics and Prompts.
• Developed MicroStrategy Metadata Objects and to date, Ago Reports, dashboards including advanced Drilling options.
• Involved in reports enhancements and performance tuning MicroStrategy Intelligence Server for better performance.
• Implemented the delivery of reports using MicroStrategy Narrowcast Server to alert the associated teams.

Confidential Irvine, CA July 2006 –Mar 2008
BI/DW Specialist

In this hybrid IT/Operations position focusing on logistics analysis and services provided to multi-million dollar apparel client averaging 500,000 units inbound/outbound per month, assisted senior IT analysts and effectively handled, analyzed and summarized large amounts of data creating reports/metrics for management and created new methodologies for improving warehouse performance. Analyzed and enhanced the software for one of their key operating programs resulting in higher operating efficiencies.

Environment: MicroStrategy 8 (Desktop, Web, Architect, Intelligence Server, Narrowcast Server) SQL Server 2008, Warehouse Management System Client Viaware 5.7.2, MS Office Suite, Windows XP

Responsibilities:

• Worked as a MicroStrategy Developer and Designer for generating a series of inventory control reports by performing detailed analysis of inventory management process and customer requirements.
• System ensured the execution of defined Inventory Control Tasks to be compliant with the Nike Audit Requirements and Hurley Standards.
• Worked extensively on creating and automating several reports on various processes of supply chain planning covering Product Relocation, Sku Velocity, Sku Location Analysis, Inventory Aging, Pick Velocity, Receiving Inbound/Outbound, Shipping, Cycle Counts, Replens and Wave Planning.
• Installed and configured the complete MicroStrategy Analytics environment and set up the Security and Connection Pools.
• Worked with the ETL and Operations to identify the required FACTS, Dimensions, Dimension Hierarchies, and referential joins in the Physical Model.
• Used warehouse catalog to create the new tables and map with respective attributes, facts and created metrics, filters and prompts.
• Developed dynamic Dashboards with drill down capability, scorecards and prompted analysis reports using MicroStrategy Report Services.
• Served as an Administrator to create Catalogs based on requirements and incorporated prompts, filters, calculations in reports and dashboards.
• Resolved complex hierarchy and strong security needs including Administration of users and user groups, applying and maintaining security for users including permissions and privileges.
• Analyzed inventory discrepancies to identify and call out the root cause of the discrepancy so they can be corrected and collectively enabled in achieving 99.9% inventory accuracy in the warehouse.

Confidential Long Beach Jan 04 –Jun 06
IT Student Assistant

The Information Technology Department is one of largest divisions of the CSU located in Long Beach CA. Growing database and demand of users to query database for reporting purposes raised the need for a new enterprise data warehouse system. This new system was more robust and it increases the query performance and decreased the return query time.

Environment: Crystal Reports, SQL Server 2000, DHCP Server, Fiber Backbone, CMS, Remote Access, Web Server, Web-based Email, WAN, Computing and Voice Data Services.

Responsibilities:

• Worked with the end users on complex queries and helped them retrieve results from the SQL Server and validating report metrics.
• Conducted walk-through sessions for database end-users to give them a better understanding of the SQL Server.
• Tested User-views across the SQL Server environment to check for the accuracy of results.
• Installation and support for data security services like Pretty Good Privacy (PGP) disk encryption, provision of VPN services to Windows, Linux and Macintosh clients.
• Provided support for Lotus-notes 6.5 and POP mail support, management of user accounts and security.
• Exposed to ADS configuration, setting up of local and group policies, installed and configured IIS, Outlook Web Access and proxy servers.

EDUCATION

• Master of Science, Computer Science
• Bachelor of Engineering, Computer Engineering