SUMMARY:

• 10+ years of total IT experience in analyzing, designing, administer, tuning, and developing Client/Server Applications and 3+ Years in Big Data - Hadoop Development and Ecosystem Analytics, Development and Design of Java based enterprise applications.
• Experience on BIG DATA using HADOOP framework and related technologies such as HDFS, HBase, MapReduce, Hive, Pig, Impala, Flume, Oozie, Sqoop, Spark and Zookeeper
• Experience in working Cloudera CDH3, CDH4 and CDH5 distributions. Experience in working with Flume to load the log data from multiple sources directly into HDFS.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Experience in data analysis using Hive, Pig Latin, Impala, HBase and Custom Map Reduce programs in Java.
• Experience in writing custom UDFs in Java for Hive and Pig to extend the functionality.
• Experience on Spark, Scala, Data Frames.
• Developed analytical components using Kafka, Scala, Spark SQL and Spark Stream.
• Worked on the Spark SQL and Spark Streaming modules of Spark extensively and used Scala to write code for all Spark use cases.
• Experience in load balancing and stress testing.
• Experience with Sequence files and AVRO file formats and compression.
• Experience in working with Amazon Web Services EC2 instances and S3 buckets.
• Experience in designing both time driven and data driven automated workflows using Oozie.
• Implemented Hadoop based data warehouses, Integrated Hadoop with Enterprise Data Warehouse systems.
• Extensive experience in Data Ingestion, In-Stream data processing, Batch Analytics and Data Persistence Strategy.
• Worked in Windows, Unix/Linux platforms.Experience working in with ORACLE and My SQL databases.
• Experience in creating Spark Contexts, Spark SQL Contexts, Spark Streaming Context to process huge sets of data
• Promote full cycle approach including request analysis, creating/pulling dataset, report creation and implementation and providing final analysis to the requestor
• Very Good understanding of SQL, ETL and Data Warehousing Technologies
• Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2014/2012/ 2008/2005/2000, DTS/SSIS, and Reporting & Analysis Services.
• Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, administer, coding, testing, and debugging new and existing client-server based applications).
• Expertise in database optimization using tools like Database engine Tuning Advisor, SQL profiler, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2014/2012/ 2008/2005/2000 /7.0,VS2013/2010, Oracle 8i/9i/10g, Toad, MySQL

Languages: C, C++, Java, Scala, Python, SQL, Pig Latin, HiveQL T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java ASP .NET, VB .NETOperating System: CentOS, Linux, Windows 98/2000/2003/ XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise ServerDevelopment tools: Microsoft SQL Studio, Eclipse, NetBeansDevelopment methodologies: Agile/Scrum, Waterfall

Other tools: GIT, MS SQL Server Reporting Services 2008/2005/2000 (SSRS), MS SQL Server Analysis Services 2008/2005(SSAS), MS SQL Server Integration Services 2014/2012/ 2008/2005/2000 (SSIS), Data Transformation Services (DTS), ODBC, SQL Server Management studio (SSMS), Erwin 7.2/7.1/4.1 MS Visio 2007/2003, BCP, Active Directory, RS Utility, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

BigData/Hadoop Developer

Environment: HDFS, Map Reduce, Hive, HBase, Pig, Java, Oozie Scala, Kafka, Spark, Git, CentOS 6.4, SBT, Eclipse, RDBMS

Confidential, Cleveland, OH

Hadoop Developer

Environment: HDFS, MapReduce, Hive, HBase,Sqoop, Pig, Java, Scala,Pyspark, Kafka, Spark, Git, Eclipse, CentOS 6.4

Confidential, Cleveland, OH

Hadoop Developer

Environment: Hadoop Ecosystem, HDFS, Map Reduce, Pig, Hive, Sqoop, Eclipse, Shell Scripting, RDBMS

Confidential, Cleveland, OH

Sr. SQL DBA/ Sr. Database Consultant

Hardware/Software: MS SQL Server 2014/2012/2008, 2005 T-SQL, SQL Server 2014/2012/2008 /2005 Integration Services (SSIS), TFS, SQL Server 2008 Reporting Services(SSRS),VS 2013/2010, MS Excel, Visio 2007, Erwin 7.2, SQL Server 2008 Analysis Services, Windows server 2008, BCP, Active Directory

Confidential, Honolulu, HI

Sr.Database Administrator (DBA) / Sr.SQL Database Consultant

Hardware/Software: MS SQL Server 2008, T-SQL, SQL Server 2008 Integration Services(SSIS), TFS, SQL Server 2008 Reporting Services(SSRS), MS Excel, Visio 2007, Erwin 7.2, SQL Server 2008 Analysis Services, Windows server 2008

Confidential, Newark, DE

Database Administrator (DBA) /Sr. MS SQL Server/SSIS/SSRS Developer

Hardware/Software: MS SQL Server 2008, T-SQL, SQL Server 2008 Integration Services(SSIS), TFS, SQL Server 2008 Reporting Services(SSRS), MS Excel, Visio 2007, Erwin 7.2, SQL Server 2008 Analysis Services, Windows server 2008

Confidential, Burlington, Massachusetts

Database Administrator (DBA) / Sr. MS SQL Server/SSIS/SSRS Developer

Hardware/Software: MS SQL Server 2008, T-SQL, SSIS packages, VSS, SSRS, MS Excel, Visio2007, Erwin 7.1, SQL Server Analysis Services, Windows server 2008

Confidential, Baton Rouge, LA

Database Administrator (DBA) /SQL Developer/SSIS/SSAS/SSRS Developer

Hardware/Software: Windows Server 2003, MS SQL Server 2005, Business Intelligence Development Studio (SSAS, SSRS & SSIS), TFS, MS Office 2007, Erwin4.1

Confidential, San Mateo, California

SQL/SSIS/SSRS/SSAS Developer

Hardware/Software: Windows XP/2003 Enterprise edition, MS SQL Server 2005, Excel 2003, TFS, VBScript, Database Engine Tuning Advisor, SQL Profiler, SQL Server Business Intelligence Development Studio 2005, Reporting Services Configuration, SSIS

Confidential

JR. SQL Developer

Hardware/Software: SQL Server 2000, VSS, VB Script, DTS, MS Access 2000/2003, Visual Studio.Net 2003