Post Job Free

Resume

Sign in

Data Analyst Manager

Location:
San Diego, CA
Posted:
April 19, 2021

Contact this candidate

Resume:

Hashmat

Mob: +1-224-***-****

E-mail : adls63@r.postjobfree.com

Professional Experience Summary

Hina Hashmat has 12 years of IT consulting experience

She has 9 years of quality experience in designing and development of ETL jobs using IBM DataStage.

She has 2+ years of extensive experience in conducting requirement analysis, architecture design, implementation and reporting systems in client/server architecture and networked environments as a PeopleSoft EPM Consultant.

She has excellent work experience as a Technical Manager.

She has strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing projects.

She has been involved in designing DW concepts like conformed dimensions, conformed facts and Data Warehouse bus architecture for ETL development.

Strong foundation of knowledge around AWS Cloud services and the cloud ecosystem

She has excellent team management, consulting and interpersonal skills with high learning ability, has a positive and structured approach towards work and good communication skills.

She has experience with creating, updating and contributing to project plans and proficiency with creating technical documentation using MS Word, Excel, Visio, and other similar tools.

She has good experience in Frontend and Backend development.

She has excellent experience in Web Application Development.

Good knowledge in various phases of SDLC Requirement Analysis, Design, Development and Testing on various Development and Enhancement Projects.

She has good problem solving, analytical skills, multitasking ability, accepts challenging jobs, can work as an individual and as well as in a team environment. .

She is Flexible enough to handle any kind of situation/environment and adherences to strict timeliness for project deliverables.

She has displayed her knowledge in providing help to the clients in the designing, development, testing, and implementation of data warehousing applications.

Professional Certifications

IBM DB2-UDB 700

IBM Datastage v7.5

IBM Datastage v8.0

IBM DB2-UDB 730

AWS Certified Cloud Practitioner

Artificial Intelligence for Project Managers

Become a Technical Program Manager

Skill Set

ERP: PeopleSoft HRMS, PeopleTools 8.4x, EPM.

Database: DB2, Informix, Oracle, PLSQL, MySQL

Languages: Java, SQL, UNIX, HTML, ASP, Java Script, C

O/S: Windows, UNIX, LINUX

Reporting Tool: SQR

Processes: IBM’s QMS (Quality Management System), Agile, Change Management and IBM AMS (Application Management Services), Waterfall, Scrum, JIRA, SDLC, SOA, Hadoop

Tools: DataStage, Putty, Remedy, MS Access 97, PVCS, Clear Case

Academic Achievements:

Post Graduate Diploma in Business Administration (M.B.A.) from Symbiosis Centre for Distance Learning, Pune –Year 2013 with Grade awarded as “A”

Graduation through Bachelor of Engineering (B.E) from Govt. Engg College, Rewa – Year 2006 with aggregate score of 80%.

Class XII th from Frommans Memorial Higher Secondary School, Rewa – Year 2001 with 81% marks.

Class X th from Frommans Memorial Higher Secondary School, Rewa - Year 1999 with 80% marks.

PROJECT HIGHLIGHTS

Projects 1: Tribolatech Inc. Remote

Client

apexanalytix

Role

Technical Manager/Data Analyst

Organization

Tribolatech Inc.

Duration

Sep 2020 – Jan 2021

Team size

5

Tools, Utilities & Environment

Informatica, Agile, Change Management, Waterfall, Scrum, JIRA, SDLC, SOA

Project Description

apexanalytix revolutionized recovery audit with advanced analytics and the introduction of first strike overpayment and fraud prevention software. Today, apex also leads the world in supplier management innovation with apexportal and smartvm, now the most widely used supplier onboarding and compliant master data management solution in global procure to pay processes.

Job Responsibilities:

Managed Services Delivery:

●Skilled in providing effective leadership in fast-paced, deadline driven environments.

●Outstanding presentation and communication skills and able to understand business requirements to cross-collaborate and increase profits.

●Lean the cost of complex business problems, by providing the technical solution.

●Work closely with the management team to identify strategic IT initiatives and facilitate the adoption of technology-based solutions.

Contributions:

●Proficient in determining system requirements and resolving technical issues.

●Recommend IT solutions that solve unique challenges we faced during working in the project.

●Led the efforts to define, analyze, and implement technical and functional requirements.

Projects 2: Star Icon Consultancy Services Delhi, India

Client

EPL Limited

Role

Sr. Data Specialist/Data Analyst

Organization

Star Icon Consultancy Services

Duration

Sep 2016 – Sep 2020

Team size

5

Tools, Utilities & Environment

DataStage, DB2, UNIX, AWS, Scala, Spark, Hadoop, Hive, Sqoop

Project Description

EPL Limited, is the largest specialty packaging global company, manufacturing laminated plastic tubes catering to the FMCG and Pharma space. These facilities cater to diverse categories that include brands in Beauty & Cosmetics, Pharma & Health, Food, Oral and Home, offering customized solutions through continuously pioneering first-in-class innovations in materials, technology and processes.

Job Responsibilities:

Managed Services Delivery:

●Manage technical and functional resources in the team, lead project planning.

●Gather requirements and deliver technical/functional tasks for new projects as well as production support.

●Handle escalations and manage resource requirements.

●Provide technical leadership and mentor team members

●New Customer Requirement analysis & Resource availability and allocation management and SLA management

●Team Meetings, Internal Team Improvement Analysis, Trainings, Up to Date Document Library Management.

●Risk Assessment: Manage and review all changes in DataStage jobs and validates their impact to production environment

Contributions:

●Working with diverse professional in global environment

●Exposure on Project Management Activities.

●Preparation of RCAs: In distributed, multi-technology customer solutions with multi-channel access through diverse devices and client applications, analyzing the root cause of an incident requires a systematic top-down approach to arrive at the root cause of an incident. Prepared many RCAs and fulfilled all the action items on time.

●Translating numbers and facts to inform strategic business decisions

●Onsite-Offshore coordination: Handled the coordination between offshore onsite teams to attain the same skill level and understanding.

●Investigation of Performance issues: Participate in investigating the Performance problems to understand issues. Performance tuning and workload analysis.

●Build and review functional and business specifications

●Solving integration issues: Troubleshoot issues between multiple interfaces and involve and coordination with Functional teams and DBAs

●Involved in the requirement analysis and Implemented Enhancements & Change requests. Maintained change request log for the same

●SWAT calls: Open the call for critical problem to involve all parties for end to end support to get a solution and decision-making

Projects 3: Blue Harmony (iERP) Noida, India

Client

Blue Harmony

Role

Sr. Data Specialist

Organization

IBM India Pvt. Ltd.

Duration

Apr 2010 – Jun 2016

Team size

10

Tools, Utilities & Environment

DataStage 8.0, SAP-plug-in(BAPI, IDoc, ABAP)., Snowflake, MQ plug-in,XML,DB2, UNIX

Project Description

Blue Harmony (iERP) is an enterprise transformation program that will take business unit and region-specific core processes such as Quote to Cash and Finance and integrate them horizontally across the enterprise on a common SAP platform.

Job Responsibilities:

Managed Services Delivery:

●Provide technical leadership and mentor team members

●New Customer Requirement analysis & Resource availability and allocation management and SLA management

●Team Meetings, Internal Team Improvement Analysis, Trainings, Up to Date Document Library Management.

●Risk Assessment: Review all changes in Data Stage jobs and validates their impact to production environment

Contributions:

●Working with diverse professional in global environment

●Exposure on Project Management Activities.

●Preparation of RCAs: In distributed, multi-technology customer solutions with multi-channel access through diverse devices and client applications, analyzing the root cause of an incident requires a systematic top-down approach to arrive at the root cause of an incident. Prepared many RCAs and fulfilled all the action items on time.

●Onsite-Offshore coordination: Handled the coordination between offshore onsite teams to attain the same skill level and understanding.

●Investigation of Performance issues: Participate in investigating the Performance problems to understand issues. Performance tuning and workload analysis.

●Solving integration issues: Troubleshoot issues between multiple interfaces and involve and coordination with Functional teams and DBAs

●Worked on DataStage Client Administration.

●Worked as a DataStage developer for extracting the data from the source system (SAP or other applications) and to build the target (SAP or other applications) Using the DataStage 8.0 as the ETL tool.

●Client Administration – Remote/local client copy, client opening

●Experience on maintenance and support of production ETL processes.

●Unit testing and resolving bug found during QA and Production testing along with maintaining defect logs

●Creating jobs for loading data into staging tables, dimension tables and fact tables, from the source files and DB2 Database.

●Developed complex mappings against IDOC and RFC structures.

●Document management through SolMan.

Projects 4: UB Project-Chrome Offshore Gurgaon, India

Client

United Biscuits

Role

Technical Developer

Organization

Tata Consultancy Services

Duration

Mar 2010 – Apr 2010

Team size

15

Tools, Utilities & Environment

Oracle, Visual Basic, Filezilla, Manugistic

Project Description

UB is a leading European manufacturer of snacks and biscuits. We were providing application support and development services using onsite/offshore model.

Job Responsibilities:

Managed Services Delivery:

●Problem and Resolution Management to avoid recurrence of incidents.

●Team Meetings, Internal Team Improvement Analysis, Trainings, Up to Date Document Library Management.

Contributions:

●Analysis of the existing data as per Application Change Request created by client.

●Development and preparing scripts.

●Preparation and execution of unit test cases.

●Preparation of Technical Specification.

●Preparing technical and business documentation

●SWAT calls: Open the call for critical problem to involve all parties for end to end support to get a solution and decision-making

Projects 5: Informix MSR Development Chennai, India

Client

The Home Depot

Role

Technical Developer

Organization

Tata Consultancy Services

Duration

Sep 2009 – Feb 2010

Team size

8

Tools, Utilities & Environment

Unix, Informix, ClearCase, Beyond Comparator

Project Description

The Home Depot is an American retailer of home improvement and construction products and services. We were building easy to use front end tools and processes for Merchants and Supply Chain Analysis of the existing data as per Application Change Request created by the client.

Job Responsibilities:

Managed Services Delivery:

●Gather requirements and deliver technical/functional tasks for new projects as well as production support.

●Mentor team members

Contributions:

●Requirement analysis which involves:

Understand customer high level expectations

Thorough understanding of testing process, methodology and applicable standard/guidelines.

●Design Understanding

●Coding, Development and preparing scripts.

●Preparation and execution of unit test cases.

●Preparation of Technical Specification

●Investigation of Performance issues: Participate in investigating the Performance problems to understand issues. Performance tuning and workload analysis.

Projects 6: PeopleSoft US/EMEA/APLA/Canada Development Mumbai, India

Client

Honeywell

Role

Technical Developer

Organization

Tata Consultancy Services

Duration

Jun 2009 – Aug 2009

Team size

15

Tools, Utilities & Environment

PeopleSoft 8.3 HRMS, Oracle, Unix, SQR, PeopleTools 8.42, Application Designer, Application Engine, People Code, DB2

Project Description

Honeywell is a leading manufacturing company in US/EMEA/APLA/Canada. We have supported the PeopleSoft US/EMEA/APLA/Canada regions which includes enhancements as per the business needs.

Job Responsibilities:

●Requirement understanding and determining its feasibility and impact on the existing functionalities.

●Analysis of the existing module

●Developing the module and unit testing.

●Preparation of Technical Specification

Projects 7: Target Corporation Chennai, India

Client

Target

Role

Team Member/Offshore-Enhancement Coordinator

Organization

Tata Consultancy Services

Duration

Aug 2007 – May 2009

Team size

15

Tools, Utilities & Environment

UNIX, DB2,DataStage, PVCS, Control-m scheduler

Project Description

Target corporation is one of the largest retailers in the USA. We have supported the EPM application (Data from EPM goes to the PeopleSoft) which includes batch support and enhancements as per the business needs

Job Responsibilities:

●As a team member did Production batch support and worked on ETL tool DataStage, including:

Analysis of the existing application.

Schedule, run, and monitor jobs all within DataStage

Create batch (controlling) jobs

Experience on maintenance and support of production ETL processes.

Excellent experience on Frontend and Backend development.

Design Jobs

As a tester needs to verify that addition of a new entity has not impacted the existing framework.

●Communicate activities/progress to Team Lead, business development, and Team Members.

●Web Application Development.

●Offshore- Enhancement coordinator- Did job design, testing and implementation of Enhancements and responsible for delivering the Enhancements on time.

Experience Summary:

Period

Employer

Location

Designation

Sep 2020 to Jan 2021

Tribolatech Inc.

Remote

Team Manager

Sep 2016 to Sep 2020

Star Icon Consultancy Services

Delhi India

Sr. Data Specialist

April 2010 to June 2016

IBM India Pvt. Ltd

Noida/India

Senior System Engineer

May 2007 to April 2010

TATA Consultancy Services

Chennai/India

Assistant System Engineer



Contact this candidate