SUMMARY

• Experienced, action oriented IT Professional with expertise in Data Warehouse Engineering/Analyst and Developing Applications that produce solutions rooted in business needs. Well honed analytical skills that consistently produce results to meet and exceed both internal and external client expectations. Well armed with extensive business savvy that translates to a high level of comfort working with any level of an organization.
• Over 15 years experience in Information Technology. Extensive knowledge of systems analysis, numerous programming and scripting languages, multi dimensional relational databases, and operating systems
• Expertise in RDBMS covering data gathering and analysis, query optimization, data mapping, data validation, OLAP, ETL tools (IBM InfoSphere DataStage, IBM InfoSphere FastTrack, Teradata Utilities - TPT, FastLoad, MultiLoad, Beq, FastExport, Tpump) and SQL performance tuning
• Over 5 years using ETL integration tool (IBM Inforsphere DataStage V8.5) to load data into ODS or EDW
• Solid experience in integration of various data sources with Multiple Databases like Teradata,
• Oracle 11g, MS SQL Server and COBOL/DB2/VSAM, JCL, PROCS, ENDEVOR package, CA7 scheduler tool, IBM Cognos
• Work closely and effectively with all levels of management, end users and cross functional team to satisfy project/productivity requirements
• Write complex Teradata/Oracle/MS SQL Server sqls for data analysis and cross data checking
• Created SSRS report writing in-line SQLs, Store Procedures or common table expressions (CTE)
• Analytical and persistent problem solver, focused on meeting customer’s requirements and expectations
• Experience in analyzing business and designing, coding and testing SQL databases to manage information
• Quickly understands the business issues and data challenges of client's organization and industry
• Excellent interpersonal skills for credibility in working with senior executives, as well as managing client relationships and external partnerships
• Optimized existing code by identifying and rewriting inefficient subroutines or codes, reducing processing time
• Proven abilities in organizing management workflow and utilizing a proactive approach to problem solving

TECHNICAL SUMMARY

Databases: Relational databases (Teradata, Oracle, MS SQL Server, DB2)

Operating System: Unix, Linux, MVS z/OS, Windows, AS400, OS/2

Languages: Teradata SQL, SQLs, Unix Korn Shellscript, Perl, Cobol, Easytrieve Plus, JCL, Spufi & File-Aid

ETL Tools: IBM Inforsphere DataStage V8.5, Teradata Utilities (FastLoad, MultiLoad, Bteq, Teradata Parallel Transporter, FastExport, SQL Assistant), Toad, T-SQL, Microsoft SQL Server Management Studio

Reporting Tools: IBM Cognos v8, v10.2, SSRS - SQL Server Reporting Services (2005, 2008), Tableau 8.1

PROFESSIONAL EXPERIENCE

Senior Operation Data Analyst

Confidential, San Bruno, CA

Responsibilities:

• Interact with clients, SME's, Business Owners, Technology team to analyze existing Netezza processes and systems for data requirement gathering and to convert processes from Netezza to Teradatawhich required data analysis, data design, data validation, data matching, data profiling between current and new Teradata system.
• Conduct data mapping review sessions with the ETL development team on various subject areas
• Converted Netezza Sql which is in normalized form To Teradata Sql which is in third normal form, do analysis on data by writing sqls to validate between two systems to ensure data correctness/completeness and called out if there are any discrepancies and work with ETL development to fix the data if needed
• Converted Tableau reports to repoint source from Netezza to Teradata sqls and build/validated Tableau Worksheets/Dashboards.
• Handle multiple requirements/projects to meet the aggressive timeline
• Created source to target column data mapping/transformation documents in Teradata from Netezza

Datastage Developer

Confidential, Redwood Shores, CA

Responsibilities:

• Technical Team Lead for all aspects of the Data Warehouse Projects and/or application enhancement. responsible for the Design, Construction, Testing, and Implementation of projects using Software development life cycle
• Manage Datastage Administration and setup users, securities, monitor the performance of the system
• Manage Cognos Administration, build complex Aggregate tables or write Reporting Views for Cognos Reporting and managed Cognos upgrade to v10.2
• Troubleshooting for data abnormities and run Sql and check impacted code for data discrepancies
• Created source to target data mapping/transformation document
• Created Interface functional design and Interface technical design user requirements
• Created detail/execute test scripts/plans and documented test results
• Responsible for the facilitation of project meetings between project and operational teams
• Used IBM WebSphere DataStage v8.5 as primary ETL tool to extract/transform/load data
• Publishing data in XML format using IBM WebSphere DataStage v8.5
• Subscribing data from XML to Oracle using IBM WebSphere DataStage v8.5
• Creating Datastage Sequencer Jobs and shell scripts for each process
• Using born shell scripting for formatting/cleansing data
• Writing Sql queries to analyze and identify data discrepancies between source and target system in Oracle 11g
• Implement code and utilize version control software Perforce
• Design, document and deploy systems pertaining to Enterprise Data Warehouse standards and best practices
• Manage Longview Forecasting Administration for FP&A/Finance team
• Provide 24x7 support on IBM Datastage, IBM Cognos, Longview processes and Jobs

Teradata Application Developer

Confidential, Concord, CA

Responsibilities:

• Design, develop, implement and support various Banking data applications under Wholesale domain.
• Develop ETL processes to populate Enterprise Data Warehouse by using Teradata utilities(Fastload, Fastexport, Multiload, and Bteq) on Unix & Linus
• Writing complex SQL queries using Teradata SQL Assistant for answering Adhoc questions from business and system analyst
• Performance Tuning and Trouble shooting and queries to improve data load times

Sr. ETL Consultant/Data Analyst

Confidential - Seal Beach, CA

Responsibilities:

• Worked as a Integration Data ETL Lead in the CoE group use DataStage (v8.5) ETL tool and Teradata Utilities FastLoad/Multiload/Bteq to convert/transform/load from Oracle into Teradata platform
• Created DataStage ETL coding/naming standard and designed DataStage Parallel jobs as is or forklifted them
• Created DataStage Sequencers, Audited Control tables to capture row counts and Shell scripts for each process
• Writen complex Teradata/Oracle Sqls for data analysis and data validation checking when needed
• Reviewed Cognos Decision Stream ETL codes and prepared source to target data mapping document for DataStage development
• Tuned the DataStage jobs and queries to improve data load times when needed
• Participated, run, and validated the ETL interfaces in System testing, executed positive/negative/minus testing cases and documented the results
• Acted as a Teradata expert to provided support for any related Teradata Utilities/Sqls to Boeing Team members
• Work as a technical lead analyst for the AppleCare Systems (ACSE & SMART) in the area of performance Teradata Sqls tuning, data analysis/data validation before migrate to UAT & Production environments.
• Work on the known performance issues to tune/optimize queries or rewrite queries to improve performance either in the area of ETL processes, dashboards, or reporting tool (Business Object)
• Review current projects to ensure ETL processes and Reports are delivered in terms of the functional area and also make sure there are no performance problems.

Senior Data Analyst

Confidential - San Francisco, CA

Responsibilities:

• Work With Data Modeler for BI 2010 Project to understand the business, logical, physical models to create source to target data mappings
• Use IDQ in Informatica software for data analysis and data profiling, also use Oracle sqls to do data check, data validation, data format
• Conduct data mapping review sessions with the ETL development team to ensure smooth transaction to begin code designs
• Handle multiple requirements/projects to meet the aggressive timeline
• Designed Datastage v8.1 jobs using Filter stage, Sort stage, Change Capture stage, Aggregator stage, Surrogate Key Generator stage, Transformer stage, Lookup stage, Modify stage, Merge stage and etc …
• Worked with Deliverable Manager and Business Owner to understand business process and user requirement to prepare the functional specifications and then curve them into Technical specifications
• Act as a Technical Team Lead for Partner Analytics project for nightly call to offshore team members to review deliverables, project statues and provided technical guidance when needed
• Analyzing both source and target systems to identify dataflow and improving the existing process and creation of new process as and when required
• Writing Oracle sql queries to analyze and identify data discrepancies/analysis between source and target system
• Creating sequencers and shell scripts for each process
• Modified Datastage jobs to fix Production data issue or missing data in the NetApp EDWNI Product Dimensions, Organization Party, Partner Analytics subject areas.
• Worked for improve the performance for Datastage jobs by tuning them, changing the job designs, changing the SQL queries
• Worked and extracted data from various database sources such as Oracle 10g/9i/8i/ and Flat files
• Prepared Unit Test plan, cases, scripts documents and captured the results
• Supporting QA testing team to run and validate the ETL interfaces
• Prepared Implementation Plan and reviewed them with the Platform team and BI Operations team
• Knowledge of the Quality Management, Change Management, Release Management, Testing Processes

Senior Data Analyst

Confidential, San Jose, CA

Responsibilities:

• Interact with clients, SME's, Business Owners and Sr. Process Analysts, Technology team to analyze existing business processes and systems for data requirement gathering
• Generate reports (Customer data, Credit data) in csv files, delimiter flat files formats using in combinations of Teradata Utilities (FastLoad, MultiLoad, Bteq, FastExport), SQL Assistant, Oracle SQL, and Unix Shell script
• Creating a Mapping, Session, Workflow using Informatica Powercenter 8.6 for loading to UK credit Staging table
• Work with Marketing email team to design campaign specifications, convert requirements into source/target rules using plain English language, prepare for building by writing Teradata queries and execution of campaign, run final campaign using IBM Enterprise Marketing Management Tool Unica general outbound email file and troubleshooting any issues with corresponding parties (internal or external)
• Handle multiple requirements/projects to meet the aggressive timeline
• Gathered high level business requirements related to Product Credit in PayPal services from Business Owners and Technology Managers to understand business needs and prepared High level Business Requirements
• Providing ongoing tracking and reporting on marketplace developments to support Marketing team
• Participated in Business and Technical Review sessions to gather Detailed Business Requirements as well as System & Process requirements
• Actively participated in Project Review sessions with Business Owners and Technology Team
• Developed data driven tests to easily maintain the scripts and to test with various data including positive and negative test data
• Role involved requirements gathering & analysis, data analysis, data design, data validation, development, and quality analysis
• Worked with PM's and SME's to gather requirements and prepare system requirements, functional specs, and detail design documentation

Lead Data Warehouse Engineer/IT Specialist

Confidential, San Bruno, CA

Responsibilities

• Technical Team Lead for all aspects of the Data Warehouse Projects and/or application enhancement. Responsible for the Design, Construction, Testing, and Implementation of projects using Software development life cycle
• Responsible for managing projects from medium to high complexity with increasing responsibility to project management
• Develop ETL processes to populate Enterprise Data Warehouse by using Teradata utilities (Fastload, Fastexport, Multiload, and Bteq) on Windows 2003/2000/NT/95/98 and Unix and Mainframe, MS SQL Server environment
• Run ETL process in Mainframe environment, use Cobol to build DB2 tables and run DB2 unload utility to create sequential files and use Teradata Fastload utility to load to Teradata RDBMS.
• Migrate Cobol code use Endevor package and schedule jobs in CA7 scheduling tool
• Created source to target data mapping document
• Created Interface functional design and Interface technical design
• Experiencein creating reports with Sql Server Reporting Services (2005 - 2008 Microsoft Visual Studio)
• Responsible for the facilitation of project meetings between project teams
• Used IBM WebSphere DataStage v7.5 as primary ETL tool to extract/transform/load data
• Publishing data in XML format using DataStage
• Subscribing data from XML to Teradata using DataStage
• Creating sequencers and shell scripts for each process
• Writing Oracle sql queries to analyze and identify data discrepancies between source and target system
• Supporting testing team to run and validate the ETL interfaces in System, Integration and Performance environment
• Tune the data movement jobs and queries to improve data load times
• Use IBM Unica Campaign Management tool to help Marketing team to generate campaign outbound email to customers
• Write complex Teradata, Oracle, MS SQL queries for data analysis, data validation in all phases of testing
• Independently lead and managed numerous projects simultaneously within Enterprise Data Warehouse
• Using shell scripting and Perl for formatting data
• Design, document and deploy systems pertaining to Enterprise Data Warehouse
• Use Unica Campaign tool to help Marketing team to generate campaign mail to customers