Professional Summary

I am a Business-Oriented and results-driven technical professional with sound knowledge of databases, analytic

techniques, and variable data manipulation approaches.

Skills

RDBMS: Teradata, V14.10.03.07, MS Access, Oracle 8i/9i/10g/11g, SQL Server 2000/2005, DB2.

Query Tools: Teradata SQL Assistant, SQL Developer

Utilities: BTEQ, Fast load, Multi-Load, Fast Export.

Scripting: UNIX KORN Shell Scripting

OS: Windows, IBM AIX, UNIX/Linux.

Languages: SQL, Teradata Utilities, IBM Mainframe JCL, COBOL, Utilities

Platforms: Teradata, Mainframe, UNIX, MS-Windows

GUI/Tools: SQL Assistant, Business Objects, SAS SWA, SAS Enterprise Guide, Information Advantage, MS Excel, Word, Outlook, PowerPoint, Access, COGNOS,

Control-M

Accomplishments

10+ 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, DB2 and SQL Server.

Experienced in Interacting with Users, Analyzing client business processes, Documenting business requirements, Performing Design Analysis and Developing Design Specifications.

Extensive SQL experience in querying, data extraction and data transformations.

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 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.

Experienced in Extracting Data from Mainframes Flat File and converting them into Teradata tables.

Strong Experience in working on MS Access, MS Excel, MS Word and MS Power Point.

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 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.

Work History

Enterprise Data Analyst 08/2014 to 05/2016

True Value Company - Chicago, IL

Working on M.D.M Item project verifying all facets of data attributes.

Worked with Oracle, SQL Server, and Mainframe DB2 to perform data analysis.

Wrote complex SQL in the data analysis process.

Used Microsoft Access and Microsoft Excel functions, Vlookup, and custom filters to derive brand names for items.

Working closely with Data and Solutions Architects in the development of a new Teradata Enterprise Data Warehouse.

Worked on Functional Design Specifications.

Performed Data Sourcing, Data Profiling, Data Cleansing and Data Integrity checking.

Developed LINUX scripts, Teradata FASTLOAD, BTEQ, and SQL functions when processing data.

Migrated Customer Information to a Teradata Data Warehouse .

Warranty Business Analyst 01/2009 to 05/2014

Sears Holdings Corporation – Hoffman Estates, IL

Worked with various Business users to gather reporting requirements.

Attended meetings to provide updates on status of projects.

Responsible for Analyzing report requirements and developing reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.

Created Monthly and Quarterly Business reports using Business Objects and complex Teradata SQL.

Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.

Created Teradata objects like Tables and Views, using DDL.

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, Collected 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 the Business.

Created pivot tables in Excel after getting data from Teradata.

Helped users by Moving Mainframe Flat Files onto UNIX Server and then converting them into Teradata Tables.

Business Objects Developer 01/2006 to 01/2009

Sears Holdings Corporation - Hoffman Estates, IL

Information gathering - interacted with the end user to understand the requirement and business logic.

Analyzed the existing OLTP system and designed and managed universes based on Business Requirements.

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

Customized the list of values (LOV's) which helps the end users to select the values.

Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.

Worked on the SQL tuning and optimization of the Business Objects reports.

Worked extensively on Web Intelligence for any new requests and performance issues.

Involved in installing Web Intelligence, creating users, user groups and categories.

Generated reports for web users using Web Intelligence and Info View.

Created Web Intelligence documents and published them to corporate documents.

Created reports using Desktop Intelligence and Web Intelligence.

Extensive testing and migrating the reports or objects from development to Production system.

Technical Analyst 01/1997 to 01/2006

Sears Holdings Corporation - Hoffman Estates, IL

Gathered requirements in JAD sessions.

Created and maintained SDLC functional / technical design specifications to ensure accurate development and synchronicity of the home services data warehouse process.

Used the Teradata utilities Fastload, Multiload to load data.

Wrote BTEQ SQL scripts to transform data.

Wrote Fastexport scripts to export data.

Wrote, tested and implemented Teradata Fastload, Multiload, BTEQ scripts, DML and DDL.

Supported the batch process that updated a Home Services Data Warehouse.

Lead process improvement projects / tasks utilizing Teradata SQL, UNIX, Mainframe, and various utilities to streamline the manual processes into Control-M job scheduler.

Maintained, updated, and provided technical support for business tools and reports to business community, and technical support for databases, systems, to peers and coworkers.

Teradata DBA 08/1992 to 01/1997

Sears Holdings Corporation - Hoffman Estates, IL

Granted rights and maintained security to data.

Managed space, Created users, databases, tables, columns, and indexes.

Monitored SQL processes running on the machine.

Interacted and helped application developers to resolve inefficient SQL scripts/programs.

Tuned database/tables for increased query performance.

Business Analyst 01/1990 to 08/1992

Baxter International Inc - Round Lake, IL

Designed, developed, and maintained Metaphor, COGNOS Query/Power play, reporting system and metrics to measure marketing performance.

Developed and maintained Marketing reports for review by executives, managers.

Created and maintained documentation and established guidelines for backup support and to ensure accurate development and synchronicity of reporting solutions.

Decision Support Analyst 01/1982 to 01/1990

Helene Curtis - Chicago, IL

Developed and maintained market share analysis using Nielsen scanner data, for executives, managers, and marketing stakeholders.

Designed, developed, and maintained Marketing analytic reports and visual dashboards using a tool called Metaphor (Ralph Kimball founder http://en.wikipedia.org/wiki/Ralph_Kimball).

Education

Certificate of Higher Education: Computer Programming, 1981

Control Data Institute - Bensenville, IL

Computer programming. (FORTRAN, RPG, COBOL)

Certificate of completion with honors.

Emphasis in COBOL Programming

High Honor Achievement Award

Associate of Arts: Computer programming and logic, 1980

Oakton Community College – Des Plaines, IL

A.A.S

Emphasis on Computer programming and logic

3.0 GPA

References

Zack Chipman Product Engineering Manager at Sears Holdings Corporation Email: acvw0k@r.postjobfree.com Phone: 847-***-****

Troy Taylor Product Engineering Manager at Sears Holdings Corporation Email: acvw0k@r.postjobfree.com Phone: 847-***-****

Contact this candidate