Padmavati Tallapareddy

• Involved in design discussion with Product owner and Business Analyst to identify and finalize the requirement and acceptance criteria n stories,task and subtasks.
• Extensively used Database Connector,Complex flat file,Sequential File,Funnel, Transformer, Lookup,Aggregator,Database stages in IBM infosphere Datastage.
• Communicated activities/progress to project managers,business analysts and clients on regular basis on scrum calls,
• Interacted in Scrum and resolve outstanding or anticipated issues with multiple teams.
• Built a script to load set of 60 files into the database table in a single go.
• Involved in extensive development of the mapping and the functional specations. Created mapping specations,Designed, and tested specations according to the requirement.
• Designed and Developed sequenciars and Parallel jobs for data flow and processing.
• Hands on experience in tuning parallel job,SQL,indentifying and resolving performance bottlenecks in various levels like sources,targets,Sql query in DataStage.
• Have a strong knowledge with Version control tool IBM infosphere information Server Manager 11.7 to Migrate the ETL code to test and production env.
• Read different source files like Json,XML,mainframe files and loaded t the database and data coing form input and loaded then to the Netezza Database.
• Well versed with Shell script commands and have written Shell Scripts to validate Source files and modified already existing scripts.

Environment :IBM information Server DataStage 11.5, 11.7,11.9 ,MobaXterm V20.5 Build 4502 , Control-M 9, Source Tree & infosphere information Server Manager(IISM) verson control.

Practice Fusion is web-based electronic health record software for physicians and medical professionals. It is labs, imaging, and billing modules integrated with a network of third-party laboratories, medical imaging centers, and medical billing services.

Patient fusion is a personal health record (PHR) system that gives patients access to their prescriptions, diagnoses, and test results, record updates physicians add information to their patient's charts, and consumers can search physicians by location and specialty and request appointment online.

Responsibilities:

• Developed complete IBM Infosphere DataStage project for mutual funds product from start using IBM Infosphere DataStage 8.5 and copybook from the vendor and Informatica jobs.
• Led Multiple projects (Mutual funds, brokerage, etc.) utilizing DataStage, SQL, Autosys and UNIX technology.
• Converted all jobs from Informatica 8.1 to IBM Infosphere DataStage 8.7 for brokerage Product.
• Loaded XML file from the third-party vendor using DataStage ‘XML INPUT Stage’ to SQL Server db.
• Full tested jobs in both Informatica and IBM Infosphere DataStage and validate the Results with QA to proceed with migration to SDLC env.
• Built the ETL process for AML team in Lower SDLC env with proper testing and migrated the code to prod after proper testing and approval.
• Used IBM Infosphere DataStage Designer, Director, and Administration for creating & implementing jobs.
• Developed ETL jobs, T-SQL scripts and Jil files as per the business requirement. Usually, we have meetings with business.
• Created Migration requests for IBM Infosphere DataStage, SQL, and AutoSys (Jil and Docit’s) from development to test Env.
• Created a User defined variable as per the requirement of our project using IBM Infosphere DataStage administrator in dev and migrated the same to test with the help of a IBM Infosphere DataStage admin.
• Extensively used Sequential File, Transformer, Join, Lookup, Filter, Funnel, Row Generator, ODBC Connector and Oracle Connector.
• Developed UNIX shell script to run the IBM Infosphere DataStage job, transfer files to the different landing zones.
• Scheduled the IBM Infosphere DataStage job using AutoSys.
• Wrote PL-SQL, T-SQL queries to generate reports for other teams for their development efforts in the given span of time.
• Used Standardization, Match Frequency Stage in Quality Stage.
• Modified already existing T-SQL as required after discussion with the business team and migrate to SDLC environment.
• Involved in Data Quality meetings. (Quality Stage).
• Analyzed the request from business & other teams and do research and generate the PLSQL and T-SQL queries and provide the data as needed.
• Performed through data profiling by using the Investigate stage of Quality Stage.
• Developed and migrated OBIEE and Tableau reports as per the requirement of business.
• Created the TDD (Technical Design Document) for numerous projects for Mutual funds products.
• Helped out Team with FRD (Functional Requirement Document), SDD (Solution Definition Document) for a project which is in a starting Phase.
• Performed unit integration testing for our project as needed and required.
• Validated the code migration to all SDLC Env.
• Migrated XML data files to SQL Server DB for Data Lineage Statistics.
• Created Data Lineage report, Impact analysis report and Business Lineage report through IBM Metadata Workbench.
• Migrated Autosys jobs in SDLC env and moved to production without any issues.
• Part of IBM Infosphere DataStage conversion project from DS 9.1 to 11.7, fully involved in testing and all code migration in SDLC Environment
• Helped Web team & Business with incidents by running batch after set of details created by the vendor to help resolve the incidents and problems.
• Created Change Request to Move data fixes from prodfix to prod after getting business approval.
• Supported the ODS (Operational Data Store) project as Prod Support to resolve incidents and Problems

Environment: IBM Web Sphere DataStage 11.3/11.5,Citrix, UNIX Shell Scripting ,Teradata 14x, SQL, ORACLE, IBM Tivoli, Job sequencer, Crontab, Airflow 2X

• Experience in Manual and Automated Testing of GUI and functional aspects of Client-server and Web based application multiple levels of SDLC and Software Testing Life Cycle(STLC).
• Analyze the business requirements and closely work with the Business Team to tet the clarification addressed.
• Good knowledge of Object oriented programming Concepts(OOPS) and Java Skills.
• Good experience in creating test scripts using Webdriver ,Selenium RC,Selenium-IDE,Selenium Grid in Java.
• Experience in Oracle,SQL sever
• Experience in Analyzing Business ,Functional and Technical specifications.
• Writing test cases ,Test procedures and Test Scripts form requirements and Use-Cases.
• Experience in Web Services testing using SOAP UI.
• Experience in Software Verification and Validation based on Testing Methodology
• well versed with Agile process,Scrum methodologies
• Selected the test cases to be automated and performed functional testing of the front end using Selenium Web driver & created a Data Driven framework using JUnit.
• Possess working Knowledge on Web Services Testing using SOAPUI and POSTMAN
• Experience in validating Web services SOAP request and response XML and REST Services.

Environment : Selenium Web Driver,Jenkins,REST API.SOAPUI,Qualitycenter,XPATH,java,HTML,Agile,GIT,SQL,Oracle and Windows.