Profile

Accomplished IT professional with 16 years ofsolid careerin architecting, designing and managing business intelligence and ITsystems.Extensive background in the areas of data warehousing, predictive analytics, systems management, process improvement, KPI development, and data quality. Offer a unique combination of in-depth technical knowledge and leadership skills that are valuable to any organization undertaking business intelligence or data architecture initiatives.

Core Qualifications

Accomplishments

• Implemented forecasting mode which helped users funding more than 4 billion in 1st quarter after implementation and saved them many hours of work preparing forecast and funding.
• Created solution for marketing data mart, which resulted into 75 saving in time for marketing department to produce forecast and plan for sales on weekly and monthly basis.
• Implemented dashboard and call volume alert system, which resulted into timely action within minutes instead of hours saving millions of dollars otherwise lost due to dropped calls.
• Architected and modeled solution for automated performance summary dashboard/reports which saved total 3 to 4 man hours on daily basis

BI Technologies and Methodologies

Professional Experience

Confidential

Principal Consultant / Business Intelligence Architect

• Responsible to provide architecture, design and development support for successful implementation of Housing and Urban Development's HUD's Next Generation Management System NGMS
• Implemented and troubleshoot MicroStrategy integration with Oracle WebCenter Portal
• Designing and maintaining data models for data marts in Oracle using Visio for new reporting requirements, reports personalization, portal navigation, and ETL audit
• Designing and developing ETL solutions for data integration and auditing using Informatica PowerCenter
• Architected and designed solutions for reports personalization using MicroStrategy and access via portal
• Designed and developed solution for comments and form entry via MicroStrategy dashboards
• Helped creating 508 compliant dashboards and reports using MicroStrategy
• Preparing and updating technical design documents to keep up-to-date with design decisions

Environment: MicroStrategy 9.3.1/9.4.1, Informatica 9.1, Oracle 11g, SQL/PL-SQL, SQL Developer, JavaScript, MS Visio, Oracle WebCenter Portal 11g

Confidential

Information Technology Scientist

• Designed and implemented financial data mart FinMart and reporting solutions Enterprise Business Accountability System EBAS for The Joint Staff, and Justice Enterprise Data Integration JEDI for Department of Justice DOJ
• Upgrading and Supporting FinMart implementation at Department of Justice DOJ including requirements management for new data integration and reporting
• Designed and Implemented new modules to enhance FinMart solution for Enterprise Business Accountability System EBAS at The Joint Staff
• Implemented MicroStrategy BI in CACI virtual cloud environment for HUD FDM team
• Designed and implemented pilot data integration and reporting solution for Navy Military Sealift Command MSC
• Functional and Technical SME on designing and implementing Integrated Budged Forecasting Model iBFM for Housing and Urban Development HUD using de-normalized relational data model
• Architected, designed and developed reporting solutions including dashboards and scorecards
• Migrated legacy systems into advanced BI solutions using Informatica
• Prepared documents like technical architecture, SOP, Data Models, Data Dictionary
• Created data model and ETL logic to create financial data mart using Oracle Warehouse Builder
• Assisted ETL team with ETL work using Informatica and Oracle Warehouse Builder
• Participating in writing winning proposals

Environment: MicroStrategy 9.0.2, Cognos 8.4, Informatica 8.6, Oracle Warehouse Builder 11g, Erwin, Visio, Oracle 11g, SQL/PL-SQL, SQL Developer, TOAD, Teland Open Studio for Data Integration, Microsoft Office 2007, VBA

Confidential

Manager Engineering

• Handled major releases end-to-end along with being functional and technical SME on major areas like accounting, finance, sales, customer service and marketing, model automation, and supporting end customers as a Manager of Business Intelligence team in fast paced environment,
• Transformed complex business requirements into real world solutions that customers truly needed
• Architect solutions keeping cost, time, integration and resources into consideration
• Guided an innovative technology architecture for data collection and utilization
• Modeled data based on top-down and bottom-up methodologies, star and snowflake schemas as well as CLDM methodologies on Teradata
• Implemented Conceptual, Logical and physical data models to support business processes
• Expertise in business analysis process to understand and transform user requirements
• Worked with internal and external partners and subsidiaries users to understand the analytical, reporting and dashboard needs to provide right solution
• Created visual and/or working prototype to validate and confirm the requirements gathered
• Designed, Developed and Troubleshoot ETL using different technologies like Informatica Power Center, SQL, Shell scripting using different sources like RDBMS, flat file, XML, proprietary data source of Salesforce.com, etc. and targets like Teradata and Oracle
• Developed complex ETL logic to handle automation, data integrity and performance
• Developed data dictionary and maintain metadata
• Implemented customer address parsing using Informatica Data Quality
• Built audit framework to ensure data quality in data warehouse
• Oversaw unit and system tests and assisted users with acceptance testing
• Worked on enhancement/upgrade projects by analyzing database structures and applications
• Tuned applications in terms of optimization, index analysis and mapping with data model
• Administered MicroStrategy BI environment including but not limited to upgrades, installations, configuration, managing users, jobs, database connections, cache, schedules, licensing, project configuration, object migration, project merge and duplication, etc.
• Metadata management as well as project architecture using right facts, attributes and hierarchies
• Designed and developed executive and departmental dashboards and reporting using MicroStrategy BI suite
• End-to-end reporting migration from one environment to other including architecture, database design, ETL and reports development
• Established reporting framework on Salesforce.com SaaS platform
• Successfully delivered projects involving multi-million dollar financial transactions
• Proficient at doing gap-analysis which includes understanding of complex business issues and organization needs, creating road-maps for large data warehouse migrations and BI solutions
• Lead and challenged the team members with outstanding communication and people skills
• Managed onshore and offshore/off-site teams involved in data warehousing development using agile and waterfall models
• Excel at team management, team building skills and mentoring
• Managed team to align with project execution plans and resource planning/tasking
• Established goals, performed mid-year and yearly reviews for the team
• Lead EDW strategic initiatives like sales tracker, web analytics, corporate metrics, Salesforce integration, etc.
• Defined technical standards
• Implemented peer design and code review process for cross training and maintain standards
• Managed ongoing module planning, estimation and resource allocation
• Prepared and maintained compliance documents
• Created, updated and maintained different reusable templates
• Prepared and maintained system design and test documents
• Worked on overall design and development of DW migration from Oracle to Teradata
• Designed, developed and implemented Voice-Of-Customer VOC system
• Guided text analytics POC working with vendors
• Prepared proposals, presentations and vendor SOW
• Provided on-call support to production systems to resolve any issue
• Troubleshooting projects to find the faults and provide the performance improvements
• Trained users with existing reporting as well as conducting in-house jump start trainings

Environment: MicroStrategy 7i/8.x/9.x, Informatica 8.x, SQL Server 2000/2005, Oracle 9i/10g, Teradata, MS Access, SQL/PL-SQL, Unix, LINUX, Toad, AetnaSuite, Erwin, MS Visio, Salesforece, VBA

Confidential

Principal Consultant Tech Lead

• Worked as a Principal Consultant helping clients of various sizes with all phases of data warehousing and business intelligence implementations, while involved in building information architecture and business intelligence consulting practice.

Confidential

Programmer/Analyst

• Worked on eCommerce and database projects involving different stages of System Development Life Cycle SDLC .

Confidential

Systems Engineer

• Started as a college trainee, later became employee as a Systems Engineer, customized and implemented off the shelf financial accounting and purchase systems.