SUMMARY:

• Around 13 years as an accomplished professional and demonstrated ability, I can focus on client service and productivity in the field of Finance and Business. I myself concentrate on providing complete solutions, emphasizing in Project Management, Business Process Design and Strategy Development, Continuous Improvement, and Technical Programming. f information - technology experience in software application development with emphasis on distributed applications, big data technologies, legacy systems with progressive advancements delivering quality and time sensitive software projects.
• Hands on experience working with Hadoop, HDFS, Map Reduce framework and Hadoop ecosystem like Hive, HBase, Sqoop, Yarn, Spark, Pig, Zookeeper, Impala, Flume, Kafka, Drill and Oozie.
• Cloudera Certified Hadoop Developer for Apache Hadoop (CCDH 410 - Version: 5)
• Experience with data architecture including data ingestion, Hadoop/Big Data architecture, ETL Data warehousing, data modeling and experience in Storage, Querying, Processing and analysis of data.
• Excellent understanding of Hadoop architecture and various components such as HDFS, YARN, Resource Manage, Node manager, NameNode, Data Node and MapReduce programming paradigm.
• Experience in big data processing and analyzing data using HIVEQL, PIG scripts and writing UDF’s based on requirements.
• Excellent understanding and knowledge of NOSQL databases like HBase.
• Extensive experience in importing/exporting data from/to heterogeneous data source to Hadoop Ecosystem using Sqoop.
• Experience in scheduling Hadoop jobs using Oozie.
• Knowledge and working experience in Continuous integration (CI) using Jenkins.
• Involved in predictive analytics, Ecommerce analytics and retail Data analytics.
• Knowledge on Multi-Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) and handling Changing Dimensions.
• Working experience in managing Hadoop clusters using Cloudera Manager tool.
• Extensive experience working in Oracle, DB2, SQL Server and My SQL database.
• Hands on experience in application development using ETL, RDBMS and Python, Shell scripting.
• Expertise on all phases of the Systems Development Life Cycle’, and effective project Management and planning skills to ensure committed project delivery within agreed cost / time lines and in compliance with quality systems/procedures.
• Experience in the domains of Retail and Manufacturing data analytics, Banking, Insurance, proficient in Capital Market Domains and Proficient in the ISO SWIFT Messages.
• Extensive experience in development, maintenance and production support projects.

TECHNICAL SKILLS:

Hadoop Ecosystem: HDFS, Map Reduce, Hive, Hue, Pig, Impala, Sqoop, Oozie, Flume, Kafka, MapR Cloudera, YARN, Zookeeper, Spark

Databases: Oracle, SQL Server, MySQL, DB2,No sql Database,Hbase

Testing Tools: SoapUI, QTP, Selenium, TestNG, LoadRunner, Swagger UI, Fiddler

Operating System: Windows, Unix, and Linux, iOS

Methodologies: Agile/Scrum, Waterfall, RUP, UML, CascadeERP PeopleSoft, SAP, Workday

Test Management: JIRA, VersionOne, Starteam, Mingle, HP Quality Center, Sharepoint, eTrack, TFS, ALM, MTM

IDE & Others: Eclipse IDE, Jenkins, Toad, MSProject, SVN Tortoise/Subversion, Quest STAT, Phire, NAS, Data Integration, RESTful, SOAP, Oracle BIEE, Oracle SOA Suite, XSLT, XSD, XML, BPEL, Oracle Virtual Box, Splunk, Putty

Middleware: Oracle Fusion Middleware 12C, 11g and 10g, Application Integration, Process Integration Packs (PIP), Oracle JDeveloper, Oracle ADF 11g, WebLogic Server, OER, OSR, BPEL, BRE, Oracle B2B, ODI, Human workflow, Oracle Application server, Oracle Service Bus(OSB), Oracle ESB

Languages: Python, Java, J2EE, XML/XSL, JavaScript, HTML, VB, Groovy Scripting, PL/SQL, SQL, C, python

App Servers: Oracle OC4J, Open source JBoss, Open source Tomcat, IBM WebSphere, Sybase EAServer, Macromedia ColdFusion, WebLogic

PROFESSIONAL EXPERIENCE:

Confidential,Tempe

Senior Hadoop Engineer

Tools: MapR, AWS, HDFS, Hive, Java, Sqoop, Oracle, DataMart, Unify, Oozie Workflows, Python& Shell Scripts, IntelliJ, Gradle, AngularJ, Junit, Web services

• Monitored workload, job performance, capacity planning, storage performance monitoring and storage analytics using MapR dash boards & Yarn and provided performance improvement.
• Design strategies, development, Consulting in various stages and platforms of project including data ingestion, ETL processing, Analytics Model execution, DataMart designs and loading, Unify reporting.
• Involved Low level design for Hive, Impala, Spark & Shell scripts to handle data ingestion process to HDFS from various media partner data sources.
• Ensure revenue is recognized in compliance with relevant Revenue Recognition rules & MapR Revenue Recognition policy
• Developed scripts to download data from AWS S3 buckets using AWS CLi
• Operationalize Enterprise Data MapR environment by developing standards based on best practices.
• Migrating the needed data from Oracle in to HDFS using Sqoop and importing various formats of flat files in to HDFS.
• Oversees secure collection, cleaning, standardization, transformation and storing of data from various sources.
• Prototype MapR solutions for specific use cases.
• Research and development of automation for administration tasks involving local and cloud base MapR topology.
• Maintains databases and related programs in a thorough and efficient manner, ensuring data quality.
• Identifies and uses appropriate investigative and analytical technologies to identify patterns, interpret and verify results.
• Uses predictive modeling, statistics, trend analysis and other data analysis techniques to explore data and to answer specific research questions.
• Co-creates models that describe the current education system and sub-systems.
• Evaluates the impact of innovations and interventions intended to improve student outcomes.
• Utilizes effective project planning techniques to break down projects into tasks and ensure deadlines are met.
• Prepares, or oversees the preparation of, reports, dashboards and presentations.
• Collaborates with the team to improve the effectiveness of computational models using data and feedback from education stakeholders.
• Used Sqoop to efficiently transfer data between Oracle database and HDFS and used Flume to stream the log data from servers.
• Ability to aggregate, normalize and process data by authoring predictive algorithms to synthesize and present actionable data insights.
• Experience in the use of SQL, data visualizations, database software and statistical programs
• Demonstrated knowledge of statistical analysis, database architecture, data mining and predictive modeling tools and techniques.
• Experience in using and learning a wide variety of tools and languages to achieve results
• Interactions with Analytics teams on features development and enhancements
• Participated in story-driven agile development methodology and in daily scrum meetings with the onsite and offshore teams.
• Managing production deployment and release cycles
• Conducting Reviews, discussions, Brain storming sessions, continuous improvement plans
• Interacting with Partners on data collection and processing techniques.
• Coordinates and supports user-acceptance test plans. Works with Scrum/Agile team or other IT teams to report and resolve complex issues. Ensures software applications meet functional and non-functional requirements.
• Participates in all aspects of testing at all levels, including functional, system, regression and load testing. Records and reports on testing metrics.
• Follows test documentation standards and makes updates as necessary.
• Performs other job-related duties as assigned or apparent.

Confidential

Senior Hadoop Engineer/ Integration Lead

Tools: CDH 5, HDFS, Hive, Spark, Impala, Java, Sqoop, Oozie Workflows, Python, Shell Scripts, IntelliJ, Gradle, Core Java, Junit

• Designed and developed data ingestion to HDFS using HIVE, Shell, Python and Spark scripts .
• Involved in loading data from RDBMS into HDFS using Sqoop.
• Worked on different file formats like AVRO, parquet, Jason.
• Developed java Map reduce XML PARSER programs to process XML files using XSD’s and
• XSLT’s as per the client’s requirement and used to process the data into Hive tables.
• Responsible for building scalable distributed data solutions using Hadoop.
• Prepared Oozie workflows using Hive, shell, Java, Python actions and schedule the Workflows using Coordinators
• Handled enhancements on Delta processing or incremental updates using hive scripts and processed the data to hive tables.
• Created customized and optimized Hive & Impala queries to extract Hadoop data to downstream applications and BI teams.
• Developed migration of hive to Spark SQL using Schema RDD’s.
• Actively involved with infrastructure teams in addressing the platform issues.
• Worked on Continuous integration (CI) (git ->Jenkins -> cluster) to build and deploy Hadoop
• Applications.
• Responsible for monitoring System health and logs and respond accordingly to any warning or failure conditions and coordinate with infra teams.
• Worked on Kerberos for hive2 actions, shell actions, Python actions by generating Key tab file in Hadoop cluster.
• Worked on creating BDR for production tables and replicated in prod environment in DEV cluster.
• Created automation scripts for production support team to get alerts on oozie monitoring, Workflow monitoring tables and reports to consumer groups.
• Involved in testing activities within QA environment which include System testing, Integration testing and writing test cases.
• Define the appropriate method for tracking quantities based on the contract to develop, create and prepare acceptance criteria, test plans, test cases, test scenarios, and test scripts for various applications; design test scripts and test automation from stored procedures and functions; Conduct all phases of development and testing including functional and non-functional.
• Utilize weighted rules of credit for quantity claiming and progress measurement to enable quantity claiming at the component level and Document application standards for integrations and develop software quality metrics.
• Get real-time percent complete status as plans are executed. HD Progress makes it easy to capture quantities and man-hours worked by task. Information is submitted and automatically updates budget and forecast reports.
• Prepare reports documenting defects and bugs and resolve defects for quality assurance testing methodology relative to the software development Lifecycle (SDLC) in agile methodology to perform trouble shooting and defect tracking;
• Get real-time percent complete status as plans are executed. HD Progress makes it easy to capture quantities and man-hours worked by task. Analyze current operational procedures, identify problems, and prepare reports and Integrate new reports and functionality with existing version of reports to have a secure infrastructure. Report bugs and issues using Microsoft Test Manager for new enterprise application development.
• Information is submitted and automatically updates budget and forecast reports to easily enter time for labor and equipment to study information processing systems to evaluate effectiveness, understand the functionality and doing impact analysis of changes on existing functionality.
• Allocate time amongst planned or unplanned work tasks to view summary of time by task and resource to review work product with teams, computer system capabilities, work flow and scheduling limitations to determine if requested program or program change is possible within existing system.
• Send time data to payroll systems, and automatically update budgets and forecasts with as-built hours to Plan and prepare technical reports, memoranda and instructional manuals as documentation of program development of services (XML, JSON, RESTFul, XSD, SOAP, etc.).
• Participating in planning meetings, task reviews, release and build review, estimations, test authoring, test executions, reviews, retrospectives. Also includes test management, co-ordination, task allocation, defect reporting, retesting and tracking to closure.
• Manage Original Budget, Control Budget, and Current Estimate at any level of the project, including WBS, line item, cost code, contract, and more to track cost trends and potential budget change. Also, integrate budgets with ERP systems to streamline project startup.
• Create and execute backup/restore and disaster recovery strategy and scripts for databases in specified environment.
• Complete tasks efficiently and timely, reporting progress to Project and Engagement Managers
• Assist with evaluating additional functionality and using current functionality in other ways to increase the benefits of the application.
• Assist staff with monitoring, processing, troubleshooting, reporting, and reconciling activity, especially as it interacts with other modules.
• Demonstrated ability to understand academic curriculum with its myriad of majors and options, and its complex set of general education requirements and collaborated with the PeopleSoft Administration and Technical Team on projects, break-fixes, upgrades and testing, project teams on an as-needed basis.
• In corporate Two Factor Authentication management for students/staff to Connect application with systems. Salesforce/Mulesoft/Peoplesoft to retrieve data and move them along with their metadata to proper repository using Application IDs.
• Support Transfers and Termination Roll out with established connectors within salesforce that will allow users to send decommission Users directly through salesforce.
• Create and modify queries and reports to assist end users and coordinates and participates in testing for PeopleSoft updates/bundles.
• Configured software packages; design, coding using object-oriented programming(OOP) language, and test program modules that meet design specifications as required; update code to address defects and change requests or enhancements.
• Escalate issues according to established communications guidelines and checklists.
• Analyze and troubleshoot application related incidents as reported by the user community.
• Complete required change management process and forms for assigned production changes; create, execute and document the tests necessary to ensure that an application or technical environment meets functional specifications and performance requirements.

Confidential

Senior Hadoop Developer

Tools: Vista Loyalty, Bit bucket, GitHub, Enterprise Service Bus, SQL, Swagger UI, SOAPUI, Windows environment, Queues, WebLogic. Cloudera CDH, Apache Hadoop, HDFS,PIG, Hive, SQOOP, Oozie, Shell Scripts, Map Reduce, CRON Jobs

• Architect and develop the Vista Loyalty Point of Sale(POS) platform service layer. Main activities included synchronous and asynchronous design flows between external clients and Harkins services.
• Tune SOA applications performance. Tuning exercises included JVM tuning, database purging strategy recommendations, specific SOA engines tuning such as BPEL engine and mediator engine.
• Define the appropriate method for tracking quantities based on the contract to develop, create and prepare acceptance criteria, test plans, test cases, test scenarios, and test scripts for various applications; design test scripts and test automation from stored procedures and functions; Conduct all phases of development and testing including functional and non-functional.
• Involved in enhancing the application for client’s requirement based on the market demand.
• Involved in gathering the client requirement and to design the requirement for development team and plan for different releases.
• Implement configuration details for integration interface, integration object, integration point and data flow design.
• Set up the interface data mapping process that maps logical exchanges to physical exchanges during development.
• Extensively converted services from REST to SOAP and vice versa.
• Contract/Canonical designing and common reusable objects.
• Review business requirements and functional specification documents to design test cases that will test interface usability, functionality, data integrity and performance.
• Execute test cases and document defects where actual results do not match expected results.
• Identify inconsistencies from application standards and recommend modifications to conform to standards.
• Communicate regular status of assigned tasks with development team and management.
• Interact with internal users to assist in the use and support of software.
• Worked on Infoscan,Qscan, UPCselect dataloading optimization projects.
• Analyzed large data sets by running Hive queries scripts.
• Involved in creating Hive tables, and loading and analyzing data using hive queries.
• Involved in running Hadoop jobs for processing millions of records of raw data.
• Responsible for loading unstructured and semi-structured data into Hadoop cluster coming from different sources using Sqoop.
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce and loaded data into HDFS.
• Involved in Data modeling like preparing the source and target mapping of the fields based on source data etc.
• Involved in Analyzing system failures, identifying root causes, and recommended course of actions and coordinated interactions with Hadoop Admins.
• Analyzed the failed data and identify critical data issues from retailers file in yarn logs .
• Developed Pig Latin scripts to extract data from the web server output to load into HDFS.
• Designed reusable, scalable and high performance application features in HIVE, Java UDF’S for evaluation, filtering, loading and storing of data.
• Responsible for moving the data from source (Teradata, Oracle) to HDFS ->HIVE tables and UnitTesting of the files moved.
• Assisted in the operations, support, management and deployment of Hadoop environments
• Trained and shared knowledge to technical teams to ensure second line of support available for business.

Confidential

Senior IT Engineer

Tools: Oracle Fusion Middleware, WebLogic, Splunk, HP QTP, SOAPUI, ALM, Oracle DB, MS SQL server, Oracle, Oracle Service Bus 11g, Eclipse, Java Web services, Spring framework, Sub Version, JDeveloper Unix, Mongo DB, Actional, JIRA, Selenium Hadoop, Java,Map Reduce, HDFS, Hive,PIG, Control M,Python, MySQL,DB2, Sqoop, spark, Oozie, Informatica, RabbitMQ, Cloudera

• Develop automation software using an automation tool specific to the Scrum Team
• Work with a team of software developers to establish and develop test automation methods and techniques; plan, develop, implement and conduct Story level tests
• Preparation of Technical specification, Involved in different phases to gather requirements, document the functional specifications, design, data modeling and development of the applications.
• Involved in complete lifecycle of Hadoop implementation tasks - Hadoop Cluster administration, write MapReduce Programs, Hive Queries and pull the log files using Flume.
• Used Sqoop to efficiently transfer data between databases and HDFS and used Flume to stream the log data from servers/sensors
• Worked on SAS migration to Hadoop on Fraud Analytics and provided predictive analysis.
• Worked on Hive optimization techniques to improve the performance of long running jobs.
• Responsible to manage data coming from different sources.
• Developed java Map reduce programs on top of JRecord as per the clients requirement and used for EBCDIC to ASCII conversation.
• Developed MapReduce programs to cleanse the data in HDFS obtained from heterogeneous data sources to make it suitable for ingestion into Hive schema for analysis
• Developed Pig UDF's to pre-process the data for analysis. Extensively used Pig for data cleansing.
• Exported the business-required information to RDBMS from HDFS using Sqoop to make the data available for BI team to generate reports.
• Performed complex Joins and performance tuning on the tables in Hive.
• Written Map Reduce java programs to analyze the log data for large-scale data sets.
• Used Control-m scheduling tool to manage interdependent Hadoop jobs and to automate several types of Hadoop jobs such as Java map-reduce, Hive and Sqoop as well as system specific jobs
• Worked with BI teams in generating the reports and designing ETL workflows on Tableau.
• Involved in generating DDL, SQL static Modules, Copy Books and BIND control cards from FSA files structures (CITI specific). Meta Data Analysis as part of VSAM to Hadoop migrations
• Utilize knowledge of test engineering and apply understanding of principles of related engineering and software technology to ensure test validity and integrity; create program test plans and procedures and compliance with program requirements.
• Perform analysis of system-level requirements and managing changes as they affect test procedures; development, tracking and monitoring derived requirements; writing standard program test documentation
• Assist in the performance of test assignments involving the definition of test and verification requirements and will operate under general supervision -- guidance received will relate primarily to general objectives and details of unusual situations and/or requirements
• Develop test automation software using an automation tool specific to the Scrum Team; work with a team of software developers to establish and develop test automation methods and techniques
• Plan, develop, implement and conduct Story level tests; utilize a knowledge of test engineering and apply understanding of principles of related engineering and software technology to ensure test validity and integrity; create program test plans and procedures and compliance with program requirements.
• Perform analysis of system-level requirements and managing changes as they affect test procedures; development, tracking and monitoring derived requirements; writing standard program test documentation
• Assist in the performance of test assignments involving the definition of test and verification requirements and will operate under general supervision -- guidance received will relate primarily to general objectives and details of unusual situations and/or requirements
• Develop test automation software using an automation tool specific to the Scrum Team; work with a team of software developers to establish and develop test automation methods and techniques
• Plan, develop, implement and conduct Story level tests; utilize a knowledge of test engineering and apply understanding of principles of related engineering and software technology to ensure test validity and integrity; create program test plans and procedures and compliance with program requirements.
• Reviewed and analyzed requirements, specifications, user documents and other project resources to develop and execute automated test sets to provide adequate test coverage.
• Experience with Agile and Waterfall software development mythologies.
• Communicated with IT personnel and business end users to utilize appropriate quality assurance tools and techniques to ensure the desired system requirements are achieved.
• Assisted in the documentation of testing standards, support documents and overall best testing practices and updated as needed.
• Worked to collaborate with other managers and dev team to develop and plan tools upgrades and standards.
• Acted as scrum master to guides overall project team and lead to manage and coordinate all aspects of project requirements.
• Implemented Service Automation Testing in the Enterprise Search Platform project which is an effort to consolidate all the Search instances across the organization and to provide Search as a Service
• Implemented Selenium frame work using Selenium web driver for Pet’s chat module and also for Lead management systems application
• Tested Android version of the event notification system using Google's Cloud to Device Messaging (C2DM).
• Key member in Keyword Automation Framework Development/BPT for Ecampus applications.
• Configured software packages; design, coding using object-oriented programming(OOP) language, and test program modules that meet design specifications as required; update code to address defects and change requests or enhancements.
• Escalate issues according to established communications guidelines and checklists.
• Improved support policies and procedures documentation in Wiki/SharePoint; create/update system and application documentation as required.
• Perform post-production system review and checkout as needed.
• Provided specific and balanced feedback to staff, peers and management.
• Attended PMO reviews for new projects and Release Management.
• Carry out business process including BPEL and PeopleSoft campus solutions/financial aid for interface related activity with flow (control and transactions) with end-to-end mapping between Osiris information to PeopleSoft system and vice versa, with basic field validations to expose data.
• Establish common design artifacts that deal with design principles and methods which are applicable across physical exchanges for interfaces and reporting.
• Analyze and troubleshoot application related incidents as reported by the user community.
• Provide development, code, and test and debug PeopleSoft issues to resolve and perform modifications feature and function review.

Confidential

Senior Software Developer /Scrum

• Develop test automation software using an automation tool specific to the Scrum Team
• Work with a team of software developers to establish and develop test automation methods and techniques; plan, develop, implement and conduct Story level tests
• Utilize knowledge of test engineering and apply understanding of principles of related engineering and software technology to ensure test validity and integrity; create program test plans and procedures and compliance with program requirements.
• Within the FA Dept, Kanban team provide data integration, reporting and analysis at the enterprise level that maintain and apply Regulatory bundles for new aid year(annually) for Dept of Ed., PeopleTools upgrades, any critical updates for ISIR, Pell, Direct Loan, FISAP, and other federal updates.
• Demonstrated ability to understand academic curriculum with its myriad of majors and options, and its complex set of general education requirements and collaborated with the PeopleSoft Administration and Technical Team on projects, break-fixes, upgrades and testing, project teams on an as-needed basis.
• Ability to use PeopleSoft tools to effect the curriculum revisions created by Academic Affairs to interpret and apply academic and administrative policies and procedures.
• Supported the continued improvement of internal procedures and policies to advance Application Support effectiveness.
• Respond to User inquiries and incidents within service level agreements and to deliver on SLA objectives. Work directly with business/end users, IT staff or 3rd party technology staff to resolve issues.
• Complete required change management process and forms for assigned production changes; create, execute and document the tests necessary to ensure that an application or technical environment meets functional specifications and performance requirements.
• Apply technical knowledge to improvements of applications for usability and stability.
• Complete design, redesign and development work in accordance with root cause analysis and system improvements as assigned.
• Provide assistance, advice, problem solving, and technical information to Users regarding the use of software applications; to act as liaison with Users regarding the status of their issues and requests.
• Assessed use of new features and functions to replace modifications and provided detailed app-tech knowledge.
• Worked in multi-phase development and deployment schedules with significant communication with functional and technical teams.
• Evaluated overall test process and made recommendations for improvements.
• Utilized knowledge of internet protocols and languages such as SOAP, XML and XSD, and provided configuration, testing, UAT, training and documentation.
• Carried out administration of test control and statistics collection (i.e., problem reporting and defect tracking).
• Functioned in a technical role as the coordinator of migrations between various environments to assure that objects were moved to incorrect environments and appropriate testing was completed prior to future migrations.
• Ensured that all production changes were processed according to change management policies and procedures, and fully documented production level changes.
• Provided guidance and assistance to other team members.
• Completed work during long and flexible hours.
• Identified opportunities to analyze performance issues and tune application to improve performance.
• Supplied technical application support to business, quality assurance and end user support teams.

Confidential

Senior Engineer / Waterfall

• Designed and implemented a test automation framework using QTP and VBScript.
• Designed and programmed automated tests, scripts and functions using QTP.
• Executed, modified and documented both automated and manual tests and test sets in ALM/QC to accommodate new software releases and changes.
• Reviewed and analyzed requirements, specifications, user documents and other project resources to develop and execute automated test sets to provide adequate test coverage.
• Experience with Agile and Waterfall software development mythologies.
• Communicated with IT personnel and business end users to utilize appropriate quality assurance tools and techniques to ensure the desired system requirements are achieved.
• Created and developed testing tools to support test data creation and management using Microsoft Visual Studio.
• Prepared activity and defect reports for software quality assurance activities and provided status reports of testing metrics to QA management and project personnel.
• Assisted in the documentation of testing standards, support documents and overall best testing practices and updated as needed.
• Interfaced Maximo with the PeopleSoft system to get updated information on items, vendors and material transactions.
• Established the business process inside Maximo and PeopleSoft for interface related activity with flow diagram.
• Mapped PeopleSoft information to Maximo system and vice versa and basic field validations.
• Set up common design artifacts that dealt with design principles and methods which were applicable across physical exchanges for interfaces documented.
• Targeted connectivity profile details, integration capability of applications and required configuration details.
• Implemented interface details, Maximo MEA configuration details for integration interface, integration object, integration point and data flow design.
• Created the interface data mapping process that mapped logical exchanges to physical exchanges during development.
• Worked on material request through Maximo work order with an acknowledgement of successful MSR creation.
• Provided material request status update and issue.
• Formulated department ID with PS financial Bus.
• Updated inventory items and attributes and captured balance and cost through real time view.
• Established vendor information, addresses, item master, attributes, unit of measure and manufacturer ID based on real time and batch mode

Confidential

Software Engineer /Waterfall

• Prepared the necessary Test cases from the use case scenarios and Identified the Test Conditions depending on the business processes
• Involved in the frame work designing and written Prepared VB Scripts using QTP 9.2
• Core member in writing User defined functions for my module and Prepared Action driven framework
• Participated in weekly and Quarterly Team meetings. Creating windows virtual machines on VM ware to build the configs.
• Working with other development team members to better understand system functionality in order to improve testing quality.
• Logging project related issues in the defect tracking tool identified for the project.
• Analyzed severs response, performance reports and graphs in various virtual user loads.
• Extensive Back end testing was done to verify and validate data using SQL queries
• Rerun of test cases and test scripts for regression testing after fixing the bugs in the software
• Identify Training requirements and forward it to the Project Manager (Technical and Soft skills).
• Customized FS11C report and added fields by altering the query and settings to the report to generate the expenditure and revenue report separately.
• Performed modifications to the funding source report by picking up only federal records and deleting state records.
• Modified fund distribution report to distribute the amount as cash, liabilities, revenue and expenditure.
• Gathered data requirements, performed data analysis and defined the data mapping.
• Worked on the vendor extract to meet state requirements, depending on vendor remittance addresses generated when the pay cycle was run.
• Carried out modification of the CCP customization process so that transactions for 'BIL' rows would pick up 'BLD' rows coming from federal draws to go to fund distribution, which included customization of tables, pages and People Code (using OOP).
• Tested various scenarios to suit the business requirement.
• Generated a monthly transaction report of CMS extract for a fiscal year at component level including CPIDs, contract numbers, legal names, amounts, service codes for contracts depending on the warrant date, adjustments incurred and generated by unit charge for a particular unit.
• Executed the VINQ conversion by identifying vendors depending on the legacy system.
• Monitored PS revenue contracts/grants/ billing/ project cost results of input to achieve agency goals.
• Notified SBA analyst of any needed appropriation or allotment changes needed to accommodate the new grant.

Confidential

PeopleSoft Technical Developer/Waterfall

• Developed formatted vocational rehabilitation warrant summary report for payment files that were sent to vendors which was similar to the report generated by sub-system using PeopleSoft.
• Set up projects to move objects to various existing environments.
• Developed new PS queries to include different scenarios on encompass.
• Established records, pages, components and new navigations to run developed reports.
• Interacted regularly with users and controllers, involving clarifying general PS finance issues regarding month and period ending validations for income statement reports and operating balance reports.
• Mapped legacy data with corresponding PeopleSoft data.
• Integrated data from CMS for claims component by agency/fund/ center for each quarter, voucher count for fixed asset transactions and travel expenditure transactions (SFY 2007 and SFY 2008).
• Generated reports to verify voucher prior to payments and developed report for GL expenditures by business unit.