SUMMARY

• Extensive experience on Business Intelligence and Data Warehousing wif expertise in MicroStrategy Architect, Report development, and installation of MicroStrategy products.
• Strong noledge of all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Expert in writing and performance tuning SQL queries for ETL and reporting against Teradata.
• Broad industry noledge of retail, mortgage, and satellite television applications.
• Experienced wif database development in Teradata, Oracle (PL/SQL) and DB2.
• Lead teh conversion of 50 MicroStrategy reports to a new data mart, wif no usage disruptions to a user base of ~25,000
• Lead extensive performance tuning across teh Business Intelligence environment which resulted in all dashboards and reports running under 5 seconds wifout pre - caching data.
• Leading a team of four Database Analysts to accomplish several projects at teh same time
• Created 3 report builders to replace 12 reports dat were running in excel using pivot tables.
• Created a dashboard dat ran in minutes to replace reports dat were running in Microsoft Visio which took hours to run.
• Using my database noledge, single handedly worked on data validation, testing teh reports and finding defects before moving to production.
• Worked directly wif business users to make sure they received proper training to use all teh functionality dat MicroStrategy provides wif teh reports dat were developed
• Worked extensively on troubleshooting and tuning teh SQL generated by MicroStrategy
• All MicroStrategy Reports ran below teh suggested SLA after tuning efforts.
• Created source to target mapping and job design documents from staging area to Data Warehouse
• Used Control M to schedule running teh solution, testing and debugging its components, and monitoring teh jobs in production.
• Worked extensively on troubleshooting, performance tuning, performance monitoring and enhancement of DataStage jobs, SQL queries, Shell Scripts.
• Wrote several complex SQL queries to extensively test teh ETL process.
• Provided production support and performed enhancement on SQL scripts in multiple projects
• Involved in data profiling for separating teh pharmacy retail values from unsalable and assisted for future vendor projects.
• Running access plans on SQLs and suggested improvements on DB objects like indexes, MDCs, MQTs etc., after careful examination of timer on cost.
• Coordinating wif business users and halp them validating teh end resultsSales Analytics/Prepaid:
• Involved in creating entity relational and dimensional relational data models using data modeling tool Erwin and Microsoft Visio.
• Developed DataStage jobs using star schema
• Coded, tested and implemented components for querying and updating teh database.
• Performed tuning of ETL jobs and SQL queries
• Documented teh ETL system design process

TECHNICAL COMPETENCIES:

Tools: MicroStrategy 9, MicroStrategy 8, Oracle, SQL Server 2008 Suite, DB2, MS Access, Teradata v13.10, DataStage, Erwin, Office, UNIX, Visio

Industry Application: Retail, Satellite Television, Mortgage

Roles: Technical Architect, Programmer Analyst, Engineer, Team Lead

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Business Intelligence Developer

Roles & Responsibilities:

• Started as a Consultant through MicroStrategy on a staff augmentation project until January 31ST 2013.
• Working to create Business Intelligence solutions stemming from a single source of truth, leveraging Teradata v13.10, SSIS 2008, AutoSys, and MicroStrategy v9.3.1.
• Working closely wif DBA's to ensure code being passed across to Teradata is properly tuned and wifin tolerances. Using EXPLAIN plans in SQL Assistant and Viewpoint to identify opportunities for performance enhancements wifin production SQL code.
• Providing guidance and feedback to data modelers to ensure dat reporting needs are properly accounted for wifin teh database design.
• Worked wif business analysts in group to halp identify appropriate logic to satisfy business needs and provide guidance on where dis should be applied wifin teh BI solution (ETL vs. Reporting).
• Researching data issues reported by end users and validating changes being made to production by tracing data from teh reporting mart back to teh system of record.
• Working wif teh Helpdesk and other team members in group to train and educate on teh Business Intelligence solutions dat has been deployed.

Confidential, Minneapolis MN

Sr. MicroStrategy Consultant / Engineer

Roles & Responsibilities:

• Consultant role on RIP Visuals project.
• Worked as a MicroStrategy Developer to migrate reports from excel to MicroStrategy
• Created a dashboard to replace reports from Microsoft Visio to MicroStrategy.
• Successfully implemented teh reports and dashboards in Production and got sign off by teh business users.
• Worked wif Target India employees to tune all teh ETL jobs and also ensure dat they followed all teh best practices.
• Worked on testing and researching data issues as well as any other issues dat came up wif MicroStrategy once we were in production

Confidential, Pleasanton, CA

MicroStrategy Consultant

Roles & Responsibilities:

• Performed project merge from development to production environment using Project Merger Wizard
• Configured MicroStrategy Intelligence Server to make project available in production environment
• Developed and troubled shoot complex retail reports
• Using MicroStrategy OLAP, created versatile reports as analytical tools for calculating sales and I inventory for any given period or moment
• Set up teh security in teh MicroStrategy system: Controlling access to application functionality (privileges & permissions)
• Performed administration on MicroStrategy web products
• Managed, audited and upgraded license MicroStrategy system for teh proper licenses
• Used Enterprise Manager, loaded data from statistics tables to data warehouse table and scheduled Enterprise Manager statistic reports
• Monitored current user’s accesses, reports running and database connection by using monitoring tools such as Job Monitor, Project Monitor, User Connection Monitor and Cache Monitor
• Migrated metadata from development environment to production environment by using Project Merge Wizard

Confidential - Lakeland, FL

MicroStrategy Consultant

Roles & Responsibilities:

• Involved in Developing Enterprise Data Warehouse (EDW) for sales, an updated version of teh previous MicroStrategy project named Scandata
• Created views in Teradata and imported into MicroStrategy using Warehouse Catalog
• Developed Schema Objects such as Attributes, Facts, Hierarchies, Transformation
• Developed Public Objects such as Metric, Prompts, Filters, Templates, Drill Maps, Custom groups and Consolidations
• Involved in creating Canned and Ad-Hoc reports
• Moved MicroStrategy Metadata objects using Object Manager from Development to Stage for user testing, resolved teh issues and then to Production Environment.
• Developed concise Training Manuals for MicroStrategy Desktop and Web for users
• Implemented windows authentication login for teh users. Identified Power users and gave MicroStrategy Desktop Agent, Web Professional privileges
• Created complex reports for users and added additional functionality to teh users
• Checked all teh reports available in previous project, Scandata were developed wif same or more functionality in EDW
• Used Narrowcast Server to deliver reports via email and in Event Driven Reporting

Confidential - Wichita, KS

Technical Architect

Roles & Responsibilities:

• Consultant role on Unsaleable and Food Merchandise Analytics project.
• Unsaleable/FMA - part of teh SQL performance tuning team dat was involved in looking at all teh ETL jobs, SQL scripts and MicroStrategy Report SQL.
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Validated teh report generated through MicroStrategy by querying DB2 directly.
• Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across all environments.
• Created best practices and performance tuning documents dat were later used in different projects

Confidential - Pine Brook, NJ

Programmer Analyst

Roles & Responsibilities:

• Sales Analytics - primarily worked on creating ETL jobs and writing SQL Scripts to extract data from multiple sources.
• Prepaid- primarily worked on performance tuning existing ETL jobs and SQL scripts.
• Analyzed teh user requirements and project specifications to identify entities
• Developed ER models and process models and transferred to physical database
• Involved in database programming wif SQL and PL/SQL
• Performed database administrator duties dat includes creation of tables, views, indexes, user roles, regular backups and monitored teh performance
• Involved in developing test cases and oversee teh manual testing