Resume

Sign in

Data Manager

Location:
Columbus, Ohio, United States
Posted:
May 22, 2018

Contact this candidate

Mano

Cell: 614-***-****; Email: ac5khq@r.postjobfree.com

Highly skilled professional having experience in system analysis, design, development, and implementation of enterprise applications. Experienced in Big Data Technology stack, Data warehousing, ETL, Data Analyst, BI reports,BSS support,and Project Management.

Expertise in Big Data solutions in building scalable distributed data processing solutions with Hadoop.

Working on Cloudera Manager Bigdata Hadoop Distributor.

Knowledge on Hortonworks and Ubuntu Hadoop Distributors.

Working as a Hadoop Developer in all phases of Hadoop and HDFS development.

Knowledge on Lambda Architecture.

Working on HDFS, MapReduce and Hadoop Ecosystem such as Pig, Hive, Flume,Kafka,YARN,Oozie, HBase, Zookeeper and Sqoop.

Well versed with developing and implementing of MapReduce jobs using Hive and Pig to work on Big Data.

Knowledge on Kafka server, and Spark.

Experience in NoSQL database like HBase.

Procedural knowledge in cleansing and analyzing data using HiveQL, Pig Latin, and custom MapReduce programs.

Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems such as Oracle, MS Sql, and My Sql and vise versa.

Working on Data visualization using Tableau.

Experienced in Informatica power center and Knowledge on Informatica big data edition.

Experience in Data wrangling such as reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources.

Worked on Data wrangling methodologies using Trifacta and Talend.

Worked on implementing ETL methodologies using SSIS, and Talend, and Knowledge on Informatica Power Center.

Extensive experience as a DWH Technical Analyst, provided Business Intelligence and Data Warehouse solutions using Microsoft Data Tools, IBM Cognos FM, and BI reports (Cognos Report studio, Tableau, Power BI).

Experienced in Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.

Worked on IBM Cognos Framework Manager, Query Studio, Report Studio, work space Advance and Cognos Administration.

Experienced on various Databases like MySQL, Oracle, and MS sql.

Extensive experience with SQL in designing data base objects such as Tables, functions, procedures, triggers, Views and CTE’s.

Experienced in Project Management,Change Mangement,Vendor Management,Agile Scrum master, Business analyst and Data Analyst, and knowledge on SDLC and STLC.

Certified Scrum Master,ISTQB,and trained on PMI-ACP.

Quick learner and Good Team player.

Having Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.

Technical Skills

SQL Server Tools

SQL Server Management Studio 2008/ 2012, SQL Profiler, SSRS, SSIS, and SSAS

ETL

SSIS, Talend

BI Reports

Cognos, Tableau, SSRS, Power BI

Analysis Tools

SSAS

Databases

SQL Server 2008/ 2012, My SQL, Oracle10G/11G

Data Modeling tool

CA Erwin Data modeler, IBM Cognos Framework Manager

Database Management tools

Oracle SQL Developer

Operating Systems

Unix/Linux, Windows XP, Windows2000/98/95, Windows 7/8/10

Languages

C, SQL

Big Data

Hadoop, Pig, Hive, Sqoop, HBase, MapReduce, Flume, Hive, Cloudera Manager, Horton works, and Ubuntu

Data Wrangler Tool

Trifacta

Project Management Tools

JIRA

Professional Experience

COX communication Jan 2017- Mar 2018

Big Data Hadoop Developer

Evaluate business requirements and prepared detailed specifications that follow project guidelines required to develop written programs.

Responsible for building scalable distributed data solutions using Hadoop.

Analyze large amounts of data sets to determine optimal way to aggregate and report on it.

knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.

Working on Hadoop Ecosystems such as HDFS, Map Reduce, Hive, Pig, Flume, HBase, and Sqoop.

Data import from different databases like MySQL, MS SQL Server and Oracle into HDFS using Sqoop.

Developing Map reduce Jobs using Hive and Pig.

Developing Pig Latin scripts to extract the data from the web server output files to load into HDFS

Exporte the analyzed data to the relational databases using SQOOP for visualization and to generate reports for the BI team.

Working on writing hive queries(HQL) for run MapReduce jobs.

Working on Hive partition and bucketing concepts, created hive External and Internal tables with Hive partition, and wrote adhoc HiveQL queries to process data and generate reports.

Experience in processing of data from various data sources into HDFS systems using Kafka and Flume, and configured Kafka topics, partitions, topics.

Experience in working with different file formats like Avro data files, xml files, and Json files.

Configuring Kafka topics for import batch and real time data into Hadoop.

Loading data from different source (database & files) into Hive using Talend tool.

Loading data into the cluster from dynamically generated files using Flume and from relational database management systems using Sqoop.

Working as Data wrangle for converting and transforming of data as JSON, TDE files for Data visualization.

Using Reporting tools like Tableau for fast analytics for Business users.

Environment: Bigdata Hadoop, Cloudera Manager, Sqoop, Flume, Kafka, Pig, Hive, Oracle DB, MySQL DB, Trifacta,Talend,Tableau.

Safeco Insurance Aug 2016-Dec 2016

Big Data Hadoop Developer

Analyzed large and critical datasets using Cloudera, HDFS, HBase, MapReduce, Hive, Hive UDF, Pig, Sqoop, and Zookeeper.

Imported data from MySQL to HDFS using Sqoop

Wrote PIG scripts for performing MapReduce jobs in Hadoop.

Created Hive tables, writing HQL for querying and managing data in HDFS.

Creating Hive Tables, loading with data and writing Hive queries which will invoke and run MapReduce jobs in the backend.

Implemented dynamic Partitions and Bucketing in Hive for efficient data access.

Loading data into the Hadoop distributed file system (HDFS) with the help of Kafka.

Developed PIG scripts for the analysis of semi structured data

Worked on Oozie to develop workflows of Sqoop, MapReduce and Hive jobs.

Worked with application teams to install operating system, Hadoop updates, patches, version upgrades as required.

Solved performance issues in Hive and pig with understanding of Joins, group and aggregation and how does it transfer to Map-Reduce.

Worked with NoSQL databases like HBase in creating HBase tables to load large sets of semi structured data.

Used Reporting tools like Tableau for fast analytics for Business users.

Environment: Bigdata Hadoop, Cloudera Mangaer,Sqoop, Flume, Hive, Pig.

ICL July 2015- June 2016

Big data Developer

Installed Hadoop distibutors such as cloudera and Horton works.

Participated in the Bigdata initiative sessions and organized inhouse sessions.

Gathered requirements form business and actively involved in selection of eco sysytems.

Imported data from MS SQL to HDFS using Sqoop.

Worked on Database migration from traditional databases to HDFS.

Wrote PIG scripts for performing MapReduce jobs in Hadoop.

Created Hive tables, writing HQL for querying and managing data in HDFS.

Developed PIG scripts for the analysis of semi structured data.

Worked with application teams to install operating system, Hadoop updates, patches, version upgrades as required.

Environment: Bigdata Hadoop, Cloudera Mangaer,Sqoop, Flume, Hive, Pig.

ICL Apr 2012- June 2015

SQL Developer

Installed, and configured MS SQL Server 2008/2012.

Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.

Created and modified database objects like tables, stored procedures, functions and triggers.

Used SQL Server Agent for scheduling jobs and alerts.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio

Performed day-to-day production support activities that are prioritized.

Identified fact and dimensional tables and Designed warehouse with star schema.

Migrated database from SQL servers to oracle servers using SQL developer.

Created SQL queries for data retrieval and Tuning SQL queries for better performance using SQL Profiler.

Created/enhanced numerous SSRS reports to support internal business users and support team to monitor various processes

Developed reports in SSRS and export them to EXCEL and PDF formats as requested by the business.

Created T- SQL queries, tables, Views, stored procedures and functions that are required for report generation.

Created functions for calculation purposes in SSRS.

Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.

Created ETL packages to validate, extract, transform and load data to data warehouse and data mart.

Designed and built OLAP cubes as per business requirements and generate adhoc reports.

Designed and developed SSIS packages to move data from different environments within the organization.

Performed various SSIS tasks, data validation checks during staging, and then loaded the data into the data marts.

Transformed data from various data sources using OLEDB connection by creating SSIS packages and schedule them as per requirement.

Designed and developed OLAP cubes using SQL Server Analysis Services.

Worked on Power BI and prepared dashboards to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.

Developed various data connections from data source to Tableau Desktop for report and dashboard development

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Developed various Dashboards using objects such as Chart Box (Drill Down, drill up & Cyclic Grouping), List, crosstab using Tableau.

Created dashboard reports using Tableau for Business users.

Worked on Cognos Framework Manager, Meta data Modeling, and Report studio.

Defined Database source in Frame work manager form different database server, configured Layers, packages, and DMR.

Worked on BI reports using Report studio such as List Reports, grouped reports, cross tab reports, Chart reports, Drill-Down and Drill-Through Reports.

Supported Business Users in generating Adhoc Reports using Query Studio.

created Active reports for remote users using Cognos BI.

Configured Data source connection, Security and JDBC connection using Cognos Administration.

Environment: SQLServer, SSIS(ETL), SSRS (Reports), SVN, Cognos FM, Cognos BI, Tableau, Power BI

ICL July 2010 -Mar 2012

PMO, Scrum master/Business Analyst

Lead team for enhancement /New project implementation, managed all phases of project development to ensure on time delivery, project continuity and internal consistency.

Developed project plans, testing plans, production deployment plans, costing and budgeting plans.

Prepared proposals, SOW, and resource allocation to ensure project accomplishment with in TAT.

Managed vendors and contractors to ensure on-time equipment procurement and installation, quality services as per business specifications.

Budget preparation and cost estimation to determine necessary funding for assigned area through projections.

Analyze and interpret financial data to determine and project budget needs.

Budget projection for CAPEX of network, project planning and control Capex/opex of the network.

Validation and approval of service vendors invoices and coordinated with invoice team to generate invoices on time.

Materials forecast for rollout and month on Month auditing, Performing Site Acceptance Tests for Improve Quality of network.

Worked between business and IT team to finalize the requirements and then converting them to functional specifications.

Proficiently Organized and facilitate daily scrum, sprint reviews, retrospectives, sprint and release planning.

Provided status reports, burn down charts, velocity and business value charts to business and product owners.

Drive a Scrum project, prioritize and organized backlogs into sprints, run the Scrum ceremonies by used Jira.

Worked as engineering representative on billing task force to define and resolve revenue issues.

Performed analysis of call routing through the network and determined the impact to billing because invoicing logic was directly tied to network configuration.

Assisted Business and IT teams in resolving billing issues.

Worked with multiple teams in environment setup and infra readiness for the project execution.

Update the Project tracker such as Daily and weekly status to project manager.

Signoff on technical strategy document and working towards change in scope management.

Worked on business requirement with immediate implementation with the help of change request.

Worked towards project scope and update to business on deliverables as per the scope.

ICL Dec 2008 – June 2010

IT support

Gathered Business requirements and spearheaded for IT infrastructure establishments for new Business outlets.

Responsible for Environment setup and supported for new installation, configuration and upgradation of servers, routers, work stations and network systems.

Supported for new installation/upgradation of software’s, enterprise business applications, and authorized desktop applications on Microsoft terminal services (windows 2005/2008/XP/7/8).

commissioned and Decommissioned of users, created users, and enable/disable of user access.

Worked with vendor support teams to resolve technical issues, and involve corporate IT teams for resolve of critical issues.

Coordinated for Integration, Backup, and Migration activities.

Created users, roles and profiles according to the application requirement.

Maintained Application support tickets and follow up with the product companies.

Requirement gather from regulatory bodies, identified the reports and columns impacted in database.

Updated metadata as per the data definitions and logical names for all the impacted column elements in the Master database.

Coordinated with business to make sure the definitions are as per the context.

Updated monitoring rules for all the columns, verified the current and Target databases are updated and validated the data matches.

Worked closely with Business on requirements and Data analysis.

Aircel Aug 2007 – Nov 2008

Data Analyst

Requirement gather from regulatory bodies, identified the reports and columns impacted in database.

Updated metadata as per the data definitions and logical names for all the impacted column elements in the Master database.

Coordinated with business to make sure the definitions are as per the context.

Updated monitoring rules for all the columns, verified the current and Target databases are updated and validated the data matches.

Worked closely with Business on requirements and Data analysis.

Integration and testing of BSS systems.

Analyzed the network performance reports, performed Network Optimization and Drive test for improve the Qos & KPI.

Leading team for all project, operation & Maintenance activities.

Done Order management, Service provisioning, and Inventory Management of network systems.

L1 support for customer complaints and processed customer complaints tracker on daily basis.

Coordinated with network operation centre, and Network teams for solving of network operation issues.

Commissioned of Microwave hops, Transmission media, Fiber nodes, and provided BW in the network.

Performed preventive, corrective maintenance and improved network availability.

Planned for Network expansion, and TRU addition depends on network traffic and coverage blocks.

Assess of vendors, validation of invoices and coordinated with team to submit Invoices on time for payment.

Aster Apr 2005 - July 2007

BSS Support

System Integration, Testing and Maintenance of OSS and BSS.

Fault and Trouble Management of BSS systems.

Trouble shooting of network alarms, Generated network performance & and network traffic reports using PROPTIMA.

Maintained daily activities tracker and network service performance logs.

Provided Integrated solutions such as Network Performance and Network Service Assurance.

Provided Point-Point/Multi point wireless access solutions, enabled Broad band access to homes and corporates.

Worked on network optimization, new nominal, and MW/LOS path selection for Network enhancement.

Planned on swap/Upgradation of BSS equipments, BW provisioned in MW and Optical Fiber Nodes.

Completed Integration testing of services, and User Acceptance testing for Telecom Applications.

Performed preventive maintenance of cell sites, done the errors rectification of Network.

TTSL May 2004 -Nov 2004

BTS support

Operation & Maintenance of BSS, Optimization of Network and rectification of RF issues.

Improved Performance of BSS, Network Traffic, and Backbone connectivity.

Managed POI, and Telco Bandwidth.

NSIC Nov 2003 – Apr 2004

Production & Testing, WLL

`

ECIL Oct 2002 – Sept 2003

Production & Testing, SCADA & WLL

SInstruments July 2001 – Sept 2002

Quality control, Production



Contact this candidate