Data Analyst Sql Server
Resume:
Rafia Khan
Chicago, IL
*******@*******.***
Summary:
Excellent professional with experience working in data analytics and data visualization tools for solving business problems using data sets for Tableau and TIBCO, BusinessObjects, Qlik, MicroStrategy, Power BI.
Proficient in preparing ad-hoc reports based on requests from Executive Management utilizing a variety of reporting tools including: B2GNow, LCPtracker, Noetix, Excel, Oracle, and PowerBI, tableau, CONGNOS.
Well versed in utilizing Change Management by managing dashboard design to help business performance using SDLC and power BI as tool.
Skilled in compiling and analyzing large data sets for project reporting in EXCEL and tableau.
Skills:
Visualization Tools: Power BI, Tableau, BusinessObjects, Qlik, MicroStrategy,
Software Languages: SSMS, SSRS, SAS, SQL 2005, SQL 2008, SQL 2012, SQL 2015, and C#, VB.NET, CSV, JAVA.
Database: Oracle 10g, Structure and design using RDMS, DEVP 2008, DB2 IBM, MS-Access, ASP, SSIS SQL Server Integration Service is the tool to perform ETL operations, i.e., extract, transform and load data Client/ Server Architecture and SQL query writing and script running.
Operating Systems: MS-DOS, MS-Windows 95 and MS-Windows 98, Windows NT, Window Vista, Window 7, AS400, Reflection 3270, UNIX.
Hardware: IBM PC, Apple and compatible.
Software: Excellent MS Office skill such as MS Excel, VBA, Access, MS-Works, MS-PowerPoint, WordPerfect, Visio, SharePoint
Education & Training:
Bachelor’s Degree in Computer Science, Northeastern Illinois University, Chicago, IL
Project Management Classes, Institute Information Technology, Chicago, IL
Certifications:
MCTS (Microsoft certified technical specialist in MS Office 2007).
Master Certification Data Management and Analytics (IIT-Institute information technology) Dec 2012
Experience:
Kansas Department of Labor:
Data Base Developer/Data Analyst July 2022-Mar 2023
Work on statistics and GIS applications, including ArcGIS and other ESRI products
Provide data collecting and processing geospatial data, and using the data for map making
Worked with state and/or federal grants.
Reviewed and approved data modeling processes and DBMS specific requirements for basic and intermediate application database requirements.
Lead logical data modeling processes for complex applications database requirements and converted logical data models into physical data models for complex application databases.
Directed root cause analysis on complex incidents and lead the problem management. Experience working in data analytics and/or visualization tools and solving business problems using data sets for Tableau
Worked on data visualization tools like BusinessObjects, Qlik, MicroStrategy, Power BI.
Lockheed Martin US Aviation (Sun Technologies) Nov 2021- Mar 2022
Data Base Developer/Data Scientist
Experience working in data analytics and/or visualization tools and solving business problems using data sets for Tableau and TIBCO.
Worked on data visualization tools like BusinessObjects, Qlik, MicroStrategy, Power BI.
Experienced in data analysis and solving business problems using data sets.
SQL experience in database modeling and data transformations.
Experience with data extract and transformation tools SAP SLT and Amazon DMS.
Utilized Change Management by managing dashboard design to help business performance using SDLC and power BI as tool.
Experience using performance tuning and query optimization techniques.
Strong problem-solving skills, business acumen, and demonstrated excellent oral and written communication skills.
Worked as a hybrid data analyst/engineer and work with functional business stakeholders and data teammates analyzing business requirements for data analytics projects. Work in transform data to make the data come to life and work with users converting database queries and tabular data into modern analytics products.
Worked as a data analyst/engineer to support data.
Applies and/or develops processes to mine and summarize data.
Utilized Power BI for designing dashboards and reports for end user.
Collaboration with business stakeholders to understand requirements, propose and develop solutions.
Responsible for analyzing large datasets, drawing inference, and preparing insights for stakeholders using narratives or visual forms.
Applies and/or develops workflows that clean, transform and aggregate unorganized data into databases or data sources
Developing data models to transform raw data into business-ready structures
Gainwell Technology (Insight Global), Chicago, IL May 2021- OCT 2021
Business Analyst
Engages business clients to elicit business requirements and understand business objectives
Produces business analysis related documentation, including (functional and non-functional) requirements & user stories, current and future state processes and workflows, and solution specifications to a high-quality standard
Conceives, proposes, and facilitates the selection of viable functional solution alternatives
Works with business and solution teams to ensure that solutions being delivered meet business intent and provide business value
Demonstrates requirements traceability and, where appropriate, leads the User Acceptance phase of initiatives (define strategy, plan, approve test cases, oversee execution); works with Business, Solution Engineering and SAS team to ensure built solutions meet stated requirements
Participates in the initiation and planning of projects - including facilitating the definition of objectives, scope, and deliverables as well as provide Business Analysis work estimates
Contributes to the operation and improvement of the delivery team
Work with DHS teams to develop plans and ensure understand the business requirements and are able to test solutions appropriately
CVS Caremark (Spectra Force) Northbrook, IL Nov 2020 - Mar 2021
Clinical Database Developer
Reviewed and approved data modeling processes and DBMS specific requirements for basic and intermediate application database requirements.
Lead logical data modeling processes for complex applications database requirements and converted logical data models into physical data models for complex application databases.
Directed root cause analysis on complex incidents and lead the problem management.
Coordinated the use of DMBS vendors and others to assist in the analysis and resolution of database problems/issues.
Lead peer reviews and identify infrastructure-wide impact/exposure of patching and configuration changes
Data manipulation, data conversion, query generation, import and export processes, report generation, macros and front-end menus or forms in Access or SQL.
SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. SQL Server Management Studio also provides Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Worked extensively on SAS program to process the drug information into the data base management system.
Analytical support multiple business disciplines.
Tableau visualizations for interactive share data to help everyone in business.
CTA PROJECT (Contractor)-22nd Century Technologies, Inc. Chicago-IL Sep 2019- Mar 2020
Business Analyst/Data Analyst:
Develops regular and special reports and analysis from data on department programs.
Modifies existing programs, develop, and implement best practices, affirmative action plans, policies, and procedures to ensure diversity values are integrated into the day-to-day activities across all operation units.
Participates in overall EEO strategy development. Translates strategies into specific actions with clear accountability and communicates priorities to management.
Utilized Change Management by managing dashboard design to help business performance using SDLC and Power BI as tool.
Creates and maintain compliance reports that identify discrepancies within computerized databases.
Coordinates with various Authority departments and systems to compile and analyze data
Identifies trends in DBE/SBE participation and economic impact on Authority contracts.
Assists with the preparation of statistical reports, tabulations, and charts as needed for the DBE attainments required by the Federal Transit Administration (FTA) and General Assembly.
Prepares ad-hoc reports based on requests from Executive Management utilizing a variety of reporting tools including: B2GNow, LCPtracker, Noetix, Excel, Oracle, and PowerBI, tableau, CONGNOS.
Performs regular maintenance of the Diversity Programs' systems of record.
collaborate cross-functionally with other departments
Handle increasingly high volume of work in a fast paced, deadline driven environment in a calm manner.
Experience with SQL queries.
Utilized Power BI for designing dashboards and reports for end user.
Used SQL Server Management Studio presents a graphical interface for configuring, monitoring, and administering instances of SQL Server.
Expert in Excel (queries, pivot tables and lookups, macros) and Access
Design KPI to Verifies data integrity and monitors data accuracy.
.
SAC WIRLESS: Chicago, IL Jun 2019 – Sep 2019
Business Analyst/Data Analyst
Maintain project financial information to ensure that project financial controls for the business.
Ensure project financial results, risks, and opportunities.
Prepare monthly financial control updates in the control system/tools, based on employee information.
Project Management for services.
Execute project procurement requests.
Experience with SQL queries for extraction of data.
Managed to upgrade the data-tier components used by your applications, such as databases.
Used SSMS and Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Expert in Excel (queries, pivot tables and lookups, macros) and Access
Support project-level budget/cost analyses (Budget/Cost Variance)
Compile and analyze large data sets for project reporting in EXCEL and tableau
Constantly be on the lookout for ways to improve monitoring, discover issues, and deliver business.
TRANSUNION: Chicago, IL Dec 2017 – Jan 2019
Senior Data Analyst
Perform Batch processing handle high volume of data.
Managed Transunion data repository within system.
Scrub and perform data cleansing for multiple file system.
Encrypted the data in the mainframe system.
Used API Integration securely integrate software system using ABNITIO Interface.
Analyze the data and create report for the client need and requirement.
Modifies program documentation and implements approved changes into production.
Converts project specifications into sequence of detailed instructions and logical steps for coding into language Creating Dashboards in Tableau.
Design the KPI’s for business process.
Used Tableau for drag-and-drop approach to visual analysis, exploring Excel data faster and easier. Tableau visualizations are interactive and highly shareable, helping everyone in your business get answers.
YMCA - (Advanced RESOURCE) Chicago –IL Apr 2017 – Nov 2017
Database Business Analyst
Changes database system by coding database descriptions.
Determines changes in physical database by studying project requirements, identifying database characteristics, such as location, amount of space, and access method.
Manages program from city database
Creates reports from SQL server 2015 from CPS database
Maintains user reference by writing and rewriting database descriptions.
Creates financial performance reports for customer management systems
Extracts data using ETL process
Maintains client confidence and protects operations by keeping information confidential.
CVS Caremark- (Spectra Force) Northbrook, IL Dec 2015 - Mar 2017
Clinical Database Developer
Reviewed and approved data modeling processes and DBMS specific requirements for basic and intermediate application database requirements.
Lead logical data modeling processes for complex applications database requirements and converted logical data models into physical data models for complex application databases.
Directed root cause analysis on complex incidents and lead the problem management.
Coordinated the use of DMBS vendors and others to assist in the analysis and resolution of database problems/issues.
Lead peer reviews and identify infrastructure-wide impact/exposure of patching and configuration changes
Data manipulation, data conversion, query generation, import and export processes, report generation, macros and front-end menus or forms in Access or SQL.
SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. SQL Server Management Studio also provides Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Worked extensively on SAS program to process the drug information into the data base management system.
Analytical support multiple business disciplines.
Tableau visualizations for interactive share data to help everyone in business.
Knowledge of Unix/Linux operating systems; data manipulation/transformation using software utilities Tableau.
Urban Bank Project – (Connect search) Chicago-IL Jun 2015 – Nov 2015
Data Analyst
Exported information from Access to SQL
Designed the entire Access database from beginning to end
Worked with Asset management for client's cash and securities.
Worked with Fixed income investment of borrower data or issuer.
Generated reports and forms for the bank
Performed Database Analysis and Design and Modeling
Exported loan information foxtrot to Access database
Worked with commercial card data available on TSYS Total Analytics (TSYS TS2)
Worked closely with Business Objects, Cognos, and Tableau
Press Ganney Healthcare (Genisis 10), Chicago, IL Dec 2014 – May 2015
Data Analyst (Contract)
Planned and Designed scalability of SQL server environment to fit organization structure and business requirement.
Performed upgrade and installation for SQL Server 2008, 2008 R2, 2012
Performed installation for SSIS, SSRS, and SAS
Created and modified SSRS reports and SSIS package for IT administration.
Created reports and pulled data from SQL server
Performed data migration for old legacy system to SQL server for ETL process within SSIS
Provided production support and maintained the data on the FTP
SSMS Installed and Configured Monitoring and Management SQL Server Clustering and Implemented service patches.
Reviewed and implemented SQL patch for production in-house application.
Designed queries and macro. Retained data for reports from the SQL server.
Assisted activities in server group, such as virtualization.
USE GEO-Dashboards for data mapping Provide support to the client.
Used SSMS for uploaded data into SQL server
Allstate – Northbrook, IL Mar2014 – Nov 2014
Data Analyst/DBA (Contract)
Interacted heavily with various customers.
Provided Internal Support Staff, Developers, and the Business/Operational Teams.
Created, logged, and updated tickets regarding issues.
Worked with Ticket Management Systems for tracking purposes.
Created scripts and queries to make updates in the database with SSIS.
Fixed all data impacted issue using the database logic and implement them
Maintained customer satisfaction by communicating SLAs and other variables affecting deliverables accurately to set customer expectations.
Maintained data transformation process through SSIS, SSRS.
Maintained the ETL operational support within the development process USING SSMS.
Analyzed the data using script and loaded the information in the system.
Worked with (Java or .net or SharePoint or web sphere or jobs).
Northern Trust Bank – Chicago, IL Oct 2013 – Dec 2013
Data Analyst (Contract)
Provided data conversion to Global Account Managing Program to create new account management system in-house
Responsible for data validity checks and maintained consistency with existing accounts in the SharePoint
Provided rules and management support according to the business need and requirements
Maintained existing accounts in Europe and Asia that required reviewing for anomalies
Prepared and analyzed Excel spread sheets for data collection process through Qlickview
USED SSMS to analyze data by running SQL queries to test the integrity of the data to ensure accuracy using Rapid SQL
Utilized ETL process and distribution of data for data integration extraction and transformation.
Performed data flow task such as data transformation, data mapping and data control through the SSIS Package
Transformed information into SharePoint site for core systems
Used Teradata for financial applications to support the financial analyses-Teradata for data warehousing and track company data
Worked with tableau for data visualization.
Mikes’ Hard Lemonade – Chicago, IL Jan 2013 – Sep 2013
Data Analyst (Contract)
Generated reports in IRI system according to business needs and requirements
Worked closely with business users to verify data requirements and access needs
Actively evaluated industry & competitor metrics and recommend improvements to competitive intelligence reports and resources
Worked with finance team to track and project revenue.
Worked closely with data architects, application development, and ETL development team to design and implement BI applications using a shared architecture/Enterprise Data Warehouse.
Worked closely with 3rd party data providers to ensure that data was accurate, consistent, and meet the needs of information consumers.
Utilized SQL for querying data, created store procedures, views, and joined data sources/tables
Strong relationship building skills and understanding of business needs
Exported data and input into Excel spreadsheets.
Worked with tableau for data visualization and data mapping.
Harley Davidson Financial Group – Chicago, IL Jul 2012 – Dec 2012
Data Analyst
Converted to Windows 7 and Microsoft Office 2010 several large Access and Excel databases
Analyzed reviews and recommended solutions to converting files.
Designed VBA Macro program for Excel 2010.
Responsible for providing setup, support and troubleshooting for data transfer including FTP, FTPS and other protocols for pgp files encryption issues
JPMorgan (Chase) – Chicago, IL Oct 2011 – Feb 2012
Data Analyst
Responsible for the creation and manipulation of the Microsoft Access database and by entering, maintaining, and extracting data
Administered organizational databases, using database management system to organize and store data
Worked with large and varied data sets, from multiple data sources, in order to conduct analysis, generate concise reporting, and present recommendations to clients and business units for future project deliverables.
Built and maintained databases using both Microsoft Access and Microsoft SQL Server management studio.
Ability to manage projects to ensure tasks and projects are completed in a successful and timely manner and maintain SharePoint
Processed fixed income investment.
Provided support for asset management investments.
Wrote VB program to extract data from SQL server in to Access database.
Extensively used Excel to design results for the report and summarize data in Excel PIVOT.
Aon Hewitt – Chicago, IL Aug 2011 – Oct 2011
Data Analyst (Contract)
Reviewed multiple data sources via Excel, Access, and plain text files to reconcile email address and Active Directory account information
Identified data integrity issuing email addresses between data sources
Organized proposed record updates in Excel to resolve data integrity issues
Performed data reconciliation analysis functions for other data points and integrity clean-up opportunities within Directory
Prepared updated files to be used by Key SMEs to update Active Directory
Located Active Directory Object using LDAP application software
Wrote VB program to get data from the SQL
Kraft Food – Glenview, IL Apr 2011 – Aug 2011
Data Analyst
Data extraction, reports, queries, stored procedures using MySQL.
Maintained COGNOS Database application and ran SAS in the background.
Utilized Nielsen and IRI System
Maintained and provided support to CPG product categories, Kraft product lines.
Merged and supported the Excel/Access, SQL applications to integrate several data sources.
Utilized MS Access, SQL, MS Excel, MS Visio, MS Office, Windows XP, Windows 7, MS Outlook, MS PowerPoint regularly
Nestle Pizza – Northbrook, IL Feb 2011 – Apr 2011
Data Analyst (Contract)
Processed invoices and tracked them in Access and Excel manually
Analyzed and provided database management
Worked with Access/Excel data reporting
Responsible for the transformation of acquiring information into Nestle from Kraft
Processed thousands of invoices per month manage them
Provided frontend and backend reports to access data
Utilized MS Access, SQL, MS Excel, MS Visio, MS Office, Windows XP, Windows 7, MS Outlook, MS PowerPoint, SharePoint regularly
Verteris – Chicago, IL May 2009 – Feb 2011
Data Analyst
Reviewed multiple data sources via Excel, Microsoft Access, or plain text files and reconcile bank data and Active Directory account information
Identified data integrity issues between data sources to generate reports
Responsible for downloading and processing data files from banks
Scrubbed the data files for various applications in oracle, SQL to ensure process and generate crystal reports to view data
Extensively used MySQL for matching row data table to the database and update the table according to the database requirement
Downloaded data from different bank and extract data using remote access system
Generated information to process in Microsoft Excel in required applications
Environment: MS Access, SQL, MS Excel, MS Visio, MS Office, Windows XP, Windows 7, MS Outlook, MS PowerPoint
AT&T – Chicago, IL Jun 2008 – Apr 2009
Data Analyst
Validated and reviewed legal contractual agreements between client and customers for Mid-West region
Inputted contract into contract databases
Responsible for generating daily, weekly, and monthly recurrent and ad hoc report from Access, Oracle, SQL server, business object, ECATS (Enterprise Contract Administration Tracking System) and CBR (Customer Billing Relationship) applications
Reduced data redundancy and inconsistency to ensure higher data integrity and report efficiency by organizing and consolidating various databases, queries, and reports for the revenue compliance department.
Developed and implemented the performance tracking database to substantiate and monitor monthly workload for the Contract Reporting Team members
Updated and managed the Report distribution logistic for the contract reporting team
Entered contractual information into designated database (ECATS) system
Provided termination charges for the required contract to the sales team
Worked extensively with the ACIS and CARS billing system used by company
Audited the contract information pulled from AT&T billing databases.
Provided calculation and after validating contract termination and shortfall charges based on AT&T tariff regulations, product guidelines, and contract language SSRS reporting tool to organize and distribution of data for retrieval using query
Utilized MS Access, SQL, MS Excel, MS Visio, MS Office, Windows XP, Windows 7, MS Outlook, MS PowerPoint regularly.
Contact this candidate