PANTAR_BIE
Senior Data Warehouse Engineer
Job Duties: Act as lead in the development of business intelligence solutions working primarily in Hyperion Essbase, Cognos, Microstategy, Oracle OLAP, Microsoft OLAP, SAS, PL/SQL and Oracle. Perform requirements analysis, report design and development using IBM Cognos reporting tools, Cognos Planning and Cognos Framework. Perform design & development of Complex Financial Report Studio Reports. Develop Data Marts, Universes, and/or Analysis Cubes, Web Intelligence documents, Crystal Reports, and Xcelsius dashboards using SAP Business Objects Tools. Work in Hyperion Planning, Hyperion partitioning, developing cubes (ASO & BSO), aggregations, and dataload scripts using MaxL. Use MDX formulas for calculating YTD, MTD, QTD, Yield Actual and Average Values. Perform SAS Programming, merging SAS Data Sets and Macro Facility. Prepare data, PROC, producing reports, validating reports, SAS formats, and storing and managing Data in SAS Files. Perform extract transform and loading using Informatica and Datastage tools to build Data Warehousing solutions at enterprise level. Responsible for administering, maintain and utilizing policies and procedures for ensuring the security and integrity of the SQL Server Databases, Analysis Services, Reporting Services, Integration Services, and Sharepoint Data Connections. Write Stored Procedures, Packages, Database Triggers, Tables, Partitions, Indexes, Roles and Functions using PL/SQL and T-SQL. Also work in SQL*Loader, Import, Export, UTL_FILE, Optimization using (Analyze, Explain Plan, TKPROF), snapshots.

Salary: $80,000/year

Employer: Pantar Solutions Inc

Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.

Apply to: Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

This notice is provided as a result of the filing of an application for permanent alien labor certification for this job opportunity in compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on this application to:

Certifying Officer, U.S. Department of Labor Employment and Training Administration Atlanta Processing Center Harris Towers 233 Peachtree Street, Suite 410 Atlanta, GA 30303

PANTAR_ERP
Senior Software Engineer
Job Duties: Oversee the design & development of Batch and Online applications using Visual age Generator to develop using CSP as 4GL, .net and J2EE as OOPS technologies. Perform analysis for integration of Mainframe technologies with J2EE technologies & .net technologies. Use Websphere, Weblogic as application servers to hold all the application logic. Use Java development tools like VisualAge, Eclipse, Jdeveloper, Visual Studio, SharePoint tools for .net applications to develop various applications. Develop and execute test scripts and test plans as well as document detailed expected results, this includes scripts for functional, regression, performance and system tests using manual and automated tools.
Salary: $80,000/year

Employer: Pantar Solutions Inc

Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.

Apply to: Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

This notice is provided as a result of the filing of an application for permanent alien labor certification for this job opportunity in compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on this application to:

Certifying Officer, U.S. Department of Labor Employment and Training Administration Atlanta Processing Center Harris Towers 233 Peachtree Street, Suite 410 Atlanta, GA 30303

PANTAR_SE
Senior ERP Engineer
Job Duties: Oversee the performance of fit-gap analysis, design and implementation of ERP using Peoplesoft, SAP and Oracle. Perform impact assessment for the retrofit of ERP for existing business functionality using Peoplesoft Internet Architecture or SAP. Design and develop reports using Crystal Reports 8.X, 9.X/ SQR. Perform analysis, design and development of GL reports using nVision reporting tool. Develop or retrofit or customize batch processes using various programming techniques. Use Component Interfaces to expose Peoplesoft data to third party systems. Use SQL on DB2/Oracle for developing SQL procedures to be used in queries or batch processes.

Salary: $80,000/year

Employer: Pantar Solutions Inc

Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.

Apply to: Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

This notice is provided as a result of the filing of an application for permanent alien labor certification for this job opportunity in compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on this application to:

Certifying Officer, U.S. Department of Labor Employment and Training Administration Atlanta Processing Center Harris Towers 233 Peachtree Street, Suite 410 Atlanta, GA 30303

PANTAR_SA
Systems Analyst
Translate business needs into technical requirements by analyzing business needs, leading collaboration with business and technical stakeholders to develop detailed system requirements and providing subject matter expertise and delivery coordination support during development and testing phases. Perform Quality Assurance and Quality Control Analysis. Perform data analysis, data modal and data mapping. Perform re-engineering of complex systems working in ETL, SQL, ERWIN, UML, XML, Quality Center, Rational Tools, Excel Macros as well as OLAP and Reporting tools for Data warehousing tools. Use knowledge of data governance and dataflow processes and work with ERP, CRM and other party systems integration techniques.

Salary: $65,000/year

Employer: Pantar Solutions Inc

Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.

Apply to: Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

This notice is provided as a result of the filing of an application for permanent alien labor certification for this job opportunity in compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on this application to:

Certifying Officer, U.S. Department of Labor Employment and Training Administration Atlanta Processing Center Harris Towers 233 Peachtree Street, Suite 410 Atlanta, GA 30303

Latest LCA's
Notice of Filing of a Labor Condition Application with the Employment and Training Administration
1. H-1B non-immigrant workers are being sought by Pantar Solutions Inc through the filing of a labor condition application with the Employment and Training Administration of the U.S. Department of Labor
2. One Worker is being sought
3. These workers are being sought as Data Warehouse Engineer.
4. Wages of $30.00 per hour fulltime are being offered to these workers
5. The period of employment for these workers is sought is 11/16/2011 to 8/31/2012
6. The employment will occur at Pasadena, California
7. The labor condition application is available for public inspection at the offices of Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

Complaints alleging misrepresentations of material facts in the labor condition application and/or failure to comply with the terms of the labor condition application may be filed with any office of the Wage and Hour Division of the United States Department of Labor.

Notice of Filing of a Labor Condition Application with the Employment and Training Administration
1. H-1B non-immigrant workers are being sought by Pantar Solutions Inc through the filing of a labor condition application with the Employment and Training Administration of the U.S. Department of Labor
2. One Worker is being sought
3. These workers are being sought as Data Warehousing Engineer.
4. Wages of $28.85 per hour fulltime are being offered to these workers
5. The period of employment for these workers is sought is 11/12/2011 to 10/31/2014
6. The employment will occur at Costa Mesa, California
7. The labor condition application is available for public inspection at the offices of Pantar Solutions, 112 South Tryon Street, Suite 755, Charlotte, NC 28284

Complaints alleging misrepresentations of material facts in the labor condition application and/or failure to comply with the terms of the labor condition application may be filed with any office of the Wage and Hour Division of the United States Department of Labor.