Data Analyst Manager
Resume:
Hashmat
Mob: +1-224-***-****
E-mail : **************@*****.***
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