Data Developer

Kamran Baig

**** ***** **, **** ** 773-***-****

Glen Ellyn, IL 60137 *********@*****.***

PROFESSIONAL 12+ years of professional experience, with strong skills in systems analysis, database design, ETL /

SUMMARY ELT development and support in processing business events.

Approach all projects with a positive attitude, quick adaptation to new technologies, and consistently deliver on commitments with high quality.

Meticulous in troubleshooting issues and developing alternative solutions based on available guidelines.

Self-motivated team player with the ability to multi-task, integrating the work of other individuals to accomplish defined and prioritized tasks.

TECHNICAL Languages: SQL, PL/SQL, Shell (bash, ksh, sh, zsh), Perl, Visual Basic, C++, HTML, XML,

SKILLS Hive, Python

Databases: Teradata 14.x/15.x, Oracle 9i/10g/11g, DB2, Access, Couchbase

ETL / BI Tools: DataStage 8.x/11.x, Automic UC4, TWS, Tableau 9.x/10.x

Operating Systems: Windows, UNIX (AIX, HP-UX, Solaris), LINUX (RHEL, CentOS), Mainframe

Applications: Endeca, MS Office, Lotus Notes, Visio, Visual Studio, ER Studio, SharePoint, NotePad++, UltraEdit, FileZilla, Sublime, WinSCP, PuTTY, JIRA, VersionOne, Confluence, Remedy, RT, ServiceNow, GIT, SVN, PVCS, CVS

Oracle: Exadata, RAC, OEM, AWR, OWCS, Expdp / Impdp, SQL*Loader, SQL*Plus, SQL Developer, TOAD

Teradata: ViewPoint, Unity Data Mover, BTEQ, TPT, FastLoad, MultiLoad, SQL Assistant, Administrator

Operational Tools: Dynatrace, IBM InfoSphere Operations Console, Ignite Database Performance Analyzer, Jenkins, STEP

PROFESSIONAL Teradata Education Network, Virtual Class 2015-16

TRAINING Teradata Physical Database Design

Explaining the EXPLAIN Webcast

PR3 Systems, Aurora, IL 2013

DataStage Essentials

Acxiom Learning Management, Downers Grove, IL 2010

Oracle 10g Advanced SQL Programming

Oracle University, Chicago, IL 2004

Oracle9i Database Performance Tuning

Oracle9i Database Administration (DBA) Fundamentals I and II

Introduction to Oracle9i: SQL

PROFESSIONAL Cars.com, Chicago, IL 02/2016 – Present

EXPERIENCE Senior Data Developer 1 year 7 months

Trained data developers to configure Endeca dimensions and properties in Developer Studio for adding consumer requested filters on search results page that improve usability of the guided navigation.

Consistently helped testers and developers to resolve all environment, database and application issues faced within OLTP, MDM, EDW and Hadoop/Big Data processes.

Revamped the underlying data behind long running Business Objects queries to improve reporting of lead generation and inferred vehicle sales to avoid 1.2 million dollars’ worth of dealer cancellations.

Coached Tableau developers to tune Tableau monthly KPI report by utilizing Teradata volatile tables to reduce the runtimes from 13 to 3 hours.

Pioneered CI/CD pipeline for Oracle database changes to automate deployment of SQL scripts pushed to GIT by using in-house tools and Jenkins for building Docker images from base container and environment configuration template.

Spearheaded continuous improvement effort of analyzing production workflow bottlenecks to compress the nightly ETL jobs in a much shorter timeframe.

Assessed and revised problem resolution and escalation procedures by collaborating with internal and external teams to achieve operational excellence.

Resolved several critical issues faced in DataStage Upgrade from 8.7 to 11.5.

Classified Ventures / Cars.com, Chicago, IL 11/2013 – 01/2016

Data Developer 2 years 3 months

Administered the effort of enabling near real-time disaster recovery of data warehouse through Teradata data mover utility triggered automatically as part of ETL jobs to replicate Production data to a DR instance.

Attained Tech Star Award twice for Teradata upgrades migrating production database to 2750 appliance and database software upgrade to 14.10 and 15.10.

Demonstrated my proof of concept to data community of practice for deploying Teradata releases without the need for DBA and shared my recent learnings in DataStage design that was followed with “Most Awesome Person” Award.

Received November 2014 “Development Employee of the Month” Award for performance tuning the queries within delta listing service and dealer metrics service each of which generated significant revenue that year.

Standardized the database deployment and rollback by documenting templates for Oracle DDL, DML, DCL statements well as shell scripting for data ingestion.

Improved Endeca extract performance by up to 200% to meet the SLA that was jeopardized several times due to expensive queries which were revised to use Oracle analytic functions or tuned by creating foreign key indexes.

Acclimated to the practices of Scrum framework by rapidly adapting to Agile methodology for product delivery of highly aggressive Inventory portfolio teams.

The Allant Group, Naperville, IL 07/2013 – 10/2013

Technical Architect 3 months

Mentored junior team members to groom them to attain a proactive approach on production by performing code reviews and filling documentation gaps.

The Allant Group, Naperville, IL 02/2012 – 06/2013

Senior Programmer Analyst 1 year 5 months

Responded quickly and effectively to changing project priorities, while maintaining standards for quality in executing complex data fixes as well as applying attention to detail in deployment of code changes.

Solved production issues on a routine basis by incorporating IT best practices applied within custom Prevalence ETL tool and tuning long-running scripts.

Indecon Solutions, Oak Brook, IL 07/2011 – 01/2012

Database Developer / Contractor – The Allant Group 7 months

Managed vague project requirements by developing a value proposition for the client to execute a successful marketing campaign harnessing analytics data.

Acxiom Corporation, Downers Grove, IL 12/2006 – 06/2011

Solutions Developer 4 years 7 months

Assumed responsibility of a track leader within a large-scale project to architect Real Time database synchronization from Data Warehouse and Data Mart to fulfill business process reengineering needs.

Earned Client Gold Award for exceeding client expectations in successful encryption of all 321 million digital images before an extremely strict deadline surpassing all challenges encountered in maximizing process throughput.

Contributed extensively to tremendous revenue growth of the account team, resulting in my individual recognition bonus for being instrumental to Acxiom’s achievement in winning address correction service from its competitors.

Overhauled the outbound process to create a more robust solution in order to avoid SLA penalties from the client due to frequently occurring system failures.

Exhibited increasing expertise in construction of Animate/Fuse GUI job scheduling tool and web portal by providing training to production support team.

Created best solutions by automating inbound data back out process request and documenting standard operating procedures that reduced client costs.

Hewitt Associates, Lincolnshire, IL 01/2005 – 11/2006

Systems Configuration Analyst 1 year 11 months

Awarded cash prize and certificate of excellence for playing a vital role in success of retiree split family implementation project during Annual Enrollment, scoring 98% in transaction accuracy audit and 95% in customer satisfaction.

Nominated for Superstar Award for facilitating actuarial valuation project in accordance with SDLC by actively participating in all phases of query-based extraction and reporting of retiree population data.

Developed complex integration test plans for implementation of message extraction and triggering of AccessDirect IVR system, preventing several overlooked test case scenarios from failing during client acceptance testing.

Executed my responsibilities efficiently by going above and beyond team members’ expectations in completing my tasks within deadline while keeping my mainframe system costs to a minimum.

EDUCATION DePaul University, Chicago, IL 2003

M.S., Information Systems (with Distinction), GPA: 3.95/4.00

Group Projects

- Conceptual, logical and physical database design of textbooks ordering system

- Design and development of B2B Extranet with message-oriented middleware

- Analysis, design, and implementation of B2C e-Learning Web site

- Analysis, design, and testing plans of Web-based travel expense system

- Object-oriented analysis and design of palm-powered cellular phone system

- Application of data mining algorithms on medical data to detect heart disease

University of Manchester Institute of Science & Technology, Manchester, UK 1999

B.S., Management (with Honors)

PROFESSIONAL Upsilon Pi Epsilon (UPE) Delta Chapter of Illinois Member since 2003

ASSOCIATIONS Association for Computing Machinery (ACM) Student Member since 2003

Contact this candidate