We provide IT Staff Augmentation Services!

Bi Lead Consultant (sql Server, Ssis, Bobj,tableau) Resume

PROFESSIONAL PROFILE:

  • Senior Business Intelligence/Data Consultant
  • Dedicated Business Intelligence professional committed to excellence
  • A high performer with 22 years’ experience in designing, developing and implementing projects.
  • Extensive Technical Expertise in SQL, Data Integration, Data governance, Dimensional Modeling, Data Mapping and EDWs
  • Experience in creating Data Models
  • Implemented data management solutions planning, architecting, developing, testing and deployment
  • In - depth understanding and experience with relational and dimensional data modeling practices
  • Experience in datawarehouse design and dimensional modeling along with solid understanding of ETL design, data governance
  • 5 years experience in SAP Business Intelligence areas with full life cycle implementations on 3 SAP BW implementations
  • BO Data Integrator (ETL) and BOBJ
  • Strong expertise in Modeling on HANA and HANA certified
  • PMI Methodologies, Ability to Staff, build and lead teams within deadlines
  • Aware of Quality Assurance processes, CMM, Six Sigma. Worked on several project Methodologies
  • Worked on various delivery models such as Waterfall, Agile
  • Diverse geographical experience working in Americas/Asia/Africas/Middle-east.

TECHNICAL SKILLS:

  • Worked on databases like Oracle/SQLServer/DB2/Netezza
  • Experienced in working on Unix/Linux
  • Experienced in Unix Shell Scripts
  • Worked on ETL tools like Informatica/SSIS/BODS/SAPBW
  • Experience in SAP BO,Tableau
  • Trained in BigData technologies like Hadoop/Hive/HBase/Spark/Scala
  • Trained in Machine Language (Regression/Classification)
  • Exposure to AWS Cloud/EC2

COMPETENCIES:

  • Design and Development
  • Enhancements
  • Modeling
  • Project Co-ordination
  • Project Management
  • Team Setup
  • Knowledge Management
  • Intergroup Co-ordination
  • Mentoring
  • Customer Service
  • CMM and Six Sigma
  • ASAP Methodology

CAREER EXPERIENCE:

Confidential

BI Lead Consultant (Sql Server, SSIS, BOBJ,Tableau)

Responsibilities:

  • Talking to key business users/power-users and creating data providers/marts from multiple sources
  • Created Data models (Dimensional)
  • Solid Understanding of ER models and clarity between OLTP and OLAP models
  • Solid experience translating business requirements into conceptual, logical, and physical data models.
  • Involved in end to end life cycle including requirement understanding/validation, analysis, design and build, testing, UAT support and deployment
  • Implement best practices and methodologies in data analysis, design and modeling.
  • Designing Visual reports in tableau
  • Designing ETL feeds using SSIS and Stored Procedures
  • Creating BO Universe and
  • End-End Ownership of delivery

Confidential

BI Consultant/Data Architect

Responsibilities:

  • Provided end-to-end consulting engagements to clients
  • Technical leadership and guidance on Modeling/ETL to developers and reporting teams
  • Created roadmaps to cover the future technology-skill gap and mitigate any risks
  • User requirement Gathering and Validation
  • Dimensional Data Modelling and Semantic Layouts
  • Data Modeling for areas such as Account Schedules/AP/AR
  • Created the high-level and low-level designs, managed Data Integration and definitions across sources
  • Created and employed standard best practices in data warehouse design and implementation
  • Designed ETL jobs/workflows and created BOBJ Universes and Webi reports
  • Foresaw risks and created mitigation plans, analyzed source data and highlighted issues
  • Worked on Datawarehouse sourcing multi-source disparate data
  • Ensured process compliance and smooth transition to support team while building datawarehouse from conception to production
  • Worked on Canned as well as Adhoc reports, created Standard Operating Procedures (SOPs) for the process
  • Team formation and Setup (whenever project demanded)

Confidential

Technology: SAP BO, SAP HANA,SAP BW

BI Consultant

Responsibilities:

  • Involved in End to End development
  • Requirements Gathering/Validation with the Business Users
  • Designed the model and high-level design
  • Design and Built data flows
  • Designed BOBJ Universes .
  • Created Standards and ensured adherence among the team
  • Contributions

Confidential

Technology: BO Data Integrator, BO Xi R3

BI Consultant

Responsibilities:

  • Overall In-charge of the delivery and Status reporting to Senior management
  • Requirements Validation with the Business and Design of ETL jobs/workflows
  • Foreseeing risks and creating Mitigation plans
  • Designed the model and high-level design
  • Managed Stakeholder’s expectations
  • Designed BOBJ Universes and Web reports and successfully deployed the solutions.
  • Created Standards and ensured adherence among the team
  • Contributions
  • Executed entire project lifecycle from scratch with relatively very junior team members. Gelled well with the team and successfully completed the development on time.

Confidential

Program Manager

Responsibilities:

  • Responsible for timely onboarding of team members
  • Planning and Resource management
  • Determined the resource requirements
  • Managed team’s work plans and ensured timely deliverables
  • Effective utilization of resources across multi projects
  • Mentored the Team members and provided Performance feedback
  • Created RACI and ensured compliance.
  • Cross team Knowledge management
  • Ensured and tracked Knowledge Transition
  • Created Standards and ensured adherence among the team
  • Contributions
  • Foreseen risks and created mitigation plans. Created and Re-used Standards.

Confidential

Technology: Netezza, ANSI SQL

Delivery Manager

Responsibilities:

  • Staffing and Team building
  • Planning and Resource management
  • Provided strategic and technical direction to the team
  • Determined the resource requirements
  • Assigned work to the team
  • Mentored teams and provided performance feedback
  • Ensured proper utilization of human resources across sub projects
  • Contributions
  • Encouraged cross-team knowledge management to create backups to mitigate unplanned absence. Leveraged best practices from other projects to increase efficiencies.

Confidential

Technology: SAP BI 7.0, Bex

BI Consultant

Responsibilities:

  • Involved in end-to-end implementation, covering the full project lifecycle as defined in ASAP methodology
  • Leveraged SAP Business Content (BCT) for architecting SAP BW Modeling and ETL processes
  • Worked on data warehouse and data marts with a focus on ECC 6.0 SAP HR applications.
  • Involved in designing including design of Cubes, Multiproviders, DSO Objects
  • Designed and Implemented Bex Queries, transformations and ABAP routines
  • Managed co-ordination with SAP Functional/ABAP/Basis team to facilitate smooth execution
  • Contributions
  • Saved 25% of person days efforts for the company by implementing the reports. Worked on the entire life cycle of HR BI Implementation. Worked on understanding the Requirements and translating into technical Design, Realization, UAT Support and deployment.

Confidential

Technology: SAP BI 7.0, Bex

BI Lead

Responsibilities:

  • End to end implementation, covering the full project lifecycle as defined in ASAP methodology.
  • Leveraged SAP Business Content (BCT) for architecting SAP BW Modeling and ETL processes
  • Worked on data warehouse and data marts with a focus on ECC 6.0 SAP MM applications.
  • Involved in designing including design of Cubes, Multiproviders, DSO Objects
  • Designed and Implemented Bex Queries, transformations and ABAP routines
  • Managed co-ordination with SAP Functional/ABAP/Basis team to facilitate smooth execution
  • Executed the Project using ASAP Methodology leading a team of 10 Onsite and Offshore
  • Created and Tracked schedules, Project Plan, Risk Mitigation Planning
  • Contributions
  • Worked on the entire life cycle of MM BI Implementation. Worked on understanding the Requirements and translating into technical Design, Realization, UAT Support and deployment. Led and Mentored junior team members and ensured timely and quality deliverables.

Confidential

Technology: Oracle/PLSQL/SQL Scripts/Informatica/Unix/BOBJ

BI Consultant/Technical Lead

Responsibilities:

  • Delivery and Requirements Validation with the Business
  • Dimensional Data Modelling and Semantic Layouts
  • Data Modeling for Areas like Account Schedules/AP/AR
  • Created high-level and low-level designs
  • Foresaw risks and created mitigation plans
  • Analyzed source data and highlighted issues
  • Ensured process compliance
  • Reporting status to Senior Management
  • Design of ETL jobs/workflows and created BOBJ Universes and Webi reports
  • Ensured smooth transition to support team while building datawarehouse from conception to production
  • Worked on Canned as well as Adhoc reports

Hire Now