OBJECTIVE:

• Result oriented hardworking professional with extensive knowledge of BI and MicroStrategy Architecture and technology, strong big data working knowledge, excellent communication, inter personal skills, and organization skills with proven ability to lead project teams to deliver to the agreed upon solutions at the highest quality in complex and challenging customer environments. Also, a fast learner with both business and technical expertise, very strong analytical ability and problem solving skills.
• Now looking for a new and challenging position, one that will make use of the best of my existing skills and experience and also further my personal and professional development.

SUMMARY:

• Over 10 years of experience in Data Warehousing technologies with primary focus in Business Intelligence Architecture, Analytics, Design, Development, Testing and Implementation.
• Deep understanding of data warehousing concepts and strong experience in Dimensional Modeling.
• Involvement in full lifecycle of Data Warehousing Architecture, BI Framework Design and Development involving multiple Source Systems.
• Extensive experience in MicroStrategy Product Suite including Desktop, Web, Integrity Manager, Administration, Distribution Services. Designing Web Dashboards with Visualizations, Intelligent Cubes etc.,
• Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
• Over 2 years of experience in Hadoop stack, HDFS, Sqoop, Pig, Hive, HBase,,Oozie and Datameer.
• Excellent experience in software development methodologies including Scrum/Agile Model.
• Extensive work experience as an Architect and Lead with complete ownership of end - to-end deliverables including requirement gathering, analysis, design, development, testing, launch and post production support.
• Certified by MicroStrategy Academy and MapR Academy.

TECHNICAL SKILLS:

Domain Expertise: Cards and Payments, Loyalty Management, Rewards and Redemptions & Life Sciences

BI Analytics & Tools: MicroStrategy Product Suite (10.1,9x,8x), Crystal Reports, XI R2, Tableau 9.3

Big Data Ecosystem: Hadoop, MapReduce, Hive, Pig, Sqoop, Oozie, Datameer

Methodologies: Waterfall, Agile

Databases: Db2 9.7.x, Oracle 8.x/ 9.x/10g/11g, SQL Server

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Big Data Tech Lead/Data Architect

• Played the role of Data Architect and Big Data Technical Lead for a large multinational credit card and financial services client. Worked on multiple initiatives in the big data space for the client.
• Worked as a Data Architect for a major initiative that involved building a derived layer in the big data repository benefitting multiple applications
• Conducted sessions with Business and Technical teams to understand the derivations required, performed analysis to come with the complex data mapping and modeled the tables in the derived layer.
• Developed code for the derived data layer using Apace Hive and Apache Pig from different sources and different types of data feeds such as history/snapshot feed types.
• Created event based scheduling jobs to trigger the ETL processing
• Worked as a Tech Lead for a project that involved creating data sets to be used for marketing campaigns based on certain events and triggers by accessing data in big data lake.
• Developed Datameer datalinks and workbooks to connect with the HDFS and hive tables and perform complex logic to build the dataset based on events and triggers.
• Imported data using Sqoop to load data from Netezza to HDFS on regular basis.
• Performed data ingestion from source systems to the enterprise big data lake using metadata driven framework.
• Involved in the migration of Talend based application to big data platform

Confidential, Phoenix, AZ

Business Intelligence Architect/Data Architect

• Played the role of BI Architect for a large multinational credit card and financial services client.
• Worked on multiple Reporting project initiatives starting from project definition to implementation.
• Involved in conceptualization, requirement gathering, performing analysis and feasibility study, proposing solutions, estimation, data modeling, functional/technical designs, development, testing and Implementation.
• Involved in Architectural tasks such as Solution Architecture, Warehouse Data modeling, BI design, Database performance tuning and database design.
• Responsible for interacting with source systems to understand source data, identify data elements/layouts needed for DW and come up with the Data Model.
• Managed a team of BI leads and developers, both Onsite and Offshore and responsible for work distribution, project timelines and quality deliverables.
• Manage complete life cycle of MicroStrategy from development to deployment along with technology and business partners.
• Created logical view tables, custom groups, consolidations, transformations and objects using pass through functions.
• Created Schema and Application objects (facts, metrics, attributes, hierarchies, reports, filters, prompts and templates) using Desktop and Architect.
• Developed Intelligent Cubes based on the technical and business specifications of the customer to increase performance.
• Developed dashboards, reports on Desktop and Web using templates and widgets.
• Performed MicroStrategy Administrative tasks

Confidential, Phoenix, AZ

QA Tester/Report Developer/Technical Lead

• Played various roles on different projects from QA Tester, Report developer to Technical Lead.
• Offshore Technical lead for various Reporting applications for a leading global information and technology services company providing clients in the healthcare and lifescience industries.
• Developed mockups of reports for approvals from business before the actual development commenced.
• Involved in design, development, testing, implementation and support turnover for all Reporting changes in MicroStrategy.
• Data modeling for the various layers (datamart and the report layers).
• Created Schema and Application objects (facts, metrics, attributes, hierarchies, reports, filters, prompts and templates) using Desktop and Architect.
• Developed dashboards, reports on Desktop, and web using templates and widgets.
• Worked extensively on VLDB Properties for performance tuning.
• Performed functional, regression and UAT testing to make sure the reports are inline with requirements.
• Offshore Lead for various maintenance releases on MicroStrategy Reporting applications.
• Projects executed using MicroStrategy Desktop, Web, Narrowcast server, Enterprise Manager, Oracle Database, Unix Shell scripting, Cybermation ESP.