PANTAR_BIE
Senior Data Warehouse Engineer
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 ana0lysis, 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.
Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.
PANTAR_ERP
Senior Enterprise Resource Planning (ERP) Engineer
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.
Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.
PANTAR_SE
Senior Software Engineer
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
Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.
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.
Location: 112 South Tryon Street, Suite 755, Charlotte, NC and various client sites throughout the U.S.