We provide IT Staff Augmentation Services!

Sr Business Intelligence Engineer Resume Profile

2.00/5 (Submit Your Rating)

Emeryville, CA

Hire Now

EXECUTIVE SUMMARY

Meticulous Data Warehouse Business Intelligence Specialist, who undertakes complex assignments, meets tight deadlines and delivers products with superior quality. Revamps existing systems by proposing efficient and cost effective solutions. Listens closely to the clients, paying attention to details and provides solutions with options. Have 10 years of experience in Data Analysis, Design, Data Modeling, Development, and Testing in Data Warehousing and Analytics. Enthusiast in Big Data, Hadoop and Data Science related technologies. Highly determined and motivated team player with outstanding written, oral, analytical and Interpersonal skills.

TECHNICAL AND FUNCTIONAL SKILLS

  • Databases Oracle, MS SQL Server, DB2, MySQL, Teradata, NoSQL, Mongo DB
  • ETL Informatica, SSIS, PL/SQL, T-SQL, UNIX Shell scripting
  • BI Reporting Tools Cognos, Tableau, Business Objects, SSRS, SSAS, Qlikview
  • Data Modeling Erwin, MS Visio
  • Programming C, C , Java, HTML, XML, Java script, R
  • Scheduling Tools Autosys, Control M, Batch scripting, Task Manager
  • Project Management Microsoft Project, FogBugz, JIRA
  • Business Analysis IBM Rational Rose Requisite Pro, CaliberRM, Confluence
  • Configuration Management Perforce, Documentum, Visual Source Safe, Git, SharePoint, Confluence

PROFESSIONAL EXPERIENCE

Confidential

Sr Business Intelligence Engineer

  • Closely worked with Sales, Finance, Accounting, Marketing, and Retail teams in gathering business
  • requirements designed and delivered the end products that best fit for the business.
  • Designed and optimized the SSIS architecture by diminishing existing Facts and dimensions by 30
  • Re-designed developed and migrated Cognos 8 packages, Cubes, Reports and Dashboards to

Confidential

Sr Consultant Data Warehouse Business Intelligence

  • Assembled and delivered multiple projects in Quality Systems, Abbott Vascular Data Warehouse,
  • Enterprise Application Interface, Supply Chain and Manufacturing IT teams
  • Played versatile roles as ETL and Reporting Developer, Data Analyst, Quality Test Lead and
  • Process Compliance Analyst PCA for various Business Intelligence and Data Warehouse projects
  • Facilitated meetings and assisted in the integration efforts for merging BI platforms of various
  • applications with enterprise data warehouse as data marts
  • Used Informatica, SSIS and PL/SQL ETL technologies to create mappings, workflows and dtsx
  • packages from various source systems to target Abbott Vascular Data Warehouse system
  • Slashed payroll/benefits administration costs by 30 by negotiating pricing and fees with vendors
  • this saved the company in total licensing costs per year.
  • Reviewed Cognos 7 and 8 Reports, cubes, servers and licenses and disabled unnecessary licenses,
  • IT projects process flow that helped for Audit purposes.
  • process design based on the Audit findings and setup of the ALM tools. This helped to stream line the
  • Performed ALM tools assessment and selected tools which best fit for the organization and involved in
  • procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router
  • services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored
  • Created Informatica maps using various transformations like SAP BAPI/RFC, SAP IDOCs, Web
  • proposing cost effective license packages
  • Designed and developed unit testing for ETL packages using Unix shell scripting to reduce the

Confidential

Developer/

  • Undergone training on Oracle PL/SQL, Informatica, Java, Mainframes and other related technologies
  • Developed Informatica ETL mappings and PL/SQL packages for a project assigned to the team based

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship