Assistant Data
Resume:
Consultant
Aditya (ETL, Teradata Developer)
*****************@*****.***
Location: WA
H1B
Passport number: Yes, Linkedin Id: Yes
Professional Summary
Around 8 years of experience in IT industry in the area of Data warehousing specialized in Extract Transform and Load (ETL) and business intelligence (BI), with particular expertise in Teradata, Informatica, ETL and Oracle and in platforms as UNIX and Windows. Specialized in the Analysis, Design, Development, Implementation, Modeling, Testing, and support of Data warehousing (DWH) applications from various heterogeneous data sources.
Experienced with Teradata utilities (TPT, BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TERADATA VIEWPOINT and SQL ASSISTANT).
Extensive experience on Data Warehousing with design, development and implementation of
Data warehouse ETL processes.
Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping and unit testing using Agile development methodologies.
Experienced with data warehousing applications in retail and telecom services.
Experienced in performance tuning and debugging of existing ETL process.
Experienced with mentoring development teams, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects & bug fixing.
Versed with proactively addressing DBMS performance issues such as partition optimization, indexes, and statistics collection.
Extensive use of Control-M, Crontab, Autosys and WLM tool for scheduling routine jobs.
Strong knowledge in RDBMS, database Normalization and De normalization concepts and principles.
Experience with ETL methodology for supporting Data Extraction, Transformation and Load processing in a corporate-wide-ETL solution using Informatica.
Worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Experience with writing ad hoc queries for reports development.
Strong experience with Teradata SQL and writing stored procedures and Macros.
Worked with different data sources non-relational Databases such as Flat files and other relational sources such as Oracle and SQL Server.
Experience in identifying and resolve ETL production root cause issues.
Familiar in Creating Secondary indexes, and join indexes in Teradata.
Experience with data modelling, converting logical models to physical models using ERWIN.
Demonstrate a willingness, interest, and aptitude to learn new technologies and skills
Reputation for strong organizational skills, excellent communication skills, dedicated teamwork, attention to details, ability to work under pressure to balance competing priorities and meet deadlines.
Good team player and can work efficiently in multiple team environments and multiple products. Easily adaptable to the new systems and environments.
TECHNICAL SKILLS:
Databases
TeradataV2R5/V2R6/12/13/14/15,Teradata 15,SQLServer2000/2005/2008/2012,MSAccess,Informatica7.1.4/8,Oracle 11g
Operating Systems
Sun Solaris, Red Hat Linux, Windows2003/2000/XP/NT/7, Unix, Linux
Languages
Teradata SQL, C, C++, UNIX shell scripting, PERL, Visual Basic
DB Utilities
BTEQ, Fast Load, Multi Load, Fast Export, TPT, TPump, PMON, Teradata Administrator, Teradata SQL Assistant, SSIS,SSRS,SSAS,Visual Explain
Scheduling Tool
Control-M,WLM, Crontab, Autosys
Tools
SVN,CSV, Erwin, Toad, SuperPutty, WINSCP, CYGWIN, Tableau Reader 8.0, MSTR 8.1.2
Others
MS Office, Telnet, Adobe Acrobat Reader/Writer, XML, HTML, UML, SFTP, FTP, SCP, Telnet, TCP/IP.
PROFESSIONAL EXPERIENCE
Wells Fargo
Charlotte, NC Jul16- Till Date
Systems Analyst/Sr ETL Developers
Perform System and Requirement analysis, Design and Develop mappings and code as per requirements and per Wells Fargo standards.
Create Design Document, Test plan Document, and develop Teradata database tables, Indexes, Stored Procedures, Views and BTEQ scripts.
Validated end user report requests using tools such as Tableau and Microstrategy
Develop unit test and perform code/document reviews for monthly and quarterly releases.
Provide support for SIT, UAT and production rollouts and monitoring and resolving issues during production cycle.
Created ETL Spec documents for ETL mappings development.
Responsible for creating technical design documents to reflect the ETL process.
Performance tuning of complex SQL queries.
Responsible for development, scheduling and monitoring of ETL jobs.
Specialized in the Analysis, Design, Development, Implementation, Modeling, Testing, and support of Data warehousing (DWH)
Review code delivery and manage the code version in TFS and monitor production Jobs using Autosys scheduling tool during the monthly and quarterly batch cycle.
Performance tuning of complex SQL queries.
Create ad hoc queries for end user.
Environment: Teradata SQL Assistant 15.10, BTEQ, Multiload, Fast Load, Fast Export, Putty .63, Linux, Visual Basic, Windows 7, ETL, Informatica 9.6.1
Sprint Feb 15-Apr 16
Overland Park, Kansas
Sr Systems Analyst/Sr ETL Developer
Responsibilities:
Design and develop ETL process which would extract the data from multiple sources flat files and load the data into the data warehouse.
Convert logical data model to physical data models.
Responsible for creating technical design documents to reflect the ETL process.
Performance tuning of complex SQL queries.
Responsible for development, scheduling and monitoring of ETL jobs.
Provided production support, debug and fix production issues.
Responsible for on-time delivery and quality of engagement deliverables.
Developed audit processes between different layers to maintain data integrity.
Acted as onsite offshore coordinator to delegate and review tasks.
Environment: Teradata SQL Assistant 15.00, BTEQ, Multiload, Fast Load, Fast Export,HDP 2.2, Visio,Hive 0.14,ERWIN, Hadoop 2.6, Putty .63, Linux, Visual Basic, Windows 7, Informatica 9.1.0
WellPoint May 14-Dec 14
Richmond, VA
Systems Analyst/ Sr Teradata Developer
Responsibilities:
Work closely with end client to gather the business requirements and convert the business requirement into technical design
Responsible for on-time delivery and quality of engagement deliverables
Design and develop ETL code which would extract the data from multiple sources like flat files and load the data into the data warehouse.
Coordinate the creation of process/data flow diagrams for data coming into EDWard from different operational sources.
Coordination with large number of stakeholders from different areas in WellPoint including WellPoint operational systems.
Apply technical knowledge using Teradata Tools (SQL Assistant) and using Teradata Utilities (BTEQ, Fast Load) for development and support of data warehouse.
Performed Source to Target mapping from Source System to final Edward systems
Develop and support Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate Teradata tables from flat files.
Developed audit processes between different layers to maintain data integrity.
Environment: Teradata 14.10, BTEQ, Multiload, Fast Load, Fast Export, Teradata SQL Assistant 14.10, Informatica 9.1.0,Putty .60, Unix, Visual Basic, Windows 7
Sears Holdings Corp Sep 12- Apr 14
Hoffman Estates, IL
Application Developer
Responsibilities:
Worked closely with end client on multiple projects to gather the business requirements and convert the business requirement into technical design for the client’s customized applications using Agile Development methodologies.
Created ad hoc reports for the end users.
Convert logical data model to physical data models .
Designed and developed ETL code which extracted the data from multiple sources like flat files, external databases and load the data into the data warehouse.
Validated end user report requests using tools such as Tableau and Microstrategy.
Involved in performance tuning of complex SQL queries.
Developed UNIX shell scripts to trigger the Teradata load scripts for the ETL process.
Writing scripts for data validation for the data coming from different source systems.
Acted as onsite offshore coordinator.
Developed BTEQ scripts for data load and report generation.
Optimized SQL queries for better performance.
Provided on call production support.
Develop and support Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate Teradata tables from flat files.
Environment: Teradata 13.11, BTEQ, Multiload, Fast Load, Fast Export, Teradata SQL Assistant,Icescrum, ERWIN,MSTR 8.1.2, SQL Server 2005, Datastage 7.5.2,Putty .60,Tableau Reader 8.0,Unix,Visual Basic, Windows 7, Informatica 9.1.0
Macys Systems and Technology Nov 11- Aug 12
Johns Creek, GA
Sr Teradata Developer
Responsibilities:
Worked closely with end clients for gathering the functional requirements and assisted in developing technical design for the client’s customized applications.
Developed Ad hoc reports for the end users.
Developed an automated process for loading the data into the base tables using Teradata Load Utilities. This involved writing Multi Load, BTEQ scripts for loading the data from the extracted files into the data warehouse.
Involved in the implementation of BTEQ and Bulk load jobs.
Wrote advanced SQL and analyze large data sets resulting in improvement recommendations.
Validated end user report requests using Micro strategy tool.
Developed UNIX shell scripts to run batch jobs in production.
Wrote scripts for data validation and data cleansing for the data coming from different source systems.
Optimized SQL queries for better performance.
Provided production support for the databases in 24x7 environment.
Environment: Teradata 13, BTEQ, Multiload, Fast Load, Fast Export, Teradata SQL Assistant, MSTR 8.1.2, SQL Server 2008, Visual Basic, Windows 7
Biglots June 11- Oct 11
Columbus, OH
Sr Application Developer (Teradata)
Responsibilities:
Developed processes on Teradata using utilities such as Fast Load, BTEQ and MultiLoad
Assisted in developing technical design for new requirements for the client’s customized applications.
Involved in the implementation of BTEQ and Bulk load jobs.
Accomplished data movement process that loads data from Oracle into Teradata by using Teradata SQL and utilities such as FastLoad, MLoad, FastExport reviewed and improved the design of Extract and Load specifications.
Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.
Performance monitoring and tuning of complex SQL queries.
Wrote advanced SQL and analyze large data sets resulting in improvement recommendations.
Involved in performance monitoring, and optimization using PMON.
Validated end user report requests using Microstrategy tools.
Using Microstrategy excel delivered embedded reports to the end-users.
Provided production support for the databases in 24x7 environments.
Environment: Teradata 12/13, BTEQ, Multiload, Fast Load,,Teradata SQL Assistant, Informatica 8.1, MSTR 8.1.1,Teradata Viewpoint, Teradata Manager, Oracle 9i,SQL Server 2005, Visual Basic, Windows 7
Apple Inc July10 – Apr 11
Cupertino, CA
Teradata Developer
Responsibilities:
Worked closely with Project Managers, Business Analysts, BI Architect, source system owners and Data Quality team to ensure timely and accurate delivery of business requirements.
Enhanced application code for better performance.
Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Fastload and BTEQ.
Developed stored procedures & macros to load data and generate the reports.
Developed processes on Teradata using utilities such as Fast Load and BTEQ.
Created BTEQ scripts to extract data from warehouse for downstream applications.
Performance monitoring and tuning of complex SQL queries.
Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
Environment: Teradata 12, BTEQ, Multiload, Fast Load, Tpump, UNIX, Teradata SQL Assistant, Informatica 8.1,Erwin 4.0,Teradata Manager, Oracle 9i,SQL Server, MSTR 9.0.1, Visual Basic
Contact this candidate