Business Intelligence Developer Resume
On-canadA
Summary
- 5+ years of experience as database and business intelligence developer.
- Knowledge of several leading business intelligence tools specialised in Microstrategy and Cognos. Well versed in developing reports and dashboards.
- Experienced in identifying the KPI s and develop the data warehouse design.
- Transferred data from the source to the DW with effective ETL methodologies and tools.
- Knowledge of business functions like finance , marketing & sales and operations
- Excellent communication and presentation skills.
- Experiencing in gathering and analyzing business requirements and guided the team to provide desired results on time.
- Ability to work on tight deadlines and on different applications concurrently .Provide timely solutions to production support issues and the new enhancements for maintenance projects
Strengths & Expertise
Business problem analysis and Requirement gathering | Data Modelling
Data Quality | Business Intelligence Systems
Business Intelligence Report Development | Entity-Relationship (ER) Modeling
Data Analysis | Software Development Life Cycle
Agile methodologies | Client & Stakeholder Relations
Technical Skill
Database Platforms: MS SQL Server, Oracle, Teradata, MS Access.
Analysis\\Design tools: Rational Rose, ER/Win
Reporting Tools: Micro strategy, Cognos, SSRS.
ETL Tools: Informatica, SSIS
Education
Bachelor in Engineering - Information Technology
CURRENT ENGAGEMENT - HIGHLIGHTS
Confidential - Business Intelligence and Data warehousing Company 2009-Present
Role & Responsibilities
- Working as Database and business Intelligence Developer.
- As a Business Intelligence Consultant responsible in collaborating projects and delivering creative solutions to clients.
Confidential, Canada
- Engaged by one of North America\'s largest packaged foods companies to facilitate the in-house development of sophisticated tools for corporate performance management.
- Provided the development team with scalable data to integrate analytical and operational reporting from heterogeneous systems into their Enterprise Analytics solution.
- Helped the company to adapt an off-the-shelf reporting solution to meet the specific data flow and reporting requirements of ConAgra.
- Re-engineered existing financial reports to resolve data quality issues in the whole data transportation layer, saving several days of reconciliation efforts.
Confidential - Micro strategy Report developer/Data analyst2007-2009
Role & Responsibilities
- Worked as Micro strategy Report developer/Data analyst Consultant.
- Assess quality and integrity of data collected, analysis performed and reports generated.
- Design, develop and produce aggregated and dashboard reports for clients.
Confidential, Micro strategy Developer
- Development of Micro Strategy dynamic dashboards and reports.
- Develop/Maintain the front-end repository including Metrics, Filters, Views and dimensions.
- Was a part of development strategies for Extraction, Transformation and Loading.
- Worked with the analytical and statistical team members to classify and quantify metrics to assist internal and external stakeholders.
Confidential, Chennai, India - Data Analyst 2006-2007
Role & Responsibilities
- Evaluate the financial data to decipher the profitable and non-profitable areas of revenue. Additionally, make conclusion about the cost incurred on various activities.
- Plan, design, and implement application database code objects, such as stored procedures and views.
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
- Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.