• Involved in development and enhancements to the key Loans and Securities lending application to improve the overall performance of the system and help in onboarding of new clients onto the lending system.• Involved in various development and analytical initiatives, related to the project Fusion which will merge the SecLending and OpenLend application to provide a single portal for Loans and Securities Lending operations.• Analyze the business requirements, analyze and document the functional work flow of data and information from source systems to destination systems.• Conduct review of the database objects such as tables, views etc. to determine the status as-is and to determine scope of improvement in the overall design from the performance point of view and provide recommendations.• Develop and update various stored procedures, functions, triggers, rules, defaults, user defined datatype, indexes etc., and complex SQL scripts, as part of enhancement efforts, in order to insert, load and validate the data into the appropriate tables.• Development and maintenance of various SQL and job scripts, in order to accomplish processing of data and facilitate complex transactional and reporting functionalities and format the data conditionally.• Performance tuning and optimization of SQL scripts, stored procedures, to improve performance slowed down considerably owing to the complexity of system and data volume increase in the last few years.• Troubleshooting of performance issues, to help quickly pinpoint the source of the bottlenecks and implement an efficient solution. Resolve data contention, deadlocks and many other performance related issues.• Conduct analysis of jobs, indexes clustered and non-clustered to modify, reorganize or recreate them if necessary to improve performance and tune the process.

• Conducted in-depth claims analysis using MS Excel to extract, transform, and analyze large datasets, identifying patterns and trends indicative of potential fraud or irregularities.• Developed comprehensive fraud detection reports in MS PowerPoint, presenting findings to stakeholders and management, facilitating informed decision-making and risk mitigation strategies.• Collaborated with cross-functional teams to create a centralized repository for claims data on SharePoint, streamlining data access and ensuring data consistency for fraud detection purposes.• Participated in frequent agile team meetings (Scrum planning, daily stand-ups, retrospectives) to provide guidance to an agile product development process.• Utilized SAP Business Objects to create detailed ad-hoc reports, extracting relevant claims data and providing actionable insights to enhance fraud detection capabilities.• Designed and implemented interactive dashboards in Tableau, visualizing complex claims data for quick and intuitive identification of anomalies and potentially fraudulent activities.• Developed custom Python scripts for data validation and cleansing, ensuring the integrity of input data for fraud analysis.• Strong experience in analyzing large amounts of data sets writing PySpark scripts and Hive queries.• Used JIRA to perform test management activities and involved in extraction of data from various sources like flat files, Oracle and SQL Server. Coordinated with the ETL team to come up with processes for ETL involving Oracle/Informatics • Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.• Experienced in software development life cycle such as Waterfall, Agile-SCRUM methodologies, Business Analysis and Modelling.

• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.• Performed requirements gathering and design analysis for customer contact history for customer relationship management.• Analyze and problem solve issues as they relate to the management of financial processes dealing with the DOD O Perform data entry, either manually or using scanning technology, when needed or required• Created, modified and uploaded financial documents to DOD Financial Powerpoint slides• Performed light Sharepoint Administration duties• Created Reports from DoD Agengies and Departments using Teradata.• Worked as business requirements analysts with subject matter experts to identify and understand requirements.• Worked on MS SQL Server interface to a Big Data Warehouse Framework (Talend and MicroStrategy) to support MDA's business inte ligence and col aboration services (MIC)• Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.• Perform ETL (Extract Transform Load) using tools such as Informatica, azure to integrate/transform disparate data sources. • Perform data scraping, data cleaning, data analysis, and data interpretation and generate meaningful reports using Python libraries like pandas, matplotlib, etc.• Generate weekly reports with visualization using tools such as MS EXCEL (Pivot tables and macros), and Tableau to enable business decisions making.• Upload daily feeds from external server on s3 using multipart upload feature of AWS and then load this data into Snowflake cloud database.

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.• Responsible for different Data mapping activities from Source systems to Teradata• Created the test environment for Staging area, loading the Staging area with data from multiple sources.• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)• Executed campaign based on customer requirements• Followed company code standardization rule• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.• Executed the SAS jobs in batch mode through UNIX shell scripts• Created remote SAS sessions to run the jobs in parallel mode to cut off the extraction time as the datasets were generated simultaneously• Involved in code changes for SAS programs and UNIX shell scripts• Reviewed and modified SAS Programs, to create customized ad-hoc reports, processed data for publishing business reports.

• Identify business, functional and Technical requirements through meetings and interviews and JAD sessions.• Define the ETL mapping specification and Design the ETL process to source the data from sources and load it into DWH tables.• Designed the logical and physical schema for data marts and integrated the legacy system data into data marts.• Integrate Data stage Metadata to Informatica Metadata and created ETL mappings and workflows.• Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.• Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.• Developed Stored Procedures to test ETL Load per batch and provided performance optimized solution to eliminate duplicate records.• Provide the team with technical leadership on ETL design and development best practices.