Technical Designer Resume
4.00/5 (Submit Your Rating)
SUMMARY
- 11.5+ Years of IT experience in design, analysis, development and implementation of various applications using BI Tools.
- Motivated and results - driven BI developer with a proven record of accomplishment in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
- Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications.
- Strong hands on experience in designing dashboards, data visualizations, and analytics using Tableau Desktop and Server.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Have excellent SQL knowledge.
- Experience with all phases of software development life cycle (SDLC) and Agile methodologies.
- Worked on small and large-scale projects. Believe in teamwork. Have delivered as a team member, team lead and as independent consultant.
- Have Knowledge of Big Data technologies like Hadoop.
- Have knowledge of basic AWS platform services like EC2,S3,VPC,Elastic Load Balancer, Route 53, Auto Scaling Group, Database on AWS like DynamoDB,Redshift, Aurora
- Have extensive experience of data modelling in OBIEE 11g/12C repository, designing Subject Area and Dashboard development, RPD, Catalog Security Migration.
- Strong experience in troubleshooting OBIEE server issues.
- Excellent communication and leadership skills.
PROFESSIONAL EXPERIENCE
Confidential
Technical Designer
Responsibilities:
- Led the design and development of reporting data module for a HR & Payroll integration portal built for HR & Payroll Campus users of UC Berkeley.
- Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
- Developed at least two - three visual options for each report for discussion with University stakeholders (product owners and leadership) and business users.
- Created new star model and modified the existing star schemas to include new dimension and fact tables in OBIEE Repository.
- Designed the Oracle BI Repository from scratch.
- Implemented security in OBIEE by creating custom Application roles.
- Designed and developed OBIEE reports and dashboards.
- Migration of RPD and catalog across environments.
- Assisting in data validation in QA environment, identifying the source data issue and coordinating with ETL team for fixing the data issues. Occasionally make changes in RPD to accommodate the changes in ETL side.
- Provided Production support to OBIEE users and Wrote Custom SQL to support business requirements.
- Interviewed Business Users of the DWH and Business Analysts to understand and troubleshoot the existing bottlenecks and problem areas.
- Co-ordinate with business users and assist them in UAT
Confidential
BI Consultant
Responsibilities:
- Analyzing user requirements and validating the available data to propose usable designs.
- Interacting with multiple stakeholders to gather business needs & developed technical specs.
- Created new dashboards, reports with various visualizations based on business requirements.
- Defined Best Practices for Tableau Report development.
- Developed cohort analysis to help support Sales target.
- Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed tracking and improving customer units Confidential .
- Supported the development and modification of Tableau views in Tableau Desktop, while preparing documentation and training users from respective units.
- Deployed over 60 analytics projects for all departments using Tableau 9.x
- Converting existing OBIEE, excel based reports to Tableau reports.
- Publishing and sharing reports with the business users on the Tableau Server.
