SUMMARY

• 22 years of professional experience in building Enterprise applications in US.
• Experience in developing software solutions on Big Data Platforms in Hortonworks, Cloudera and AWS.
• Hands on development experience in Hadoop ecosystem components, Map Reduce, YARN, HDFS, HBase, Apache Hive, Apache Sqoop, Pig, Zookeeper, Oozie, SOLR, Flume
• Experience in cloud computing, Amazon Cloud services, Microsoft Azure, AWS, SaaS, IaaS and PaaS
• Expertise in big data application tuning and optimization
• Expertise in Scala, Python, Apache Spark RDD, Spark SQL, Spark Streaming, DataFrames and Kafka
• Familiarity with machine learning pattern using Mahout and Spark MLlib
• Expertise in Business Intelligence tools—Tableau, PowerBI and QlikView
• Expertise in NoSQL Database HBASE, Cassandra, Mongo DB and Apache Phoenix
• Experience in configuring cluster and installing the services and monitoring the cluster.
• Technical Leader with 15 years of experience in HIGH volume database design and architecture
• Expertise in gathering business requirements, capacity planning, resource planning, functional analysis, design, implementation and gap analysis.
• Hands on development and basic administration experience in Oracle 12c/11g/10g/9i/8i/7 RDBS server.
• Expertise in Conceptual, Logical and Physical design of both OLTP and OLAP (Data warehouse) databases.
• Very strong programming skills in SQL, ANSI SQL, PL/SQL, Database Packages/Procedures/Triggers, ERWIN, Oracle SQL Modeler, Oracle Designer, SQL*Loader, Data Pump and Data Base Administration tools.
• Expertise in high transaction database modeling, design and development.
• Sound knowledge in MySQL, Teradata, MS SQL server and ETL Tools (SAS, Data Stage and INFORMATICA).
• Expertise in building J2EE Enterprise applications for financial, medical, automobile, insurance, telemarketing, production planning, MRP II and human resources management industries.
• Experience in complete software development life cycle (SDLC) and software maintenance.
• Very strong programming skills in Java, Servlets, JDBC, JSP, HTML and JavaScript.
• Strong programming skills in EJB, Java/J2EE, Struts framework, Spring Frame Work and Spring MVC
• Sound knowledge in Hibernate, JPA and IBATIS.
• Hands on experience in WebSphere App Server 6.x /7.x, Web Logic 9.x/10.x, RAD 7.x/8.x and WSAD.
• Strong programming skills in Business Objects and Crystal XI.
• Sound knowledge in RUP and Agile methodology - SCRUM, Rational Tools and Eclipse IDE.
• Experience in onshore-off shore round the clock project development and maintenance model.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

• HDFS
• Hive
• Sqoop
• PIG
• Oozie
• Flume
• KAFKA
• SOLR
• Zookeeper
• MAP Reduction
• YARN
• TEZ
• HUE
• Teradata SQL Assistant for Hadoop
• IMPALA
• Zeppelin
• Ambari
• SPARK
• NoSQL
• Dynamo DB
• HBase
• MongoDB
• Apache Phoenix
• Ambari
• Cloudera Manager
• AWS
• EC2
• S3
• SaaS
• IaaS
• PaaS
• Windows Azure
• Oracle Data Base Server (12c/11g/10g/9i/8i/7/6)MySQL
• Teradata
• MS SQL Server
• ANSI SQL
• PL/SQL (All versions)
• TSQL
• ERWIN
• SQL data modeler
• Oracle designer 2000/6i/11g
• Oracle SQL developer 3.x
• TOAD
• SQL Navigator
• Oracle JDeveloper
• ETL Tools - SAS9.x
• Data Stage 8.x 9.x
• INFORMATICA 6.x
• Java2
• Java 5/6/7
• SCALA
• HTML
• XML
• UML
• FpML
• Java Script
• JSP
• Servlets
• EJB 2.x
• DTD
• XSD
• XSLT
• AJAX Struts Frame Work
• Apache Tiles
• Spring Frame Work
• Apache Commons
• JSON
• AVRO
• Parquet
• Hibernate
• Design Patterns
• ANT
• Hudson
• SOAP
• WSDL
• JAXB
• JUnit
• Eclipse 3.x
• RAD6.x/7.x/8.x WSAD5.x
• Change Man
• PVCS
• Visual Source Safe
• Clear Case
• IBM Web Sphere (6.x/ 7.x) BEA Web Logic (8.x/9.x
• 10.x)
• Tomcat
• MS Visio
• Power Point
• MS Project
• MS Office products
• Developer
• Forms
• Reports
• SQL*Loader
• Data Pump
• Oracle Financials 10.7 11i
• Tableau
• Qlikview
• Business Objects
• Crystal Enterprise XI
• Rational Rose
• MS Windows (95/98
• NT/XP/Vista/7/10.x)
• Unix (HP-UX
• Sun Solaris & AIX)
• Linux
• PYTHON and Shell scripts

PROFESSIONAL EXPERIENCE

Confidential - Dallas

Big Data Architect

Responsibilities:

• Define project scope, goals and project deliverables interacting with Confidential &T Product Managers
• Responsible for the Design and Architecture of Hive Data warehouse for 1 PB database
• Heavy coding efforts to develop and test various Hadoop application components.
• Code and Test hundreds of hive programs using Python, hive HQL, Scala and Spark SQL
• Code dozens of SQOOP import to support data ingestion/ETL to Confidential &T 790 Nodes Hadoop Cluster
• Create dozens of SQOOP export programs for customer interface into Oracle and SQL Server RDBMS
• Expertise in Scala, Spark SQL, Data Frames and Spark RDD
• Expertise in Hortonworks, Beeline, Linux Scripting, Kerberos, Kafka, Zookeeper, Ambari and Zeppelin
• Deploy hive, spark and python programs to PROD environment
• Expertise in HUE, HWX Hive View 2.x, Teradata SQL Assistant and TOAD for Hadoop
• Develop process automation using Oozie and crontab
• Create BI data visualization components using Microsoft PowerBI
• Hadoop application tuning of Hive and Spark program to optimize the latency and through put
• Interface Hive Data warehouse environment with NoSQL database
• Train and Mentor other team members in the group
• Support Map Reduction programs written SCALA and Hive HQL on the Hadoop cluster
• Tune Queries for TEZ Horton Works frame work

Confidential - Dallas

Big Data Architect

Responsibilities:

• Perform data modeling and design for Chase Mortgage, HELOC and Auto loan applications
• Define and manage the architecture and life cycle of Hadoop and SPARK projects
• Develop Map Reduction jobs in Hadoop in Scala/Python/Java/PIG/Hive
• Expertise in writing Scala code to run SPARK jobs in Hadoop HDFS cluster
• Expertise in SPARK Streaming using KAFKA
• Expertise in SPARK SQL, DataFrames, RDD and MLlib
• Experience in writing Pig Latin scripts to load data in to HBase in AVRO format
• Hands on experience in Hive, HiveQL, Impala and Parquet
• Hands on experience in NoSQL Databases Mongo DB and HBase
• Hands on experience with data loading tools like Flume, Sqoop
• Manage Hadoop jobs using scheduler Oozie
• Cluster Coordination services through Zookeeper
• Expertise in Data visualization and Business intelligence using Tableau
• Create database design artifacts, ERD, DFD, conceptual, logical and physical designs using ERWIN for various databases, Oracle, MySQL and NoSQL HBase
• Design data warehouse for star schemas, dimensional, bottom-up Kimball approach
• Design architecture for ETL loads.
• Lead and hands-on effort in Develop, Test and Optimize about 300 Oracle APIs-business logic units in PL/SQL
• BMC Control M designs and implementation for project automation.
• Conversion of SQL Server database procedures into Oracle database packages in PL/SQL using MS visual studio and TOAD.
• Source code control of Oracle APIs, Database packages, Triggers, DDL, DML and DCL scripts in Subversion
• Implementation of projects using Agile SCRUM product development strategy.
• Mentor and train junior staff in the team.
• Demonstrated competence around the areas of product knowledge, relationship building, professionalism and personal excellence, leadership, people focus, and business development.

Confidential - Chicago

Hadoop Architect/ Solution Architect

Responsibilities:

• Participates in facilitating the definition of project scope, goals and project deliverables
• Responsible for managing the development and deployment of Hadoop application components
• Used Oozie to automate data loading into the Hadoop Distributed File System and PIG to process the data
• Provided design recommendations and thought leadership to upper management that improved processing speed and data storage problems by leaps and bounds
• Hands on experience to move data from RDBMS and data warehouse to Hadoop HDFS cluster using SQOOP
• Data visualization efforts against HDFS, Hive and NoSQL databases Mongo DB and Casandra
• Perform data modeling and analysis for NT Compliance Analyst and Liquidity applications
• Create data modeling artifacts using ERWIN for OLTP and OLAP (Data warehouse) projects
• Create detailed design for new projects. Generate DDL, DML, DCL scripts for both traditional and dimensional
• Create design artifacts and documentation in UML (ERD, DFDs, Sequence diagrams, Class Diagrams…)
• Design and create database tables with partitions to store billions of rows
• Code and Test several database packages with several stored procedures and functions
• Develop and test Data Stage (ETL) Jobs to extract data into data repository and Oracle database from upstream systems
• Written a number of shell scripts and parser routines to automate data extraction from several upstream systems Bloomberg, AIP, NDR, FpML, SWAPs, Options and OTC DataMart
• Work on project automation using Control M scheduler
• Expertise in Data visualization and Business intelligence using Tableau and Qlikview

Confidential

Technical Lead/ Data Architect

Responsibilities:

• Design Big Data model to transfer data into Hadoop echo systems from Oracle and SaaS data stores as part of company’s new initiate data analytics
• Data visualization efforts against HDFS and Hive
• Written code to move data into HDFS cluster using SQOOP and PIG Latin
• Perform data modeling and analysis for a 5 Terabytes OLTP data model.
• Create database design with integrity constraints and triggers.
• Create design artifacts and documentation for OLTP and Data warehouse.
• Work with business stake holders and business analysts to create credit models.
• Design and create database tables with partitions to store billions of rows.
• Perform basic database administration on DEV and QA instances.
• Develop over 30 database packages with dozens of stored procedures and functions.
• Written several SQL*Loader script to migrate data from legacy databases.
• Written a number of shell scripts to automate data loads from CSV files.
• Write and optimize hundreds of SQL queries and database views for Java/J2EE UI interface.
• Design data warehouse for star schemas, Top-down Inmon methodology.
• Develop and implement data integration architecture with OLAP database using SAS.
• Develop technical detail design for all the major tasks.
• Assign tasks to team members onsite/offshore and monitor status till completion.
• Conduct project status and follow-up meetings and discussions.
• IBM application server WebSphere 7.x administration tasks.
• Perform root cause failure analysis and recommend resolutions.
• Mentor and guide junior team members onsite/offshore.
• Guide QA team to test the software components developed.
• Involved in unit testing, integration testing, feature testing and Regression testing.
• Participate in software gap analysis with business analysts and product managers.
• Manage open tickets and find resolutions.

Confidential, Chicago

Technical Lead/Solution Architect

Responsibilities:

• Work with business users and business analysts to develop requirements and translate requirements into technical designs.
• Functional analysis, data modeling and database design for Oracle 11g RDMS Databases.
• Data migration from legacy systems and other DBMS Systems.
• Research advanced concepts to develop reusable solutions to recurring problems.
• Work with product managers on capacity planning.
• Participate in software gap analysis with business analysts and product managers.
• Created several DB packages, stored procedures, functions, and triggers.
• Wrote large number of Oracle queries. Heavy coding effort in PL/SQL. Data base administration.
• Analyze functional requirements, Use Cases and technical specifications for J2EE Architecture and design.
• IBM application server WebSphere 6.x administration tasks.
• Preparation of design documents in UML.
• Project Management and sizing.
• Lead and mentor developers in the team
• Implementation of Struts MVC pattern frame work using Struts2.
• Unit testing using Junit.
• Involved in unit testing, integration testing, feature testing and Regression testing.
• UNIX and Shell scripts, Source control management in Subversion.

Confidential, Melrose Park (Chicago)

Team Lead and Solution Architect

Responsibilities:

• Conduct sessions/interviews with the business side to secure detailed information pertaining to application and data usage.
• Worked both directly with business users and with business analysts to develop requirements and translate requirements into technical design
• Functional analysis, data modeling and database design for Oracle 11g RDMS Databases
• Preparation of design documents in UML
• Weekly communication and reporting of project status risks and issues
• Construct and optimize complex SQL queries
• Heavy coding effort in PL/SQL
• Assign tasks to team members onsite/offshore and monitor status till completion.
• Mentor and guide junior team members onsite/offshore.
• Guide QA team to test the software components developed.
• UI coding efforts in JSP, JavaScript and HTML
• Develop applications using Spring MVC pattern frame work.
• Integration with IBM MQ series
• Used SOA and Web services for importing BOM structure from TEAMCENTER application
• Develop WSDLs, SOAP.
• Heavy hands on programming efforts in control and UI layer.

Confidential, Chicago

Solution Architect

Responsibilities:

• Analyze functional requirements, Use cases and technical specifications.
• Application architecture and design.
• Preparation of design documents in UML.
• Research advanced concepts to develop reusable solutions to recurring problems.
• Construct and optimize complex SQL queries.
• Go to guy in the team for Oracle queries, stored procedures, functions, packages and triggers.
• Implementation of Spring MVC pattern frame work.
• Data management and persistent layer development in open source ORM tool IBATIS.
• Implementation of Dependency Injection using Light weight Spring frame work
• Heavy hands on server side programming efforts in Java.
• UI coding efforts in JSP, AJAX, JavaScript and HTML.
• Extensive coding efforts to develop oracle data base packages and IBATIS mapping files.
• Design and develop SSL encryption and single sign on features of the application.
• Rational tools Clear case and Clear quest for source control and defect tracking.
• Mentor junior programmers in the team.

Confidential, Chicago

Application Architect Treasury Services

Responsibilities:

• Data migration and data loading programs in Oracle environment
• Conversion of Oracle PL/SQL systems into J2EE Application.
• Written a number a Database packages and triggers in PL/SQL
• Data modeling and database design focused on Oracle environment
• Installation, administration and maintenance of Oracle 10G Database for the development and QA environment
• Construct and optimize complex SQL queries
• Analyze functional requirements, Use Cases and technical specifications
• Preparation of design documents in UML
• Implementation of Struts MVC pattern frame work using Action Servlets and JavaBeans
• Data management and Persistent layer development in open source ORM tool Hibernate
• Implementation of Dependency Injection and AOP using Light weight Spring Frame Work
• UI coding efforts in JSP, JavaScript and HTML
• Extensive programming efforts in server side Java business layer
• Rational tools Clear case and Clear Quest for version control and defect tracking
• Mentor junior programmers in the team, both onshore and offshore.
• Involved in unit testing, integration testing, feature testing and Regression testing

Confidential, Chicago

Senior Oracle/ Java/J2EE Consultant

Responsibilities:

• Analyze functional requirements, Use Cases and technical specifications.
• Implementation of MVC pattern in Struts frame work and Tiles using Action Servlets and Java beans
• Data management and Persistent layer development in open source ORM tool Hibernate
• Implementation of Inversion of Control and AOP using Light weight Spring frame work
• UI coding efforts in JSP, JavaScript XML, CSS and HTML
• Construct complex SQL queries in Oracle and DB2
• Conversion of legacy reports into Crystal4Eclipse in J2EE environment
• Developed Business Object report designs.
• Perform administration on WebLogic app server for QA and DEV environment
• Mentor junior programmers in the team
• Used RUP software development methodologies