Vidyamani Mayannanakoppalu Puttaswamy
mason,OH
Summary
Adept Developer with over 6 years of experience on expertise in Designing, developing and Database solution. Proficient in Snowflake, ETL DataStage, SQL Server, DataStage and UNIX Scripting with a proven record of enhancing business operations through meticulous database management and data analysis and awarded ‘developer’ of the year for exceptional development contributions Used IBM Information Server for all type of ETL activities and Coding requirements. Hands on experience in building data warehouse/Data marts with ETL tools like IBM Information Sever Datastage11.3/9.1/8.5/8.01 Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Deployment. Proficient in Extraction, Transformation and Loading (ETL) processes using IBM Infosphere Information Server. Performed Debugging, Troubleshooting and performance tuning of Datastage Jobs. Expert in Dimensional Data Modeling, Star Schema modeling, Snowflake Schema modeling, fact and dimension table design, physical and logical Data modeling using Erwin. Experience in Database Programming Load Data Warehouses (Star Schemas). Developed Strategies for Extraction Transformation Loading (ETL) mechanism Strong analytic skill of debugging existing DataStage applications. Hands on experience in Migration Projects Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities Extensive experience in designing and working with MICROSOFT SQL SERVER 2012 and writing SQL queries and T/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers. Proficient in writing Unix Shell scripts. Developing ETL job streams, which reflect business logic to populate Netezza warehouse database. Prepared documentation for standard practices using Datastage for enhanced performance. Hands on Experience in Production support and tickets triaging.
Experienced with ETL processes and data transformation techniques essential for optimizing data workflows. Utilizes advanced SQL and data warehousing skills to ensure seamless data integration and improvement in data quality. Track record of effective collaboration with cross-functional teams and adaptability in dynamic project environments.
Overview
7
7
years of professional experience
Work History
ETL Developer and stored procedure development
FHN (First Tennessee Bank)
USA
10.2012 - 06.2017
- At FHN Bank, monthly statements for marketable securities are received from multiple sources, requiring Relationship Managers (RMs) to manually compile values and update individual spreadsheets. This manual process is time-consuming and prone to errors.
- To address this, a new application/tool is being developed to automate the tracking and performance monitoring of loans secured by collateral in the form of securities. The solution will:
- Automatically list accounts managed by RMs
- Extract data from files generated by various source systems and data pools
- Match and reconcile information across datasets
- Perform mathematical calculations using relevant fields from both sources
- Present the consolidated results through an integrated dashboard interface
- This tool will streamline operations, reduce manual effort, and enhance visibility into loan-to-collateral performance metrics.
- Responsibilities:
- Interpreted business and functional specifications to develop detailed technical design documents.
- Collaborated with Business Analysts and Project Owners to understand high-level design (HLD) and develop low-level design (LLD) documentation.
- Analyzed source and target systems to create accurate and complete data mapping documents.
- Created high-level design documents upon finalizing workflows for subject areas, followed by detailed low-level documentation reviewed with architects prior to ETL development.
- Led the design phase by guiding the team through data models and ETL workflows (HLD/LLD), ensuring clarity and consistency.
- Facilitated Agile stand-up meetings, providing project updates on behalf of Data Analysts, ETL Developers, and QA teams to Project Managers.
- Directed ETL development efforts, enforcing best practices and code quality standards to support high-volume data loads; conducted detailed code reviews for each process.
BI Developer, Data Modelling and development of SP’s
M&T Bank
USA
04.2011 - 10.2012
- In the context of securities lending and borrowing, collateral refers to the assets pledged by a borrower as a guarantee to secure a securities loan. These assets may be seized by the lender if the borrower defaults. Collateral Management encompasses all activities involved in overseeing and tracking the collateral provided, ensuring it meets required standards and remains sufficient throughout the duration of the loan.
- SmartLine
- SmartLine is a credit facility similar to an overdraft, where a bank extends a predefined credit limit to current (checking) account holders. This arrangement allows customers to withdraw funds even when their account balance is zero, effectively borrowing up to the approved limit.
- Unlike traditional overdrafts that may be secured by assets or property—giving the lender the right to seize collateral in case of default—SmartLine is an unsecured line of credit, meaning no collateral is required.
- SmartLine is governed by specific eligibility rules and usage conditions:
- Credit Limit: Offers a modest borrowing limit, capped at $500. Customers cannot exceed their assigned credit limit.
- Eligibility: Credit card holders are not eligible for the SmartLine product.
- Repayment Terms: If the borrowed amount is repaid within 10 days, the SmartLine account remains active. Failure to repay within this window results in the account being frozen.
- This product is designed to provide short-term financial flexibility to qualified customers while maintaining responsible lending practices.
BI Developer
M&T Bank
USA
12.2010 - 04.2011
- BBFB (Business Bundle for Business) is a comprehensive service package designed to help companies save both time and money. Business owners who enroll in the bundle gain access to incremental benefits and can unlock even greater value by consolidating their business and personal banking relationships with M&T. As preferred customers, they automatically qualify for exclusive advantages across both segments of their financial engagement.
- The BBFB project encompasses a wide array of technologies, including:
- Database design and implementation to support robust data storage and retrieval
- Application architecture and development tailored to business needs
- Real-time data integration using Enterprise Service Bus (ESB) for seamless communication between systems
- Batch-based data processing through ETL (Extract, Transform, Load) for non-real-time data movement
- Streamlined ETL processes, improving data integration efficiency across multiple systems.
SQL, T-SQL Developer & BI Developer
Crowe Horwath
US
03.2010 - 11.2010
- Sonic Automotive dealerships offer a full suite of services, including the sale of new and pre-owned cars and light trucks, replacement parts, vehicle maintenance, warranty support, paint and collision repairs, as well as extended warranty, financing, and insurance solutions for their customers.
- The primary goal of the SIMS Project is to develop a comprehensive web application that supports these dealership operations. The project involves a wide range of technologies, encompassing database design and implementation, along with robust application architecture to ensure seamless functionality and scalability.
- Responsibilities:
- Collaborated with end users to gather and understand business requirements, focusing on the rationale behind data model changes.
- Designed and implemented both logical and physical data models, incorporating necessary updates and maintaining a detailed data dictionary.
- Developed SSIS packages, stored procedures, configuration files, and functions, adhering to best practices for optimal performance and maintainability.
- Utilized SSIS Control Flow tasks such as Execute SQL, File System, Send Mail, Data Flow, Execute Process, and Execute Package to orchestrate ETL workflows.
- Built SSIS packages to extract data from heterogeneous sources, ensuring seamless integration across platforms.
- Incorporated standard procedures for notifications, auditing, logging, and package configuration to enhance traceability and reliability.
- Conducted data profiling from source (PS) to target (ES), including operations like date concatenation, whitespace removal, and null value handling.
- Applied configuration control mechanisms, including check-in/check-out processes, to manage versioning and collaboration.
- Participated in peer reviews and client-facing code walkthroughs to ensure quality and alignment with business goals.
- Executed unit testing, including the development, review, and execution of test cases to validate functionality.
Education
Bachelor’s degree - Information science and Technology
Visvesvaraya Technological University
DIPLOMA - Information science and Technology
B.E.T polytechnic
Skills
- ETL Development, DataStage, UNIX Scripting, SQL Server, Python, Snowflake, SSIS, SSMS
- I am learning some of the stuff like below by my own
- Connecting DataStage to Google Cloud Storage (GCS)
- Loading/extracting data from BigQuery
- Handling streaming-like ingestion similar to Pub/Sub
- Re-creating Dataflow-style transformations
- Operationalizing pipelines
- BigQuery (Stronger Weightage)
- Designed and optimized BigQuery SQL pipelines using partitioning and clustering, improving query performance by 40%
- Built ELT workflows loading data from GCS into BigQuery using DataStage connectors
- Implemented cost-efficient BigQuery models, reducing warehouse spend by 25%
- Developed analytical datasets and materialized views for reporting and ML use cases
- GCS (Supportive Weightage)
- Managed GCS buckets for raw, curated, and processed zones with lifecycle policies
- Ingested large-scale datasets (1–5 TB) into GCS using DataStage and automated scripts
- Processed Parquet/Avro/JSON files stored in GCS as part of ETL pipelines
- Integrated GCS with BigQuery for automated data loading and schema evolution
- Data transformation
- Data modeling
- SQL development
- Data mapping
- Error handling
- Change data capture
- Team collaboration
- Data analysis
- Testing and debugging
Timeline
ETL Developer and stored procedure development
FHN (First Tennessee Bank)
10.2012 - 06.2017
BI Developer, Data Modelling and development of SP’s
M&T Bank
04.2011 - 10.2012
BI Developer
M&T Bank
12.2010 - 04.2011
SQL, T-SQL Developer & BI Developer
Crowe Horwath
03.2010 - 11.2010
DIPLOMA - Information science and Technology
B.E.T polytechnic
Bachelor’s degree - Information science and Technology
Visvesvaraya Technological University