Data Analyst / Application Developer Resume Seattle, WA - Hire IT People

SUMMARY

10+ years of experience working in Data Migration along with experience with developing DTS, data migration documents like method, mapping template etc.
Data Analyst 10+ years of experience working with different methods of Customer Master Data. Also worked on projects like Customer Engineering Communication Management System and developed customer engineering Multi - Tier application
10+ years’ Experience as a and developed data-process methodology, Developed Data Model for Data warehouse - ETL, Developed a data warehouse documents like metadata.
Experienced Data Analyst and SQL developer with a strong background in gathering requirements, executing strategy and working cross functionally to support teams.
Knowledgeable in API level testing
Knowledgeable in data process methodology and evaluating key data trends.
Passionate about improving existing systems and transformations.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Data Analyst / Application Developer

Responsibilities:

Gathered client requested data, analyzed and generated reports using Excel / SQL
Maintained and improved web content
Developed web-based Freight Dispatching System for small sized trucking companies
Managed trucking operation in one place to reflect: Loads, Invoices, Shippers, brokers, drivers
Documented and tracked equipment and maintenance requirement
Maintained the website content to improve better search and traffic generation using JavaScript, jQuery, CSS, HTML5, PHP and MySQL

Confidential, Seattle, WA

Business / Data Analyst & SQL Developer

Responsibilities:

Developed data-process methodology
Performed data extraction, transformation and loading (encrypting and decrypting) using internal tools and industry standards (SAP EDS, Microsoft Excel, Microsoft SSIS (SQL Server Integration Service)
Developed Data Model for Data warehouse - ETL
Experience in analyzing and designing Customer Master Data, Data analysis, Data Mapping etc.
Supported multiple marketing programs with report generation via Excel and limited Tableau
Improved existing systems and removing redundancies with automation using SQL Stored procedures/Functions/triggers

Confidential

Business Analyst

Responsibilities:

Developed functional specifications (business rules, UI)
Interpreted and translated complex transformation rules into functional specification
Analyzed Oracle database model (using SQL Developer, Visio, Toad)
Designed and Develop SQL Query codes for Business Transformation Rules of Data Migration/ Integration using Toad, Oracle SQL Developer, Oracle APEX
Developed and validated system functionality, lineage and data-flow diagram
Performed unit testing and support Integration testing as required
Configured/Created Outbound Tables/Queries (Oracle) to map for SAP Objects (Material, Bill of Materials, Classifications)

Confidential

System / Business Analyst

Responsibilities:

Software Quality Assurance Engineering, Integration / functional testing (Agile Development)
Validated CDW PMVIEW (Oracle Database Views)
Executed SQL Script to validate CR Views in multiple environment using ASP .Net WSDL (Web Services)
Performed Test Harness and Test Automation using Quality Center/Quick Test Pro

Confidential

Sr. Software QA Engineer / Data Analyst

Responsibilities:

Developed a data warehouse document (artifacts), metadata
Web Analytics responsibilities to track where students were spending their time researching programs and universities
Designed test cases with embedded SQL scripts and API to validate data integrity
Developed a DTS (Data transformation tool) for data migration
Web UI testing / Quality Assurance
Developed test plan and test cases (presentation layer)
Used automation testing (using Selenium and some ruby, JMeter Performance test)
Developed data migration documents (i.e. method, mapping template)
Worked with Business Analyst to compile data sources from the legacy system
Developed SQL script, Java code for the target database
Worked with Talend /MySQL/ Toad to validate data discrepancy
Validated data quality using Actuate Report against transaction and aggregated data.
Worked with Google, Yahoo and MSN API Search Engine for click and impression and Lead Generation

Confidential, Seattle, Washington

Sr. Software QA Engineer

Responsibilities:

Developed Test Plan, Test Cases against product specification, use cases.
Prepared FMEA (Failure Mode and Effective analysis) for multiple projects
Developed product configuration tool for automation and regression test using Java programming
Performed API level Back-end testing via Quest Toad validating data integrity
Wrote SQL scripts against Oracle and MySQL databases.
Performed regression, system testing of Integrated Clustered Environment sing
(Web-Service SOAP, Application Server and Database Tier) in BEA WebLogic and Apache/Tomcat platform
Filed program defects, track till they are fixed
Mentored fellow new test engineers
Performed Data Migration, Report Analysis and Payment Processor testing with 3rd party application (CyberSource)