We provide IT Staff Augmentation Services!

Dataanalyst / Business Analyst Resume

PROFESSIONAL SUMMARY:

  • 7 years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.
  • In depth knowledge of SDLC phases such as requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies like Waterfall, Iterative and Agile.
  • Working knowledge of Health and Insurance domains.
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL.
  • Experienced to work as Data Analyst to perform complex Data Profiling, Data Definition, data mining, data analytics, validating and analyzing data and presenting reports.
  • Experience on business intelligence (and BI technologies) tools such as Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
  • Expertise in Data consolidation and harmonization
  • Experienced in writing UNIX shell scripts, SQL Loader, Procedures/Functions, Triggers and Packages.
  • Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
  • Excellent exposure in Data Profiling with reference to Data Warehouse and BI development.
  • Worked extensively with Dimensional Modeling and Data Migration.
  • Experience in Performing data validation, transforming data from RDBMS oracle to SAS datasets
  • Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
  • Developed SQL scripts for data validation and cleansing.
  • Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
  • Conducted extensive data validation on large data sets, communicated conclusions and recommendations to Project Manager.
  • Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
  • Ensured all documents and workflows meets the client requirements.
  • Worked with Data Modelers to create a Physical Data Model from the Logical Data Model using Erwin tool.
  • Experience with creating reports using Business Objects.
  • Excellent understanding of Microsoft BI toolset including Excel, Power BI, SQL Server Analysis Services, Visio, Access.
  • Experience in Creating master Data workbook which represents the ETL requirements such as mapping rules, physical Data element structure and their description.
  • Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.
  • Proficient in programming using SQL, PL/SQL.
  • Strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, nested sub queries, and resolving key performance issues.
  • Extensive experience in creating simple and parameterized reports and complex reports involving sub reports, charts and graphs in various BI and data visualization tools like Tableau.

TECHNICAL SKILLS:

Software s: SharePoint, Spark, Microsoft Office (Word, PowerPoint Excel, Outlook), Adobe (Photoshop, Dream Weaver), Prezi

Reporting Tools:: SAP Business Objects, Costar, Web focus Information Builders

Data Analysis Tools:: Tableau Software, Python Advanced Excel (macros, VLOOKUP, HLOOKUP)

Programming models and methodologies:: Scrum, Sprint, SDLC life cycle, Waterfall, Agile

Project Management Tools:: MS Project, Workfront, Lucernex, WBS Chart Pro, JIRA

Modeling Tools:: MS Visio, Erwin, SQL Power Architect, Mockplus

Programming Languages:: C, C++, XML, Java, JavaScript, HTML, CSS

Database Management:: Microsoft Access, Oracle, SQL Server 2008, MySQL, IBM DB2

PROFESSIONAL EXPERIENCE:

DataAnalyst / Business Analyst

Confidential

Responsibilities:

  • Collaborate with developers, testers and end users to ensure the technical compatibility.
  • Extracting data from different databases as per the business requirements using Sql Server.
  • Worked on different mapping documents (FDW & IDW) which captures attributes pathing in the object model and data used to develop the workflow
  • Formulate and define business and/ or system scope and objectives based on both user needs and applicable industry requirements.
  • Work with users and stake holders to analyze communicate and validate requirements and then subsequently model them.
  • Devise or modify procedures to solve complex problems considering business and/ or system limitations, operating time and form of different results.
  • Created Use Case and process flow diagrams using MS Visio, Mockplus and document the steps involved with each actor.
  • Writing of SQL Queries to pull the required information from database.
  • Generates the XML via Test harness and test the xml if any attributes are missing from the particular Quote or Policy.
  • Adding of missing Policy, Claims or Billing attributes to the Schema.
  • Responsible for generating the XSD and verifying the newly added tags and upload it to Bit bucket after each sprint.
  • Responsible for updating Integration Definition workbook for every iteration with all the attributes.
  • Used to write more complex SQL queries for Oracle, DB2, SQL Server and other data sources.
  • Detects, documents and recommends approaches for handling data quality issues.
  • Provide Outstanding support to the business areas for data needs including ad-hoc data requests/analysis, user support and troubleshooting data related issues.
  • Create Dashboards using business intelligence (BI) tools such as Tableau, Power BI, OBIEEE based on the business user needs.
  • Articulates data derivation or transformation rules in business terminology.
  • Devoloped and documented functional and non-functional detailed requirements.
  • Providing technical expertise understanding the relationship between the business, data and the technology.
  • Perform data analysis using advanced MS-Excel features and VBA Macros to provide business insights and support in taking business decisions.
  • Support end to end system testing through out the integration and user acceptance by performing the bug triage to the appropriate tier in the system
  • Develop data queries to perform business analysis and data research.
  • Participate across multiple project methodologies like agile and waterfall.
  • Perform gap analysis, identify the data elements needed for downstream systems for operations and reporting needs
  • Creating complex technical mapping documents involving SQL queries and Xpath’s for integration of various systems implementing SOA structure.

Environment: Tableau, Mockplus, Oracle 10/11/12, Sql Server20012/2016, UML, Visio, Excel 2007/2010, VBA, Sql Management studio, sql developer, and XMLspy.

Data Analyst

Confidential

Responsibilities:

  • Involved in defining the Source To business rules, Target data mappings, data definitions.
  • Performing Data Validation / Data Reconciliation between disparate source and target systems (Salesforce, Cisco-UIC, Cognos, Data Warehouse) for various projects.
  • Worked on projects specific to reporting - data validation and review of all data entered into Access as well as all reports generated from Access and Lucernex.
  • Performing data profiling and analysis on different source systems that are required for Customer Master.
  • Extracting data from different databases as per the business requirements using Sql Server Management Studio.
  • Used SQL queries to pull the data from disparate systems and Data warehouse in different environments.
  • Perform periodic data integrity reviews to facilitate and monitor status for data cleanup to ensure consistent and reliable data flows.
  • Used Data Quality validation techniques to validate Critical Data elements (CDE) and identified various anomalies.
  • Saved the company money by identifying incorrect billing due to the lease such as caps on CAM with the help of Lucernex.
  • Interacting with the ETL, BI teams to understand / support on various ongoing projects.
  • Extensively used MS Excel for data validation.
  • Interacting with the Business teams and Project Managers to clearly articulate the anomalies, issues, findings during data validation.
  • Analyze data from site maintenance, identify issues, outline possible solutions and provide feedback to unit Manager.
  • Worked on projects specific to reporting - data validation and review of all data entered into Access as well as all reports generated from Access and Lucernex.
  • Utilize the newly developed Lease Controller software to capture leases and costs; design & document new SOX process for new leases/subcategories.
  • Writing complex SQL queries for validating the data against different kinds of reports generated by Cognos.
  • Generating weekly, monthly reports for various business users according to the business requirements.
  • Gathering the data from conversations and inputting into the CoStar database, Manipulating/mining data from database tables (Redshift, Oracle, Data Warehouse).
  • Providing analytical network support to improve quality and standard work results.
  • Ensure data files are produced in accordance with approved business logic rules.
  • Utilize a broad variety of statistical packages like SAS, R, MLIB, Graphs, Hadoop, Spark, Map Reduce and others.
  • Support validation team responses for site maintenance findings as well as corrective actions.
  • Create statistical models using distributed and standalone models to build various diagnostics, predictive and prescriptive solution.
  • Created and implemented procedure manuals for co-workers and future lease administration staff
  • Broad knowledge of programming, and scripting (especially in Python)
  • Improved processes and accuracy with advanced Excel tools including Pivot Tables, index, and VLOOKUP’s.
  • Interface with other technology teams to load (ETL), extract and transform data from a wide variety of data source.
  • Provide feedback in continuing validation process improvement.
  • Created additional data validation reports to help ensure accurate data and identify possible data issues.

Environment: Data Governance, SQL Server, Python, ETL, MS Office Suite - Excel (Pivot, VLOOKUP), DB2, R, Visio, HP ALM, Agile, Azure, Data Quality, Costar, Lucernex, Siterra, Tableau and Reference Data Management.

Data Validation Analyst

Confidential, Bloomfield, CT

Responsibilities:

  • Demonstrable expertise in core IT processes, utilizing ETL tools to query, validate, and analyze data.
  • Expert business and technical requirements documentation skills employing contemporary tools for data mapping, diagramming, Use Cases, and business rules to produce concise functional specifications.
  • Follow and assess the business process model defining metadata rules and critical data elements.
  • Conduct analysis, gather requirements, develop Use Cases, data mapping, and workflow diagrams.
  • Investigate unused modules of the DQM and report viability and feasibility for implementation.
  • Utilize multimedia office suite applications and conduct surveys for high level dashboard reporting.
  • Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS.
  • Interpret and analyze complex lease clauses such as tenant radius restrictions while maintaining current and accurate lease administration database information.
  • Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
  • Business requirement gathering and translating them into clear and concise specifications and queries.
  • Prepare high level analysis reports with Excel and Tableau. Provides feedback on the quality of Data including identification of billing patterns and outliers.
  • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysis.
  • Responsible for designing an approach for the application testing and the testing of interfaces that are integrated with the application.
  • Conduct data validation on inputs that trigger member communications including identifying high risk data files
  • Interacting with the Business teams and Project Managers to clearly articulate the anomalies, issues, findings during data validation.
  • Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts).
  • Gather analytical data to develop functional requirements using data modeling and ETL tools.
  • Improved Data quality using Macros, Advanced Excel functions, pivot tables & VLOOKUP to identify missing data.
  • Generated on data profiling and data validation for accuracy of the data between the Datawarehouse and source systems.
  • Used Ref cursors and Collections with bulk bind and bulk collect for accessing complex Data resulted from joining of large number of tables to extract data from data warehouse.
  • Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans.
  • Used Teradata as a Source and a Target for few mappings.
  • Load data from MS Access database to SQL Server 2005 using SSIS (creating staging tables and then loading the data).
  • Extensively using MS Excel for data validation.
  • Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
  • Migration of MS Access to SQL SERVER 2012.
  • Requirements gathering, analysis, Use Cases, data mapping, and workflow diagramming.
  • Data quality analysis and execution of the Data Quality Management (DQM) package.
  • Wrote SQL queries using analytical functions.
  • Documented Business Requirements, Functional Specifications, User stories.
  • Created UML based diagrams such as Activity diagrams using MS Visio.
  • Perform data extrapolation and validation of reports for analysis and audits.
  • Created T/SQL statements (select, insert, update, delete) and stored procedures.
  • Performed drill down analysis reports using SQL Server Reporting Services.
  • Documenting the extent to which data fails to meet threshold reporting requirements
  • Develop various SQL scripts and anonymous blocks to load data SQL Server 2005

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Access, MS SharePoint, MS Visio), SQL, SSIS, ETL, SSRS, Erwin, Tableau, SQL

Data Analyst

Confidential

Responsibilities:

  • Used Informatica Data Validation to create ETL Testing situation and conducted Data Validation before and after migration.
  • Archived and retrieved several applications using Informatica to archive the data and backload into the data warehouse.
  • Analyzed the relevant business information, transformed the data into a required business format and loaded into the Data Warehouse.
  • Used Informatica to create repeatable tests that validate PowerCenter mapping data.
  • Performed the validation between the development target and the testing target.
  • Used Informatica TDM tool for data masking. Tested complex masking rule, Plans in TDM to mask application
  • Perform periodic data integrity reviews to facilitate and monitor status for data cleanup to ensure consistent and reliable data flows
  • Used advanced excel to create pivot tables, charts, used VLOOKUP, and other functions.
  • Worked actively in ETL process and writing complex SQL queries for querying data against different databases (SQL Server and Netezza) for data verification process.
  • Created and executed all the test cases using Informatica PowerCenter.
  • Worked actively in data profiling, data scrubbing and data cleansing for Data Warehouse.
  • Written SQL queries to validate the data from Source to Target database.
  • Developed test scripts using QTP for Functionality and Regression Testing
  • Used Rally for Test Management and Defect Management.
  • Worked in OBIEE to generate reports and also test those reports according to the business needs.
  • Worked on automating most of the Manual testing scenarios using QTP.
  • Involved in writing automation script to validate the data from pre-stage to different staging layer and to the fact table.
  • Used advanced Excel features (Pivot Tables, VLOOKUP, Reporting) to analyze the data.
  • Used the UFT (Unified functional tool) for automation using the VB script as a scripting language.
  • Actively involved in Business meeting and the team meeting to understand the requirement properly.
  • Performed end to end data validation in the Historical Migration process from SQL Server to Netezza.
  • Performed end to end data validation in incremental data load in Netezza and making sure the data is flowing from Retention to Fact as per the lookup condition.
  • Used Informatica (Informatica Designer, Manager, and workflow) as ETL tool to check if the data is loading correctly and to debug the data using the debugger tool in Informatica.
  • Reported directly to the Director of Technology and Channel Managers on project metrics, status, schedules and risk assessments
  • Manage technical projects for software development and infrastructure improvements that encompass software and system upgrades.

Environment: Informatica, HPALM, OBIEE, SQL Server,Netezza, UNIX, Oracle, Jira, Agility Workbench, Flat Files and UNIX, Netezza, QTP

Hire Now