SUMMARY:

• Over 6 years of experience as Database developer using SQL Server and 3 years with Big Data Ecosystems including Hadoop MapReduce, Pig, Hive, Impala, Sqoop, Flume, Oozie, Spark, Scala.
• Extensive knowledge of UNIX/Linux OS, System administration skills, Utilities and Shell scripts. Strong analytical skills with problem solving and root cause analysis experience.

TECHNICAL SKILLS:

Big Data Bootcamp: Big Data, Hadoop, NoSQL, Spark

Hadoop Fundamentals:   MapReduce, Pig and Hive Introduction to HBase and Cassandra NoSQL database

Business Analysis:  Problem Solving, Decision Making, Probability, Statistic and Decision Analysis, Forecasting, Modeling Process, Financial Analysis, Project Management PERT / CPM, Computer Simulation and Risk Analysis, Gwinnett Technical College

Oracle Intermediate (PL / SQL Programming):  Functions, Stored Procedures, and Packages, Transaction Management, Advanced Cursor Concepts, Managing PL / SQL Code and Code Debugging

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Hadoop Developer 

• Big Data Development and Analytics using Hadoop stack (HDFS, MapReduce, Pig, Hive, Impala), Spark
• Engage in query performance tuning.
• Data cleansing and analytics using Python, Scala shell scripting
• Transfer Data from SQL Server to Hadoop using SQOOP.
• File format used(Text file, Sequence file, ORC, JSON).
• Exposure to NoSQL Databases(Cassandra, Hbase, Netezza)
• Writing Complex SQL and T - SQL scripts for data analysis.
• Resolve data issues in test and production environments
• Data Confidential design(Dimension data modelling)

Confidential, Plano, Texas

Hadoop Data Engineer 

Responsibilities:

• Big Data Development and Analytics using Hadoop stack (HDFS, MapReduce, Pig, Hive, Impala), Spark
• Engage in query performance tuning.
• Data cleansing and analytics using Python, Scala shell scripting
• Workflow scheduler system using Autosys and Oozie
• Transfer Data from SQL Server to Hadoop using SQOOP.
• Design, develop, and execute packages to migrate client data to Hadoop
• Exposure to NoSQL Databases(Cassandra, Hbase, Netezza)
• Writing Complex SQL and T- SQL scripts for data analysis.
• Collaborate with project management and business analysts to develop data Migration packages that meet client business rules.
• Data visualization using Tableau.
• Perform complex data analysis to identify patterns and anomalies.
• Resolve data issues in test and production environments
• Data Confidential design(Dimension data modelling)
• Create BI design patterns, designs, standards
• Database programming Including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects.

Confidential

SQL ETL Developer 

• Provided T-SQL programming (Stored Procedures, Functions, Indexes and Triggers).
• Wrote complex SQL scripts (primary keys, foreign keys, constraints, joins, unions, aggregate functions and SQL functions) using SQL Server Management Studio and Toad.
• Provided data conversion, data migration, data mapping, data validation, data analysis and data cleansing.
• Software configuration and implementation
• Involved in the ETL process (SSIS), including development, data validation, data cleansing, UAT and moving to production
• Queries Performance tuning (Database Engine Tuning Advisor, Query execution plan and Query Analyzer).
• Maintained E-R (Entity-Relationship) diagrams and data dictionary normalization.
• Offered customer report development using SSRS and Crystal Reports.
• Integrate ERP(PeopleSoft) to non-ERP(IVOS).
• Provided application support (troubleshooting and resolving production issues).
• Software implementation and configuration
• Provided client setup and production support.
• Installed and upgraded, provided service packs and security updates, and configured SQL Server 2008.
• Provided configuration management.
• Loaded data from OLAP environment to OLTP environment.
• Oversaw high availability (log shipping, database mirroring and replication).
• Provided database backup, restore and recovery models table partitioning.
• Created and maintained SQL Server database security (users, roles and privileges).
• Managed database security and maintenance plans.
• Maintained jobs scheduling using SQL Server Agent.

Confidential . 

T-SQL Developer

• Provided T-SQL and PL / SQL programming (Stored Procedures, Functions, joins, aggregate functions, Indexes and Triggers) using SQL Server Management Studio, Toad and SQL Navigator.
• Provided data conversion, data migration, data mapping, data validation and data analysis.
• Involved in the ETL process (SSIS), including development, data validation, data cleansing, UAT and moving to production.
• Wrote SQL scripts (primary keys, foreign keys, constraints, joins and unions) and data normalization.
• Provided database monitoring (SQL Server Profiler).
• Scheduled jobs using SQL Server Agent.
• Provided reports development (SSRS and Crystal Reports).
• Wrote complex SQL queries to provide reports (financial, medical, billing and claims).
• Created a database maintenance plan (backup, database integrity check, index reorganize and rebuilding and statistics updating).
• Oversaw high availability (log shipping, database mirroring and replication).
• Provided database backup, restore and recovery models table partitioning.
• Provided performance tuning (Database Engine Tuning Advisor, Perfmon and Query Analyzer).
• Involved in software development (Visual Basic).
• Provided application support (troubleshooting and resolving production issues).
• Recognized critical systems, critical timeframes and milestones.
• Provided procedural documentation and produced report definition reports for management.

Confidential

SQL-PL/SQL Developer

• Updated databases and wrote T-SQL scripts.
• Wrote Stored Procedures, Functions and Triggers (T-SQL/ PLSQL).
• Wrote complex SQL scripts (primary keys, foreign keys, constraints, joins and unions) using SQL Server Management Studio.
• Provided reports development using (Oracle Reports and Crystal Reports).

Confidential

T-SQL Developer

• Wrote Stored Procedures, Functions and Triggers (T-SQL / PLSQL).
• Wrote complex SQL scripts (primary keys, foreign keys, constraints, joins and unions) using SQL Server Management Studio and Toad.
• Maintained E-R (Entity-Relationship) diagrams and data dictionary normalization.
• Provided data conversion and data migration.
• Involved in the ETL process (SSIS), including development, data validation (data quality), UAT and moving to production.
• Provided SQL Server administration, schema maintenance and backup / restore.
• Created and maintained SQL Server database security (users, roles and privileges).
• Provided performance tuning (Database Engine Tuning Advisor, Perfmon and Query Analyzer).
• Provided database monitoring (SQL Server Profiler).
• Scheduled jobs using SQL Server Agent.
• Offered software development (Visual Basic 6.0).
• Used ODBC and ADODC technology.
• Provided Active Directory management, IIS configuration and network configuration.