SUMMARY:

• Over 20 years experience in Design, Development & Software Quality Assurance.
• Proficient in Implementing HADOOP( HDFS, MapReduce, YARN, MR2,Hive,Pig,Hbase,F lume Sqoop, Tez, Spark( Core, DStreams, sql, mlib, ml, R), HUE, Impala, oozie, solr, zookeeper, kafka, kerberos ) for Big Data processing using Cloudera, Hortonworks, MapR, AWS.
• Strong knowledge in No SQL databases HBase & Mongo DB
• Proficient in ETL using TALEND (DI, DQ, MDM, ESB, TIC, DSC, DataPrep)
• Proficient Designing and implementing Data Warehouse
• Strong knowledge in data mining
• Proficient in Design/Development of web based real time applications using .Net, PHP, Java,Spring.
• Ability to effectively interact with the business groups on Business Requirements, Software Development and Implementations.
• Proficient in Software Development Life Cycle.
• Knowledge in designing Use Cases, Entity - Relationship Diagrams, Data Models.
• Solid understanding of Service Oriented Architectures
• Proficient in Designing N-Tier Systems, Designing Database Schema, MVC Web interface, Developing API, Web Services using .Net, PHP, Java, Spring
• Proficient in big data visualization reports using Tableau, Pyramid Analytics.
• Expertise in developing enterprise custom reports.
• Experience in Web and Windows applications development using .NET and Java Technologies.
• Experience in database development, for creating complex database Queries, Indexes, Views, Stored Procedures, Cursors and Triggers in Oracle, SQL Server.
• Experience using SCRUM Agile development methodologies.
• Proficient in Developing Test Plans, Test Cases for functional and system testing.
• Proficient in developing automated test scripts using Winrunner7.1, QTP11.5, and Selenium2.5.
• Experienced in migration across different versions of the software.
• Expertise in building cross browser web interface.
• Proficient in troubleshooting, writing bug reports and working with bug tracking tools.
• Excellent team player with strong communication skills.
• Ability to learn new tools / technologies quickly.
• Strong interest in improving Software Design / Development and QA processes.

TECHNICAL SKILLS:

Frameworks/Languages/Web/Mobile: Microsoft .NET Framework 4.0/3.0/3.5, ASP.Net 4.0, VB.NET 4.0, ADO. NET 2.0, ASP3.0, CGI, PHP 5.5, PERL 5.18,Phython 3.4, Java SE 8, J2EE,Scala, Java8.0,Java Spring MVC, Hibernate, Log4j,VBScript, C, C++, C#, HTML, DHTML,XML, XLS, CSS, .Net Web Services, SOAP, VeriSign CC Processing, nAnt, nUnit, nDoc, UML, WCF4.5, WPF4.5, AJAX, Silverlight, JQuery 2.0, Node.js,Express,Angular JS, Bootstrap 2.4, Ruby on Rails 4.0, Apache2.4, IIS 8.5, Android SDK 4.2, .NET Compact Framework 3.5, JQuery Mobile 1.4,Jenkins

Cloud/BigData: AWS S3/EC2/EMR/RDS/DP, Clodera,MapR,Hortonworks HADOOP(YARN, Pig/Hive/HDFS/HBase/HCatalog/ZooKeeper/Kafka,MapReduce/Spark(Core,Sql, MLlib,DStreams,R),Tez,Kerbaros,Impala,HUE,Cassandra)

ETL: TALEND (DI, DQ, MDM, ESB, DataPrep, TIC)

IDE/Tools: MicrosoftVisualStudio2010, VisualInterdev6.0, Visual SourceSafe6.0, CVS, SubVersion 1.8, GIT 1.8, SecureFax, SecureCRT, argoUML, Microsoft Project 2010, PhpEd 12.0, Eclipse, Zend 10.5, Engenium3.1, CAD/CAM, VisualBasic6.0, Developer2000, Confluence 5.4, ASANA

Visualization/Reports: Tableau 8.0, Actuate Bert 4.3, Jasper Reports 6.0.1,PyramidAnalytics

Database: Oracle11g, MongoDB2.4, Solr4.6, MS SQL Sever2000, MySQL, PostgreSQL 9.2, SQL, PL/SQL, ODBC, JDBC, OLEDB, TOAD 9.0, SQL Developer 4.0

Testing Tools: Loadrunner6.0, Winrunner7.1, Testdirector6.0, SQA Suite, QTP 11.5, Selenium 2.5

Bug Tracking: Mantis1.2, Jira 6.1, RT 4.2

Operating Systems: Amazon Linux AMI, Windows Server 2012 R2, Windows2000/2003 server, WINNT, UNIX, Solaries9.0 and Linux

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Review of Technical requirements
• Work with client team in implementing the solution including design, develop the jobs.
• Implement Big Data Integration using Cloudera distribution and Talend.
• Review and contribute for detailed design.
• Design/Develop Sqoop,Pig,Hive, Impala, DI jobs and run using Spark framework.
• Implement inter process messaging using Kafka.
• Load data from UNIX file system to HDFS
• Involve in creating Hive tables, writing Hive and Impala queries
• Review Hadoop log files
• Coordinate with development and QA activities
• Involved in Test plan creation.
• Involved in Application and Data level test cases.
• Involved in automating the test scenarios.
• End to End testing of all the jobs and document the time taken for completing initial load and delta loads
• Involve in load testing.
• Document the Solution Architecture.
• Provide KT to client users.

Environment: CDH 5.14, Hive, Sqoop, Impala, Hue, Pig, Kafka, Talend Data Fabric 6.3.1, JAVA8.0, Postgresql10, Oracle10g, MySQL6,SQL Server2016

Confidential

Technical Lead, Tampa, FL

Responsibilities:

• Review of Technical requirements
• Review and contribute for detailed Micro design.
• Work with client team in implementing the solution including design, develop jobs.
• Coordinate with development activities.
• Design job flows
• Implement Talend Big Data Integration, Talend Data Mapper.
• Design/Develop Sqoop,Pig,Hive, Impala, DI jobs and run using Spark framework
• Documenting creating Hive tables, loading data, and writing Hive queries
• Review Hadoop log files
• Document the Solution Architecture.
• Provide KT.

Environment: AWS, EC2,EMR, Sqoop, Impala, Hue, Pig, Java8.0, Postgresql10, Talend Data Fabric 6.3.1

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Review of Technical requirements
• Implement Talend DSC console
• Implement Salesforce big data integration using Hortonworks distribution.
• Review Installation, Configuration of Talend Integration Cloud 6.4.1
• Review and contribute for detailed Micro design.
• Work with client team in implementing the solution including design, develop the jobs.
• Coordinate with development activities.
• Conduct Integration test.
• Provide KT to client users.

Environment: Talend Integration Cloud 6.4.1, Talend DSC 6.2, JAVA8.0, SQL Server 2014, HDP3, Hive, Sqoop, Impala, Ambari

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Review of Technical requirements
• Involve in upgrade and configuration of Talend Dataprep 2.0, Talend DataFabric 6.3.1 in cluster mode.
• Configure SSL on Dataprep, TAC.
• Configure Kafka, Zookeeper, MongoDB.
• Involve in Integration and load testing.
• Provide KT to client users.

Environment: Talend DataFabric 6.3.1, Talend Dataprep 2.0, Java8, MongoDb,Kafka, Zookeeper, Linux CentOS, SqlServer2014

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Review of Technical requirements
• Review Installation, Configuration of Talend 6.2.1
• Involved in DW dimensional modeling using star schema and snowflake models.
• Involved in Creating mappings document.
• Review, Contribute for detailed Micro design.
• Implement Talend DI to support BI/DW solution.
• Involved in Generating various BI reports.
• Involved in Creation of Dashboards
• Involved generating predictive model for visits forecasting using Spark MLLib
• Work with offshore team in implementing the solution including design, develop the DI jobs, BI reports
• Coordinate with development activities.
• Conduct Integration test.
• Provide KT to client users.

Environment: TALEND5.4 (DI, DQ, MDM), JAVA8.0, SQL Server 2014, Pyramid AnalyticsCDH 5.14, Hive, Sqoop, Impala, Hue, Spark.

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Review of Technical requirements
• Review upgrade from Talend 5.3.1 to Talend 6.1.1
• Review the configuration to insure all needed jars are available within the environment.
• Review the existing jobs to improve the performance with the newly added features of the Talend 6.1.1
• Coordinate with migration activities
• Conduct Integration test.
• Workforce enablement to train on the latest features of Talend 6.1 for the skills upgrade.
• Provide KT to client users.

Environment: TALEND5.4 (DI, DQ, MDM), JAVA8.0, SQL Server 2014

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Implement Talend DI, ESB
• Review of technical requirements
• Review, Contribute for detailed Micro design
• Work with offshore team in implementing the solution including design, develop the DI jobs, ESB Services.
• Coordinate with development activities
• Conduct Integration test.
• Provide KT to client users.

Environment: TALEND5.4 (DI, DQ,DSC, ESB), JAVA8.0, SQL Server 2014

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Used Cloudera distribution for hadoop ecosystem installed and configured Flume, Hive, Pig, Sqoop and Oozie on the Hadoop cluster.
• Build/Tune/Maintain Hive QL and Pig Scripts for user reporting
• Developed MapReduce jobs and ran using Spark framework.
• Defining job flows
• Manage and review Hadoop log files
• Involved in loading data from UNIX file system to HDFS
• Involved in creating Hive tables, loading data, and writing Hive queries
• End to End testing of all the scripts and document the time taken for completing initial load and delta loads.
• Documenting the Solution Architecture.
• End-User Training.

Environment: CDH distribution, YARN, MapReduce, HDFS, Hive, HBase, Sqoop, Java (jdk1.6), Pig, Oozie, Oracle 11/10g, MySQL, Eclipse, ETL Tool (Talend), Spark, PL/SQL, JavaJSP, JDBC, Linux, Shell Scripting, Toad, WinScp, Putty, XML, JSON, JIRA

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Implement Talend MDM (DI, DQ, MDM)
• Review of technical requirements
• Review, Contribute for detailed Micro design
• Work with Confidential leads in implementing the solution including Configuration, MDM data modeling, Data profiling, ID Matching, Survivorship, MDM data load.
• Coordinate with development activities
• Conduct Integration test.
• Setup data pipeline for talent jobs execution.
• Provide KT to Confidential team

Environment: TALEND5.4 (DI, DQ, MDM), AWS S3/EC2/EMR/RDS/DP, Java SE 8, Pig 0.14, MySQL, Amazon Linux AMI.

Confidential

Technical Lead, Scottsdale, AZ

Responsibilities:

• Perform Daily 834 process and send Summary report with number of records loaded to MDM, Data Steward and Member Prominence system.
• Monitor 270 Request/Response routes for active members.
• Monitor EZCap (PCG) member Extract job
• Monitor DQ (Denta Quest) Daily Load job.
• Perform ad-hoc processing of IRX files
• Run MCPD Load job to send list of active providers to Massachusetts State.

Environment: TALEND5.4(DI, ESB, MDM), Java SE 8, SQL Sever 2012, Oracle 10g, Windows Server 2012 R2

Confidential, NYC, NY

Team Lead

Responsibilities:

• Design, development and maintenance of software
• Coding and deployment of new and existing application.
• Design and develop visualization reports using tableau.
• Write Stored Procedures for Bulk insertion from csv files.
• Write migration scripts.
• Schedule and plan development and maintenance tasks.
• Facilitate project related meetings and communicate project schedules
• Identify process inefficiencies and suggest improvements.
• Involve in design and code reviews.
• Create technical specifications, models, test plans and implementation strategies.
• Design major and minor enhancements within the existing framework of the application.
• Upgrade the software.
• Design and Maintain Database Schema.
• Design and Develop API, Web Services
• Develop the Web interface
• Design and Develop background processes.
• Design and Develop library for Error Handling, Logging and Cryptography.
• Setup and maintain the search engine tool.
• Design and develop Rate algorithms.
• Developed web components using JSP, Servlets.
• Implemented JQuery validator components.
• Developed Spring MVC controllers for all the modules. used Hibernate tool to deal with database.
• Implemented Spring IoC framework
• Developed Spring REST services for all the modules.
• Developed Maven scripts to build and deploy the application.
• Resolve software issues.
• Involve in System Testing of the application.
• Work closely with development team, graphic designers, and sales and marketing professionals
• Involve in Requirement gathering, Functional and technical specifications
• Involved in optimizing existing queries.
• Write queries for custom reports.
• Setup and Maintain Credit Card Processing.
• Setup environment on amazon cloud.

Environment: .Net4.0, PHP5.5,Java7.0, Bootstrap 2.4, JQuery 2.0, Ruby on Rails 4.0, Oracle10g, Java Spring MVC4.3, Hibernate4.3, Linux, Win2000 Server, Tableau8.0, Amazon EC2/S3, Apache2.4, IIS8.5