SUMMARY:

• Over 12 years of extensive Information Technology experience in Business Intelligence/Data Warehousing across various domains including Pharmaceutical, Banking, Insurance, Telecom, Retail and Hospitality with extensive experience in architecting, administering and creating Dashboards / scorecards, Mobile applications using MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy office, MicroStrategy Architect, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, Command Manager, SDK.
• Over 9 years extensive Hands on experience in Logical and Physical Data Modelling, Database Schema Design, Development and Administration using Teradata, Teradata SQL, ORACLE, SQL, PL/SQL, IBM DB2, Hadoop. Experience in designing ETL processes using Informatica, Data Stage, Ab - Initio 2.8, TERADATA utilities and Unix Korn Shell scripting. Over 12 months experience using Hadoop, HIVE, HBASE, and SQOOP.
• Over 6 years extensive experience leading enterprise data warehouse and reporting system teams in large and complex AGILE environments and delivering BI/DW projects on-time and within budget. Extensive knowledge and experience in all stages of Software Development Life cycle (SDLC), Rational Unified Process (RUP), and Project life cycles, Agile and Waterfall software methodologies.
• Over 9 years experience in gathering business requirements and process information to create clear, concise and complete business and functional requirements and analyzing and redesigning business processes.
• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Extensive experience Designing and creating MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Extensive experience developing and Administering MicroStrategy server/projects/users/security using command Manager, scanMD, configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, and performance monitoring, tuning and troubleshooting.
• Extensive experience coordinating and deploying MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Excellent interpersonal and communication skills with proven ability to develop strong relationships within the organization in order to coordinate project operations, and leading diverse customer base (internal and external) and contention on resources and prioritizing on delivery tasks.
• Successful at transforming business ideas and processes into complete solutions and configuring applications to fit the company's business model.

TECHNICAL SKILLS:

RDBMS: Teradata v12, Oracle EXADATA, DB2, MS Access, Sybase, SQL Server 2000

OLAP/ETL: Business Objects 5.1/4.x/3.x, WebIntelligence 2.0/2.6, Infoview 1.0, Cognos Impromptu6.0, CognosPowerPlay 6.6.1, MicroStrategy 9/8/7.x/6.0, Informatica, Ab-Initio 2.8.

OS: MS: DOS, SCO UNIX, Red Hat Linux, UNIX (Sun Solaris), MVS, MP-RAS, Windows98/ XP/2000/NT, Hp R-11i/9000/3000, IBM Aix 4.x.

Hardware: SUN Ultra 450, SUN E6500, HP: UX 10.0, IBM Compatible PC's, EMC2 5000 servers.

Applications: Erwin, MS Visual Studio, Designer 6i, VB 5.x/6.0, crystal reports, Web logic, Visual Caf, Rational Rose

Utilities: BTEQ, Fastload, Multi: Load, TPump, Queryman, WinDDI, Oracle SQL- Loader, ERWin 3.5.2, TOAD, Visio, Enterprise Manager 1.2.2

Languages: Java, C, C++, SQL, XML, HTML, DHTML, MQ-Series, UML, COBOL II, JCL, Visual Basic, PL/SQL, SQL*PLUS

Others: ER Data Modeling, Normalization Techniques

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead/Architect

Responsibilities:

• Provided Technical Leadership and performed project scope Determination, Requirements Gathering, Requirements Analysis, Design, Development, Testing, UAT Presentations, Implementation and Post production support of MicroStrategy projects.
• Implemented agile delivery approach for MicroStrategy projects and worked closely with stake holders, business users and developers to formalize business ideas, define requirements. Lead and delivered multiple projects with-in budget on time
• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Coordinated and deployed MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Designed, Developed, Tested and supported ETL processes for a Data Warehouse from their legacy systems. Designed, developed System and Unit Test plans and performed extensive System, Regression and Unit Testing of the ETL Job streams.

Environment: Hadoop, MicroStrategy 9.4, Oracle, SQL Server 2005, Windows NT / 2000, Windows XP.

Confidential

Technical Lead/Architect

Responsibilities:

• Lead and delivered multiple projects with-in budget on time. Developed the Project Scope, Vision, Project plans, Estimates, Road Maps and Traceability documents. Performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Coordinated and deployed MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Worked closely with stake holders, business users and developers to formalize a business idea and define requirements.
• Implemented agile delivery approach for MicroStrategy projects. Designed Components, Templates, Filters and generated MicroStrategy Reports in grid and graph mode. Developed and Administered MicroStrategy projects/users and designed reports. Refined reporting business requirements. Created necessary objects to meet report requirements.
• Created and maintained attributes, metrics, filters, prompts and reports. Maintained security for all users. Created database views and performed quality assurance for all reports.
• Analyzed, gathered requirements data, verify requirements and create functional design specifications (FDS). Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Performed project scope Determination, Requirements Gathering, Requirements Analysis, Design, Development, Testing, UAT Presentations, Implementation and Post production support of BI projects.

Environment: MicroStrategy 9.2.1, Oracle Exadata, Windows NT / 2000, Windows XP.

Confidential, Vienna, VA

Technical Lead/Architect

Responsibilities:

• Leading an onsite team and an offshore MicroStrategy Global Development Centre Team. Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Coordinated and deployed MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Developed the Project Scope, Vision, Project plans, Estimates, Road Maps and Traceability documents. Performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Worked closely with stake holders, business users and developers to formalize a business idea and define requirements. Implemented agile delivery approach for the BI projects. Provided Technical Leadership to Business Intelligence/Enterprise Data warehousing team.
• Created Technical Architecture Diagrams and Data Flow Diagrams. Developed the Project Scope and Vision document in assistance with the Project Manager. Also performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Assisted the testing team in developing the test plan, test conditions, and test cases based on business requirements and technical specifications. Developed estimates, project plans (Microsoft project), training material, BI reports using Micro strategy.

Environment: Business Objects, MicroStrategy 9.2.1, Teradata, Windows NT / 2000.Windows XP.

Confidential, Orlando, FL

Technical Lead/Sr. Developer

Responsibilities:

• Performed project scope Determination, Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of MicroStrategy projects.
• Generated Report services Documents and implemented MicroStrategy Reports. Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Coordinated and deployed MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Built Narrowcast Server to deliver reports and alerts via multiple delivery methods and publications. Involved in developing the logical data model that serves as the map for schema object creation in MicroStrategy 7.2.2 Architect and allows for multidimensional analysis. Upgraded and Migrated MicroStrategy Projects from MicroStrategy 6.x to MicroStrategy 7.x
• Migrated the target data warehouse from ORACLE to TERADATA. Created logical and physical models. Created new database objects, tables, views, macros, and users in TERADATA to support the functions of the existing objects in ORACLE. Monitored tablespace usages in the databases. Extensively used T- SQL.

Environment: MicroStrategy 8.1.1, Oracle 8i, Windows NT / 2000.Windows XP.

Confidential, DE

Technical Lead/Sr. Developer

Responsibilities:

• Extensively worked in both Ad-hoc and standard reporting environments and Involved in creating Reports scalable to large volumes of data. Lead projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Coordinated and deployed MicroStrategy report changes to the Production environment using object Manager. Created proactive delivery reports using MicroStrategy distribution services and narrowcast servers. Monitored and Tuned Performance of MicroStrategy Intelligence Server.
• Designed ETL process to extract data from SQL server2000 and SAS to Teradata and performing data scrubbing, restructuring and consolidation for Web reporting. Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata SQL to transfer clean up and summarize data, Wrote Perl and UNIX Shell scripts. Automated transfer of data entry using Informatica Power Center.
• Developed and assembled reports for technical documentation of production incidents and system changes. Conducted Code Reviews and Design reviews in both the development phase and the data migration effort made to production systems.

Environment: MicroStrategy 8.0/7.5,Informatica 7.1.3, SQL, BTEQ / BTEQWin, FastLoad, MultiLoad, FastExport, TPump, Visual Explain, OleLoad, Queryman, DB2, Oracle 8i, Windows NT / 2000.Windows XP.

Confidential, GA

Technical Lead/Sr. Developer

Responsibilities:

• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Developed and Administered MicroStrategy server/projects/users/security using command Manager, scanMD configured project sources, optimized using VLDB properties, configured project statistics, applied security filters. Created database views, performed quality assurance, Technical problem solving, performance monitoring, tuning and troubleshooting.
• Built Narrowcast Server to deliver reports and alerts via multiple delivery methods and publications. Involved in constructing the logical data model that serves as the map for schema object creation in MicroStrategy 7.5 Architect and allows for multidimensional analysis
• Involved in various backend Informatica ETL development tasks and production support. Developed standard and reusable mappings and mapplets using Mapplet Designer. Used different transformations like Source Qualifier, Joiner, Aggregate, Lookup, Stored Procedure and Router Transformations in mappings.
• Responsible for technical documentation of the entire ETL process. Worked on debugging and performance tuning of mappings and sessions. Created and scheduled Sessions and Workflows using Informatica Workflow Manager.

Environment: MicroStrategy 8.0, 7.5, 6.0, Informatica 7.1.3, Teradata (v2r5), Teradata V2R4.1, SQL, BTEQ / BTEQWin, FastLoad, MultiLoad, FastExport, TPump, Visual Explain, OleLoad, Queryman, DB2, Oracle 8i, Windows NT/2000, Windows XP.

Confidential, VA

BI Developer/Business Analyst

Responsibilities:

• Designed, Developed, Tested and supported ETL processes for a Data Warehouse from their legacy systems using Ab-Initio. Designed, developed System and Unit Test plans and performed extensive System, Regression and Unit Testing of the ETL Job streams.
• Extensively worked in both Ad-hoc and standard reporting environments and architected MicroStrategy Mobile dashboards and scorecards using Intelligent Cubes scalable to large volumes of data. Modelled Snowflake schemas for optimum performance and scalability.
• Designed and created MicroStrategy Projects, Facts, Attributes, attribute roles, attribute relationships, table aliases, Hierarchies, Transformations, logical views, compound metrics, filters, prompts, View filters, Derived Elements, Thresholds, templates and Drilling.
• Implemented Ab-Initio configuration and well-tuned setting up environment for Production and development environment. Responsible for deploying Ab-Initio graphs and running them through the Cooperating systems mp shell command language.

Environment: NCR Teradata 4.x, MicroStrategy 7.3.2, Ab-initio 2.8, Oracle, PL/SQL, Korn Shell Scripting, Teradata, Hp- Unix, TOAD.