We provide IT Staff Augmentation Services!

Senior Data Analyst Resume

Charlotte, NC

SUMMARY

  • A bright, talented and self - motivated Data Analyst and SQL Server Developer with 7+ years of experience, who has excellent organizational skills, is highly efficient and has a good eye for detail
  • Experienced in the developing and upgrading of database system and analytical techniques
  • Expert in Data Lineage, Data Control, Data Cleaning, Meta-data Management, and Data Dictionary
  • Skilled in developing Scorecards and Dashboards on Data Governance and Data Quality issues
  • Experienced in Financial Market data, Regulatory Financial data - Dodd-Frank, Comprehensive Capital Analysis and Review (CCAR), Basel Committee on Banking Supervision (Basel III)
  • Strong understanding of Financial concepts with a background in Economics (Microeconomics, Macroeconomics, International Trade, and Foreign Exchange) and Financial Management System
  • Expert in writing complex T-SQL and Teradata SQL queries using filtering and sorting, Join and Apply, Grouping and Windowing, Full-text data queries, XML data queries
  • Experienced in developing database objects in SQL Server - creating Tables, Schemas and enforcing Data Integrity; designing and creating Views, Functions, Stored Procedures, Triggers; Implementing Transactions, Error Handling, and Dynamic SQL; analyzing query performance using Coding Best Practices, Indexes, Statistics, Execution Plans, etc.
  • Skilled in developing ETL process using T-SQL and BCP and Command-line utility in SQL Server
  • Experienced in developing SSIS packages in generating various format of report data files (using Flat File Connection Manager, SMTP Connection Manager, etc.) and in resolving the issues related to data transformation and character encoding (from Unicode to non-Unicode characters and vice-versa)
  • Experienced in Data Conversion and Data Migration (using SSIS and DTS services) across different databases platforms and data sources such as Oracle, DB2, Excel, CSV, XML, etc.
  • Expert in Excel for data analysis and reporting using its various functionalities (VLOOKUP, EXACT, PIVOT Table, Text to Columns, etc.) and expressions
  • Experienced in data visualization using different BI tools like Tableau, Micro Strategy, Dundas, etc.
  • Skilled in creating reports in SSRS using Grouping and Sorting and creating Sub Reports, Cascading Parameters Report, Snapshot Report, Drill-through Reports, Parameterized Reports, and Ad-hoc Reports
  • Expert in Logical and Physical Data Modelling, ER Diagram, Class Diagram, Process Documentation, Data Lineage Documentation, System Documentation, Requirement Gathering, Report Writing, etc.
  • Skilled in Statistical Analysis - Descriptive Statistics, Probability, Regression, Time Series, Panel Data
  • Critical thinker, self-starter, disciplined with the attribute of investigative and logical approach in problem solving; ability to work in tight schedules and efficient in time management; collaborative with client’s complex business requirements, and translate them into efficient database solutions

TECHNICAL SKILLS

Database Tools: Microsoft SQL Server, T-SQL, SSIS, SSRS, SSAS, Teradata SQL, Red Gate

Data Visualization Tools: Tableau, Dundas, Excel, Power BI

UML and Data Modeler Tools: Microsoft Visio, Erwin

MS Office Tools: MS Word, MS Excel, PowerPoint, Outlook

General Purpose Languages: C, FORTRAN, Python

Statistical/Mathematical Analysis Tools: STATA, SPSS, R, Maple

Soft Skills: Relational Database, Regression Analysis, Time Series Analysis, Panel Data Analysis, Economic Analysis, Game Theory, Mechanism Design, Policy Analysis, Budget Analysis, Computer Fundamentals, Data Structure and Algorithm, Risk Analysis

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Responsible for implementing and managing the day-to-day needs of the data governance and data quality program
  • Recommend and implement policies and procedures for data governance approved by the Data Governance council and Data Governance team
  • Identify data quality opportunities and drive compliance with data governance and quality initiatives
  • Work with Auditors and Regulators (SEC, Fed, etc.) to gather requirements, develop documentation, and provide data/reports according to the requirement aligned with different financial acts and rules of the US Government and International Authorities
  • Design and Develop various scorecards relating to the health of the Party Reference Data
  • Implement the Data Quality and Data Movement Rules by developing SQL queries
  • Develop ad hoc SQL code to check the data quality rule breaches
  • Design and Develop SQL Stored Procedure to extract data for a client’s Tableau dashboards
  • Analyze, create, and maintain project related document deliverables used for requirements gathering, high level design, test planning, metadata, testing and validation
  • Perform data analysis to identify and correct data problems using different MS Excel functions and expressions like VLOOKUP, EXACT, Pivot Table, etc. and Notepad++
  • Develop SQL Scripts to extract data from Teradata for metadata analysis and to check completeness and validity of the data according to regulators’ requirements
  • Design and develop dynamic scorecards and dashboards using Tableau and Excel
  • Identify key data elements to develop regulatory and audit reports and provide metrics to senior management for weekly reporting using Excel and PowerPoint
  • Review source systems in order to understand the key data elements for CIP (Customer Identification Program) and CDD (Customer Due Diligence)
  • Analyze data extracts from source systems and their movement up to the system of AML (Anti-Money Laundering) Compliance team to identify data quality or gap issues
  • Interpret data, analysis results and provide ongoing reports
  • Coordinate with ETL developers and QAs to ensure requirements and functional designs

Environment: Teradata, SQL Server, SQL Assistance, Teradata SQL, SQL Server Integration Services, SQL Server Reporting Services, Tableau, Visual Studio 2013, Microsoft Visio, Notepad++, Win Merge, Red Gate, MS Office 2013

Senior SQL Developer (T-SQL, SSIS)

Confidential, Columbia, MD

Responsibilities:

  • Actively participate in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system
  • Identified documented business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders
  • Develop new triggers, update and alter existing triggers according to the change in requirements and for new development
  • Develop SQL Scripts to find tables that have Identity Columns, tables that do not have primary key
  • Use Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints
  • Create indexes on selective columns to speed up queries and analyses in SQL Management Studio
  • Design and develop ETL proses using T-SQL, BCP and Command-line utility of SQL Server
  • Design and write code for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
  • Create Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server
  • Schedule the monthly/weekly/daily reports to run automatically
  • Work on querying data and creating on-demand reports using Report Builder in SSRS reports
  • Develop complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
  • Design SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all
  • Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks
  • Enhance performance using optimization techniques - normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts

Environment: SQL Server 2014, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2013, T-SQL, Microsoft Visio, Notepad++, Win Merge, Red Gate, MS Office 2013

SQL Server Developer (SSIS, SSRS)

Confidential - Alpharetta, GA

Responsibilities:

  • Actively participated in interaction with clients, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Develop complex T-SQL queries for data extraction, generating reporting data, and performing data conversion according to clients’ specifications
  • Plan and design various database objects for report data and develop DDL scripts to generate tables, views, Stored Procedures, functions, Clustered and Non-Clustered Indexes, etc.
  • Monitor, review, verify processes and databases to ensure orders are updated correctly
  • Write queries and stored procedures in T-SQL to format report data, use Import and Export Wizard to import heterogeneous format of data (such as excel, Flat files, XML, etc.), and review them for quality and data integrity, and sends them to internal clients and external suppliers
  • Work with Database Administrators to update order data as necessary
  • Create and maintain detailed documentation as required pertinent to problems and errors produced by database processes and applications
  • Develop various SSIS packages to generate different format (Excel, CSV, Tab Delimited, etc. ) of report data files for different client
  • Work with DBAs in deploying the SSIS packages in production, maintain and update the packages if it fails to execute in production or any changes in requirements from the client side
  • Create User Defined Functions to check the existence of special characters in the data that are not accepted in clients’ report data files.
  • Optimize existing SSIS packages by evaluating time they took to execute, inspecting the tasks and transforms used inside the SSIS package
  • Provide production support (including ad hoc T-SQL querying, reporting, and process monitoring) for internal business units
  • Perform data analysis to identify and correct data problems using different MS Excel functions like VLOOKUP, EXACT, Pivot Table, etc. and using Notepad++.

Environment: Windows 7 OS, SQL Server 2012, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2010, T-SQL, .NET, Microsoft Visio, Notepad++, Win Merge, Red Gate, JIRA, ERWIN, MS Office 2013

Technical Data Analyst (Data Lineage, T-SQL)

Confidential - Charlotte, NC

Responsibilities:

  • Identify key data elements used to develop each regulatory reports and provide metrics to senior management for weekly reporting using Excel and PowerPoint
  • Profile data for identified data elements, document technical metadata, create Data Dictionary and artifacts inventory for BCBS project
  • Write complex SQL queries for ad hoc data analysis and support data lineage task
  • Review data elements, metadata definitions with respective LOBs to ensure correctness
  • Create a weekly ad hoc report using Excel, PowerPoint on project status
  • Work with Internal Auditors to validate the accuracy and completeness of the data flow designed by Audit team in collaboration with Counterparty Risk Management (CCRM) team
  • Work directly with report SMEs, senior management to validate accuracy of data lineage from system of origin (SOR) to downstream reporting systems
  • Identify and document gap on key data elements that didn’t have stored procedures, log files and transformation logic
  • Identify gap of data movement from CRISP to external SunGard’s Adaptiv system
  • Remediate gap consulting with SMEs, document and update the lineage template
  • Drive and assist with data analysis to improve operation including uncovering data anomalies and performing research of other forms of key operational data to enable efficiencies and overall data quality

Environment: Windows 7 OS, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2008, T-SQL, .NET, Microsoft Visio, Notepad++, Win Merge, Red Gate, Tortoise SVN, JIRA, ERWIN, MS Office 2010

SQL Server Developer (T-SQL, SSIS, Data Analysis)

Confidential - Charlotte, NC

Responsibilities:

  • Create databases for each quarterly CCAR run according to the specification from the Corporate Market Risk Department of WF
  • Design and develop database schema, DDL script to generate tables, views, Stored Procedures, functions, Clustered and Non-Clustered Indexes, Constrains
  • Develop various SQL scripts and use SQL Server Import and Export Wizard to populate base tables in CCAR database from different internal data sources of different data format
  • Create complex SQL scripts to populate the CCAR report tables from the base tables in the database that are designed according to the requirement of FRB and in consistent with the FRB’s Q templates
  • Identify root causes of CCAR report data inconsistency issues raised from Corporate Market Risk Department and debug the respective SQL script/scripts to resolve the issues
  • Perform data validation checks during staging, and then loaded the data into databases
  • Create complex Stored Procedures, Functions, Views, Indexes to increase performances
  • Provide production support (including ad hoc T-SQL querying, reporting, and process monitoring) for business units - Market Risk Oversights (MROs), Corporate Market Risk Department, and the Risk Analytics team of WF
  • Check performance and perform index tuning and query optimization for the business users
  • Perform data analysis to identify and correct data problems using different Excel functions like VLOOKUP, EXACT, Pivot Table, etc.
  • Assist in database technical design and development T-SQL code reviews
  • Create SQL query for Risk Analytics on demand and also provide data accordingly
  • Develop and maintain SSIS packages to extract data from production to the On Demand Risk (ODR) database as part of daily CCAR process known as CCAR Lite
  • Develop T-SQL scripts that are being used by the SSIS packages; finding out the cause of not being success and debug the scripts if the daily ETL job is failed
  • Used various SSIS Transformation tasks such as Conditional Split, Merge, Sort, Lookup, Aggregation, Derived Column, Dimension Processing, etc.
  • Design and develop the technical process overview (cook book) for the quarterly CCAR Process and support the documentation team of WF to develop a detailed CCAR Process document for FRB.
  • Developed Analysis Services Tabular Projects in SQL Server Data Tool (SSDT) and imported data from a variety of relational sources by using the Table Import Wizard
  • Update the excel functions in the CCAR Q-Templates’ fields according to the change in the data tables structure as part of the FRB’s requirement
  • Generated Ad-hoc, Drill-down, Drill-through, and Parameterized Reports using SSRS for the internal use in the CCAR technology team
  • Support and lead newly joined developers as part of knowledge transfer and provide status update on their work to upper management

Environment: Windows 7 OS, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2008, T-SQL, .NET, Microsoft Visio, Notepad++, Win Merge, Red Gate, Tortoise SVN, JIRA, ERWIN, MS Office 2010

SQL Server Developer

Confidential – Palo Alto, CA

Responsibilities:

  • Created Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects
  • Developed Analysis Services Tabular Projects in SQL Server Data Tool (SSDT) and imported data from a variety of relational sources – SQL Server, Access, Oracle, etc. – by using the Table Import Wizard
  • Migrated DTS packages to SSIS packages under SQL Server 2008R2 using BIDS and updated the packages into SSIS under SQL Server 2012 using SSDT
  • Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs
  • Design and developed SSIS packages to extract data from different source files – Excel file, Flat file, Access file, CSV file, etc. – into SQL Server 2012/2008R2 for further data analysis and reporting
  • Deployed the created packages on different servers by configuring them
  • Used various SSIS Transformation tasks such as Conditional Split, Merge, Sort, Lookup, Aggregation, Derived Column, Dimension Processing, Slowly Changing Dimension etc.
  • Performed data validation checks during staging, and then loaded the data into the Data Warehouse
  • Created complex Stored Procedures, Functions, Views, Indexes for increasing performances
  • Checked performance and performed index tuning and query optimization
  • Created reports to retrieve data using stored procedures that accept parameters
  • Constructed technical documents for the stored procedure and schema requirements

Environment: Windows OS, SQL Server 2012/2008R2/2000, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2008/2010, T-SQL, .NET, Microsoft Visio

Economic Analyst and Data Analyst

Confidential

Responsibilities:

  • Develop T-SQL queries to retrieve data according to the requirement
  • Create Stored Procedures, Functions, Triggers, Views
  • Developed different DDL scripts to design data tables for the database using Relational Data model concepts and logics
  • Analyze the impact on Gender Equality and Poverty Alleviation of the National Budget (2007/08 FY) using the data from the data warehouse of the Ministry of Finance
  • Revise and modify the Recurrent, Capital, Gender, and Poverty (RCGP) Model and the Macro Model
  • Prepare the manual of the Macro Model, developed by Finance Division of the Ministry of Finance
  • Work as a core member of the National Budget (2008/09 FY) Preparation Team
  • Write project proposals and assess the progress of the on-going projects

Environment: Windows OS, MS SQL Server 2005, T-SQL, SPSS, STATA, MS Office

Hire Now