Technology Manager
Bank of America
Total years of experience :20 years, 4 Months
Summary: Worked on multiple projects in different roles, starting from dev lead to overseeing multiple development teams as a
technology manager. Responsible for team/resource management and solution architecture for software delivery.
Highlights:
• Responsible for strategic direction of the technology program as well as day to day activities and sprint deliverables.
• Partnering with business teams to review upcoming requirements and feature grooming to convert it into technology
solutions.
• Engaged with creating business processes, best practices, standards, templates and operating procedures to optimize IT
project development to best align with management and business expectations.
• PI planning and Sprint planning, accounting for resources, technologies in use and strategic direction.
• Feature/Story grooming and facilitating the teams to think of scalable solutions to deliver stable products.
• Overseeing the software delivery planning and alignment with release management.
• Evaluations and assessment of different technology stack being used and review of how they can be best leveraged.
• Engaged with the resource management, interviewing, hiring, performance reviews across both internal team members
and team members from Bank strategic partners.
• Provided a secure environment for developers to thrive as well as allowing them to enhance their skill set and career.
• Engaged with conflict resolution to bring a common understanding for a shared success path.
Summary: Oversaw a project to consume data stream from messaging apps used in hospitals and create sequential, stackable encounters that are layered to provide a comprehensive history of how a patient encounters happen for analytics through the data mart.
Highlights:
• ETL Architect to design solutions for multiple projects using Informatica PowerCenter, DT Studio, Oracle Exadata, OHADI and Netezza based on the Business requirement.
• Developing best practices for system wide implementation, data audit and data consumption including guidelines for uniform code, understanding and scalability with Performance tuning of various objects to achieve optimal performance while moving data between Oracle and Netezza.
• Designed an audit control process for job tracking, audit, restart ability, cleanup and validation for checks and balances.
• Responsible for Mentoring, oversight, work load distribution for the development team.
Summary: Worked as an ETL Architect/Sr. Developer on multiple projects including MAPS, Billing Events and prototyping solutions utilizing Hadoop, Cassandra and Analytic Compute Grid to provide analytical data, merging Monitoring, Availability, Performance and SLAs.
Highlights:
• Developed the architecture for the new dimensional model to provide scalability for new applications including MAPS and Billing Events.
• Development of a new logic for transforming the raw json data into condensed state changed tabular records.
• Requirement gathering, analysis and designing technical specifications for the data migration per Business requirement.
• Assess the viability of using columnar databases and Hadoop using Analytic Compute Grid (ACG).
• Development of Unit and System Test Plans and overseeing the overall testing effort along with defect remediation.
Summary: Worked as ETL Lead / Sr. ETL Developer on multiple acquisition projects (NCC and Royal Bank of Canada, Bank of USA)
Loan conversion to PNC systems along with Consumer Credit Risk applications.
Highlights:
• Designed and developed code for Commercial Source Systems (ACBS and Enterprise) and various Mortgage Systems.
• Weekly business user meetings to discuss business requirements, data governance, performance issues and data accuracy.
• Oversaw development team to create Informatica mapping based on the business and technical requirements
• Oversaw the testing process, including development of unit and system test plans.
• Development of Informatica guidelines for uniform code, understanding and scalability.
• Creation of audit control process around Informatica code for job execution along with balance and count checks
Summary: Sr. ETL Developer/Informatica Admin on multiple projects. Oversaw data flow from SQL Server Databases (NAS/ Legacy Agent TRAX System/ LandAm System) to Oracle Database (TRAX Application) using Informatica, including infrastructure maintenance, applying patches and content upgrades. Was responsible for Code migration for versioned repositories.
Highlights:
• ETL routines and design specs to get data from Flat Files/Online Transaction Processing System (OLTP) and load into Oracle and SQL Server systems for ODS and Fraud Protection Systems.
• ETL designs to generate reports for Revenue Accounting System (RAS) for interfacing month-end close general ledger (GL) accounting data and transactional policy/endorsement detail from TRAX to RAS.
• Administration work including repository backups, restores, managing Informatica services.
• Disaster Recovery (DR) testing and exercises and creation of run books for jobs, monitoring and support routines.
• Version control using IBM rational Clear case and Clear Quest for Defect tracking.
• Worked with external Data Quality tools like Name Parser and Address Cleanser for cleansing the data.
Summary:
Worked on Sales Performance Data Mart on the entire development life cycle, from requirement specifications to deploying
the tested products in production to provide crucial insights into sales dynamics with proactive information delivery and selfservice data analytics.
Highlights:
• Designing Data extraction and transformation routines for daily batch processes.
• Architecting the different mappings, business processes related to data mapping, data migrations, testing.
• Conducting meetings with Users for understanding and negotiating requirements and creation of new Business andPage 4 of 4
Functional requirement documents.
• Responsible for work distribution / resource management for the entire ETL team.
• Coordinating Onshore and Offshore development including review and approval of design and test scripts
• Responsible for mentoring junior developers in the team.
• Worked on developing standards and document templates to expedite the understanding of requirements.
Summary:
ETL/Data warehouse Developer on Actuarial Data mart project to ingest data from a legacy system for claims and premium.
Included gathering data for reporting to meet the goals of actuarial, replace the Access databases and ultimately to provide a
single source to analyze data.
Highlights:
• Designing Data extraction and transformation routines for loading into the warehouse.
• Informatica installation and upgrade from 7.1.3 to 8.1.1 SP3 64bit on AIX platform.
• Administration including performing backups, managing users/groups and folders, managing connections etc.
• Creation of consistency guidelines between various components
• ETL mappings and test plans using various Informatica tools.
• Proficient with Visual Source Safe for version control for Informatica objects, Oracle views and packages and test scripts.
• Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g
Summary:
Worked on various projects to consolidate data coming from multiple source systems into the Data Marts for the purposes of
extraction of financial data.
Highlights:
• Worked on all stages of data warehouse development life cycle
• Designing and fine tuning existing and new data warehouse and data marts
• Code conversion from version 6.x to 7.x
• Designed, Developed and Implemented Reporting system using Cognos impromptu and powerplay
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in Impromptu reports
• Developing reports in ReportNet1.1 using Report Studio & Query Studio
,