Professional Summary
**+ years of working experience in the Information Technology industry. I specialize in data management, business intelligence, analytics, and reporting.
Certifications
The following certificates can be verified by going to: https://mcp.microsoft.com/Anonymous/Transcript/Validate and using transcript id: 1223350 and password: hinacert
Nov 2017 – MCSE – Data Management and Analytics.
Jan 2017 – MCSA – SQL Server 2012/2014.
Mar 2016 – MCP – Microsoft Certified Professional.
Aug 2018 – Scrum Master Certification. Member ID: 822390
Oct 2019- Power BI Certified
Tableau Desktop Specialist (Badge)
American Heart Association Courses:
CPR AED Class and First Aid Class
Professional Skills
Data Analysis: For data analysis we perform 3 different stages:
oStep 1: Edit Query - where we connect to database, clean up data, remove null/errors.
oStep 2: Data Model - Create Relationship, create calculated columns also perform DAX
oStep 3: Report View - where we create reports, dashboard, apps.
Databases: Microsoft SQL Server, Microsoft Dynamic CRM 2010, Siebel (Oracle), Microsoft Access.
T-SQL: Database design, Advance Queries, Stored Procedures, Functions and Triggers
Business Intelligence, Analytics and Reporting: Expertise in querying, data mining, online analytical processing (OLAP), and reporting as well as business performance monitoring, predictive and prescriptive analytics. Used statistical analysis and predictive modeling to establish trends.
Business Intelligence, Analytics and Reporting Tools: Power BI, Tableau, Alteryx, SSIS, SSAS, SSRS.
Alteryx: Developed and deployed multiplied workflows into production, convert manual business process and old SSIS Packages into Alteryx (by using Preparation, join, IN/Out and Transformation tool).
SharePoint Development and Administration: Expertise in building forms and sites, displaying reports from SSRS. Experience in working with 3rd party components and controls.
Software: Proficient in Microsoft Office Suite Word, Excel, PowerPoint, Access, Visio. Microsoft Visual Studio
Professional Experience
Invited (ClubCorp) Manager Tableau (contract 03-2022-2023 present)
Responsible for Migration from Power bi to tableau, develop above 100 tableau dashboards including (redesign and develop and testing. Architecture/ design with team and provide training to the team.
Design and develop Alteryx package and automate business manual process. Architecture Alteryx workflows and converted all SSIS packages into corresponding Alteryx workflows and publish on server.
Establishing functional specifications for reporting apps requires an understanding of business needs. Shape data into reporting and analytics solution rapidly. Translate business needs to technical specifications, Design, build and deploy BI solutions.
Develop and execute database queries and conduct analyses, Develop and execute database queries and conduct analyses. Prepare all the documentation for reporting and provide training to the end users.
DXC Technology
Tableau: Senior Programmer Analyst (January 06, 2020, to 02-2022)
Develop and design Tableau Travel and Finance Dashboard by using heat and tree map and using GEO Code. Work with filter, parameters, actions, set and groups in Tableau. Work with live and extract data.
Architecture/design Dashboard and reports in both power Bi and Tableau.
Performs design, implementation and maintenance of complex multiple product modules/subsystems or on lower-level issues of multiple products to ensure proper functioning of products. Participates in product design meeting to ensure that design concepts are transferred into application development successfully.
Serves as product architect as necessary, to ensure design and implementation of product meets objectives.
Performs more complex product design, system analysis and programming activities on application software to ensure that company technology needs are met.
Simmons Bank
IT Analyst IIII / Power Bi (March 04-2019 to 12-31-2020)
Develop SharePoint Demand Management process and Architect solution include Development, Design and Test
Develop Dashboard/Reports by using Power BI, Tableau, python and share with Business users.
Analyze SQL Datawarehouse and develop views and Reports.
Provide solutions and understanding for using SharePoint and Power BI and SQL Database.
American Heart Association American Stroke Association
Tableau Developer – (Nov 2013 - 01-01- 2019)
Heart Association is a non-profit organization that fosters appropriate cardiac care in an effort to reduce disability and deaths caused by cardiovascular disease and stroke.
Responsible for managing Data warehouse for American Heart Association
Developed, maintained, and upgraded SSIS packages to support CPR & First Aid department.
Wrote and debugged complex queries. Wrote and maintained ETL packages.
Wrote reports using SSRS, Tableau and Power BI. Built Alteryx packages.
Developed Alteryx workflows and converted all SSIS packages into corresponding Alteryx workflows.
Developed Tableau Report and Dashboards. Develop Executive dashboard that displays Graphic presentation and maps.
Worked with business teams and project stake holders in understanding project objective and offering technical solutions to achieving desired results.
Delivered reports and status updates both verbally and in written format.
American Heart Association
Database Manager/Tableau Developer– July 2011 to Nov-2013
Responsible for managing company database in Siebel and generating reports from it.
Worked on SharePoint 2010 managing permission, generating sites and customize pages with C# code.
Worked with Microsoft Access database, creating reports, forms and maintaining backups.
Responsible for CPR Verify Application and its documentation. Provided support to CPR Verify team and its clients.
Worked on AHA application “Global Connector AHA” onlineaha.org, Online Key Manger and Instructor Network
Worked with Microsoft Dynamic CRM
Experience with Opera Report and Market Share Report in Siebel (Oracle).
Thorough understanding of AHA software applications and data structures.
Responded to and resolved database access and performance issues and conducted database transaction audits.
Worked with the application support and development teams for responsible databases.
Professional Experience (cont’d)
Agile Information Technology Group, Inc
SQL Server Developer – Jul 2009 to Jun 2011
Agile Information Technology Group, Inc. is a custom software development firm. I worked primarily for their client Big Commerce.
Responsible for leading, developing and optimizing reporting solutions using SQL Server Reporting Services (SSRS). Authored, managed, and delivered dynamic, interactive, drill-down web-based reports.
Analyzed massive and highly complex data sets, performing analysis using SSAS and data manipulation (ETL) using SSIS.
Discussed requirements on business intelligence needs with internal staff and external clients.
Dallas Fort Worth Minority Supplier Development Council
SQL Server Developer/ SQL Reporting Analyst – Aug 2007 to Jun 2009
DFW Minority Supplier Development Council is a none for profit organization with the goal of advancing business opportunities for certified Asian, Black, Hispanic, and Native American business enterprises.
Responsible for all SQL Database related issues. Responsible for NMSDC data collection and distribution. Database backup, recovery, and database reports. Worked primarily with SQL Server 2008.
Used SSRS (SQL Server Reporting Services) to create tabular and Matrix reports.
Responsible for completion of all reports required of National Minority Supplier Development Council (quarterly, year-end, special) and local reports for other agencies as directed by the president.
Responsible for Industry Group communication, information retrieval and sourcing. Responsible for NMSDC data collection and distribution; MBYSIS Management; also, the Liaison to Direct Connect, the IT Industry Group and works across Industry Groups and Working Groups on all data related projects.
Managed BYSIS database. Responsible for writing queries, reports, backup, recovery and ETL packages.
Professional Experience (cont’d)
Senior Whole Health (SWH)
SQL Server Developer – Feb 2006 to Aug 2006
Developed SSRS reports and presentations for executive and management teams. Worked closely with stakeholders to define, document, develop, maintain and supports repots built using SQL reporting services.
Maintained the research database and audited it from time to time and ensured safe storage of data.
Education
Bachelor in IT -Gujrat Institution of Technology
Diploma in Information Technology
(2) Hina Khawar LinkedIn