Onboarding Specialist/ Data Analyst Resume

PROFESSIONAL SUMMARY:

13+ Years of IT experience with experience
Excellent knowledge and experience in data warehouse design and implementations
Key Expertise in various database like Oracle, MS SQL Server, My Sql, Sybase, Aster data etc
Extensively involved in programming with SQL queries, PL/SQL programs, Stored Procedures, Triggers, Functions, creating Tables, Views, Indexes Conceptual models from system requirements, produced logical design, database schema, analyzed transactions and large data volumes
Played key role in data modeling, data migration, data cleansing, data mining & data scientist
Experienced in monitoring and optimization of query/ procedure/ function performance tuning
Performed complex ETL transformation using Informatica, Dell Boomi, Informatica, DTS, SSIS, SQL*Loader, Pentaho ETL tools
Data Migration process and tuning of BI reports and processes
No Sql database knowledge includes HBase, Cassandra, MangoDB
Posses knowledge language like ‘R - Language’, SAS, Python etc
Development, testing and deployment of Business Intelligence (BI) solutions including Data Warehouses, Business Object, Tableau and Pentaho
Knowledge on Apache Hadoop, MapReduce, Pig, Hive, HBase, Sqoop, Flume, Oozie, Machine learning. Shark Sql, Scala, Spark
Excellent analytical, communication skills, work ethics and have the ability to work in a team environment with strong determination and commitment to the deliverables
Extensive experience in complete Software Development Life Cycle (SDLC) including requirements gathering, system analysis, architecture & design

PROFESSIONAL EXPERIENCE:

Confidential

Environment: MongoDB, SQL, Oracle, Dell Boomi, Unix, AWS

Onboarding Specialist/ Data Analyst

Responsibilities:

Support pre-sales, POC and deployments with scoping, requirements gathering
Work with Customer Success Manager and on-boarding specialists ensuring successful delivery of apps
Responsible for delivery of multiple customer deployments across Elementum’s Supply chain applications product suite
Created and implemented various solution like Onboarding Mongo Gateway (OMG) for accessing mongo data, multisource SQL browser, automated geocode finder tool
Responsible for Implementing and managing reporting infrastructure using SQL databases, MongoDB
Data Migration from MongoDB to MySQL using OMG and Dell Boomi
Work with Customer success manager during key milestones such as key user training, user acceptance testing, and go-live
Support global rollout of Elementum's managed services, providing first generation data capture from customer partner network (Suppliers and Logistics Service Providers) that do not have automated EDI communication infrastructure in place
Work with operations/I.T. teams within partner organizations to identify and set compliance levels with regard to consistent collaboration of advanced shipment notifications, carrier milestone events and other critical data sets relevant to shipment visibility
Implement sustainable communication protocol for partners within customer supply chain that aligns with service level expectations to timely capture data and upload via any/all forms of coms. Establish and utilize best practices, to proactively identify and correct any data integrity issues
Perform analysis and root cause determination for all partners. Monitor and evaluate compliance, performing analysis & root cause determination that will ensure quality control standards are maintained and improved over each period of measurement
Model compliance levels and measurement standards with Elementum’s managed services policies and procedures to support mission, values and standards of Elementum

Confidential

Environment: Oracle, Business Object, Informatica, Hadoop, Map-reduce, Java, Pig, Hive, Oracle, R, SqoopScala, Spark, MLib

Sr. Data Architect/ Analyst, Project Lead

Responsibilities:

Leading project, coordination between business user, technical team (onsite and offshore) and various other teams of Juniper
Planning and scheduling, implementation and closing of project
Sql/ Pl/Sql and DB jobs development and maintenance
ETL design, Development, maintenance, monitoring daily, weekly & monthly jobs
Involved in different levels of testing like Integrating, System, and UAT
Designing the reports in WEBI as per the client’s requirement
Updating and enhancing the existing universes and Performance tuning
Production support activities
Juniper network’s big data world and extensively involved in multiple initiative related to it.
Involved various exercise from planning
Handled multiple solution
Migration projects from various sources (mostly databases/ file/SAP system) to hive, pig etc.
Used spark for data analysis and data discovery
Preparing lesson learned, user documents/ training document

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship