Management Sales

KEY PROFILE Strong mathematical and IT background as well as ability to translate business questions and requirements into reports, views, and BI query objects.

Ability to combine information from multiple sources and make effective decisions.

Good understanding of information systems, data modeling, business intelligence, relational database design and knowledge of how to access multiple information sources for analytical purposes.

Deep understanding of Various Software development life cycle (SDLC) aspects such as Requirement Analysis, Design, Development, Testing and Deployment.

BI Delivery Development, Demand Management and Enterprise Change Management process.

Excellent experience in UI/Designing QlikView dashboards.

Involved in Testing, Production support and Maintenance.

TECHNICAL Reporting/Analytics QlikView 10.x and 11.x (SR1,SR2,SR3); Toad™ Data Point

SKILLS Software Systems Microsoft Office Suite and Windows 10/XP

RDBMS MS-Access, Oracle, SQL Server 2008/2012

Languages SQL

Operating Systems MS-DOS, Windows, UNIX

QV Administration Tool QEMC, Qlikview Power Tools 1.1, Qlikview Governance

Dashboard, Qlikview System Monitor

WORK

HISTORY SunTrust Bank Atlanta, GA /07-2014 - 09-2014/

JDC Group, Atlanta, GA /03-2014 - 06-2014/

Anchor Logistic Services, Alpharetta, GA /08-2012 - 12-2013/

International Environmental Management (IEM), Alpharetta, GA /01-2011 - 07-2012/

Primerica Financial Services, Duluth, GA /02-2005 - 12-2010/

PROFESSIONAL

EXPERIENCE Business Intelligence Solutions Analyst / QlikView Developer

SUNTRUST Banks, Inc., Risk & Finance., Atlanta, GA /07-2014 - Present/

SunTrust Banks, Inc., is one of the nation's leading financial services holding companies.

Responsibility:

My responsibilities for management and delivery of enterprise reporting solutions supporting Risk and Finance practices included, but was not limited to, responsibility for report and dashboard development and enhancements, requirements review, release planning/management, QlikView Off-shore team Management, and BI tool issue resolution.

Led Demand Management Process. Created a demand entry using the Enterprise Change Management System (Work Front), when consider a new demand, break-fix or report modification. Organized and tracked demands, so I could monitor development resources month over month to ensure we’re using them in the best of our capacity.

Prepared the estimates within reason and get tracked, so we can monitor consumed vs used.

Reviewed impact analysis conducted by off-shore to determine if there are any gaps in the BRD or other requirements documentation that required clarification from the requestor to ensure the app is not break.

By CFO request, created a new BRD (Business requirement document) Template, with Data Mapping Fields table, which is in use for now and for future dashboards.

Held Architecture and Design sessions between on and Off-shore teams to create high level, logical design documents for large projects. Used my senior QlikView developer experience to help Off-shore team in development and design of Credit Risk Executive Dashboard.

Proposed four different models to integrate the data based on granularity, level of complexity, performance. By reviewing source tables from Risk Data Mart, made a suggestion to use one Fact table with aggregated data, which led to star schema Data model in QlikView, considered an Incremental Load and thus, improving dashboard performance.

Created two Project Plans for the dashboards with coordination of QA & Prod release dates and migrations well ahead of time. Emphasized on Sprint levels, Tasks to accomplish, Dates, Team’s responsibilities, as well with high level estimates to determine the number of Units of Value (UoV) that are required to complete the development process. It helped Company to keep dashboard development within a budget and ensured the dashboards get developed on time.

Unit /SIT Testing. Provided relevant Test cases to the developers to ensure all scenarios are properly tested, reviewed SQL validation quarries to confirm test results for quality and adherence to the requirements. Enhanced the SIT Template to increase the advocacy of testing.

Participated in dashboard certification meeting (DCM) to ensure all standards are followed prior to migration of the application to QA.

Served as the single point of contact (SPOC) to BICE, DICE, QlikView COE (Center of Excellence) and PSO for post- production migration issues: Requested a new dashboard initiation, Data base PID (Process ID) when a new data sources access is needed, submitted new AD (Active directory) groups, helped COE to create a new connection string for Dev, QA & Prod, worked with developers to help them with Harvest migration procedure and reviewed mistakes associated with migration process.

Executive Financial Dashboard. The Executive Financial Dashboard (EFD) provides Executive Management

a full year current forecast view of key financial metrics comparing various scenarios across Segments.

Responsibility:

Developed Executive Financial Dashboard for Corporate Controller and SFOs to assess quarterly consolidated financials for actuals, plan, and forecast.

As a part of the project, helped to build: Consolidated Financial Dashboard, Segment Financial Dashboards for Consumer, Mortgage, and Wholesale, LOB (Line of Business) and Account Details.

Helped with development and design to provide the teammates an understanding of the key accounts by LOB, account, trends and scenario focused on the variances driving Net Income attributable to Common Shareholders.

Worked on Set Analysis as an essential piece in creating advanced aggregation formulas.

For data mapping, I have built the .xls document in which there are details about: physical fields, logical fields, business logic, QlikView calculation, mockup dashboard object reference, valid values examples, and dimension/metric.

Validated dashboard numbers, submitted Migration requests, created Data Lineage Diagram.

Third Party Risk Management (TPRM) Dashboard. Data from the TPRM database contains information for

third party services provided by vendors as well as performance metrics associated to the vendor.

Responsibility:

Worked independently to build a Dashboard, which included: Portfolio snapshot of all products/services used by the Segment/Function, SLA (Service Level Agreement) Tracker trending by product/service, Qualitative Service Scorecard trending by product/service, Due Diligence Assessment summary by product/service, Findings with applicable Risks/ Incidents/ Issues by product/service. The dashboard has combined twelve different reports which client has been used before implementing QlikView software.

Discussed with business users and stakeholders the interaction between all reports and guidance to navigate users from one report to another based on requirements and specifics.

Developed and analyzed data model and identified strategies to maximize data integrity and business intelligence performance.

Implemented the various QlikView sheet objects including multiple Chart types, Trends, KPI's, Aggregation Ratings, Custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.

QlikView Developer / Children's Healthcare of Atlanta, Atlanta, GA /03-2014 - 06-2014/

Children's serves our community with three hospitals and more than 20 neighborhood locations, including five Urgent Care Centers.

IT Analytics and Reporting. Provide a framework to aid in optimal usability of QlikView applications by defining a reasonable, consistent, and effective coding and user style

Responsibility:

Creation of QVD builders and applications, upgraded existing QVD files due to major restructure of medical database - EPIC.

Provided coding standards to ensure uniform coding practices reducing oversight errors, and the time spent troubleshooting errors.

Revised and corrected the qualities of usability as used within the applications include readability by other QV developers, ease of implementation, maintainability, consistency and ease of use by end-users.

QEMC - set up and scheduled of jobs after any changes are completed by the developers.

Created a Change Control requests due to promotion of jobs from development stage to production server. Ensured that the ODBC configuration is correct and verified that the database file is accessible. Managed file location and connection strings.

Worked with BA/End-users in testing phase to ensure the application requirements are satisfied.

QlikView Developer / Synovus Financial Co., Columbus, GA /10-2012 - 12-2013/

Synovus Financial Corp. ( Synovus) is a financial services and a bank holding company.

Sales Analysis Dashboard Synchronize Sales With Evolving Market Conditions. Dashboard shows performance analysis identifies cost saving opportunities and increases yield. Managers can quickly ascertain which agents have the highest customer retention rates and monitor actual results against plan.

Financial Analysis More Accurate, Efficient and Effective Financial Management. Performs profit analysis, and find and retain the most profitable customers, develop and analyze services, and manage and mitigate credit risk.

Forecasting and Predictive Analysis Help business users choose the best forecasting algorithm to satisfy their needs. Dashboard shows the forecast and predict the future market, competition and buying behavior of its customers and prospects.

Responsibility:

Worked independently and within a small team of 4, with a focus on helping clients to formulate proper business concepts, interface design and content presentation.

Developed and analyzed data models and identified strategies to maximize data integrity and business intelligence performance.

Worked on sales performance tracking and analysis by enterprise, division, region and individual sales rep.

Worked with the BA/Customers/PM to identify the KPI’s needed for the Dashboards: Sales volume and pattern analysis; Market share and contribution analysis; Margin and price waterfall analysis; Retail POS data integration and analysis; Order management and billing analysis; Customers profiling and segmentation; Sales call effectiveness tracking; Call activity reach and frequency analysis, and Managed care market analysis.

Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.

Performed analysis, documentation, for calculation for various attributes.

Assisted the financial analysts to focus on interpreting information instead of data crunching and having to resolve inconsistencies.

International Environmental Management (IEM), Alpharetta, GA /01-2011 - 07-2012/

Software Developer - IEM is a sustainable business leader and innovator, helping commercial property owners, developers and managers drive towards zero waste while focusing on their bottom line.

Project Management Office Dashboards Dashboard provides the ability to cascade objectives and measures throughout the organization and provides middle managers and executives with the business alignment they need to work toward goals and to quickly adapt to changing conditions and alter processes and assignments to achieve objectives.

Inventory and Supply Chain Dashboard Lower Costs and Risks While Aligning Inventory With Actual Usage. Ensures accurate, timely data for better insight into revenues and Inventory costs for confident decision and maximized profitability.

Responsibility:

Developed QlikView scripts to extract, transform and load data from different data sources - flat files, SQL Server and Oracle.

Optimized the applications by using QVD's, removing non key fields and script variables.

Created analysis of inventory turns, months on hand, aging and other measures to identify Excess & Obsolete (E&O) inventory that ties up cash and clogs warehouses.

Strategies and action plans for optimizing inventory levels, including assistance to help liquidate E&O through secondary channels and to avoid future E&O growth.. Analysis of wholesale purchases vs. actual sales. Price change analysis comparing purchases to changes over time. Analysis of wholesale purchases vs. actual sales.

Developed front end reports using various QV objects including: bar, line, scatter, combo, pie, gauge charts to visualize KPIs such as budgets, revenue, overhead for project offices, profit margins, etc.

Provided ongoing QlikView support to QV Dashboards and jobs.

Business Analyst / Primerica Financial Services, Duluth, GA /02-2005 - 12-2010/

Primerica is a distributor of financial services and sells products in the United States, Canada, Puerto Rico.

As of 2008, it was the largest independent financial services marketing organization in North America.

Responsibility:

Developed reports, graphs, charts and presentations to guide senior management decisions in control and implementation of the strategy to integrate the risk assessment processes across all financial areas.

Gathered, analyzed, prepared and summarize recommendations for business plans, acquisition activity, trended future requirements, operating forecasts, working capital requirements, rates of return, depreciation and impact of governmental requirements, etc. Reading and understanding engineering plans and maps.

Reviewed plans for compliance with applicable regulations and adherence to mandated guideline.

Developed business requirements, user requirements and functional requirements and documented the same by creating use case document and system functional requirements document

EDUCATION Tashkent Polytechnic University – 1990 - Tashkent, Uzbekistan

Bachelor in Electronic Communication National Management Center – 1991 – Business Analyst

Contact this candidate