Principal Consultant Resume

SUMMARY

Over 19 years of extensive highly motivated exposure in IT Industry focusing on Technical Analysis, Business Analysis and Data Warehousing and Business Intelligence Projects Development.
Strong Project Management and Time Management Skills.
Strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
Experience in E - R modeling, Dimensional Modeling (Star schema, Snow-flakes schema) to create Data Models, Logical and Physical design by using Erwin.
Experience in working with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
Expertise in Data Modeling Tools such as ERWIN and Data Warehouse Tools ETL such as Informatica PowerCenter.
Expertise in Identifying System Bottlenecks and enhancing the performance.
Expertise in design/Development/Analysis of OLAP SDLC (System Development Lifecycles) in Data Warehousing/Business Intelligence.
Experience in integration of various data sources like Oracle, SQL Server, Flat Files and DB2 into the staging.
Developed Stored Procedures using Oracle PL/SQL.
Broad exposure and proven ability to work with OLAP tools such as Crystal reports and Cognos for decision support.
Possess excellent communication and interpersonal skills and able to work in a team as well as individually.

TECHNICAL SKILLS

Project Domain: Application Development, Data Architect, Systems Integration, Project Office, etc.

Hardware: PCs, Compatibles

Operating Systems: Windows XP, Windows 2000, Windows NT, Windows 98/95, Windows 3.x, MS-DOS

Computer Languages: Visual Basic 4.0 - 6.0, VBA, HTML, JavaScript, VBScript, PL-SQL, Transact-SQL, Java, C/C++

RDBMS: Hyperion Essbase, MS SQL Server 4.5-7.0, ORACLE 9i, SYBASE 4.5-11.9.2, DB2, Access, MS SQL Sever 2005

Development Tools: Qlikview, QlikSence, SQL Navigator, Erwin, Visual Studio, Essbase Application Manager, MicroStrategy, Sagent ETL, MS OLAP Services, Informatica PowerCenter 7.1, Crystal Reports, Toad

PROFESSIONAL EXPERIENCE

Confidential

Principal Consultant

Responsibilities:

Gathered business requirements, design and implementation.
Designed and Developed QlikSense QA reports to validate data between SQL Server and QlikSense Data Model. The effort resulted in reducing significant amount of time spent on manual validation and errors.
Redesigned existing QlikSense reports to point to a new data model.
Replaced existing Qlik objects with Vizlib library extensions and subsequently designed the visualizations.
Designed and developed KPIs/dashboard visualizations using QlikSense for the leadership board.

Confidential

Senior BI Developer

Responsibilities:

Create and manage all BI/ Reporting functions within the IT serving HQ in Needham as well as offices worldwide.
Design of reports/dashboards/KPIs using Qlikview, DOMO.
Gather business requirements, design and implementation.
Managing and coordinating all aspects of project tasks and scheduling.

Confidential

Solution Consultant

Responsibilities:

Design, develop, validate, test of reports/dashboards/KPIs using Qlikview
Provide reporting support and enhancements to the various clients.

Confidential

Business Analyst/BI Reporting

Responsibilities:

Create and manage a new BI/ Reporting function within the International division serving HQ in Cambridge as well as over 30 offices worldwide.
Translate business requirements into functional requirements and logical data model requirements.
Demand management: Ensure that unmet business needs are understood, surfaced, and prioritized. This includes providing estimates for level of effort and costs associated with each request.
Work closely with the BI Competency Center to create data marts, cubes and corresponding data loads and to create and maintain the ‘Data Dictionary’ for International.
Design of reports/dashboards/KPIs using Qlikview, or management of 3rd party vendors when volume or complexity exceeds capacity.
Develop, validate, test and promote requested solutions and enhancements.
Maintain a report library of common reports which can be shared across departments and countries/regions.
Provide first line support for the FP&A International division’s BI/Reporting function.
Production monitoring of data loads and system performance. Create and maintain documentation as needed.
Participate in ongoing data validation to ensure data integrity and reliability.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship