JIRA
Manasa Nukala
Senior BI Consultant II
Austin,TX
Summary
Results-focused Business Intelligence professional with strength in Informatica Power center ETL tool Informatica Data quality,Oracle and Unix shell scripting with 7 years of experience. Proficient in leveraging ETL knowledge to promote Integration of different systems. Adept at managing concurrent objectives to promote efficiency and influence positive outcomes. Reliable when leading training and overseeing daily activities. Increased employee retention through team building, problem solving and positive atmosphere.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
Work History
Senior BI Consultant II
Santander Bank,Mirai Advisory
Boston, MA
09.2018 - Current
- Managed the team of 6 members,Delegated daily tasks to team members to optimize group productivity. Reviewed and optimized work of other team developers, providing feedback and instruction for skill improvement and knowledge transfer.
- Perform analysis of source systems and translating the Functional Requirements into Technical Specifications.Designed and developed complex ETLs using Informatica power center 10.1
- Provided excellent service and attention to customers when face-to-face or through phone conversations.Trained non-technical users and answered technical support questions.
- Gained Domain knowledge in Banking systems and have good understanding in credit risk management.
- Worked closely with offshore team and helped them to understand the requirements and meet the deadlines
- Evaluated employee performance, identified areas of improvement and communicated plans to employees.
- Designed and developed complex workflows to generate files for Basel data reporting as per the user requirements by integrating data from different sources.
- Created Tool using informatica to leverage automatic logs of workflow executions,source/target statistics,status of the executions by using worklets and complex transformations like SQL,Transaction control.
- Created rules engine tool using informatica which helps the user to input the rules in metadata tables for segmenting the data.
- Created several reusable components for automatic partition maintenance in oracle tables,for applying different data quality checks and help us understand bad data,for monitoring a file continuously using informatica power center,for controlling execution fo a workflow.
- Designed and developed informatica workflow to understand the dependencies on a workflow using xml transformation.
- Provided post production support and documented production levels, materials used and special incidents to keep management informed of daily activities.
Senior Software Engineer
Nissan,Accenture Services Private
Hyderabad, India
06.2014 - 05.2016
- Supervised team of developers to deliver project requirements, develop solutions and meet deadlines,discussed project roadblocks to drive issue resolution and promoted use of best practices.
- Designed and developed complex workflows using Informatica 9.6 to migrate data from different SAP source systems to new SAP systems.The logic was made reusable by creating mapplets and worklets.
- Prepared effective Unit, Integration and System test cases of Mappings for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
- Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
- Worked on Java transformation to automate the process of comparison between the files and the database Environments: Informatica Power Center 9.6.1, Oracle 10g/11g, PL/SQL, TOAD, Oracle Applications 11i, Windows XP, Informatica Data Quality.
- Provided excellent service and attention to customers when face-to-face or through phone conversations.
Software Engineer
BestBuy,Accenture Services
Mumbai, India
06.2012 - 06.2014
- Worked closely with business analyst to understand the requirements and Collaborated with senior developers to design and developed ETLs using Informatica 9.1.
- Identified performance issues in existing sources, targets and mappings by analyzing the thread statistics, dtm and data buffer utilization and data flow, evaluating transformations and tuned accordingly for better performance.
- Assisted in User Acceptance Testing for Retail customers, verifying ETL jobs complied with all assigned parameters.
- Applied multiple data models to ETL tasks, including Conceptual, Logical, and Physical & Dimensional/Relational model designs.
- Worked as part of project teams to coordinate database development and determine project scopes and limitations.
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services. Prioritized and organized tasks to efficiently accomplish service goals.
Education
Bachelor of Science - Electrical, Electronics And Communications Engineering
JNTU
HYDERABAD,INDIA 06.2008 - 05.2012
Skills
Business Intelligence Analysis
Software
Service Now
CTRLM Scheduling Tool
Maestro Scheduling Tool
Accomplishments
- Was awarded with "Accenture Celebrates Excellence Awards" for the financial year 2014-2015.
- Was identified as best employee in Mirai Advisory for the financial year 2019-2020.
- Supervised team of 6 staff members.
- Have experience in coordinating with offshore team.
- Tuned Performance of multiple jobs and stabilized production environment
- Have good experience on working with all types of transformations,reusable components in Informatica
- Have written multiple Unix shell scripts for triggering workflows from external schedulers and looped the workflows to run for 30 days in the month.
- Proficient in writing SQL code for DML’s, DLL’s and DCL’s with good programming knowledge in creating PL/SQL Anonymous blocks, Packages, Stored Procedures, and Functions.
- Collabarated with Technical Architect in designing the data model using ERWIN.
Timeline
Senior BI Consultant II
Santander Bank,Mirai Advisory
09.2018 - Current
Senior Software Engineer
Nissan,Accenture Services Private
06.2014 - 05.2016
Software Engineer
BestBuy,Accenture Services
06.2012 - 06.2014
Bachelor of Science - Electrical, Electronics And Communications Engineering
JNTU
06.2008 - 05.2012
Similar Profiles
SHUBHAM SINGHSHUBHAM SINGH
Consumer Relations Specialist at credit one bank , Santander BankConsumer Relations Specialist at credit one bank , Santander Bank
JACQUELINE WOLFGANGJACQUELINE WOLFGANG
Relationship Banker at Santander Bank UsRelationship Banker at Santander Bank Us
Juliana SanchezJuliana Sanchez
Representative Teller at Santander Bank UsRepresentative Teller at Santander Bank Us
Tatiana T. TorresTatiana T. Torres
Senior Enlisted Advisor at U. S. Navy, Recruit Training CommandSenior Enlisted Advisor at U. S. Navy, Recruit Training Command
JOSE MACEDOJOSE MACEDO
Trust and Safety at Accenture/WhatsappTrust and Safety at Accenture/Whatsapp