Home

Harika - PL/SQL SSIS Developer

[email protected]

Location: Herndon, Virginia, USA

Relocation: Yes

Visa: H1b

SAI KRISHNA HARIKA POTHURAJU [email protected] Summary Over 8+ years of experience in IT industry as MSBI developer, involving Software analysis, SQL server databases and data loading and reporting tools with SSIS in Banking domain. Demonstrative experience working with Microsoft SQL Server Integration Services with hands on development experience using Microsoft SQL server programming language. Proficient in designing and deploying SSIS packages using various transformations such as Multicast, Merge join, Look up, Conditional split, Aggregate, Derived column, Sort, Multi-cast, union etc. Experience in providing logging, Error handling by using Event handlers for SSIS packages hands on experience in identifying and resolving performance bottle necks in various levels like source, target, mappings. Developing, implementing database objects like Tables, Views, Stored procedures, Functions using SQL. Used SSIS to migrate databases such as Oracle and SQL server database, flat files to destination. Having around 8years of experience in financial domain. Working in Agile methodology, estimates for sprints to accurately reflect the effort required. Participating in various sprint ceremonies such as standups, sprint planning and sprint reviews. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. TECHNICAL SKILLS: Languages : SQL Tools: SSIS, Actimize, Toad, GIT, SVN, Power BI, SSRS, SSAS Soft Skills: Leadership, Customer Support, Presentation, Documentation, Time Management, Event Management WORK EXPERIENCE: Project 1 Client: MUFG bank USA. Project: AML/SAR Role: Actimize and Database Developer Tools: AIS Visual Modeler 4.9, PL/SQL Developer, TOAD, Eclipse IDE Duration: Jun 2023 to Apr2024 Responsibilities / Deliverables: Working on Data migration from SQL to Oracle databases. Working on decommissioning of application. Working on exporting CASE/SAR and Alert PDF s. Writing complex queries to extract data from Databases. Working on Batch files for migration of data. Working on Testing of Data after migration to new data base. Creating HLD documents. Unit testing and Performance tuning. Taken care of Deployment and Release management Support the Post deployment code maintenance. UAT testing Support. Production Support to validate post production to monitor the performance. Data analysis, reconciliation. Project 2: Client: Bank of America(USA) Project: GLOTR/ETLA applications Role: Technology Lead Duration: Jan 2021 to Mar 2023 Responsibilities / Deliverables: In this project we develop new SSIS packages based on client requirement and to automate the SSIS packages. Instead of running packages through deployment in SQL server we went through third party tool to automate which reduces the load on server and increases performance. Creating tables, Views, Indexes, Stored Procedures, Triggers and provide constraints and user defined rules and defaults. Using multiple join statements to retrieve data from multiple tables. Working on the scheduler tool (third party) to automate the SSIS packages. Implementing transformation logic using Derived transformation and resolving data load issues in SSIS packages. Deploying packages and procedures to update the data from production to data warehouse tables. Creating SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases. Configured SSIS packages using Package configuration wizard to allow packages run on different environments. Derived column, conditional Split, Aggregate, Row count, Look-up, Sort and data conversion to load data into Data warehouse. Actively participating in interaction with users, team lead, DBA s to fully understand the requirements of the system. Understanding the dependencies of external systems. Creating complex SQL queries, Derived tables, common table expressions (CTE s), complex stored procedures etc. Extensively involved in designing (Logical and Physical) of customer database. Migration of SSIS packages. Creating complex ETL packages using SSIS to extract data from staging tables to portioned tables with incremental load. Creating reusable SSIS packages to extract data from Multi formatted flat files, Excel, XML files into database and DB2 systems. Developing, deploying and monitoring SSIS packages. Performing operations like Data reconciliation, validation and error handling after extracting data into SQL server. Project 3: Client: Bank of America(USA) Project: Reg W application Role: SSIS, SQL, Actimize, Oracle developer Duration: Nov 2016 to Dec 2020 Responsibilities / Deliverables: Reg W governs transaction between a bank and its affiliates. It establishes certain limit and requirement on such transaction. BOFA preserving safety and soundness of bank and bank subsidiaries by making certain legal and regulatory requirement of Reg W. Primary objective is to load the data from different sources into a single DB where user tests it against set of rule data. Gathering User requirements by participating in meetings and analyze requirements. Creating Database Objects like Stored Procedures, Views, tables and other objects to achieve business requirements. Involved in the ETL phase of the project. Creating packages at SQL server integration Service platform by using various tasks and transformations. Creating SSIS configurations as per requirement. Involved in modifying various existing packages, procedures, functions according to the new business needs. Optimizing SQL s using explain plan to analyze the execution plan and tune the statements. Integration of the modules and Unit testing so that they work as per the requirement in Production. Impact analysis and root cause analysis of production deployments. Performing Unit testing, UAT and designing test cases. Involved in Development Process and support activities, Job monitoring and prepare documentation. User job scheduler to send email notifications for job and record insertion failure. Project 4: Client: Bank of America (USA) Project: Triton application Role: SSIS, SQL developer Duration: Dec 2015 to Oct 2016 Responsibilities / Deliverables: This project is to provide the support for analytic needs of the banking organization to meet its compliance needs. Process is to extract the data from traditional database, cleanse and process the data to store in data warehouse from which reports are generated to meet the organizational needs. Requirements gathering for ETL and Analysis specifications. Creation of packages in SSIS to load data from OLTP to staging, DWH tables. Applying Derived column, Multicast, Conditional Split and lookup transformation while loading data into DWH. Provided L2 support for Triton application model runs. In SQL server created queries in order to efficiently retrieve log data from log table considering various parameters as per business requirement. Interactions with support team about their day- to-day monitoring activities. Regular interaction with client in daily basis. EDUCATION: Bachelor of Technology in Computer Science and Engineering from Vignan s Institute of Information Technology. Keywords: business intelligence database information technology procedural language