We provide IT Staff Augmentation Services!

Technology Analyst Resume

Charlotte, NC

SUMMARY

  • 9+ years of IT experience in implementing Data Warehouse projects using Teradata and UNIX shell scripting.
  • 9+ years of experience in banking domain.
  • 2 years of working experience with Informatica, Netezza and SQL server.
  • Good experience in Project Planning, Effort estimation, Business analysis to meet needs of Clients and developing efficient solutions.
  • Project experience in both Waterfall and Agile methodologies.
  • Expertise in Teradata utilities - TPT, BTEQ, Fast load, MLOAD, TPUMP scripts.
  • Excellent knowledge on Teradata SQL Performance tuning for optimal performance and good knowledge on Collect statistics, Derived tables, Volatile/Global Temporary tables, join strategies, join types and Explain/Optimizer plans.
  • Excellent knowledge on Teradata Standards, best Practices and ANSI SQL.
  • Expertise in creating complex Adhoc SQL queries to support user help requests within a short time frame using OLAP functions, derived tables and complex joins.
  • Good Data Warehousing ETL experience using Informatica Power Center Client tools - Power Center Designer - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplets, Workflow Manager, Workflow Monitor and Repository Manager.
  • Experience working with business Analyst and Subject Matter Experts (SME's) to identify, prioritize, and implement solutions to improve efficiency, reduce risk, and support new business
  • Excellent analytical skills.
  • Good Experience in implementing Data Quality (DQ) checks and Recon checks.
  • Good Experience working in a Global Delivery Model

TECHNICAL SKILLS

DATABASES: Teradata v12;v13;v14, MS-SQL Server, Netezza, Oracle

Teradata Utilities: TPT(LOAD, UPDATE, STREAM, SQL Selector, ODBC, Fast Export, Data Connector Operators), BTEQ, FASTLOAD, MLOAD, TPUMP,FASTEXPORT

ETL Tools: Informatica Power Center v9.5.1 and v9.6.1 -Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager, SSIS

DB Tools: Teradata SQL Assistant, Toad

Languages: Unix/Linux Shell Scripting, ANSI SQL

Scheduling Tool: Autosys

Other Tools: JIRA, SVN Versioning Tool, Visio, Putty, WINSCP, Quality Center

PROFESSIONAL EXPERIENCE

Confidential | Charlotte, NC

Technology Analyst

Environment: MS SQL Server, SSIS, Oracle, Teradata

Responsibilities:

  • Gathering business requirements across different Line of Business
  • Attending business sessions and preparing the High and low level design
  • Used Teradata for sourcing the data
  • Prepare Business requirement document(BRD), Data request memory and other documentation for each testing
  • Develop SSIS packages and SQL scripts to load, analyze and generate reports
  • Automate the process of data reception, data load, data analysis and report generation from different systems

Confidential | Charlotte, NC

Technology Analyst

Environment: Informatica, Netezza, UNIX, Oracle

Responsibilities:

  • Develop Informatica workflows to load data from different sources, combine, transform, analyze the data as per the Data model
  • Create views on top of final tables to generate the reports
  • Create jobs for the workflows and schedule them using Autosys
  • Develop UNIX shell scripts for passing certain parameters
  • Designing the Conceptual, Logical, Physical Schema of tables needed as per the requirements
  • Preparation of Metadata document for all the tables used in the project.
  • Interacting directly with client (over phone or in person) and explaining business to the offshore teammates.
  • Taking the project through the Change advisory board (CAB) through SIT, UAT and PROD
  • Coordinating with other applications/ systems involved in this project through Quality Centre (QC) for end to end testing
  • Provide support during PROD/ UAT release

Confidential | Charlotte, NC

Technology Analyst

Environment: Teradata, UNIX

Responsibilities:

  • Interacting directly with client (over phone or in person) and explaining business to the offshore teammates.
  • Attending business sessions and preparing the High and low level design.
  • Develop BTEQ/ shell scripts to load the data and process
  • Used Teradata utilities (MLOAD, FLOAD, TPT etc) to load/ export the data
  • Performed tuning and optimization of complex SQL queries
  • Preparing the estimates for the requirements in terms of number of resources needed, amount of money and probable number of months needed to execute the project.
  • Preparation of Metadata document for all the tables used in the project
  • Presenting the design to internal Architectural review board (which reviews the design, codes and schemas of the various projects and give feedbacks) for approval
  • Taking the project through the Change advisory board (CAB) through SIT, UAT and PROD
  • Performing Code reviews and developing the optimized SQLs.
  • Allocating tasks to the offshore team and tracking daily level task status
  • Reviewing the code and re-writing SQLs (if needed) as per the design

Confidential

Software Developer

Environment: Teradata, Unix

Responsibilities:

  • Developed the business calculation core engine for a brand new REWARDS program for a well-known bank
  • Preparation of Low Level Design of project
  • Writing new BTEQ, Mloads etc. and shell scripts as per client requirements
  • Performance tuning of the SQL queries in the BTEQ scripts
  • Schedule the jobs using Autosys
  • Planning and managing day to day activities
  • Ensuring the timely deliverables
  • Interaction with onsite lead to facilitate smooth implementation
  • Unit testing, Integration testing
  • Support during UAT migration, PROD migration
  • Provide support consistently for a month after PROD release to ensure smooth transition to support team
  • Worked extensively with bank’s Deposits, Investments, Cards (both credit and small business) products
  • Responsible for developing the test scripts SQLs for SIT as per the test objectives/plan given by Data Analyst

Hire Now