We provide IT Staff Augmentation Services!

Bi Data Architect Resume

SUMMARY

  • He has broad set of technology skills to be able to design and build robust Hadoop solutions for big data problems.
  • He has a proven track record of guiding full lifecycle of Hadoop Solution including requirements analysis, platform selection, technical architecture design, application design and development, testing, and deployment.
  • He is a Self - starter, with a keen interest in technology and highly motivated towards success and has extensive experience includes following
  • Maintains current knowledge of marketplace changes, technology changes, and client businesses relevant to the Domain
  • Expertise in data modeling - relational and dimensional. Logical and Physical
  • Implementation of ETL and Reporting applications
  • Application/implementation of custom analytics
  • Designs complete Bigdata architecture having more than 1 PB data
  • Click Stream data analysis with 40 million plus customers
  • Administration of relational databases

PROFESSIONAL EXPERIENCE

Confidential

BI Data Architect

Responsibilities:

  • Managed Bigdata project from requirement specifications to solution implementation
  • Participated in high performance data analytics project using Hadoop in collaboration with Palo Alto research Center
  • Developed business use cases on areas where Hadoop helps to solve business problems.
  • Providing leadership on the Hadoop Architecture team responsible for defining technology architecture
  • Actively participated in evaluation and selection of new technologies.
  • Liaising with Business Users and Technical team to convert business requirements into Technical Specifications
  • Designed logical and physical enterprise data models. Consultation and review of logical and physical database design on all major projects
  • Provided thought leadership in emerging technologies as they relate to BI and Bigdata.
  • Develop requirements documents, performing data analysis on operational systems to verify business assumptions.
  • Designed solutions within the company and worked to build a plan to effectively gain buy-in from all business participants.
  • Worked closely with different Groups to insure cross group communications in an accurate and timely manner for support of new releases requiring modifications to the database structures
  • Identified opportunities for process improvements
  • Implementing Hadoop implementation in BI
  • Driving and participating in hands-on development of Map/reduce algorithms using Java and python

Technologies: Oracle, Linux, DataStage, Microstrategy, Hadoop, Hive, Pig, java, python

Confidential

BI Architect

Responsibilities:

  • Developed EDW and Dimensional data models to support analysis via Microstrategy and the Sales Portal.
  • Responsible for logical and physical models (200+ tables)
  • Worked with Business Analysts and Business Customers to define the Requirements and Delivery Approach.
  • Instrumental in the implementation of various standards and methodologies for maintaining and implementing data modeling standards including the mandatory capture of all relevant metadata at the logical level.
  • Designed and implemented ETL processes.
  • Developed Business Integration scenarios, technical design and data mapping
  • Assisted team during build documentation and creating unit test plans, conducted code reviews
  • Provided detailed documentation and training to the IT and business communities on the changes made and the impact on their application coding.
  • Implemented processes for data profiling
  • Improved performance and maintainability by implementing BI reporting models and data warehouse
  • Responsible for the deliverables for Data source development, Enhancements, design and development of end to end BI solution
  • Assisted and trained Finance and Distribution end-users to create and enhance reporting
  • Reconciled data between source systems and data warehouse
  • Supported international end-users on technical and functional issues
  • Single point of contact responsible for business requirements for Finance, Sales and Production departments as well as reporting environment support.

Technologies: Oracle 10g, AIX 5L, RS/6000, Oracle Warehouse Builder, Cognos8, PeopleSoft/JDE, RS/6000

Confidential

Database Performance Analyst

Responsibilities:

  • Worked on Extraction, Transformation and Loading of data.
  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
  • Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Developed ETL strategy and design.
  • Mentored new team members and effective resource management
  • Managed software releases after each stage of the testing and defect removal.
  • Managed project scope and change / enhancement requests

Technologies: Oracle, Microstrategy Informatica, Erwin, Solaris v1280

Hire Now