We provide IT Staff Augmentation Services!

Sr. Programmer/interface And Conversion Analyst Resume

Sacramento, CA

SUMMARY:

  • Experienced IT professional with over 9 years of expertise in data analysis, conversion, commerce enablement, information management, infrastructure and business analytics.
  • Proven expertise with public sector and financial clients implementing global delivery models; extensive experience working with onsite and offshore teams.
  • Proven experience in achieving operational objectives by coordinating and facilitating strategic plans, managing tasks and actions via eliminated redundancy and improved operational efficiency, and customer service standards.
  • Expertise experience working with Oracle SOA based technologies to successfully implement foreign system interfaces to support distributed architecture systems for customers.
  • Expertise in design, develop, test, and implement PeopleSoft Interfaces with flat files: csv’s and fixed length files.
  • Proven experience in analyzing PeopleSoft Interfaces, batch process related file processing errors, triage issues and identify, analyze and resolve the root cause for errors.
  • Extensive experience with Interfaces execution of different business processes in estimating, planning, designing, and developing automation framework process for large - scale distributed Web applications and Client/Server systems.
  • Strong exposure to financial data analysis, data mapping, MDM, governance, multi-dimensional data modeling and ETL.
  • Extensively experienced of SDLC methodologies like RUP, Waterfall and Agile Scrum and involvement in all the stages of the life cycle.
  • Strong Experience in Business analysis, Data Analysis, Data Modeling, Data profiling, Data Migration/Conversion .
  • Extensively involved in testing of interfaces and conversions files from Legacy/Third party systems to PeopleSoft applications.
  • Extensive experience in conducting Market Research, Feasibility Studies, Risk Identification, Risk Assessment, Risks Analysis, and Risk management.
  • Proficient in creating UML diagrams including but not limited to Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams and Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams)
  • Facilitated meetings with business users, data architects, data modelers, business analysts, QA and multiple delivery teams to define the data quality and profiling requirements.
  • Effectively facilitated Joint Application Development (JAD) sessions to gather requirements and resolve conflicts.
  • Provided thought leadership regarding Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into transactional systems and data marts.
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Solution-oriented, analytical, collaborative, problem-solving, motivated professional with excellent interpersonal and team management skills.

TECHNICAL SKILLS:

ERP Applications: Oracle R12 EBS, PeopleSoft

ERP Modules: Contracts, Projects, Billing, Accounts Receivables,, Revenue Management, General Ledger, Commitment Control, Asset Management, Expenses, Purchasing, Supply Chain management, Timekeeping

ETL Tools: Informatica PowerCenter, IDQ, IBM InfoSphere DataStage, ODI

Reporting: Crystal Reports, SQR, Microstrategy, Tableau

Databases/Servers: SQL Server 2008, WebLogic Server, PeopleSoft Application Servers and Process Schedulers, Oracle 8i, 9i, 10g, 12c Access, MS SQL Server

Other Tools: SSIS, SSRS, SSAS, Visual Studio .Net, MS Project, Business Objects, SQL Loader, Oracle report builder, Oracle form builder, Teradata, Collibra, IBM RQM, IBM RTC

Languages: C#, Java, HTML, XML, SQL, PL/SQL, T-SQL, TOAD

Web Technologies: ASP.Net, JavaScript, CSS, Web services

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Sr. Programmer/Interface and Conversion Analyst

Responsibilities:

  • Develop methodology to assess current state and suitability of existing data architecture and IT systems of different departments, including standard assessment criteria to interface departments existing systems with FI$Cal.
  • Perform Interfaces process architecture analysis, recommend process automation improvements, and support the implementation of approved improvements.
  • Implement and support the application and data integration between FI$Cal application and other department systems.
  • Assist with data efforts for all data related production support incidents.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Assure integrity of interfaced data, including data extraction, storage, manipulation, processing and analysis.
  • Perform data integration with new departments and maintain data extraction and transformation processes.
  • End-to-end processing and testing of data files from departments, including reviewing file specifications and loading data into system and resolves errors.
  • Develop technical reports that capture programmatic needs, challenges, and propose solutions for improving or streamlining the use of modeling and data resources.
  • Maintain and administer UC4 workflows and jobs, including creating, configuring; integrating, updating, programming, and scheduling, monitoring/maintaining system performance for Daily and Nightly FI$Cal batches.
  • Collaborate with software applications team, lead users and business subject matter experts (SME’s) to identify critical scenarios, identify data to be used in testing and documents expected vs. actual results.
  • Perform Descriptive, Diagnostic, Predictive and Prescriptive analysis of Department’s existing systems to interface with FI$Cal application.
  • Work with Technical and Functional teams in creating and delivering ad-hoc reporting as well as automating ongoing reporting to meet client needs.
  • Perform ad-hoc analysis to identify process improvement opportunities and/or trends to determine effectiveness.
  • Lead discussion during Interface decomposition sessions, identifying and resolving conflicts and bringing multiple stakeholders to consensus.
  • Implement data analyses, data collection systems and other strategies that optimize efficiency and quality.
  • Coordinate data models across marts and warehouse; manages dictionaries and other documentation across multiple data marts and data warehouse.
  • Resolve the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
  • Perform detailed data analysis (DDA), data quality analysis (DQA) and data profiling on source data.

Confidential, Sacramento, CA

Data Conversion lead

Responsibilities:

  • Perform Data conversion activities for all the conversions/Modules and Report weekly status at the file level to State.
  • Lead State Data cleansing process, working closely Conversion Specialists and ETL developers in State Conversion Team.
  • Ensure and support Interface/Conversion activities are performed as described in the state methodology.
  • Work with State and Accenture team to design/develop data migration strategies.
  • Work with SI, Business teams and Developers on any Interface/Conversion related enhancements.
  • Facilitate meetings with customers for better understanding of Legacy systems and Inventory.
  • Co-ordinate JAD sessions to identify issues, risks and potential road blocks on Interface and Conversion Process.
  • Ensure that Interface/conversion processes through the PeopleSoft environment are efficient and work with the development team to evolve the tool as necessary.
  • Guide and assist FI$Cal staff by providing expert knowledge for interactions with the System Integrator on issues regarding F1$Cal/Departmental systems Interface, data cleansing, and other data migration & development activities.
  • Process inbound interfaces and conversion files and provide feedback to customers on the errors, help the customers understand the file errors and bring it to closure as per requirement for the PeopleSoft Environment.
  • Generate Outbound PeopleSoft interface files to load and process in Customer’s legacy systems, support customers about the outbound interface files processing feedback.
  • Identify/Support Non Production incidents related to interfaces and Conversion, troubleshoot issues to identify the root cause, resolve and promote to production as needed.
  • Support PeopleSoft Interface and Conversion Setup as well as configurations in Non-Production environments.
  • Support, Develop and Modify Interface and Conversion programs in support of Departmental Legacy systems Interface and Data Migration efforts.
  • Analyze Interface batch process related errors to identify root cause.
  • Escalate risks, issues, scheduling items or resource needs for Interface/Conversion related items.
  • Obtain oversight comments and recommendations from ERP and team experts as required.
  • Provide knowledge transfer and documentation to FI$Cal staff for Interface and Conversion process.

Confidential, Sacramento, CA

Sr. Interface/Conversion Specialist

Responsibilities:

  • Act as the liaison between Project Entities, System Integrator, Business Teams, and PMO for Conversion Process.
  • Work closely with customers regularly to support FI$Cal onboarding activities, conduct PeopleSoft interface/conversion test cycles, monitor process, troubleshoot issues, and resolve interface/conversion related errors.
  • Provide supports on mapping legacy data with FI$Cal.
  • Review Department’s accounting, budget, cash management, procurement contract and purchase order files for validation errors and advise customers of needed corrections/additions.
  • Identify, clarify and resolve issues and risks, escalating them as needed.
  • Data modeling for different domains in staging layer.
  • Create requirement documents for custom ETL tool for Data Conversion activities.
  • Support Department for data validation and manual data entry in PeopleSoft environment.
  • Resolve the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
  • Capture different kinds of DQ validation rules to ensure that the system gets the cleansed data for report generation.
  • Performed detailed data analysis (DDA), data quality analysis (DQA) and data profiling on source data.
  • Extract data specs and created diagrams to visually represent the SQL extracts.
  • Identify functional data fields and their flow as well as establishing and executing quality data in support of FI$Cal process, workflow and system requirements.
  • Assist with troubleshooting of post-go-live interface/conversion issues that may occur.
  • Analyze and interpret complex data on source and target systems and provide resolutions to all data issues to customers.
  • Develop user manuals, presentations and training manuals as per project specifications and timelines.
  • Collaborate with SI to analyze data to prepare for integration with the FI$Cal.
  • Document Interfaces and Conversion process improvement as well as approach.

Confidential, Houston, TX

Sr. Financial Analyst/Business System Analyst

Responsibilities:

  • Work Closely with Developers and Quality Assurance Analysts to ensure requirements and design that support long term business objectives.
  • Ensure IT deliverables align with business requirements with measurable results.
  • Act as the liaison between Business and System Analysts, Developers and Project management groups.
  • Evaluate and Present design solutions objectively and facilitate conflict resolution.
  • Implement procedures and controls to ensure the LOB/Region adheres to the SOW Process.
  • Design, assess, and optimize master data management strategies.
  • Provide support and Escalation to LOB/Region to facilitate the resolution of issues rising from the activities within SOW Process.
  • Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data mapping, Data Integration and Process flows.
  • Provide support by monitoring batch jobs, interfaces and collaborating with developers to provide solutions to problems.
  • Support technical integration problems and work with support team and developers to resolve any issues and roadblocks.
  • Support Daily system management and monitoring of primary interfaced systems, proactively monitoring and reviewing interface error logs, system performance, tuning and interface enhancements, downtime management, and writing scripts for automation.
  • Performs troubleshooting and resolution of incidents and assists application developer team with troubleshooting as needed.
  • Perform a gap analysis on the existing data model of the staging layer versus the requirement on Data Management Portal.
  • Prepare S-T mapping document incorporating different business transforming logic for implementation of the ETL process.
  • Create complex stored Procedures, Triggers, Tables and SQL.
  • Create and Validate Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, and User defined data types.
  • Automate procedures in statistical analysis for credit monitoring, data reporting and statistical forecasting and pattern recognition, including univariate, bivariate, multivariate and extensive use of logistic regression.
  • Create statistical grade data set optimized for modeling and analytics emphasizing data validation, data cleansing and data reduction.
  • Involved in a periodic reconciliation of data between the various source and the end target system and create a BO report on the reconciliation breaks to be displayed in the DM Portal.
  • Create a monthly release notice to communicate and aware various business partners on upcoming releases and implementations.
  • Help mentor junior level team members on best data architecture/analysis practices.

Confidential, New York, NY

Sr. Data Analyst/Business Analyst

Responsibilities:

  • Work with business requirements analysts/subject matter experts to identify and understand requirements.
  • Facilitate JAD session to utilize complex data mining techniques and queries to gather business intelligence regarding data acquisitions and conversion to support the organization’s business and growth initiatives.
  • Work closely with the Quality Assurance team during integration, interface testing and user acceptance testing.
  • Ensure data integrity and security of interface databases by validating accurate data maintaining restore procedures.
  • Resolve any issues found with integrity of interfaces, make changes or support to ensure interface databases working as per client requirement.
  • Support maintenance and enhancements operations efforts for the ongoing changes made to interfaces to serve the business needs.
  • Define key facts and dimensions necessary to support the business requirements along with data modeler. Coordinated data models across marts and warehouse; manages dictionaries and other documentation across multiple data marts and data warehouse.
  • Resolve the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
  • Work closely with ETL team to provide pseudo code for the complex transformation logic, answer questions that ETL team has regarding the mapping document regarding the relationships between different entities.
  • Create weekly report for all the exception data using BO to provide it to the source LOBs for remediation and tracking the progress.
  • Capture different kinds of DQ validation rules to ensure that the EDW gets the cleansed data for report generation.
  • Perform gap analysis of the staging data model against the Business requirement and resolve an existing gap through a change management process.
  • Work closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support data analysis, data quality and ETL design that feeds the logical data models of new the EDW.
  • Meet with user groups to analyze requirements and proposed changes in design and specifications.
  • Perform detailed data analysis (DDA), data quality analysis (DQA) and data profiling on source data.

Confidential, Overland Park, KS

Data Analyst

Responsibilities:

  • Conduct JAD sessions to identify requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
  • Perform Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
  • Support setting up process standards, policies and procedures in interface design, development, implementation and maintenance.
  • Maintain operation, monitoring, and integrity of production, test, and development systems as well as inbound/outbound interfaces connecting different LOB throughout the organization to meet established standards.
  • Create Business Requirements and converted them into detailed Use Cases, Report Specifications and Non-Functional Requirements.
  • Create and maintain Data Dictionary.
  • Create data models and data flow diagrams for the as-is and to-be process.
  • Research upstream data sources and ensure its owners attested all source data sources.
  • Create report specifications containing mapping to source data sources.
  • Develop business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio.
  • Work closely with the developers on resolving the reported bugs and various technical issues.
  • Test the FSDs and ETL mapping which were developed to load from different legacy source systems in the Teradata staging /target areas.
  • Validate the data between the source to staging and staging to target using the source to target mapping document as reference.
  • Perform and validate data flows and support ETL processes according to business requirements and in corporate business requirements into design specifications.
  • Help the infrastructure team in loading the XML’s generated by the Informatica into the Limit management system.
  • Conduct internal and final DFD reviews with the ETL team (EIS), data quality and metadata management team, data architects, and business and application data stewards.
  • Perform data profiling on source to compare with list of valid values while mapping source to target and writing exception cases if necessary.
  • Responsible for validating and supporting issues/defects during Interfaces testing using SOAP UI, System Integration testing, User Acceptance testing, Performance testing, and Prod Implementation.

Hire Now