Sql Server Data Quality

Tariq Hussain

**************@*****.*** (***) *** – 2481

EDUCATION

Computer’s System Institute – Chicago, IL

Business Career Program - Digital Multimedia Concentration JNTU University – India

Master of Technology in Digital Electronics and Communications Bachelor of Science in Electronics and Communications 2020 — 2021

2012 — 2015

2008 — 2012

TECHNICAL SKILLS

• Platforms: UNIX, Linux (Red Hat 5.x,6.x), CentOS, Windows 8/7/Vista/ XP, UNIX

• Products: Service Now, BMC Remedy ARS 6.3, 7.1, 7.5, 7.6, 8.0, BMC Remedy ITSM 7.1, 7.5, 8.0, BMC Atrium CMDB 7.5

• Software Applications: Informatica Power Center/10.1 10/9.6.1/9.5/9.1/8.6, Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), MDM, SSIS, Salesforce, DataStage, Visual Studio, VS Code, etc.

• Internet: Remedy Mid-Tier, Remedy Web Services, HTML, JavaScript, XML, JSON

• Tools: Remedy ARS 5.x/ 6.x/ 7.x, Remedy ITSM 6.x/7.x Incident, Change, Problem, Asset, Service Now, SLM, Remedy Administrator, Developer Studio, Crystal Reports, BMC AIE, BMC Remedy Migrator, BMC Dashboard, BMC Service Request Management 7.6, HP DDM Discovery and Dependency Mapping.

• Reporting Tools: Crystal Reports 9, Remedy Reports

• Database Tools: SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), Teradata, AQT v9 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN, Oracle 8, 9, 10g, Ms Access, Ms Sql Server.

• Programming Languages: Java Script, HTML, SQL, Python

• Graphic Design: Photoshop, Adobe, Digital Image Processing, Webpage Styling, Web Content Management

• SEO\SMO: Google Search Console, Google Analytics PROFESSIONAL SKILLS

• Strong organizational and prioritizing skills with high level attention to detail

• Java Script, HTML, and XML, Workflow experience - Excellent verbal and written communication skills

• Strong troubleshooting skills to quickly resolve production issues from end user (UI) to persistence layer per business and technical requirements

• Upgrade and patch management skills, experience

• Good Leadership skills and a proven record of ability to influence business or IS colleagues

• Strong planning, organizational and coordination skills

• Excellent communication skills with an ability to explain plans and activities clearly and concisely. EXPERIENCE

Retail Store Manager, Burlington Sep 2023 - June 2024

• Highly motivated manager driving sales growth, improving customer satisfaction, and reducing operational costs.

• Skilled in developing and executing effective customer engagement and visual merchandising strategies as well as analysing sales data to identify opportunities for targeted promotional campaigns.

• Expert in point-of-sale (POS) systems, meeting ambitious sales goals and training sales associates on cashier, sales floor, inventory and customer service functions.

• Payroll budget management, workforce management and scheduling.

• Conducting interviews, on boarding and training for new associates, provide on-going coaching in the moment and implement structured learning and development activities for all team members. Tariq Hussain

**************@*****.*** (224) 795 – 2481

• Directed management and oversight of Assistant Managers, Supervisors and Store Associates to ensure implementation of established company policies.

• Review receiving, transfers, debits/damages, returns-to-vendor (RTV's) and charge-back paperwork to ensure accuracy of inventory. Proven track record in training and coaching teams to deliver exceptional customer service and achieve business objectives. Hiring, training and overseeing new staff.

• Complied with all government regulations to maintain a minimal level of liability for the retail location. Examples: OSHA Wage and Hour Law, EEO, Sales Tax, etc.

• Motivating the sales team to meet sales objectives by training and mentoring staff.

• Creating business strategies to attract new customers, expand store traffic and enhance profitability.

• Responding to customer complaints and concerns in a professional manner.

• Ensuring store compliance with health and safety regulations.

• Developing and arranging promotional material and in-store displays.

• Preparing detailed reports on buying trends, customer requirements, and profits. Senior Python Developer, L&T June 2021 - June 2022

● Developed Architecture for Parsing applications to fetch the data from different services and transform to store in different formats.

● Experience in MVC architecture using Django for web-based application in OOP concepts.

● Implemented Algorithms for Data Analysis from Cluster of Web services.

● Developed web page and form validation with team using Angular.JS, React.Js, Node.js, HTML5 & CSS3.

● Developed the tools using Python Django and used MongoDB for databases. Parsers written in Python for extracting useful data from the design database. Used Parse kit (Enigma.io) framework for writing Parsers for ETL extraction.

● Contribute to the client's development standard practices of Microservice architecture by developing reusable product extensions and writing knowledge articles based on experience.

● Integrate the dynamic pages with Angular 6 and j-query to make the pages dynamic

● Worked in API group running Jenkins in a Docker container with RDS, GCP slaves in Amazon AWS.

● Worked on MongoDB concepts such as locking, transactions, indexes, Sharding, replication, schema design.

● Developed multiple spark batch jobs using Spark SQL and performed transformations using many APIs and updated master data in Cassandra DB as per the business requirement.

● Engineered a data processing pipeline with GCP, API, CSS, API & OpenSlide APIs to pre-process large-scale

● As part of the POC migrated the data from source systems to another environment using Spark, SparkSQL.

● Developed and implemented core API services using Python with spark.

● Configuring auto scalable and available Microservices set with monitoring and logging using AWS, Docker, Jenkins, Splunk.

● Created Terraform scripts for EC2 instances, Elastic Load balancers and S3 buckets.

● Implemented Terraform to manage the AWS infrastructure and managed servers using Chef and Ansible.

● Upgrading and maintaining the JavaScript libraries and widgets so that data is managed the same way.

● Used PySpark-SQL to load JSON data and create schema RDD, Data frames and handled Structured data using Spark-SQL

● Used PowerShell scripts to automate tasks and test functions

● Built numerous Lambda functions using python and automated the process using the event created.

● Developed Merge jobs in Python to extract and load data into MySQL database.

● Created data frames in particular schema from raw data stored at Amazon S3 using PySpark. Tariq Hussain

**************@*****.*** (224) 795 – 2481

Informatica Developer and Analyst, Abbvie March 2020 – November 2020

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, and support for production environment.

• Defined, configured, and optimized various MDM processes including landing, staging, base objects, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM Hub console.

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target databases.

• Involved in extracting the data from the Flat Files and Relational databases into staging areas.

• Created Stored Procedures for data transformation purpose.

• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management

• Worked on Informatica Power Center 9 x tools – Source Analyzer, Data warehousing designer, Mapping, Designer, Mapplet & Transformations.

• Worked on Database migration from Teradata legacy system to Netezza and Hadoop.

• Worked in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

• Used Teradata Utilities (BTEQ, Multi-Load, and Fast-Load) to maintain the database. Built a reusable staging area in Teradata for loading data from multiple source systems using template tables for profiling and cleansing in IDQ

• Actively involved in Exceptional handling process in IDQ Exceptional transformation after loading the data in MDM and notify the Data Stewards with all exceptions.

• Worked on Autosys as job scheduler and used to run the created application and respective workflow in this job scheduler in selected recursive timings.

• Generated PL/SQL and Shell scripts for scheduling periodic load processes.

• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.

• Invoked Informatica using "pmcmd" utility from the UNIX script.

• Wrote pre-session shell scripts to check session mode (enable/disable) before running/ schedule batches.

• Involved in supporting 24*7 rotation system and strong grip in using scheduling tool Tivoli.

• Involved in Production support activities like batch monitoring process in UNIX. Tariq Hussain

**************@*****.*** (224) 795 – 2481

Service Now IT Administrator, Genpact

Client: Allstate

June 2015 – June 2018

• 4+years of experience in IT industry as Service Now Admin.

• Understanding and representing your customer’s needs as part of providing IT services that meet or exceed those business needs.

• Responsible for the optimal operation of our environment by actively investigating issues and solving problems before they occur

• Working with ITSM team members, internal customers, and external partners to design, develop, configure, test, document, and deploy new functionality and fix existing issues

• Updates & maintains a comprehensive testing protocol for Service-now instance upgrades with the purpose of certifying all applications for use after the upgrade completes

• Escalates performance issues, unresolvable incidents and service interruptions to Service-now technical support. Creates and updates incident records in Service-now’s tracking system

• Knowledge of ServiceNow applications for Incident, Change, Problem, CMS, Facilities, Knowledge, CMDB and reports / metrics, as well as Performance Analytics

• In depth understanding of ServiceNow functionality and how ITIL processes can be implemented in ServiceNow including, but not limited to Incident Management, Change Management, Problem Management, Asset Management, CMDB Management, Service Catalog, Knowledge Management, and Service Portal modules

• Use data-driven techniques, analyze and interpret data.

• Demonstrate proven leadership skills and the ability to influence others at all levels of an organization

• Communicate effectively to team members on a regular basis

• Work across functional areas to drive continuous improvement

• Strong technical skills, including knowledge and relevant experience in SDLC

• Perform system and application configuration and management

• Complete development, configuration and workflow administration to support business processes

• Coordinate with business owners for modifications and changes in ServiceNow

• Perform QA testing and UAT testing

• Develop, maintain and publish documentation regarding use of Service Now enhancements

• Apply knowledge of technical components such as LDAP, SSL and cloud-based technology

• Configure User Accounts, Groups & Roles

• Use the UI to administer Tables, Fields and Relationships

• Add configuration items to CMD

ServiceNow Admin, Amazon August 2012 — March 2014

• Implementation, design and development of different modules in ServiceNow.

• Creation of Incidents and Service Requests for the supported applications, first point analysis on tickets and assigning them to L2/L3/other service lines based on the scope.

• Tracking of Incident from Opening to Closure, with timely communication to business.

• Communication with Business Clients and first point of contact/interface for application issues and outages between Business and Technology Team.

• Creation and Estimation of efforts for software change requests or enhancements.

• Team Progress Tracking.

• Coordinated service catalog options, cart controls and variables.

• Created various Crystal Reports such as Monthly reports, SLA Reports etc., on Demand as well as Scheduled reports.

Tariq Hussain

**************@*****.*** (224) 795 – 2481

• Investigated performance issues, use troubleshooting tools and system logs to find issues

• Integrated Workflows into applications

• Incident Management and Problem Management activities.

• Reviewing SLA performance and recommend corrective action.

• Work across the company IT process based on ITIL v3 framework and ServiceNow system.

• Utilize ServiceNow and Remedy problem management tools to open and track tickets

• Create new workflow and process for new Service Catalog Item in ServiceNow.

• Oversee Service Desk activity and reporting on out of SLA incident and Service request with ServiceNow.

• Strong IT record with Service now (ITSM) Ticketing tool.

• Strong knowledge of ITIL v3 methodologies, ITSM concepts, enterprise IT architecture, relational databases.

• Ability to work flexible hours and be available 24x7x365

• Created Pivot tables and charts using worksheet and data external resources, modified pivot tables, sorted items and group data and refreshed & formatted pivot tables.

• Experienced with Vlookups and data sorting & filtering.

• ITIL Certified

• Lean trained

• Experience in installation, Upgrade and configuration of MS SQL Server database..

• Quickly resolve all IP network issues to reduce waste and downtime while also ensuring client Service Level Agreements.

• Recommended design changes for network systems that included router, switch, and firewall configuration.

Contact this candidate