SUMMARY

• Over 8 years of experience in Data Analysis, Business Reporting, Data Validation, ETL and Documentation.
• Worked with various Hadoop Big Data components like hive.Pig,Hadoop streaming with python.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Expertise in using Teradata SQL Assistant, Teradata Manager, Teradata Administrator, Teradata Index Wizard, Teradata Statistics Wizard and data load/export utilities - BTEQ, Fast Load, Multi Load, Fast Export and exposure to Tpump on UNIX(linux,Aix) environments.
• Ability to program and process complex data in pig latin,Hive QL .
• Worked with wide variety of data varying from domains like insurance,Banking and E-Commerce.
• Worked with business analysts by providing specific and Business Critical information through data mining using Teradata, SQL, BTEQ, and UNIX.
• Experienced in all aspects of SDLC from requirement gathering to testing.
• Experienced in Data warehouse, ETL-Extraction/Transformation/Loading, Data Analysis, Data migration.
• Able to understand and work on Informatica mappings/workflows.
• Experienced in performing Ad-hoc reports by using Teradata, BTEQ and UNIX.
• Experienced in developing and maintaining large number of financial/Insurance reports using Teradata, BTEQ.
• Handled all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Attended project meetings periodically with Project managers, Associates, business analysts, statisticians, and internal customers, end users. Strong written and communication skills.
• Experienced in Data warehouse, ETL-Extraction/Transformation/Loading, Data Analysis, Data migration.
• Experienced mainly in the industries of Insurance and Banking business processes.
• Proficient in managing Teradata (V2R6-0.0/0.1, TD 12.0, TD 13.0, TD 13.10, TD 14), Teradata SQL Assistant, UNIX, DB2 (9.1, 9.5, 9.7), PowerPoint and Windows environment.
• Good Data Warehousing concepts including strong data analysis experience in RDBMS database.
• Experienced inFinancial (Credit card and Banking) and Health Insurance Domains.
• Experienced in working within a marketing/business intelligence environment.
• Contributed personal insights into planning business market strategies using business intelligence, market segmentation, and product analysis.
• Good experience in preparing financial reports and automation of scripts with help of VBA, Excel and SQL Assistant.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top-down and bottom-up approach.
• Extensive experience in performance of (ETL process) data extractions (from Source table/s), data transformations (to stage and target table), data loading (to data warehouse/data mart), data interpretation and performance tuning through Teradata *Load, Tpump and other utilities.

TECHNICAL SKILLS

Langages: SQL, PL/SQL,UNIX Shell Scripting.

Databases: Teradata, Oracle10g, MS Access, DB2

DB Utilities/Tools: BTEQ, fast Load, Multi Load, Fast Export, T Pump, SQL *Loader, Teradata Administrator and Teradata SQL Assistance

ETL Tools: Informatica 9.5.1

BigDATA Technologies: Cloudera Hadoop (CDH 4), Pig,Hive,HDFS

Modeling Tools: Visio and Erwin (Dimensions, Star schema and Snow flake)

Version Control utilities: Github, CA Harvest, Microsoft VSS

Job Schedulers: Opswise 5.1,6.1, Autosys, Tivoli Workload Scheduler

Operating Systems: HP-UX, Red Hat Linux, Windows2003 /2000/ XP/NT, IBM AIX

GUI: MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr Teradata Developer

Responsibilities:

• Building and maintaining Data marts for Email Marketing .
• Coding using Teradata analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Working with different sources of data like HDFS files,weblogs.
• Integrating the data between HDFS and Teradata.
• Processing the data in HDFS using Pig Latin and Hive queries .
• Working on Data Verifications and Validations to evaluate the data generated according to the requirements which is appropriate and consistent.
• Worked with various Business users togather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Created and presented analyses of complex data projects explaining trends.
• Provided technical support, training and guidance to application end users.
• Developed numerousTeradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and advanced techniques like RANK and ROW NUMBER functions.
• Worked on loading data from flat files to Teradata tables using Multiload Import and Fast Load Techniques.
• Working with Business users and providing them the resources for generating reports .
• Maintaining user level environment with specific access to business to differentiate between the Business layer and ETL layer .
• Worked with UNIX shell scripts to validate, format and execute the SQL’s on UNIX environment.
• Automated the process of data load and extract jobs using UNIX shell scripting

Confidential, Addison,TX

Sr TeraData Developer

Responsibilities:

• Design, develop and maintain Database applications.
• Involved in creating various Teradata Tables, Views, Macros and Triggers
• Coding using Teradata analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Working on Data Verifications and Validations to evaluate the data generated according to the requirements which is appropriate and consistent.
• Worked with various Business users togather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Created and presented analyses of complex data projects explaining trends.
• Provided technical support, training and guidance to application end users.
• Developed numerousTeradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and advanced techniques like RANK and ROW NUMBER functions.
• Created and implemented Macros and Stored Procedures with the help of VBA.
• Automated weekly, biweekly reports with help of VBA and SQL Assistant.
• Worked on loading data from flat files to Teradata tables using Multiload Import and Fast Load Techniques.
• Experience in writing korn shell scripts for automating the jobs.
• Automated reports by connecting Teradata from MS Excel using ODBC.
• Developed the Interfaces in SQL, for data calculations and data manipulations.
• Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the database.
• Worked with UNIX shell scripts to validate, format and execute the SQL’s on UNIX environment.
• Automated the process of data load and extract jobs using UNIX shell scripting
• Used Inner, Outer Join, UNION, INTERSECT, RANK, QUANTILE and OLAP functions CSUM, MSUM, MAVG, MDIFF.
• Worked extensively on performance improvement & query tuning tasks.
• Worked on complex/simple queries to map the data as per the requirements.
• Created documentation and updated them so as to reflect the most current process.

Environment: Teradata 13.10, SQL Assist, UNIX Shell Scripts, MS Excel, MS Power Point.

Confidential, Irving,TX

Sr. Teradata Developer/Analyst

Responsibilities:

• Developing Stored procedures for each client to net the correct claims and eliminate the fraudulent ones.
• Understand Business requirements and functional design.
• Checking for reusability of code between different clients and reducing the effort of man hours.
• Interact with the End users for the Functional requirements and Design specifications.
• Write SQL statement for ad-hoc report generation.
• Create technical design documents based on functional design; this includes documents such as source-to-target (STT) mapping spreadsheets.
• Work with the development team to identify and resolve any design questions during the development process.
• Working on complex queries to map the data as per the requirements.
• Closely working with Informatica developers in the project and helping them with the source qualifiers used in data extracts.
• Create test cases and test queries. Validate the data produced by Enterprise Data Warehouse (EDW) development team using these queries.
• Performing Teradata configuration, Performance tuning and query optimization.
• Modify the BTEQ, MLOAD, FLOAD scripts and SQL procedures to meet the changing standards.
• Production support for the high revenue clients on a need basis.
• Assist in the user acceptance testing process by analyzing root causes of defects and their remediation.

Environment: Teradata 12/13 Teradata SQL Assistant, BTEQ, FLOAD, FEXPORT, MLOAD, TPUMP, INFORMATICA 8.6, Business Objects UNIX Shell Scripting, Smart Putty, Windows XP, UNIX.

Confidential, Irving,TX

Teradata Developer

Responsibilities:

• Teradata database development which includes developing database applications for clients.
• Working with explain statement in analyzing SQL access paths and tuning stored procedures.
• Onsite co-ordination and communication regarding clarification, design, development andproject related processes.
• QA tasks that are part of DB from any perspective.
• Run time DB issues.
• Processing of all the custom and as well as generic edits required by each client.
• Performance tuning on a periodical basis to increase the billing cycles productivity.

Environment: Teradata 12/13, SQL Assistant, BTEQ, FLOAD, FEXPORT, MLOAD, TPUMP, INFORMATICA 8.1, Business Objects UNIX Shell Scripting, Smart Putty, Windows XP, UNIX.

Confidential

Software Engineer / DBA

Responsibilities:

• Configuring Oracle networking, creating online backup scripts and implementing the same,
• Altering/creating the stored procedures and make the procedures work in Specific requirements
• Handling the change requests for code changes to implement additional features
• Taking weekly cold backup to make the data setup in the local environment on par with Client Environment
• Creating users and create profiles to the users by assigning roles and privileges
• Creating objects like tables, indexes, constraints, and refreshing the database every month.

Environment: - Oracle10g, Oracle10g application server