SUMMARY:

• Business Intelligence Analyst with strong experience performing data analysis and reporting Using SQL Server Management Studio, SAS, Teradata, MS Visual Studio, Tableau, QlikView, Oracle, SQL Developer, AQT, MIcrostrategy. Netezza, SAP Business Warehouse, SAP Business Object, SAP Business Intelligence, Business Objects, VBA, D&B, SSIS, SSRS, SDIS, Visual Studio, Sharepoint, MS Access, MS Power Point, and Excel.
• Data analysis skills with data mining and manipulation utilizing Access, Excel, Crystal ReportsOracle, Microstrategy, Netezza, Teradata, QlikView, SAP, SSRS and SQL for reporting and/or analytical purposes.
• Experience in developing and creating big data reports as well as working with complex data models using SAS, SQL, SQL Developer, Teradata, SSRS, Tableau, Business Objects and Netezza.
• Knowledge of dimensional data modeling, OLAP, report and dashboard development, data mining, visualization, and data integration/transformation concepts. Ability to streamline processes and procedures for optimal performance.
• Ability to perform development activities from gathering requirements and designing solutions through developing codes/reports to testing and release/deployments using SDLC or Agilie methodologies.
• Ability to effectively collaborate with the end users. Stakeholders and support partners to identify business needs/goals.
• Problem solving/troubleshooting experience/skills to assist/support Production in issue resolution by analyzing root cause, issues, gap analysis, recommending and implementing solutions.
• Financial, legal, mortgage, marketing, supply chain, healthcare, and aero industry experience.
• Experience in international trade operations and deploying compliance policies.
• A self - starter with the ability to meet deadlines without compromising quality.
• Able to prioritize, multi-task, and adjust to a fast paced changing environment.
• Excellent communication skills with knowledge of multiple languages: English, Russian, and Spanish; Conversational knowledge of Armenian and Azeri; Certified Translator.

TECHNICAL SKILLS:

Software packages: SQL Server Management Studio, MS Visual Studio, SSRS, SAS, SIS, Netezza, Visual Studio, SQL Developer, Word Processor, Excel, Access, Power Point, Oracle Financial, Oracle, Monarch, SAP BO, SAP BI, SAP, SAP BW, GCSS(Export/Import), PROM, Mainframe, Crystal, AQT, SQL Server, Aerovantix, Aerolytix, Live Link, Co-Exprise, Microstrategy, Ultra Edit, AQT.

Development languages: SQL, Oracle, SAP Visual Basic.

Database skills: Access, SQL, Oracle, SAP BW, SAP BO BI, Netezza, AEPROD, AEUAT, CDRRPROD, CDRRUAT, EQMRPROD, EQMRUAT, Excel, MEDPAR ETL, MEDPAR PROD, Transform, Quality Advisor, STGFX.

Operating systems utilized: Windows XP, Windows Vista Business, Windows 2010, MS Office Suites 2007, 2010.

Languages: Fluent in English, Russian, and Spanish; conversational knowledge of Armenian and Azeri.

EXPERIENCE:

Analytic Consultant

Confidential

Responsibilities:

• Creating reports to fulfill requests from the Financial Crimes Risk Management team and WF Commercial Capital.
• Creating and Analyzing reports to provide the team with sufficient information to identify potential risks based on policy compliance and other LOBs requirements.
• Running SSIS Packages using Visual Studio and publishing updated reports in Tableau.
• Performing heavy data analysis using SQL Server Management Studio and SQL Developer.
• Creating Adhoc Reports or updating existing reports based on ARC Requests from business partners using SQL Server, SQL Developer, Visual Studio, Tableau, Access, Excel.
• Optimizing, fixing and deploying SSIS packages. Utilizing Visual Studio to consolidate files from different sources.
• Collaborating with operational managers and business partners to translate the business needs into analytic and reporting strategies.

Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Creating reports and dashboards and performing data analysis for projects and reports using SQL Server 2012, Access and Excel.
• Developing graphs, reports and presentations for company’s Executives.
• Resolving data issues with the sourcing and transforming of data to be used for the analytics and reporting.
• Manipulating massive amounts of numerical data to create and modify reports.
• Collaborating with Sr. Executives and operational managers to translate the business needs into analytic and reporting strategies through development, execution and resourcing specific projects plans for analytic delivery.
• Performing application integration by creating custom applications, Transact-SQL scripts, or SSIS packages.
• Running jobs - backups, data imports or exports.
• Ability to create complex SSIS and TSQL procedures to extract, transform and loading the data required and perform a wide range of tasks, including monitoring and maintenance tasks.
• Troubleshooting.
• Knowledge and skills in relational database build and support, including ability to design, create, update, and maintain databases in SQL and Access.

Business Systems Consultant

Confidential, Charlotte, NC

Responsibilities:

• As a part of Wholesale Regulatory and Finance Data Management, interacting with lines of businesses, management and personnel to obtain data and information to improve the accuracy and completeness of data flowing through from data systems and marts to the regulatory submissions and otherwise support corporate Data Management and maintenance activities and other risk data initiatives.
• As Teradata Developer, was responsible for maintaining DBA functions such as development, test, production, performance tuning, including collecting statistics, analyzing explains and determining which tables needed statistics.
• Created and modified databases, loaded data from various data sources and legacy systems into Teradata production and development warehouse using UNIX and Informatica.
• Table loads, updates, Inserts, DDL. Debug complicated codes, recommended fixes, if necessary and performed fixes as well. Performed Data modeling.
• Working with lines of businesses and owners of data warehouses to source current regulatory data for Traded Products, Derivatives & Deposits, Capital Markets Group and Wholesale Controllers regulatory reporting.
• Resolving data issues with the sourcing and transforming of data to be used for the analytics and calculation of regulatory reporting and for ongoing activities surrounding the transmission and data validation.
• Defining business requirements for the automation of regulatory reporting for Capital Market Group Controllers.
• Creating and executing SQL scripts to generate reports as per business requirements and working With IT, end users and data warehouses owners to ensure delivery of quality reporting solutions. Tools used: SQL Server Management Studio and Teradata. Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Defining business requirements where required data is not currently in data warehouses, to be consistent with the rules of regulatory reporting and other credit risk management needs, such as risk aggregation or other regulatory reporting.
• Creating complex queries for extracting and analyzing data using SQL, Teradata or SAS.
• Preparing analyses and processes to verify the completeness and accuracy of the regulatory submissions. Creating reports, analyzing data by slicing/dicing, drill down, roll up.
• Analyzing root cause, issues, gap analysis and recommending solutions as a contribution to team’s remediation efforts.
• Test data to verify it is consistent with established requirements or to investigate its suitability for its Intended use.
• Documenting problems with regulatory reporting, its resolution and development plans.

Sr Business Intelligence Analyst

Confidential, Charlotte, NC

Responsibilities:

• Analyzed and translated business requirements into reporting technical requirements.
• Facilitated analytical initiatives in support systems strategic, operational and quality projects.
• Collaborated with facility executives, service lines leaders and operational managers to translate the business needs into analytic and reporting strategies through development, execution and resourcing specific projects plans for analytic delivery.
• Analyzed data with millions of rows and working with complex data models using SAS and Netezza.
• Created reports, analyzed data with millions by slicing/dicing, drill down, roll up.
• Understood of the architecture for what works best for sourcing data.

Business Intelligence Analyst

Confidential, Charlotte, NC

Responsibilities:

• Worked with BI Delivery Manager and Operations to analyze and document business processes and requirements.
• Analyzed and translating business requirements into reporting technical specifications.
• Collaborated with project ream, business partners, Reporting Delivery Manager, and senior level executives to ensure delivery of quality Reporting solutions.
• Reviewed reports for trends, outliers, quality, data structure, report validity and data details.
• Was responsible for ensuring the full workflow of the reporting request is followed, documented and closed.
• Planned and managing business requirements, functional requirements, QA and documented activities.
• Accessed reporting needs; provide recommendations for enhanced solutions and match needs to reporting tools and capabilities.
• Created and running executive-level reports and managed business requirements documentation.
• Managed issues/risks tracking and status reporting.
• Managed Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Performed QA and UAT testing.
• Designed Adhoc Reports.

Technical Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Gathered requirements and processed documentation.
• Created SQL queries in SQL Server 2008 R2 to produce and publish reports.
• Updated reports and databases.
• Created Dashboard Reports and KPI’s.
• Ran SQL queries to provided technical analysis support.
• Published Reports, Documentations and Presentations on SharePoint.
• Analyzed data documentation and query complex database content to create reports to meet business requirements.

Systems Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Performed root cause analysis and resolution of issues with reports and universes.
• Produced and publish weekly and monthly reports using SQL queries.
• Created SQL queries to pull data and created reports per client’s requests.
• Modifed reports in SQL Server 2008 R2.
• Modified and ran reports utilizing Microsoft Access. Update MS Access Databases.
• Administered and executed queries utilizing AQT.
• Coordinated efforts with developers in testing PAD Warehouse and DES Projects.
• Knowledge of of Healthcare Informatics databases and table structures.
• Utilization of SQL and Microstrategy scripts to determine data source, report logic and reporting strategy.
• Manipulated massive amounts of numerical data to create and modify reports.
• Investigated cause of data quality issues related to QualityAdvisor, Advisor Exchange, and QualityMeasure Reporter. Analyzed and resolved and made appropriate recommendation to impacted areas.
• Provided operational and data quality support for internal and external customers.
• Provided day to day data quality and operational support and provided solutions for the problems.
• Conducted or coordinate tests using statistics to ensure intelligence is consistent with defined needs.
• Wrote SQL scripts for quality check testing. Mapped processing script testing.
• As part of project management team, executed projects effectively and efficiently to tie project results to business goals.
• Liaison with development, project management, and cross functional teams.Worked with project teams: Architect, Developers, QA, and Project Management on different projects.
• Reviewed and transferred projects business and functional requirements and designed specifications into SOP.

Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Ran SAP, Aerovantix, Aerolytix reports to support accurate SCM metrics.
• Performed Dashboard and Analytical Reporting on the Business Objects XI 3.1
• Ran and analyzed reports from SAP, Aerolytix (BI 3.1) and Aerovantix (Web Intelligence)
• Updated and modified reports using Business Objects and Business Intelligence Applications.
• Ran and analyzed savings report utilizing business intelligence tools or systems.
• Elicited, captured, developed and implemented customer requirements in creating and deploying reports.
• Published and integrated reports into Microsoft SharePoint.
• Created and updated mapping in suppliers and commodity databases.
• Data Validation from SAP and Business Intelligence Applications.
• Ran and validated SAP report for Supplier Diversity.
• Modified reports in BI stack.
• Participated in testing BI 4.0.
• Performed market research to support commodity strategies.
• Utilized SCM data warehouse for quick look up for supplier metrics.
• Worked with SBUs and IT to perform SCM data cleanup.
• Maintained Training documentation for tools, reports, commodity management process.
• Performed data mapping to ensure accuracy and improve supplier data.
• Produced and published weekly and monthly reports.

Research Analyst

Confidential, Charlotte, NC

Responsibilities:

• Researched and investigated court case data via the internet and Mainframe application to verify or supplement information relative to searches.
• Analyzed, collected, interpreted, and edited case data and ensure that the data has been appropriately documented to produce a preformatted report for clients.
• Promptly pinpoint and addressed abnormalities or conflicting data that may lead to erroneous reporting.
• Processed of all cases in a timely manner and efficiently obtained results with minimal internal delays.
• Increased proficiency in navigating proprietary and consumer applications.
• Effectively adapted to frequent changes in processes due to changes in customer requirements.