SUMMARY:

• Overall 6 Years of Experience in IT Design, Development, Testing and Production Support.
• 5 Years of Experience in Data Analysis, Report Generation, Maintenance of Business Report Processes and Data Verifications and Validations.
• Experienced with different Relational databases like Teradata, Oracle and SQL Server.
• Experienced in Interacting with Users, analyzing client business processes, Documenting business requirements, Performing Design Analysis and Developing Design Specifications.
• Experienced in Financial (Credit card and Banking) and Health Insurance Domains.
• Extensive SQL experience in querying, data extraction and data transformations.
• Extensive Experience in working as Dual Controller on various Business Projects which requires Dual Data Validation and Data Consistency.
• Experienced in writing numerous SQL Queries and Performing ADHOC analysis.
• Experienced in developing business reports by writing complex SQL queries using views, macros, volatile and global temporary tables
• Experienced in creating UNIX Korn shell scripting for Batch jobs.
• Experienced in Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
• Experienced on File Transferring from Windows Server to UNIX and Mainframes Servers using UNIX FTP Commands
• Experienced working on large volume of Data using Teradata SQL and BASE SAS programming.
• Worked with Affinium tool - Comfortable with all the process boxes
• Experienced in Extracting Data from Mainframes Flat File and converting them into Teradata tables using SAS PROC IMPORT, PROC SQL etc.
• Strong Experience in working on MS Access, MS Excel and MS Power Point
• Good experience in Production Support, identifying root causes, Trouble shooting and Submitting Change Controls
• Experienced in handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Possess strong analytical and problem solving skills and have quick learning curve. Committed team player and capable of working on tight project delivery schedules and deadlines.
• Experienced in writing Design Documents, System Administration Documents, Test Plans & Test Scenarios/Test Cases and documentation of test results.
• Experienced in Designing and Preparing Training Material and Conducting Training Sessions to the users.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Proficiency in prioritizing and multi-tasking to ensure that tasks are completed on time
• Demonstrate a willingness, interest, and aptitude to learn new technologies and skills.
• Good Communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: Teradata, Sql Server, MS Access, Oracle.

Query Tools: Teradata SQL Assistant.

Utilities: BTEQ, Fast load, Multi-Load, Fast Export, SQL *Loader.

Scripting: UNIX KORN Shell Scripting

Languages: SQL, PL/SQL

GUI: MS Office Suite, Visual Basic 6.0

Servers: Microsoft IIS 4.0/5.0

OS: Windows XP, Windows NT/98/2000Web: GITHUB, Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Data analyst

Responsibilities:

• Implemented different data strategies to get the data from several tables and tune the data to easily understandable in a report by writing several case statements, aggregate functions like max, sum and rank.
• Worked on loading data from flat files to Teradata tables using Import and Fast Load Techniques.
• Develop critical to quality SQL scripts in Teradata specifically structured for Tableau dashboards to support the strategic, analytical, and regulatory needs of the business
• Developed numerous PROC SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins
• Performing Data Analysis for data cleansing and data standardizing purpose. Worked with several business managers to gather financial data and understand the requirements and build reports using Teradata SQL.
• Single point of contact for all changes made to the current SQL data warehouse for scorecard reporting in order to maintain the data model
• Implemented Indexes, collecting Statistics and Constraints while creating Tables and Views.
• Resolving Data issues to improve data quality within the given time frame.
• Modified the existing mapping template.
• Created and updated the Metrix lexicon, with all the source tables and columns at end of each project before transitioning the reports.
• Utilize advanced SQL optimization techniques through the use of INDEX, COLLECT STATS and PARTITION to optimize data.
• Created a flat script with all the required tables in a report by eliminating duplicates and by using several point in time tables by joining on snap dates.
• Used GITHUB, SVN and JENKINS to version control and store all the scripts, documents used for the scorecards development.
• Designed & developed various departmental reports by using SAS and Teradata.
• Involved in several meetings with the business and process management teams to better understand the data and align the report as per the specifications.
• Performed a data quality check on the Metrix lexicon and Teradata scripts to make sure all the business requirements are captured and well documented.
• Remediated the existing reporting scripts from sql server to Teradata by referencing the cross walk document provided by data stewardship.
• Performed various data checks after remediating the scripts to make sure the data is matching between the two reports.
• Followed up with development team to add several missing tables to Teradata from sql server for reporting purposes.
• Uploaded huge files in to user defined tables using fast load to support the business score cards.
• Involved in testing the data with business current views to make sure the logic implemented are working as intended.
• Developed complex SQL queries to bring data together from various systems.
• Developed mapping, testing, correction and enhancement and resolved data integrity issues.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Updated and remediate existing Business objects reports to Teradata applications to reflect changing business data requirements.
• Performing source to target Mapping
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Data analyst

Responsibilities:

• 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 Multiload, Fastload, Fast export and BTEQ.
• Developed numerous PROC SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins
• Performing Data Analysis for data cleansing and data standardizing purpose. Worked with several marketing managers and project manager to gather financial data and requirements and build reports using Teradata SQL.
• Worked on loading data from flat files to Teradata tables using SAS Proc Import and Fast Load Techniques.
• Proficient in creating sas reports using SAS PROC SQL, PROC REPORT and PROC SORT statements.
• Implemented Indexes, collecting Statistics and Constraints while creating Tables and Views.
• Resolving Data issues to improve data quality.
• Modified the existing mapping template.
• Developed complex SQL queries to bring data together from various systems.
• Developed various charts and graphs such as scatter diagram-np charts to monitor process.
• Developed mapping, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel.
• Determined the natural keys for the target tables.
• Performed Data alignment and Data cleansing.
• Involved in Data Migration between Teradata, MS SQL server and Oracle.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirement delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Validated the data during UAT testing.
• Performing source to target Mapping
• Involved in Metadata management, where all the table specifications were listed
• Developed Korn Shell scripts to parallel extract and process data from different sources simultaneously to streamline performance and improve execution time in a parallel process for better time, resource management and efficiency.
• Served as Subject Matter Expert for Mortgage data assisted in requirement gathering, data modeling and data quality
• Providing monthly reports to Loan origination, CRM & default management

Teradata data analyst

Responsibilities: -

• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Responsible for Analyzing 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.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Performed in depth analysis on the data pulled for adhoc request and prepared graphs Using MS Excel and MS PowerPoint.
• Worked with Process Manager to review the existing Business Processes and helped to enhance and make better.
• Created Teradata objects like Tables and Views.
• Extensively worked on to convert ORACLE scripts into Teradata scripts
• Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.
• Created Multiset, temporary, derived and volatile tables in Teradata database.
• Implemented Indexes, Collecting Statistics, and Constraints while creating tables.
• Utilized ODBC for connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Worked on different Segmentations such as Direct Mail, Email segmentation processes
• Unix Shell Scripting was used for automating logs, for user created table backups and for checking daily log.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Helped users by Extracting Mainframe Flat Files (Fixed or CSV) onto UNIX Server and then converting them into Teradata Tables using BASE SAS Programs.
• Used SAS PROC IMPORT, DATA and PROC DOWNLOAD procedures to extract the FIXED Format Flat files and convert into Teradata tables for Business Analysis.

Environment: - Teradata SQL Assistant 12.0, BTEQ, Oracle 9i, Teradata V2R6, Windows NT, UNIX Shell scripts, SQL, PowerPoint, Excel.

Data analyst/Developer

Responsibilities: -

• Gathering of Requirements from various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Provided support to other developers in accurately mapping source attributes into the Teradata FinancialServices Logical Data Model (FSLDM) and in interpreting business requirements
• Worked closely with the Data Modeler and Data Architect in enhancing the FSLDM
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Implemented logical and physical data modeling with techniques using Erwin in Data Mart
• Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirements.
• Worked on testing primary index and skew ratios before populating data into tables using sampling techniques, explain plan in Teradata before querying large tables with several joins.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created a BTEQ script for pre population of the work tables prior to the main load process.
• Used various Teradata Index techniques to improve the query performance
• Writing UNIX shell scripts for processing/ cleansing incoming text files.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts.
• Involved heavily in writing complex SQL queries to pull the required information from Database using TeradataSQL Assistance.
• Extensively worked on root cause analysis for resolving data issues and resolving data discrepancy
• Involved in developing packages to convert data from legacy to Oracle
• Created a shell script that checks the corruption of data file prior to the load. .
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
• Involved in troubleshooting the production issues and providing production support.
• Developed unit test plans and involved in system testing.

Environment: - Teradata V2R5, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, Teradata FSLDM, Quality Center, UNIX, Windows 2000, Shell scripts.