Sr. Business System/analyst Resume
Alpharetta, GA
SUMMARY:
- Senior Analyst focusing on the application of technology system that improves the business functions.
- Detail focused and uses technical expertise competently producing software system applications; critically evaluate information gathered from multiple sources, reconcile conflicts, loyalty, decompose high - level information, and distinguish user requests from their underlying true needs.
- Information Technology, Telecommunication, Banking, Health Care, Medical Claims, Insurance, Manufacturing, Customer Relationship Management, Supply Chain, Analytics, Retail and Consumer Good industries
- Access Management, Identity Management, Governance, Compliance, Business Analysis & Development, Marketing & Loyalty, Project Management, Banking (Retail and Consumer Banking), Small Business Loans, Investment Banking,Life Insurance, Property Insurance, General Insurance, Call Center based applications, CRM, Website Design and Development, E-Commerce, Web Applications, Online Check Deposit (OCD), Image Cash Letter (ICL), Fraud Prevention, IAM, Anti-money Laundering (AML) and Services
- Effective communicator with ability to work with the team and independently; Structured, well-organized & detail oriented; Ability to build strong client relationships; Strong facilitation and collaboration skills; Excellent written, oral, and presentation skills
TECHNICAL SKILLS:
MS: PowerPoint, MS-Visio, MS-Access, MS-Excel, MS-Publisher, MS-Word, Windows 95, Windows 2000, XML, Windows NT, RUMBA, COBOL I, Advanced COBOL II, Join Requirement Planning, C#, C/C++-Programming, JAVA, DB2, UNIX, MS-DOS, POS, Pascal, Data structure, Assembly, Data Base Management, Visual C, Visual Basic, Basic, Lawson, AUDIX, MS Project, Auto-Tester, Telecommunications, MS Excel, VISIO, Turnover, RUP, WMS, EDI, MS-SQL Server 2005, Software995, WMS, Catapult 6, File-Zilla, Adobe 7.0, Outlook Express, Code/400 designer, Visual Mapper, SharePoint, A-JAX, Heat, Web application, Crystal Reports, ETL, Same-Time, UML diagrams, Master Data Management (MDM), IBM Optim, Ab Initio Profiler, Talend Profiler, TOAD, Test Director, Initiate, .NET, waterfall/agile, UI Design
Analytical: Process Analysis/Improvement Techniques, Time Management
IBM AS/400: COBOL I, COBOL II, RPGII, RPGIII, RPG IV, RPG ILE, Free-Format, QUERY, SEU, DFU, JWalk, SQL, SDA, MAPICS, INFINIUM, JDA, DRM, SEBAL, TLA/ASHFORD, HAWKEYE, FTPCool: 2E/Synon, Embedded SQL, SQL, Win-Runner, PRTF, Sterling EDI, SEQUEL, API's, DSPF, DB2/400, ALDON, Turnover CMS, Job Scheduler, WDSc, Bosanova TCP-IP 5.15, Visual Age 6.0, SQL Server Integration Services (SSIS).
PROFESSIONAL EXPERIENCE:
Confidential, Alpharetta, GA
Sr. Business System/Analyst
Responsibilities:
- Utilized User Stories, Requirement Elicitation, Requirement Documentation, IAM, Electronics Records Management, Validation, MDM, Corporate/Cyber Security, Modeling, Risk Analyst andAnalysis. Proficient ininterviewing stakeholders Confidential all levels and in conducting JAD sessions (both onsite and using video-conferencing). Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes within a MEAN stack.
- Leading initiatives and providing consultation to the internal and/or external customer.
- Worked in an AGILE/SCRUM/.NET environment, which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Performed unit integration testing, data warehousing, data mapping, system implementation, and maintained system software functions. A liaison for the business leaders to ensure that all estimates were updated/validated with supporting data. Independently track costs related to all specific warranty matters.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- Developed Web-API to display customers’ detail transaction for business process requirements to maintain information.
- Experienced in writing requirements for consuming web services using RESTful API. Documented a RESTful style Web Services layer to interface with a RPG and DB2 system, and an AJAX front end. Utilized Jira to break down epics into detailed user stories to identify all functional and technical product requirements.
- Proficient in writing Use Case Specifications,AJAX, PL/SQL, UI/UX, Business Intelligence, IAM, Goggle Analytics, KPIs, Data Warehousing, Business Intelligence, Product Owner, Functional Requirement Specifications(FRS),Technical Requirements Specifications(TRS),BRD,PRD, and RequirementsTraceability Matrices(RTM). Utilized Business Analysis tools such asMS Visio,Word,Excel(including Pivot tables, Macros and Vlookup),Rational Requisite Pro,and iRise. Proficient inSQL querying with Databases, SQL Server Integration Services (SSIS) and developing reports/dashboards.
- Experienced with development of Web Applications and Enterprise Software; experienced in System Testing, Data Mapping, UAT Testing & writing Test Plans & Test Cases. Proficient in creatingad-hoc reportsusingBusiness Objects Web Intelligence tool.
- Experienced with giving PowerPoint presentations and performing product demonstrations to customers; handled projects in extremely challenging situations and delivered good quality product.
- Excellent communication and interpersonal skillswith strong Customer orientation and Client interfacing skills. Experience working in Medicare projects and experience in conducting Strengths, Weaknesses, Opportunities, Threats (SWOT) Analysis, Cost Benefit and ROI Analysis.
- Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals.
- Followed change management procedures.
- Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances (+/-) for each of the scenarios.
- Experience in User Acceptance Testing, Smoke Testing, Regression Testing Performance Testing and Functional Testing.
Confidential, Atlanta, GA
System Analyst
Responsibilities:
- Reviews, analyzes and modifies systems including configuring, testing, debugging and installing POS system; as well as manages software updates, AJAX, PL/SQL, UI/UX, Business Intelligence, Confidential -SQL, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, configuration changes and maintains existing hardware. Uses internal systems and resources, as well as external where necessary, to access sales numbers including customer, market and shopper data, category sales, and SKU level sales. Leading initiatives and providing consultation to the internal and/or external customer.
- Achieves specified success metrics and for recommending improvement programs. Run customized customer reports to support sales, trade teams in analyzing current business (Vendor Performance Scorecards, POS Reports, Distribution Gap Trackers, etc.). Maintain standard reports to track business (Lost Sales, In-stock %, Fill rates etc.). Identify opportunities and improve business with Replenishment / Demand Planning teams. Diagnose success of promotional activities. Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Utilized User Stories, Requirement Elicitation, Access Management, Identity Management, Data Governance, Data Compliance, Requirement Documentation, Validation, Modeling, IAM, HL7 andAnalysis; Proficient ininterviewing stakeholders Confidential all levels and in conducting JAD sessions (both onsite and using video-conferencing). In depth knowledge of SDLC:Rational Unified Process (RUP), Agile, and Waterfall methodologies. Proficient in business modelingusing Work Flow Diagrams, offshore, Data Flow Diagrams and UMLDiagrams (Use Case Diagrams, Activity Diagrams, State Chart Diagrams).
- Evaluated, documented business, functional requirements, asset protection (loss prevention/safety), MDM, prepared use cases, Confidential -SQL, Stored Procedure, Product Owner, Triggers, Data Modeling/Mapping, sequence diagrams and class diagrams with Rational Rose. Supported UAT activities for all products utilizing Rational Clear Quest and implemented SQL queries with Toad application services. Experienced in writing requirements for consuming web services using RESTful API. Utilized Jira to break down epics into detailed user stories to identify all functional and technical product requirements.
- Gathered requirements from the business and technical end to develop the mainframe, e-commerce and the web portal backend. Actively participated during the Production releases of the products and provided go-live support during Production deployments. Performed maintenance to existing software as needed for WMS and Supply Chain systems. Resolved system issues as they relate to production processing, report applications and system output. Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.
Confidential, Alpharetta, GA
Business System/Analyst
Responsibilities:
- Communicate with clients to gather, document requirements, fraud management, data warehouse, data mapping, write business specifications, write test plans and conduct testing.
- Prepare use cases, test cases, test data, and perform data analysis, strong writing skills, AJAX, Electronics Records Management, PL/SQL, UI/UX, Business Intelligence, ETL, Confidential -SQL, Stored Procedure, SQL Server Integration Services (SSIS), Triggers, Corporate/Cyber Security, Data Modeling/Mapping, SQL knowledge.
- Consulted with key stakeholders on client and internal requirements, HR/HCM/Six Sigma projects and proposals, audit responses and new business opportunities.
- Experience writing detailed specifications, team oriented, and the able to thrive in a fast passed environment.
- Developed Web-API to display customers’ detail transaction for business process requirements to maintain information.
- Created User Stories, offshore teams, Requirement Elicitation, Anti-money Laundering (AML), Fraud Management, IAM, Product Owner, Risk Analyst, Requirement Documentation, Validation, Modeling, andAnalysis; Proficient ininterviewing stakeholders Confidential all levels and in conducting JAD sessions (both onsite and using video-conferencing).
- Experienced in writing requirements for consuming web services using RESTful API.
- Documented a REST-ful style Web Services layer to interface with a RPG and DB2 system, and an AJAX front end. Utilized Jira to break down epics into detailed user stories to identify all functional and technical product requirements.
- Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes within a MEAN stack.
- Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Utilized business modelingusing Work Flow Diagrams, Access Management, Identity Management, Data Governance, Compliance, Goggle Analytics, MDM, Data Flow Diagrams and UMLDiagrams (Use Case Diagrams, Activity Diagrams, and State Chart Diagrams). Proficient in writing Use Case Specifications,.Net, Java, Functional Requirement Specifications(FRS),Technical Requirements Specifications(TRS),BRD,SRD, Online Check Deposit (OCD), KPIs, Data Warehousing, Business Intelligence, Image Cash Letter (ICL) and RequirementsTraceability Matrices(RTM). Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customers’ needs. Created Product List specific for particular customers’ customization.
- A liaison with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals.
- Leading initiatives and providing consultation to the internal and/or external customer.
- Followed change management procedures.
- Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.
- Worked with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures.
- Provided mobile device support for smart phone and tablet devices. Support included application, wireless and email configurations for Blackberry, iPhone and iPad devices.
Confidential, Atlanta, GA
Business Solution/Analyst
Responsibilities:
- Assisted in various stages of Software/System Development Life Cycle (SDLC), such as defining scope, product design, development strategy, production and quality assurance.
- Experienced inStatistical Data Analysis,Gap Analysis, Feasibility Analysis, Impact Analysis, Risk Analysis, Change Management, Business ProcessRe-engineeringand Cost-Benefit Analysis.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- In-depth experience in financial analysis, financial modeling, Research, Accounting, and good knowledge of Assets, Liabilities, Fixed Income and Taxation.
- Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test Plan, Test lab and Defects).
- Liaised between client and client project teams as PM to ensure work met client requirements.
- Communicated to client team when business requirements changed. Assisted project leader for project management and delivering project.
- Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.
- As a member of production support team, I have provided on-call support to all enhancements done on production servers and e-commerce. Performed Functionality, Integration, Product Owner, GUI, Regression, Usability and System testing. Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules in the Application according to the Business Requirement Documentation. Extensive usage of analytical, collaborative and operational customer relationship management (CRM) like Oracle, Salesforce, and JDA. Experienced in writing requirements for consuming web services using RESTful API.
- Documented a RESTful style Web Services layer to interface with a RPG and DB2 system, and an AJAX front end.
- Utilized Jira to break down epics into detailed user stories to identify all functional and technical product requirements.
- Supported functional solutions, analyzed business requirements, Access Management, Identity Management, Data Governance, Compliance, reviewed system performance and maintained system legal aspects. Executed Oracle application upgrades and supported application maintenance.
- Executed Oracle application upgrades and supported application maintenance. Documented business requirements, prepared conceptual designs and conducted user acceptance testing. Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customers’ needs.
- Created Product List specific for particular customers’ customization.
Confidential, Atlanta, GA
Business Solution/Analyst
Responsibilities:
- Experienced creating documentation for development HR/HCM/Six Sigma projects, including technical specs for SharePoint development team; Developed Forms, AJAX, Electronics Records Management, PL/SQL, UI/UX, Business Intelligence, Confidential -SQL, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, Reports, and SQL Queries using TOAD tool with Oracle database; website layout prototyping uses iRise.
- Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database; created data models and data flow diagrams for the to-be process. Leading initiatives and providing consultation to the internal and/or external customer.
- Worked in a LAWSON/AGILE/SCRUM/.NET environment, which posed initiating several JAD Sessions and active interaction with business, technical teams, data warehousing, data mapping, product owner, activity and state. Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
Confidential, Atlanta, GA
Sr. Business Solution/Analyst
Responsibilities:
- Evaluated, reviewed SOA activities, financial information, data warehousing, data mapping, business drivers, participated in activities, webcasts reviewed and documented payroll allocations as per margins.
- Developed, maintained margin analysis reports for, conducted research and analytical activities for exam candidate trends.
- Evaluated, documented business, functional requirements, prepared use cases, sequence diagrams and class diagrams with Rational Rose.
- Supported UAT activities for all products utilizing Rational Clear Quest and implemented SQL queries with Toad application services.
- Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
Confidential, Marietta, GA
Lead System/Analyst
Responsibilities:
- Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes.
- Leading initiatives and providing consultation to the internal and/or external customer.
- Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, UI/UX, activity and state.
- Perform usability testing and organizing focus groups to discuss and ensure effective adoption of feedback to improving the usability of the mobile applications and web based applications within a MEAN stack.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
Confidential, Atlanta, GA
Lead Business System/Analyst
Responsibilities:
- Evaluated, reviewed SOA activities, offshore teams, data warehousing, Corporate/Cyber Security, IAM, data mapping, financial information, ETL, MDM, risk analyst, business drivers, participated in activities, webcasts reviewed and documented payroll allocations as per margins.
- Developed, maintained margin analysis reports for, conducted research and analytical activities for exam candidate trends.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances (+/-) for each of the scenarios. A liaison for the business leaders to ensure all estimates are updated and validated with supporting data.
- Independently track costs related to all specific warranty matters.
- Leading initiatives and providing consultation to the internal and/or external customer.
- Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, UI/UX, data, running queries and understanding specific customers’ needs. Created Product List specific for particular customers’ customization.
- Supported budgeting, Anti-money Laundering (AML), KPIs, Data Warehousing, Business Intelligence, Fraud, AJAX, PL/SQL, Business Intelligence, IAM, projection processes, analyzed monthly variances, implemented SOA suite activities, platform modernization and business analytical services. Reviewed product drawings, formulated packaging specifications, created business processes, software flow processes and user stories. Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.
Confidential, Chamblee, GA
Instructor/Analyst
Responsibilities:
- Utilized an Analysis approach based on SDLC process, maintaining dashboard, SQL Server Integration Services (SSIS), Data Mapping, design architecture of IT Portal, joint application design (JAD)/joint requirement planning (JRP), and perform Stakeholder Analysis.
- Hosted formal security requirements reviews, obtain sign-offs on security requirements, and work to make sure requirements become part of project requirements.
- Assess and validate project solutions against security requirements.
Confidential, Atlanta, GA
Business System/Analyst
Responsibilities:
- Developed Forms, AJAX, UI/UX, PL/SQL, Business Intelligence, data warehousing, data mapping, Confidential -SQL, Stored Procedure, SQL Server Integration Services (SSIS), Triggers, Data Modeling/Mapping, Reports, and SQL Queries using TOAD tool with Oracle database; website layout prototyping usesiRise.
- Leading initiatives and providing consultation to the internal and/or external customer.
- Analyzed raw marketing data using SQL Queries and tools like MS Access and Excel to identify growth opportunities into new and existing markets; worked closely with project manager to determine areas for product quality enhancement and cost reduction.
- Worked in an AGILE/SCRUM/.NET/customer relationship management (CRM) like Salesforce environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
Confidential, Alpharetta, GA
Sr. IT Security/Analyst
Responsibilities:
- Utilized an Analysis approach based on SDLC process, maintaining dashboard, Corporate/Cyber Security, IAM, MDM, design architecture of IT Portal, and perform Stakeholder Analysis. Leading initiatives and providing consultation to the internal and/or external customer. Created a Requirements Communication Plan while work withSecurityteam to refine Risk Assessment requirements, Data mapping, ETL, Confidential -SQL, SQL Server Integration Services (SSIS), UI/UX, KPIs, Electronics Records Management, data warehousing, data mapping, Business Intelligence, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, Supply Chain, and ERP systems.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- Participated in HR/HCM/Six Sigma projects effort estimations on behalf of InformationSecurityDepartment to ensure appropriate trusted data sources.
- A liaison for the business leaders to ensure all estimates are updated and validated with supporting data.
- Independently track costs related to all specific warranty matters. Worked in an AGILE/SCRUM/.NET/customer relationship management (CRM) like Salesforce environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customers’ needs. Created Product List specific for particular customers’ customization.
Confidential, Atlanta, GA
Sr. Business System/Analyst
Responsibilities:
- Provided thorough documentation of all BI applications, Access Management, Identity Management, Data Governance, Compliance, and processes to be use in the event of equipment or system failure; assisted in the integration efforts for merging BI platforms with enterprise systems and applications.
- Analyzed and consolidated data across the business/system, Data Mapping, SQL Server Integration Services (SSIS), maintaining dashboard, Supply Chain, and made effective planning decisions.
- Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- Participated in HR/HCM/Six Sigma projects improvement opportunities using LEAN, XML, UI/UX, AJAX, PL/SQL, Business Intelligence, XML Schema, Online Check Deposit (OCD), Image Cash Letter (ICL), data warehousing, data mapping, joint application design (JAD)/joint requirement planning (JRP), MDM and Sig Sigma.
- Analyze operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances. Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state. Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customers’ needs. Created Product List specific for particular customers’ customization.
Confidential, Alpharetta, GA
Sr. Business System/Analyst
Responsibilities:
- Utilized documented supporting (Marketing, vision, scope, AJAX,KPIs, Data Warehousing, Business Intelligence, UI/UX, PL/SQL, IAM, Electronics Records Management, MDM, UML diagrams, context diagrams, joint application design (JAD)/joint requirement planning (JRP), and use-cases, maintaining dashboard, mockups, Test Director, and traceability matrix). To gather requirements for products, HR/HCM/Six Sigma projects and system innovations / enhancements across key functional stakeholders.
- Drove out business/system needs with cross-functional teams for data cleansing & conversion.
- Worked in an AGILE/SCRUM/.NET environment which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
- Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customer’s needs.
- Created Product List specific for particular customer’s customization.
Confidential, Lawrenceville, GA
Sr. Business System/Analyst
Responsibilities:
- Translated conceptual user requirements into functional requirements in a clear manner that is comprehensible to developers/project team, maintaining dashboard and project planning/scheduling/change management.
- Created as-is and to-be process models, Data Mapping, specifications, joint application design (JAD)/joint requirement planning (JRP), and diagrams. Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
- Worked with the Catalog team to help subset customizable business process for the customer and pulling reports, data, running queries and understanding specific customers’ needs.
- Created Product List specific for particular customers’ customization.
- Validated data and coordinated data validation with Business/system Process Owners and other SMEs. Performed maintenance to existing software as needed for WMS and Supply Chain systems.
- Experienced in using SSIS tools like Import and Export Wizard, KPIs, data warehousing, data mapping, Business Intelligence, Package Installation, and SSIS Package Designer. Worked in a Lawson/AGILE/SCRUM/.NET/customer relationship management (CRM) like Salesforce environment, which posed initiating several JAD Sessions and active interaction with business, technical teams, product owner, activity and state.
Confidential, Norcross, GA
Sr. System/Analyst
Responsibilities:
- Integrated and resolved web applications, business/system process errors, Data Mapping, maintaining dashboard, performed maintenances to existing software as needed.
- Supported all production operation activities, AJAX, UI/UX, PL/SQL, Electronics Records Management, Online Check Deposit (OCD), Image Cash Letter (ICL), Business Intelligence, Lawson, SQL Server Integration Services (SSIS), with focus on integration and development of new and existing products and services.
- Performed analysis of products, joint application design (JAD)/joint requirement planning (JRP), processes and software capabilities.
- Created UML diagrams, system process analysis, data warehousing, data mapping, VISIO, mockups, MS-Project, design and prototyping.
- Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances (+/-) for each of the scenarios.
- A liaison for the business leaders to ensure all estimates are updated and validated with supporting data.
- Independently track costs related to all specific warranty matters. Built out system for clients to help track their data for transactions, shipping, and inventory, transmitting PO's orders and invoices electronically.
Confidential, Duluth, GA
Sr. Programmer/Analyst
Responsibilities:
- Generated new applications utilizing SDLC concepts, AJAX, UI/UX, PL/SQL, Business Intelligence, RPG, JWalk, UML diagrams, mockups, Supply Chain, and created software test plans, procedures, system implementation, SQL Server Integration Services (SSIS) and maintained system software functions for manufacturing/multi-media application on the AS/400 Platform.
- Drove out business/system needs with cross-functional teams for data cleansing & conversion.
- Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
Confidential, Atlanta, GA
Business System/Analyst
Responsibilities:
- Identified data issues, joint application design (JAD)/joint requirement planning (JRP), and provide recommendation for resolution to ensure optimal performance.
- Integrated and resolved web applications and business/system process errors.
- Performed maintenance to existing software as needed for WMS and Supply Chain systems. Assembled data using SQL Query, AJAX, PL/SQL, Business Intelligence, SQL Server Integration Services (SSIS), data warehousing, data mapping, Confidential -SQL, Stored Procedure, Triggers, Data Modeling/Mapping, Data Mapping, RPG, JWalk, Lawson and Interacted with IT professionals and members of the business to understand the business/system rules behind data processing systems.
- Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
Confidential, Atlanta, GA
Business System Engineer
Responsibilities:
- Responsible for the mainframes that receive the HL-7 message in pre-approved format from the middleware as disclosed in the documentation.
- Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan).
- Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set; Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business/system processes.
- Acted as a liaison between the business and the development team by translating moderately complex and varied business needs into application requirements.
- Worked on project to development and maintaining a new large group enterprise underwriting rating system.
- Acted as a resource to users of the software to address questions/issues and updated rating systems as needed with new product and rating information while understanding all impacts to table structure and rating application.
- Captured and developed business rules for rating system as business needs changes.
- Performed ongoing quality assurance to ensure accuracy and consistency of output in the system.
- Acted as project team member on Confidential Blue Shield of Georgia's initiative to combine a local and national claims processing system into one single platform.
- Conducted user acceptance testing and data validation of web applications used to present benefit information.
- Loaded and maintained Health Care s and Riders in Document Database.
- Wrote and entered SQL language in Benefits Confidential a glance view within Confidential Healthcare system.
- Generated reports and performed data validation in SMART Confidential Blue Shield Custom App. Implemented and maintained account benefit updates in a system as part of National Health Care Reform mandates.
