Data Analyst/ Hadoop Developer

MD. SAJJADUR RAHMAN

Washington •DC • Cell: 240-***-****• *****.******@*****.***

SUMMARY:

• Having 8+ years of professional IT experience in Software development, Data Analytics, Hadoop technologies and Telecom industries.

• 4 years of Telecom Project Planning & Management along with operational expertise in Provisioning, billing and Mediation System.

• Having 4+ Professional experience in System Design, Development, Integration and Implementation of enterprise software related to Enterprise/Web based n-tier architecture systems.

• Experience in all phases of software development life cycle (SDLC) including Requirement Gathering by client Interaction, Development, Implementation, Integration, Documentation, Testing, Builds, and Configuration.

• Expertise on working with Hadoop, HDFS, Map Reduce framework and Hadoop ecosystem like Hive, HBase, Sqoop and Flume.

• Extensive experience in analyzing and documenting business requirements

• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture

• Efficient in Dimensional Data Modeling, Process Modeling for Data Warehouse

/Data Mart design, identifying Facts and Dimensions, creation of cubes, Star Schema and Snowflake Schema

• Experience in implementing advanced procedures like text analytics and processing using the in-memory computing capabilities like Apache Spark written in Scala.

• Good Exposure on Hive, PIG Scripting and Distribute Application and HDFS.

• Familiar with Enterprise wide Data Warehouse Architecture

• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.

• Experienced in Data transformation, Data mapping, Data migration from source to target database schemas, data cleansing procedures

• Familiar with BI tools like SSIS,SSAS, SSRS etc.

• Have experience in Visual Studio.Net, Python, Scala, Spark, R-programming, SAS, HTML, Java Scripting.

• Sound knowledge in UNIX,, Windows and scripting.

• Handled performance fine-tuning of large database system in conjunction with front-end applications.

• Experience in Design and Development of database systems using Relational Database Management Systems including Oracle 9i, and SQL Server, Ms Access.

• Expertise in programming with SQL, PL/SQL, TSQL, Function and Stored Procedures.

• Successfully completed the courses on ITIL

• Highly motivated, quick starter Process and Process Improvement, Software Capability Maturity Model and analytical knowledge about Software Change Control Process., solution-oriented programmer, Strong in object oriented analysis and design, Excellent at solving complex problems under strict deadlines. TECHNICAL SKILLS:

Operating Systems Windows 10/8/7/XP/NT/2000, DOS, Unix. RDBMS/DBMS Microsoft -SQL Server 2014/2012/2008/2000, Oracle 8i & 9i, MS Access.

BI /Data model Tools Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS And Visio.

Programming

languages

ASP.Net, C#.Net, VB.Net, Visual Basic, Scala, Java, Python, T- SQL, PL/SQL programming.

Database Tools Toad, PLSQL Developer, SQL Navigator, SQL Tools. Hadoop Ecosystem

Development

HDFS, Hive, Pig, Flume, Oozie, Zookeeper, HBASE, Spark and Sqoop.

Application

Packages:

MS Office.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005, SQL Server Enterprise Manager, T-SQL, Data

Transformation Services (DTS), ODBC, OLAP, OLTP.

Web Technologies HTML, XML.

Script Languages Unix Shell scripting, Perl scripting, Pig Latin. Others Object Oriented Designing Methodology, UML, RDBMS Concepts, and ETL.

PROFESSIONAL EXPERIENCE:

The Cure Is Now, Yonkers, New York Aug 2015 – Oct 2016 Data Analyst/Software Developer

Responsibilities: -

• Involved with Business Analysts team in requirements gathering and in preparing the Functional specifications and Technical specifications.

• Design and coding of screens, reports and components.

• Design database.

• System documentation.

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

• Involved in the debugging, testing and designing of database

• Implemented the best suited CRM as per company requirement.

• Performed the customization of CRM for the best practice of organization’s work flow.

• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.

• Responsible for data collection, cleaning and transformation from various source to single platform.

Environment: AgileCRM, WordPress, My SQL, Ms SQL Server, VB Script, Java Script University of Bridgeport, Bridgeport, CT Feb 2015 – June 2015 Data Analyst on Big Data Project as Graduate Assistant Responsibilities: -

• Extensively involved in Design phase and delivered Design documents.

• Involved in Testing and coordination with business in User testing.

• Importing and exporting data into HDFS and Hive using SQOOP.

• Developed Java Map Reduce Programs.

• Implemented custom DataTypes, Input Format, Record Reader, Output Format, Record Writer for Map Reduce computations.

• Written Hivejobs to parse the logs and structure them in tabular format to facilitate effective querying on the log data.

• Involved in creating Hive tables, loading with data and writing hive queries that will run internally in map reduce way.

• Used Pig as ETL tool to do Transformations, even joins and some pre-aggregations before storing the data onto HDFS.

•

Environment: Hadoop- HDFS, Map Reduce, HIVE, Pig, Sqoop, Scala, Java, Unix Robi Axiata Limited, Dhaka, Bangladesh Nov 2013 – Aug 2014 Data Analyst

Responsibilities:

• Designed strategic plan for component development practices to support future projects.

• Managed creative projects from concept to completion while managing outside vendors.

• Managed the process of Data Import/Export from/to various source to central single platform.

• Responsible for creation effective and error free ETL.

• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.

• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

• Advocated for end-users to perform testing and problem analysis for server, desktop and IT infrastructure work

• Created use cases, class diagrams, sequence diagrams and data flow diagrams using Rational Rose and Visio for new procedures that would help improve existing processes.

• Prepared high level logical data models and BRD (Business Requirement Document), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.

• Developed an analysis model that includes use case diagrams, use case narratives and activity diagrams using UML methodologies in Rational Rose, which provided the development team a view of the requirements for XML design and construction phases

• Monitored the data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department

• Monitored network performance and provided network performance statistical reports for both real-time and historical measurements.

• Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.

Environment : Huawei HLR9820 SMU Client and BSCS 8, Oracle 9i, MS SQL Server 2012, SSIS, SSAS, SSRS, Hive, Spark and HP-UX

Robi Axiata Limited, Dhaka, Bangladesh Jul 2010 – Oct 2013 Sr.Programmer

Responsibilities:

• Design, configuration and development of projects and integration with the IUM (Mediation) system.

• Ensured network, system and data availability and integrity through preventative maintenance and upgrades.

• Followed up with clients to ensure optimal customer satisfaction.

• Provided base level IT support to non-technical personnel within the business.

• Responsible for operation and maintenance of both online server and both backup and archival server.

Environment: Mediation (HPIUM4.5), BSCS 8, Oracle 9i, MS SQL Server2005, HP-UX Dohatec, Dhaka, Bangladesh Feb 2005 - Jun 2010

Software Developer

Responsibilities :

• Implemented designs, including experimentation and multiple iterations.

• Consulted regularly with customers on project status, proposals and technical issues.

• Prepared detailed reports concerning project specifications and activities.

• Worked closely with other team members to plan, design and develop robust solutions in a timely manner.

• Modified existing software to correct errors, upgrade interfaces and improve performance.

Environment: ASP, ASP.Net, Microsoft Visual Studio, Ms.SQL Server, VB Script, Java Script, Visual Basic, Windows API, Java Applet, MS SQL Server in IIS 5.0 Platform.

EDUCATIONAL QUALIFICATON

University of Bridgeport, Bridgeport, CT,USA

M.S. in Technology Management (Major Information Technology) Shahjalal University of Science & Technology, Bangladesh B.S in Computer Science & Engineering

Contact this candidate