Sr. Data Analyst Resume
Richmond, VirginiA
OBJECTIVE
- An energetic self - motivated and result oriented IT professional looking for an opportunity to work in a challenging environment where I can utilize my knowledge skills in effective contribution to the success of the organization and also for the improvement of my personal skills.
SUMMARY:
- Around 5+ years of IT professional experience in Software industry with Data Analyst and good working knowledge of SQL disciplines, tasks, resources and scheduling in domain strong analytic and programming skills.
- Strong experience in Business and Data Analysis, Data Governance, Data Profiling, Data Migration, Data Mining, Data cleansing, Data Conversion, Data visualization, Data Quality, Data Integration, Master Data Management, Metadata Management Services and Configuration Management.
- Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
- Proficient in writing complex Snow SQL and python queries for data validation for verifying the SSIS Packages and business Rules.
- Well Versed with advance concept in Excel. Worked with Vlookup, Index, Match, Pivots and creating complex formulas
- Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Definitions and Data Formats.
- Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, T- SQL Joins.
- Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
- Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
- Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
- Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
- Worked on Waterfall, RUP and Agile methodologies.
- Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
- Extensive experience in writing SQL to validate the database systems and backend database testing.
- Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
- Created Data Mapping document after each assignment and wrote the transformation rules for each field as applicable.
TECHNICAL SKILLS
Operating Systems: Windows 10, UNIX, Linux, MAC OS
Languages: T-SQL, Pl/SQL, Python, Unix Shell Scripting
Webservers: AWS, Apache Tomcat
Databases: Snowflake, Microsoft SQL Server, Teradata, SQL Workbench
Scripting Languages: Pyspark, Snow SQL
Reporting tools: Hyperion, Tableau, Excel
Microsoft Suite: MS Office and tools.
PROFESSIONAL EXPERIENCE
Confidential, Richmond, Virginia
Sr. Data Analyst
Responsibilities:
- Designed data visualization to present current impact and growth
- Created test cases during two-week sprints using agile methodology
- Developed Python based API to track sales and perform sales analysis using SQL Workbench and PostgreSQL.
- Managed companies’ virtual servers at Amazon EC2, S3 in data loading.
- Played a key role in a department wide transition from Subversion to Git, which resulted in an increase in efficiency for the development community
- Maintained customers relationship management databases (MySQL / PostgreSQL)
- Identified, analyzed, and interpreted trends or patterns in complex data sets.
- Filtered and cleaned data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
- Worked on Developing and implementing databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
- Acquiring data from primary or secondary data sources and maintaining databases/data systems.
Environment:Snowflake, Python, SSMS, Teradata, Hyperion, Linux, Unix, Excel.
Confidential, Richmond, Virginia
Sr. Data Analyst
Responsibilities:
- Developed modules to extract, process & transfer the customer data using Teradata utilities.
- Created Fast Export scripts for extracting and formatting customer data from data warehouse in a mainframe file.
- Performed discharge of stale components from mainframe in turn reduced the maintenance cost for bank.
- Followed department SDLC methodology and development procedures.
- Perform weekly migrations for Business Objects universe and reports.
- Monitor and schedule monthly backup of universe and reports.
- Update the Operating procedures document continuously with improved process and methodology
- Monitoring the Order fulfillment Metrics jobs to make sure data being loaded into Teradata tables.
Environment:Python, Teradata, Unix, Linux, Excel.
Confidential, Dallas, Texas
Business Data Analyst
Responsibilities:
- Worked on Interpreting data, analyzing results using statistical techniques and providing ongoing reports.
- Worked on Developing and implementing databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
- Acquiring data from primary or secondary data sources and maintaining databases/data systems.
- Identified, analyzed, and interpreted trends or patterns in complex data sets.
- Filtered and “cleaned” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
- Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
- Worked with other team members to complete special projects and achieve project deadlines.
- Worked with management to prioritize business and information needs.
- Located and defined new process improvement opportunities.
- Worked with the company in Technical expertise regarding data models, database design development, data mining and segmentation techniques.
- Good Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)
- Worked with analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Extensive experience in writing SQL to validate the database systems and for backend database testing.
- Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
- Used advanced Excel functions to generate spreadsheets and pivot tables.
- Created Data Mapping document after each assignment and wrote the transformation rules for each field as applicable.
Environment:SQL server 2014, Excel.
Confidential
Sr. Analyst
Responsibilities:
- Worked on Requirement Analysis, Asset management, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems.
- Extensively worked on Confidential (Confidential Information System) tool.
- Prepared Business Requirement Documentation and Functional Documentation.
- Primarily responsible for coordinating between project sponsor and stake holders.
- Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.,
- Performed Business Process mapping for new requirements.
- Designed reports in Access, Excel using advanced functions not limited to Vlookup, pivot tables, formulas
- Prepare Use case models based on Business Requirements documentation gathered through
- Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database
- Independently designed and developed project document templates based on SDLC methodology.
- Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
- Exported Requirements, test plans and test cases to QC.
- Created Traceability Matrix to ensure that all requirements are covered in test cases.
- Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
- Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
- Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases.
Environment:Atlas, SQL, Excel.