PROFESSIONAL SUMMARY:

• About 9 years of total experience in analysis, design, development testing / validation, application support of ETL, Client/Server, data warehouse, and analytic reporting and big data based projects.
• Extensive experience in Big Data, Hadoop, Hive, Pig, Sqoop, Flume, Ruby, Python, Java, Scala, Netezza, SQL, PL/SQL, Oracle, Unix Shell Scripting, Perl, XML, Java Script, ESP Cybermation, Business Objects, JSON, C/C++,Pro*C.
• Excellent leadership and organization skills including but not limited to task planning, coordination, delegation, scheduling, tracking and progress reporting to concerned stakeholders.
• Understanding of various software development models such as Waterfall, Agile, RAD, and Prototype models and experience in their application from project conception to project deployment, support and maintenance.
• Knowledge of functions and responsibilities of project lead, big data architect, environment manager, application support staff member, onsite /offshore coordinator, analyst programmer, and technical business analyst roles.
• Excellent interpersonal, communication, troubleshooting and analytical skills and demonstrates pro - activeness and quick learning.
• Subject matter expert in telecom, media, advertising and marketing domain functional areas such as Order Management, Provisioning, Pricing, Modeling, Billing, Payments/Adjustments, Fraud and Risk Management, Collections, Reporting, Divestiture and System Data conversion.
• Experience in linear and digital media domain analytics such as subscription management, and reporting, click through (web) analytics, social media analytics and data integration of disparate data sources and their reporting.
• Experience in marketing domain analytics such as pricing, demand & supply models, mixed effect models, Time Series, Auto-regression and Logistic regression models.

TECHNICAL SKILLS

Roles: Project Lead, Team Coordinator, Analyst Developer, Application -Support Member, Environment Manager, Technical Business Analyst

Operating Systems: Solaris 5.9, Windows XP, NT, 2000, 98, MS DOS, HP-UX, Ubuntu 12.04, RHEL 5.6

Languages: Hadoop, Hive, Pig, Sqoop, Flume, Ruby, Python, Java, Perl, SQL, PLSQL, FCP, XML, JSON, C/C++, Pro*C, Netezza, Oracle, JavaScript, ESP Cybermation, Business Objects:

Databases: Oracle (7.x, 8.x, 9.x, 10g, 11g), MS Access, Netezza, SQL Server

SQL Utilities: SQL*Loader, Export, Import, External Tables, NZLOAD

Version Control: Dimensions, PVCS, CVS, SVN

IDE: PLSQL Developer, TOAD, SQL Developer, VISIO, IntelliJIdea, Rubymine, Eclipse, FC

PPROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Big Data Analytics Platform Big Data Architect

Responsibilities:

• Liaison with product leadership to understand the big data characteristics, processing needs and volume requirements to create detailed data models using ER/Studio Data Architect
• Liaison with existing data warehouse teams, BI architects/leads and third party data providers to procure sample datasets for data integration, metrics development and transformation rules.
• Provide data integration of retailer POS data, demographics data, CPG data for design and implementation of predictive mathematical models for aiding simulations and decision making processes.
• Plan backwards from required metrics to design and develop data model, source data mappings and transformation by adhering to big data best practices and choice of big data technology.
• Prototype and implement POCs for these identified datasets using Hadoop, HDFS, Java Map reduce, Hive, Pig, Scala, Oozie, ruby and python to develop first set of identified metrics from scratch
• Develop best big data practice guidelines and their adherence at each milestone of artifacts (unit test, system test, User acceptance test and Production deployment)
• Plan, Track, Maintain and report deliverable statuses during the course of parallel projects.

Confidential, Atlanta GA

Big Data/ Data Warehouse projectSenior ETL developer / Big Data Architect

Responsibilities:

• Design, development and deployment of gaming site’s social achievement badge tracking and analytical reporting solution for enhancing user experience.
• Design, development and deployment of subscription tracking and its reporting for subscription and product management and its analytics.
• Design, development and deployment of ETL/ELT/ETLT processing framework to automate ETL processing activities from feed reception, cleansing, staging, aggregation and summarization.
• Designed and developed multiple summaries for reporting click through data metrics to assist better decision making. The developed metric functional areas included SEO/SEM reporting, ad revenue monetization, web analytics, and social alert tracking for multiple media brands.
• SEO/SEM reporting included developing metrics by identifying keywords as branded or organic and reporting to enhance search engine results. In addition, developing automated integration between Google webmaster and our analytics platform.
• Web analytics reporting included developing page impressions, unique visitors, page clicks by page, keywords, referrals, section, business unit etc.
• Monetization summary development included calculation of ad revenue by matching ad impressions with ad flights and click rate to assist tracking and monitoring of traffic and their behavior on digital media.
• Social brand alerting and reporting development included capturing and classifying social media messages to track and monitor brands in real time.
• Architected and lead the initial hdfs/Hadoop deployment for project from scratch and made it fully operational to move the processing from netezza platform on HDFS within one quarter.

Environment: Hadoop, HDFS, Netezza, Ruby, Python, Perl, Scala, Java, Netezza, Business Objects, SAP Data Services, C/C++, Oracle, SQL Server, SQL, NZSQL, PLSQL, UNIX, Shell Scripting, Linux, Ubuntu, XML, JSON.

Confidential, Alpharetta, GA

Senior Technical Associate / Team Lead

Responsibilities:

• Lead for entire SDLC including but not limited to requirement capture with business, functional (FD) and technical design (TD) document specifications, code construction, unit test, system test support, deployment and warranty support.
• Demonstrate knowledge of task planning, coordination, delegation, scheduling, tracking and its progress reporting to development project owners.
• Create Database Objects, SQL / PLSQL, NZSQL.
• Design and develop Procedures, Functions, Triggers and Packages to convert Business logic to code.
• Design and develop Front End GUI applications using FCP a CASE tool.
• Design and develop back end services specification using Client server architecture with one to one GUI design mapping.
• Design and develop asynchronous batch jobs in Pro*C, UNIX, Perl, Java for pricing, provisioning, fraud detection / prevention, billing and reporting.
• Design and develop J2EE web services for web based order management system.
• Provide solutions and take responsibility of requirement capture, impact analysis and using business knowledge to deliver optimal solutions.
• Design and develop ETL Jobs and System Data conversion using SQL Loader, Business Objects Data Integrator, SQL / PLSQL, NZSQL, Import, Export and OCI.
• Provide application support for asynchronous batch jobs from incident inception to closure with SLA adherence.
• Develop knowledge and train team members on Usage of Perl, AWK, Unix Shell commands, shell scripts and Java based Applications built on Web-logic and Tomcat.
• Use professional structured methods, standards and techniques in the development of data requirements, data models, and data dictionaries per CMMi - Level 5 standards.
• Reverse-engineer existing databases in order to create logical data models as part of system design and re-design.
• Design and develop in-detail ER Models and Maps in development phase.

Environment: - C, C++, OCI, Pro*C, Oracle 9i/ 10g, SQL, PL/SQL, UNIX (scripting), Perl, Core Java, Apache tomcat, XML, JDBC, JAXP, J2EE, FCP (Foundation Cooperative Processing), Weblogic 10.3, Business Objects, AWK, Windows 2000, Sun Solaris, HPUX, Remedy, PLSQL Developer.

Confidential

Technical Associate / Coordinator

Responsibilities:

• Strong knowledge of Creating Database Objects, SQL / PLSQL.
• Created Procedures, Functions, Triggers and Packages to convert Business logic to code.
• Created Front End GUI applications using FCP a CASE tool.
• Created back end services in Pro*C using Client server architecture corresponding to each GUI.
• Created asynchronous batch jobs in Pro*C, Unix, Perl, Java for pricing, provisioning, fraud detection / prevention, billing and reporting.
• Responsibilities included requirement capture, impact analysis and using business knowledge to deliver optimal solutions.
• In-depth knowledge on usage of Perl, AWK, Unix Shell commands and shell scripts.
• Used professional structured methods, standards and techniques in the development of data requirements, data models, and data dictionaries.
• Delivered artifacts and assignments included functional and technical design document specifications, code, unit testing, assembly/ system test support and its deployment followed by warranty support.

Environment: - C, C++, OCI, Pro*C, Oracle 9i/ 10g, SQL, PL/SQL, UNIX (scripting), Perl, Core Java, Apache tomcat, XML, JDBC, JAXP, FCP (Foundation Cooperative Processing), Weblogic 10.3, AWK, Windows 2000, Sun Solaris, HPUX, Remedy, PLSQL Developer