Business Intelligence Architect | ||
| Availibility: | Available | |
| Date Posted: | Aug 05, 2009 | |
| Location: | Bay Area, CA | |
| Resume: | Summary:
β’ 8 years of IT experience in Software Analysis, Design, Development, Implementation of business applications for Retail, Ecommerce, Financial, Insurance, Media and Marketing verticals β’ 6 years of experience in database development using Microsoft SQL Server 2005 / 2000 and Oracle 10g / 9i / 8i β’ Expert at designing complex data models, data mapping documents to integrate seamlessly in various type of web and desktop based reporting platforms and other applications β’ Experience working with Microsoft Sql Server Integration Services (SSIS), Microsoft Sql Server Reporting Services (SSRS), Microsoft Sql Server Analysis Services (SSAS) and DTS packages β’ Experience writing complex T-SQL, SQL, PL/SQL, Stored Procedures, Cursors and Views etc. β’ Expert at designing integration logic and components to support source to target mapping, edit rules and validation, transformations and business logic β’ Easy to work with and able to clearly convey technical information to non technical business users β’ 3 Certifications in Microstrategy business Intelligence reporting platform and 3 Certifications in Oracle β’ Very strong technical knowledge in ETL tools like Informatica, Datastage & Talend etc β’ Well developed resource management and time management skills β’ Good knowledge of PMI recommended project management methodologies β’ In-depth knowledge of client - server and web applications β’ Able to work successfully both independently and within a team β’ Good organizational, verbal and written communication skills β’ High energy and a total go getter attitude Technical Skills: BI & Reporting MicroStrategy, Business Objects, Crystal Reports, Cognos, SAS, Microsoft Reporting Services, SSAS, SSRS, Performance Point, QlikView ETL Data cleansing, Data Profiling, SSIS, Informatica, Datastage, SQL Plus, SQL Loader Data Modeling OLTP, OLAP, ROLAP, MOLAP, Cubes, Star Schema, Snowflake Schema, Dimensional Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin, Embarcadero ER/Studio, MySQL Workbench Databases Microsoft SQL Server, Oracle, MySQL, Teradata, Netezza, Microsoft Access Web Design Adobe Illustrator, Adobe Photoshop, Macromedia Flash, Microsoft FrontPage, MS Visual Web Developer, Eclipse, Netweaver Programming SQL, PL/SQL, Transact SQL, HTML, DHTML, XHTML, CSS, PHP, Ruby on Rails Education& Certifications: β’ Bachelors in Computer Science β’ Coursework in MBA - International Business β’ PMI approved Professional Project Management Certificate β’ Microstrategy Certified Report Developer (CRD) β’ Microstrategy Certified Platform Administrator (CPA) β’ Microstrategy Certified Project Designer (CPD) β’ Oracle Certified Associate (OCA) in SQL β’ Oracle Certified Professional (OCP) in PL/SQL β’ Oracle Certified Professional (OCP) in Internet Applications β’ Certified in Data Warehousing β’ Diploma in Web design PROFESSIONAL EXPERIENCE: Online Marketing, San Francisco, CA Jul2008 β present Sr. Database / BI Architect - Consultant Ecommerce β Knowledgebase Management Application This is a global advertising and marketing agency. It operates in many communications disciplines including: advertising, direct marketing, public relations, public affairs, brand development, customer relationship management, sales promotion, interactive marketing Responsibilities β’ Created Logical and Physical data models while translating logical data structures into physical database objects β’ Analyze business requirements, plan and deliver solutions based on client needs β’ Design datawarehouse architecture and optimized solutions for BI platform β’ Perform complex data analysis to create Ad-hoc reports β’ Design and develop optimal ETL solutions for new and existing data feeds, for Microsoft SQL Server and Oracle datawarehouse using stored procedures and SSIS packages β’ Implement change management strategies to prepare for growth β’ Troubleshooting, testing and tuning of T-SQL and PL/SQL stored procedures for optimal performance β’ Setup email campaigns using blast agents like Yesmail Enterprise β’ Analyze campaign effectiveness and consumer behavior β’ Prepare recommendations for various clients based on data based insights β’ Set up periodic ETL imports from multiple data sources like Omniture, Google, Yesmail and various FTP clients β’ Train business users, vendors and clients on the usage and capabilities of the solutions developed β’ Planned and coordinated the large scale migration from Oracle to SQL Server database β’ Migration of all Oracle specific ETL, Procedures to Sql Server specific Procedures and SSIS packages β’ Configure and install various business intelligence applications including Microstrategy and Business Objects β’ Performed full upgrade of Microstrategy BI platform including the Web, Desktop, Narrowcast Server and Enterprise Manager β’ Design and direct analytics and reporting projects from project inception through final debrief Environment: Oracle, SQL Server, Microstrategy, Business Object, Windows Server 2003, MS Office, TOAD, Sql Loader, Batch files, Perl, Omniture, Google Analytics, Yesmail Enterprise Retail, San Francisco, CA Oct2007 β Jun2008 Sr. Database / BI Architect - Consultant Ecommerce Retail β Sales Channel Analysis This is one of the world\\\\\\\'s largest specialty retailers. They operate four of the most recognized apparel brands in the world. Responsibilities β’ Provide expertise in data management to the business in evaluating requirements and developing solutions and design proposals β’ Created new and modified existing logical, physical BI data models to compliment the changes made in OLTP, ETL and company websites β’ Provided hardware requirements and worked with infrastructure teams on data warehouse builds β’ Interacted with Business user group in Requirements gathering, Analysis aiding in Implementation of better optimization techniques for improved Performance β’ Understanding the Historical Data and analyzing User requirements. Worked with user groups and business users in defining their requirements β’ Train and manage new resources and other users β’ Interface with Business Analysts, QA and development teams on day to day basis β’ End to end Administration, Schema development and Maintenance of Microstrategy 8i business intelligence platform and Narrowcast Server β’ Developed end to end ETL solutions using PL/SQL, SQL Loader for data from various FTP sources and CSV files β’ Created Services, Schedules and Subscription Sets in Narrowcast Server β’ Configured Metrics, Attributes and Filters for each Report. β’ Perform prompt completion of tasks following biweekly release cycle, in an agile development environment β’ Testing and Tuning of Reports and Queries using Explain plan, Indexes and Partitions etc Environment: Oracle, SQL Server, Teradata, Microstrategy, Crystal Reports, IIS, Windows XP Professional, Windows Server 2003, MS Office, TOAD, Sql Loader, Perl, Datastage, Omniture Analytics Data Social Network, San Francisco, CA Dec2007 β Jul2008 Technical Project Manager Social and Professional Networking Startup This is a 100% free to use social and professional networking service. Responsibilities β’ Wore different hats throughout the life cycle of this start site and helped with all sides of development and planning β’ Designed and developed a robust backend OLTP database platform to compliment the cutting edge web 2.0 networking application β’ Managed off shore and on shore development efforts β’ Used Trac wiki and issue tracking software to manage all the development activities β’ Recruited cost effective development and QA resources β’ Prepared detailed project plans β’ Used agile development methodologies to deliver product release on time β’ Proactively managed changes in project scope, resources and budget, identified potential crises, and devised contingency and mitigation plans β’ Performed end to end planning of deliverables as per requirements β’ Performed end user QA to test the quality of product β’ Involved in architecting the data model for scalability and performance β’ Acted as Product manager and created detailed PRDs. Environment: LAMP, WAMP, MySQL, Sql Server, Eclipse, Trac Wiki, Google Analytics, PHP Finance, San Jose, CA Apr2007 β Oct2007 Business Intelligence Lead Architect Finance β Mortgage Securities Application This company invests in, credit-enhances, and securitizes residential and commercial real estate loans and securities. Responsibilities β’ Interacted with On shore and Off shore teams, Technical Leads, Senior Management and Stakeholders on day to day basis β’ Managed Business Intelligence and datawarehouse teams comprising of many developers, administrators and architects β’ Created Project Plans and conducted team meetings β’ Created Data/Dimensional Models using Embarcadero ER Studio β’ Planed and implemented end to end ETL solutions using T-SQL and SSIS 2005 Packages β’ Planning and development of advanced financial reporting using SSRS and SSAS β’ Understood the business measures and attributes to develop a reliable Star Schema and required Facts and Dimensions β’ Validated and managed project scope, goals and objectives in collaboration with senior management and stakeholders β’ Worked as a subject matter expert and guided/helped team members in following best practices and issue resolution activities β’ Interviewed resources/consultants for upcoming positions β’ Assisted in seamless relieving of Microstrategy employees working on site and knowledge transfer to off shore team in India β’ Oversaw the end to end Administration, Schema development and Maintenance of Microstrategy 8i business intelligence platform β’ Created various Projects and maintained different Project Sources Environment: Microsoft Sql Server, SSIS, SSRS, SSAS, Microstrategy, T-SQL, Unix, Linux Lead Generation, San Francisco, CA Jun2006 β Apr2007 Sr. Business Intelligence Architect / Analyst Ecommerce β Strategic Analysis Application This is a leading performance based marketing services company. It delivers over 1.5 million quality customers and leads each month to clients across select consumer verticals. Responsibilities β’ End to end Administration, Schema development and Maintenance of Microstrategy 8i business intelligence platform and Narrowcast Server β’ Facilitation of meetings with different departments and conduct training sessions and presentations β’ Defined, designed, built, and deployed cutting edge data warehouse and reporting infrastructure β’ Moving the Prototype Metadata Repository from MS Access to Oracle 9i production data mart, during Phase 2 β’ Set up periodic ETL imports from multiple data sources like Omniture, Google, Web Trends and various FTP clients β’ Collected PRDβs from various departments and created BI solutions as per their requirements and analyzed their feedbacks to make enhancements to the newly created reports and documents, from time to time. β’ Understanding the business measures and attributes to develop a reliable Star Schema and required Facts and Attributes β’ Development of Complete Metadata using application datawarehouse using SQL Server and Oracle β’ Creating various Projects and maintain different Project Sources β’ Setting up Metadata Repository in MS Access to develop a prototype, during Phase 1 β’ Developing various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters etc Environment: MicroStrategy, SQL Server, Oracle 9i, SAS, MS Access 2003, IIS, Windows XP Professional, Windows NT, Windows Server 2000, MS Office, TOAD, Visio 2003, Omniture, Web Trends, Google Analytics, Google Adsense data, Unix, Linux Staffing, NJ Oct2005 - Jun2006 Database / BI Consultant Ecommerce β Strategic Analysis Application Responsibilities β’ Understanding the Historical Data and analyzing User requirements. Worked with user groups and business users in defining their requirements. β’ Designing and Maintenance of Metadata using MicroStrategy DSS Architect. β’ Designing and Development Project Sources, Projects, Customized Attributes, Hierarchies, Facts, and Base Formulas. β’ Involved in designing the Data mart following Multidimensional models and Logical Model β’ Developing Customized and Ad hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations. β’ Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats. β’ Created Relationship Filters based on Existing Model. β’ Configured Metrics, Attributes and Filters for each Report. Administrator, Architect & Designer Roles. β’ Interacted with Business (User) group in Requirements gathering, Analysis aiding in Implementation of better optimization techniques for improved Performance. Environment: MicroStrategy, IIS, Windows XP Professional, Windows NT, Windows Server 2000, MS Office, Oracle 9i,10g, Sql Server, Visio, Unix, Linux Staffing, San Jose, CA Feb2004 β Oct2005 Database / BI Consultant Responsibilities β’ Involved in various business intelligence projects at companyβs client locations throughout US. β’ Managed a team of bi developers directly β’ Created Project plans and target deadlines for product launch etc β’ Provided immediate support to a team of junior developers β’ Developed design and analysis documents β’ Created MicroStrategy Filters, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, and Hierarchies etc. for developing project. β’ Involved in migration from Crystal 7.0 to 10 β’ Involved in the development of reports by using Crystal Reports 10. And Oracle 9i as database. β’ Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports 10. β’ Developed Cross Tab Reports, Sub Reports by using Crystal Reports version 10. β’ Created and modified Oracle views according to users requirements. Environment: MicroStrategy, Crystal reports, Crystal Enterprise, MS Office, Teradata, Sql Server, Unix, Linux Staffing, San Francisco, CA Mar2002 β Feb2004 Informatica ETL / Database Developer Premium Module Management Responsibilities β’ Design and develop OLTP and OLAP databases β’ Write complex T-Sql and PL/SQL procedures β’ Responsible for Business Analysis and Requirements Collection β’ End-to-end ETL development of the Premium Module Data Mart β’ Maintained warehouse metadata, naming standards and warehouse standards for future application development β’ Parsing high-level design spec to simple ETL coding and mapping standards β’ Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer β’ Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Tuning the Informatica Mappings for optimum performance β’ Modeling and populating the business rules using mappings into the Repository for Meta Data management β’ Understand the business needs and implement the same into a functional database design β’ Building advanced ad hoc and canned reports using Cognos Business Intelligence platform Environment: Informatica, Oracle, Sql Server, Cognos, UNIX, Linux |
|
| Education & Certifications: |
Microstrategy Certified
Oracle Certified Professional |
|
| # Years of Web Analytics Experience: | 5 | |
| # Years of SEM Experience: | 4 | |
| # Years of SEO Experience: | 4 | |
| Expert skills / experience in: | BI, SQL, PL/SQL, Microstrategy, Oracle, SQL Server, MySQL, Reporting, Project Management, Communication, Documentation, MS Office, HTML, CSS, PHP, ETL, Data Extracts, Omniture, Doubleclick, A/B Testing | |
| Contact for Availibility: | contractor@iqworkforce.com | |
| Go back to last page | ||
 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||