Sr. Tableau/sql Developer Resume
SUMMARY:
9 years of comprehensive experience in design, development and deployment of Data warehouse & reporting solutions while ensuring effective timeline management and delivery. Dynamic professional with customer - focus, has worked on up-scaling Data warehouse implementations to cater to changing analytic and decision-making needs of business.
TECHNICAL SKILLS:
- Tableau v2018.x, v10.x, v9 & v8 - Tableau Desktop, Tableau Server, Tableau Public and Tableau Prep
- IBM Cognos BI 10.2/10.1/8.4/8.2 - Framework Manager, Transformers and Cubes, Report Studio, Cognos Administration, Cognos Configuration & Security, Analysis Studio, Query Studio, Workspace Advanced, IBM Cognos Adaptive Warehouse, IBM Cognos Workforce Performance Analytics, Cognos Connection
- SAP BI - Data Services Designer, Information Design Tool, Webi, QWAS, HANA
- Oracle
- SQL Server, T-SQL
- Amazon Redshift, Postgres SQL
- Informatica - Work flow Manager, Powercenter Designer, Work flow Monitor
- Data Modeling, Data warehouse methodologies, Star Schema
- Python programming (self-learning)
CORE COMPETENCIES:
- Comprehensive Business Intelligence Solutions Development
- Implementing Real-time Reporting Solutions
- Dashboard Design and Story Building
- Dimensional & Relational Modeling
- Application Development, Testing and Administration
- Requirement Gathering and Design
EXPERIENCE:
Confidential
Sr. Tableau/SQL Developer
Tools: Tableau 10.3, SAP BODS, Oracle, SQL Server
Responsibilities:
- Creating tableau dashboards as per business requirements
- Data modelling and implementing the business logic in SQL Server
- Understanding requirements and creating the high-level design
- Determining the data flow strategy and design.
Confidential
Tableau Developer
Tools: Tableau 10.3/10.5, SAP HANA
Responsibilities:
- Creating tableau dashboards as per business requirements
- Designing a summarized version of the dashboard for the tableau mobile platform
- Understanding requirements and creating the high-level design
- Determining the data flow strategy and data modelling.
- Received quarterly employee appreciation award shared with the team
Confidential
Tableau Developer
Tools: Tableau 10.1/10.2, SAP HANA
Responsibilities:
- Creating tableau dashboards as per business requirements
- Designing a summarized version of the dashboard for the tableau mobile platform
- Understanding requirements and creating the high-level design
- Determining the data flow strategy and data modelling.
- Received quarterly employee appreciation award shared with the team
Confidential
Data Analyst
Tools: Tableau 10.1, Amazon Redshift, Postgres SQL, Oracle, MS SQL Server, AWS Platform
Responsibilities:
- Creating tableau dashboards as per business requirements
- Understanding requirements and creating the high-level design
- Determining the data flow strategy and integration of various heterogeneous data sources.
- Data modelling and creation of star schema
- Creating SQL scripts to enable data extraction and cleansing.
Confidential
Technical Consultant
BI Tools: IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS
Responsibilities:
- Defined scenarios influencing the business and customer experience in the process.
- Converted these scenarios into requirements and HLD.
- Requirement gathering, brainstorming, logic building to tackle the changes required at the Data warehouse end in order to maintain seamless User Experience.
- Transitioned the HR Data Marts onto the new standards.
- Extensive testing and production deployment of code changes.
- Mentored team members and subordinates to ensure effective delivery of agreements.
- Directed quality assurance (QA) efforts to maximize customer satisfaction and minimize bugs/errors.
- Highly appreciated by client for robust design and successful production deployment.
Technical Consultant
Confidential
BI Tools: IBM Cognos BI 8.4, IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS
Responsibilities:
- Installation and migration of Cognos Version 8.4 to 10.2.2 on the new servers.
- Prepared Impact Analysis and mitigation plan for server migration task as well as Cognos version upgrade.
- Migration of application from one set of windows server to a set of new servers as it had reached end-of-life.
- Coordinated with IBM team and raised PMRs for glitches faced with 10.2 version functionality and applied fix packs accordingly.
- Thorough testing of complete distributed architecture and migration of the Data warehouse on newer version.
- Received recognition for the team’s performance from client post production sign off.
Technical Consultant
Confidential
BI Tools: IBM Cognos BI 8.4, IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS
Responsibilities:
- Translated business goals, feature concepts and customer needs into prioritized product requirements and use cases, and then to technical specifications and prepared High Level Design & Scope of proposed application.
- Developing the FM models to cater to the report developer needs.
- Building Transformer OLAP Cubes to cater to the Business Analyst’s needs.
- Providing training to end users on Cognos Connection and Analysis Studio use.
- Implementing enhancements and adding additional features to the existing application, in order to improve performance & enhance customer experience.
- Managed and delivered a project from start to finish for building a data mart for the Training function of the client organization using IBM Cognos BI Adaptive Warehouse.
- Responsible for End-to-End implementation and worked single-handedly on the entire SDLC for this project.
- Build the data model & reports using Oracle ERP as the source, Cognos WFPA for model design and Cognos BI for reporting & security.
- Achieved customer delight through earnest efforts. Successful go-live and a fully functional bug-free application currently being used by the client to report and influence business decisions on their Training Vertical.
Confidential
Developer
Responsibilities:
- Developed Report Studio reports using Cognos 8.4 BI Suite.
- Worked with Business team to obtain detailed technical requirements.
- Responsible for design, coding, testing & documentation for reports.
- Performed code reviews and functional testing of reports.