There are ERP Business Analyst Job vacation at USA.
if you interested please let me know. and send to me (email@example.com) your updated CV.
Under general supervision, is responsible for creating and maintaining business processes by providing process analysis, needs assessments, infrastructure requirements and cost/benefits analysis in an effort to align informationtechnology solutions with business initiatives. Provides references for users by writing and maintaining user documentation, providing help desk support and training users. Also responsible for providing in-depth Project Management for selected projects. This job works closely with all constituents to identify and maximize opportunities for using data warehouse systems to improve business processes, promote the strategic use of information technology, and enable analysts and management to use these systems for improved, timely decision making. This job provides the leadership, vision, and direction for data warehouse and business knowledge systems, ensuring support of the company’s business objectives and requirements.
Collaborate with Executive, Business unit, and ITS Management to translate corporate/functional business and information objectives into data warehouse business intelligence and translate them to strategic/tactical business plans and systems development. Analyze JD Edwards ERP and Legacy data sources and design a detailed mapping to the datamart schema. Identify all the rrequired business dimensions, attributes, facts, measures and Key Performance Metrics based on reporting and business needs and facilitate rapid development of GUI for the Enterprise Reporting Initiative (ERI). Perform data modeling (Conceptual, Logical and Physical) based on Star, Snowflake and hybrid design suitable for operational reporting, Analytical reporting needs. Design the Architectural framework required to support the analytical needs using Informatica, OBIEE and DB2 UDB. Manage the overall project which includes a team of onsite and offshore resources.
Independently design and create repository (RPD) using OBIEE 11G Tool. Develop repository objects such as physical data source objects, connection pools, Business Model Mapping Layer, Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tools. Create reports and dashboards to visualize and add instructiveness to the information using Graphs, Charts, Pie Charts, Gauges. Create user friendly dashboard and analysis. Perform unit testing and integration testing of developed reporting objects and document the results. Validate the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model mappinglayer. Implement Fragmentation, Aggregate Navigation & Level based dimensions in the BI repository.Develop efficient data load processes using Informatica version 9.x tool. Create ETL mappings and scripts using Informatica power center designer tool objects such as source analyzer, target designer, mapplet designer, transformation developer objects, repository manager, workflow manager. Perform unit testing and integration testing of developed code and document the results.Manage and direct on-shore and off-shore application developmeent team to develop and deliver applications assuring proper solutions are developed and tested for user review.
Perform ETL Code, SQL Code and Reporting code tuning to get desired performance at all levels.Candidate should ensure accuracy, efficiency and completeness of development done by other project team members working onsite and offshore.Remain knowledgeable of current IT and company business operations and processes. Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personalnetworks; benchmarking state-of-the-art practices; participating in professional societies. Provide training and ongoing application support including End User support. Maintain user confidence and protect operations by keeping relevant information confidential. Support IT application group using analytical skills.
Desired Skills and ExperienceBachelor's Degree required (Business administration/Information Technology preferred) with a business background and the equivalent of at least eight years' experience in process design and documentation in a related industry. Extensive working experience in OBIEE 11G and Informatica 9.x ETL tool sets with atleast 7 to 10 years of hands on experience in these tools. Very good understanding and usages of various Transformations like Expression, Filter, Joiner, Lookup, Update Strategy, and Router etc. to transform, migrate and clean data. Heavily worked on and workflow monitor. Very good understanding of DB2 SQL Script writing and Procedures.Literate with computer programs, the Microsoft Office suite a must.Excellent interpersonal skills.Ability to adapt to new software and technology.Familiar with andd have command of software documentation tools.Ability to perform System Analyst duties.Provide user support and application support