We provide IT Staff Augmentation Services!

Lead Analyst Programmer Resume

SUMMARY

  • 16+ years of experience in Teradata BI/ETL Lead,Development, Analysis, Design, Modeling, Implementation, operations and Maintenance of various Client/Server and applications in Banking, Telecom and health projects.
  • Work Extenseviely on Data Warehousing tools mainly Teradata utilities TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Written scripts for loading huge volume of data from legacy systems to target data warehouse using BTEQ, FLoad and Mload, TPT utilities.
  • Written Unix shell script to check & process the data file, also for executing BTEQ scripts to load data into Teradata tables. Very Strong in writing complex, large & Analytical SQL queries to help client in reporting the data access quickly.
  • Strong expertise in database creating independent DataMart and provide to different user for reporting according to their business requirement
  • Writing complex Teradata SQL queries, Advance feature of Teradata 16.20, Dynamic SQL, Analytical functions, performance tuning of SQL queries and different scripts. Reduce turnaround time of different application from 24 - 36 hours to 10-15 minutes. Increased performance by 70-80% in some situations.
  • Coordinate discussions between leads, business analysts and ETL developers and help facilitate design and development to ensure requirements are fully coded, tested and implemented.
  • Leading and Managing Team and monitor day to activity.
  • Getting Customer feedback and pass appropriate message to team, assignment of tasks.
  • Provides leadership on development projects, assignments, and highly complex analysis.
  • Proficient in Teradata EXPLAIN plans, Collect Statistics option, Primary Indexes, Secondary Indexes, Partition Primary Index, Join Indexes, Volatile, global temporary, derived tables etc.
  • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors, Hash Indexes in Teradata.
  • Provided 24 hour on-call support to production operations WFH on remote VPN.
  • Experience in Logical and Physical Data Modelling and Dimensional modelling (Star and Snowflake) skills in Physical database design, Relational Models
  • Good exposure in Data Modelling for OLAP, OLTP, ODS and Data Mart or Data Warehouse for Financial Application.
  • Expert at team building, stakeholder management and leading with a clear direction and purpose
  • Strong expertise in database creating independent DataMart and provide to different user for reporting according to their business requirement
  • Worked on the proof-of-concept for Apache Hadoop 1.20.2 framework initiation
  • Installed and configured Hadoop clusters and eco-system.
  • Developed automated scripts to install Hadoop clusters
  • Involved in all phases of the Big Data Implementation including requirement analysis, design, development, building, testing, and deployment of Hadoop cluster in fully distributed mode Mapping the DB2 V9.7, V10.x Data Types to Hive Data Types and validations.
  • Expertise in Tableau 2019.2/10.5/10.4/10.3.1/10.2/10.1/10.0/9. x/8.x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting.
  • Extensive knowledge and hands on experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
  • Experience in gathering requirements, developing, validating and deploying reports using Tableau.
  • Experience in Tableau 2019.2 extensions using TREX files, pulling data and displaying on dashboard.
  • End to end experience in designing and deploying data visualizations using Tableau.
  • Created interactive dashboards by developing different visualizations including Crosstab's, Pie/Bar Charts, Gant Charts, Scatter Plots, Bullet Graphs, Heat/Geo/Tree Maps, Circle Views, Line/Area Charts and Histograms in Tableau Desktop.

TECHNICAL SKILLS

Databases: Teradata V2R5, V2R6, V2R13, V16.20, DB2, Oracle 10g, 11g, 12C, SQL Server 13.0.

SQL Tools: Teradata SQL Assistance 15.10, TOAD 12.8, SQL Developer, T-SQL.

Languages: SQL, PL/SQL, Java Script, Perl, Python.

Reporting Tools: Tableau 2019.2/10.5/10.4/10.3.1/10.2/10.1/10.0/9. x/8.x/7.x, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SAP Business Objects BI 4.2/ XI 3.1 R1/R2,6.5, SAP Business Objects Dashboards/Xcelsius 2008, SAP BO Web Intelligence

DBA / ETL /Modelling Tools: BTEQ, Fast Load, MultiLoad, Fast Export, Tpump, TPT, Teradata viewpoint, Teradata Visual Explain, Teradata Manager, PMON,Informatica Power Center 10.1.Erwin r9.7, Erwin Studio, CICD, GIT GUI, DevOps, AppOps, JIRA, SAS DI 4.9, Confluence, IWS.

Configuration Tools: BMC Remedy, IBM Rational Team Concert6.02, VSS 6.0, Clear case, Zillow.

Project Methodology/Tools: Waterfall, Agile, Hybrid, Scrum, MS office 2016, MS VISIO 2016, MS Project 2016, JIRA, SVN, GIT, CI-CD Pipeline.

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux

BigData/Hadoop Technologies: HDFS, Spark, SnowFlake

PROFESSIONAL EXPERIENCE

Confidential

Lead Analyst Programmer

Responsibilities:

  • Direct interaction with Enterprise Holdings business users,, Daily spirnt update at 9:15 AM meetings and updates.Meeting with different stake holder Anaylysts and Modeler.
  • Provide technical leadership in scoping, designing and solutions delivery.
  • Leading and Managing Team and monitor day to activity.
  • Getting Customer feedback and pass appropriate message to team, assignment of tasks.
  • Provides leadership on development projects, assignments, and highly complex analysis.
  • Leading team size of 10+ people, co-ordination of on-site offshore team, hand over take over work.
  • Manage the Teradata Servers across the globe, monitor the performance of databases and make tuning changes, researched and evaluated alternative solutions related query performance and recommend the most cost-effective design solutions.
  • Writting BTEQ scripts and do CICD build process via Jenkins.
  • Getting direct requirement from business customers, do the analysis, mapping, design and documentation. Engage with business stakeholders on all facets of BI activity.
  • Expert in performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance.
  • Create and manage dashboard reports for management review, Writing Complex Data warehouse Teradata SQL Queries, Dynamic SQL queries.
  • Proficient in using Teradata utilities such as TD Manager, Visual Explain.
  • Performance tuned and optimized various complex SQL queries.
  • Working on Teradata utilities SQL, BTEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain, Query man, and Unix Shell (Korn) scripting.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 16.20, Analytical functions, performance tuning of SQL queries and different scripts.
  • Experience in performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance.
  • Created Tableau Data Sources using EDW Tables and custom SQL with inner, left and right joins.
  • Created extract or live connection based on the amount of salesforce data pulled into tableau to improve the workbook performance.
  • Used date functions to compare the data between current year and previous year for Benefits enrollments, Surveys and Salesforce data.
  • Used Rank functions, advanced analysis in Tableau, analytical functions in SQL and parameter passing through SQL to build the reports to show top companies and their usage metrics.
  • Worked with tableau extensions by using TREX files and pulling data into the dashboard.

Confidential

Teradata Module Lead

Responsibilities:

  • Direct interaction with Confidential - business users, Managers, directors, analysts.
  • Getting direct requirement from business customers, do the analysis, mapping, design the and documentation. Engage with business stakeholders on all facets of BI activity.
  • Provides leadership on development projects, assignments, and highly complex analysis.
  • Collecting the all claims files from Confidential and processing the files into system and analyses the revenue collection every day. Reason for claim denial & their status.
  • Analysis of data for more than 15 different metrics like Medicare, Medicaid, Tobacco, and breast CX, Remission, Med Reconcile, Patient Encounter and summary, claims etc.
  • Create and manage dashboard reports for management review, Writing Complex SQL Queries, Dynamic SQL queries.
  • Working on Teradata utilities SQL, BTEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain, Query man, and Unix Shell (Korn) scripting.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 16.20, Analytical functions, performance tuning of SQL queries and different scripts.
  • Experience in performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance.
  • Work in conjunction with Analytics team to develop and improve specific operational metrics
  • Analyze data and create information in the form of reports (ad hoc, standardized) to provide proactive and preventative support models across the Program
  • Participate in establishing and improving metrics and Key Performance Indicators (KPIs) across the program
  • Aggregate information from key operational stakeholder to produce enterprise views of data
  • Review the trending of KPIs and KRIs and any other Performance indicator metrics for both Regional Health System - RHM and Country Health System - CHS.
  • Analyze source and target databases, tables and create transformation rules to migrate the data from source to target system.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 15, Analytical functions, performance tuning of SQL queries and different scripts.
  • Coordinate discussions between product leads, business analysts and ETL developers and help design and development to ensure requirements are fully coded, tested and implemented.
  • Successfully completed Data Modeling to upgrade existing system and created new scripts, table column mapping and ETL.
  • Provides advance analysis and profiling of new and existing data sources.
  • Provides analytical insight into the design and development of data marts supporting analytics, and value added processes.

Confidential - Lansing, MI

BI Lead Analytics

Responsibilities:

  • Writing complex Teradata SQL queries, Advance feature of Teradata 15, Dynamic SQL, Analytical functions, performance tuning of SQL queries and different scripts.
  • Analyze source and target databases, tables and create transformation rules to migrate the data from source to target system.
  • Working using Teradata utilities ( BTEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain, Query man, and Unix Shell (Korn) scripting.
  • Working on Teradata utilities required by clinet /isntruction provided by data modeler.
  • Reduce turnaround time of different application from 24-36 hours to 10-15 minutes. Increased performance by 70-80% in some situations.
  • Coordinate discussions between leads, business analysts and ETL developers and help facilitate design and development to ensure requirements are fully coded, tested and implemented.
  • Performance tuned and optimized various complex SQL queries.
  • Domain expertise to provide best and optimized solution to customer
  • Customized and developed Database Stored Procedures, database mapping, Views Involved in database design/preparing to support the larger databases.
  • Creating day to day independent DataMart and provide to different user for reporting according to their business requirement
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database. Participated in JAD (Joint Application Development) Meetings, gathered requirements and supporting Analysts.
  • We process data from 23 different source systems using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT).
  • Designed and modeled many Data Marts as per business requirements.Developed ETL maps and shell scripts to clean and load data into Data mart
  • Successfully completed Data Modeling to upgrade existing system and created new scripts, table column mapping and ETL.
  • Working database, Enterprise Conceptual Data Model, EDW Logical and Physical Data Models.
  • Daily stand up meeting for 15 minutes for status update.
  • Set and follow Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
  • Evaluate business requirements to come up with Informatica mapping design that adheres to Informatica standards.
  • Implement performance tuning on a variety of Informatica maps to improve their throughput.
  • Managed Folder/Category structures for Report level and Universe Level within Business Objects.
  • Migrated reports from Business Objects 6.5 to Business Objects XI 3.1, BI 4.0/4.1/4.2.
  • Migrated from Universe design tool (UDT) to Information design tool (IDT).

Hire Now