We provide IT Staff Augmentation Services!

Senior Technical Data Analyst Resume

Herndon, VA

PROFESSIONAL SUMMARY:

  • Software Engineering, Software & Database Design, Technical Troubleshooting, Software Development Life Cycle (SDLC), Testing Methodologies
  • Data Modeling Concepts, Cross - Team Collaboration, Client Relationship Management
  • Analytical, highly adaptable professional with extensive experience in the field of software design, development and testing of business applications aimed at improving quality and efficiency.
  • Adept in translating business needs into solutions that meet technical specification, client expectation and project timelines.
  • Experience in the Data Analysis, Design, Development, Implementation and Testing using ETL
  • Worked on creating tables, views, triggers (DML and DDL) and store procedure based on business logic
  • Experience in the SQL development tool set and creating Data definition and metadata repositories.
  • Participated in physical implementation partitioning, cluster, indexing, etc.
  • Experience in creating Data definition and Metadata repositories.
  • Experience in Dimensional Data Modeling, Star Schema modeling, fact and dimension table design, physical and logical Data modeling
  • Experienced in Load Data Warehouses (Star Schemas) and developed supporting Jobs for Extraction transformation Loading (ETL) mechanism.
  • Experience in Report creation using Tableau and Pentaho BI suites.
  • Skilled troubleshooter continually focused on identifying, isolating and resolving technical issues.
  • Strong organizational skills evident in executing many complex tasks simultaneously.
  • Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.
  • Establish data integrity auditing process

TECHNICAL EXPERIENCE:

Programming Languages: SQL, VB.NET, TQL, JavaScript, C, C++, C#.net, ColdFusion, Snowflake Pentaho, SnapLogic, Dbamp, Clover, DataStage, Tableau

Databases/Servers: MySQL, SQL Server, PostgreSQL, Oracle

Operating System: Visual Studio, GitHub, MobaXterm, MS Visio, JIRA SQL Server Management Studio, DBConnect, SQL Developer, Source Tree, WinSCP Linux, Windows 7, Windows 2000/NT, XP

PROFESSIONAL EXPERIENCE:

Senior Technical Data Analyst

Confidential, Herndon, VA

Responsibilities:

  • Organized & led extremely complex projects, defined project scopes, schedules and deliverables.
  • Analyzed data requirements, developed complex MS SQL Server queries/stored Procedure to extract data using advanced techniques to research causes for data gaps, discrepancies and drove insights via longitudinal analysis
  • Performed Quality improvement analytics on operational activities across the client-base and consolidated reports by identifying and defining metrics, thresholds and benchmarks
  • Worked on Data definition and Metadata repositories.
  • Worked on Data analysis and Validation
  • Developed customized reports to ensure adherence to data management regulations and policies.
  • Developed and maintained dashboard reports using MS SQL, MS Excel and Tableau to visualize data and provide insight applying accurate and appropriate interpretation of data
  • Worked on production support as front line to solve issues immediately.
  • Worked on business Intelligence solutions in Data warehousing using ETL tools
  • Created new Data models based on source system
  • Worked on Data Mapping
  • Identify continuous improvement initiatives and provide support and input to improvement projects
  • Develop, refine, and manage data quality success metrics and Key Performance Indicators (KPI’s)
  • Created and maintained technical design documentation which includes current functionality, data dictionary, data mappings and flows/diagrams
  • Fostered an agile culture, building trust and collaboration across all team members.
  • Developed dashboard using tableau to provide visualization which empower clients to make better decision
  • Worked on Data profiling using complex sql query and Etl tools like Pentaho
  • Worked on designing and creating access and Identity Management
  • Supported automation and enterprise consolidation of data used in monthly, quarterly, and annual metrics reports for Confidential .
  • Developed star schema model.

Technical Scope: SQL, MySQL ETL Tools: Pentaho, DTS, SSIS Packages, Visio, Visual Studio, Tableau

Senior Technical Data Analyst

Confidential, Sterling, VA

Responsibilities:

  • Consulted with business unit management to identify and document business needs, current operational procedures, problems, data scope, usage, formatting and security.
  • Gathered, analyzed business data and generated reports in order to identify issues & trends.
  • Utilized technical and industry knowledge to work on projects across multiple insurance platforms
  • Provided technical, business and expertise in identifying, analyzing, evaluating, and developing systems and procedures
  • Developed, coordinated, and implemented plans to test business and functional processes
  • Coached team delivering stories to meet the definition of done
  • Involved in defining the source to target data mappings, business rules and data definitions
  • Involved in defining the source to target data mappings, business rules and data definitions
  • Partnered with the business as a functional expert in a specific technology platform or IT focus area.
  • Proposed process improvements within a specific technology platform
  • Involved in defining the source to target data mappings, business rules and data definitions
  • Created data trace map and data quality mapping documents.

Technical Scope: SQL ETL Tools: Pentaho, DTS, Visio

Senior Technical Analyst

Confidential, Washington, DC

Responsibilities:

  • Effective in cross-functional environment, able to work with Manager, Business Architects and Team Leaders to understand the business requirements and implement the business rules to redesign and enhance the existing dataflow and develop new integration with different systems.
  • Support more than 25 internal customers for their ETL needs, integration with Salesforce, Workday, Expense system and other internal systems .
  • Work with business data stewards to define data quality rules, and BTS resources to implement data quality validations/reporting
  • Ability to prioritize competing demands to ensure that data quality activities are delivered on time in line with business expectations
  • Play a key role in creating sources to target mapping and low-level design documents . Redesign existing system for better data performance and scalability.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Created, tested and ran the application configuration to compile the list of data quality issues and compute data quality metrics.
  • Created and developed User stories for various project on Data warehousing
  • Developed user store for data integration modules
  • Analyze business requirements and perform current/target/gap analysis.
  • Analyzed the physical and logical data model
  • Worked on Data Mapping for cloud base application like saleforce and workday
  • Proficient in designing and developing ETL jobs , utilizing Pentaho as an ETL tool to extract data from heterogeneous sources, applied transformation logic to extract data and load into Data Warehouse Databases.
  • Created data trace map and data quality mapping documents.
  • Performed data profiling and data quality in the source systems
  • Achieve data accuracy and identify data anomalies by using Information Analyzer across various projects.
  • Expert in creating ETL jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Copy, Modify, Filter, Change Data Capture, Column Generator, Row Generator, etc.
  • Work on Data Migration of products between different centers.
  • Successfully complete critical business processes on a daily basis . Perform data investigations to pinpoint source of failures and provide round the clock support and quick resolution for failures.
  • Maintain Data Warehouse table by loading dimensions and facts and enhance them.
  • Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
  • Participate in writing test scripts and creating shell script to run Pentaho jobs from UNIX; utilize scheduling tool to run the ETL jobs.
  • Manage the central and local repositories using Github.
  • Facilitate the migration of data flows to QA and production environment for Go Live.

Technical Scope: SQL, MySQL, ETL Tools: Pentaho, SnapLogic, DBAmp, DTS, SSIS Packages Salesforce, and BI Reporting Design

Application Developer

Confidential, Gainesville, VA

Responsibilities:

  • Developed applications based on design specifications in .Net platform and user interfaces using C#.net, Web Services, JavaScript and AJAX, as well as, developing scripts using SQL and T-SQL which interfaces to a .NET backend.
  • Designed, developed and published comprehensive reports using SQL server reporting services integrating data from a variety of sources. Created test plans and managed unit and integration testing.
  • Integrated and developed web applications with corporate data source which are mission critical and highly available.
  • Provided technical support for existing applications by trouble shooting and diagnosing application issues.

Technical Scope: SQL, My SQL, VB.NET, Telerik, JavaScript, Ajax, SSRS, BML, Big machines, Salesforce and VSS

Software Engineer

Confidential, Vienna, VA

Responsibilities:

  • Designed high level and detailed mock-ups for Data Management Center application.
  • Created reports to track performance of drivers, agents and sub-contractors, sum up exception details, summarize in - house accounts and get POD count report.
  • Improved system performance through customizing partner sites, designing reports based on requirement and resolving problems by interacting with customers.

Technical Scope: C#net, SQL, TQL, Java Script, jQuery, Ajax, Cold fusion, Visio, Paint.net and Dreamweaver

Software Engineer

Confidential, Vienna, VA

Responsibilities:

  • Interacted and gathered requirements from various satellite operators to customize COMPLAN.
  • Strategically analyzed and enhanced all the phases of Complain which is used in communication satellite development & operations.
  • Developed an application to track internal delivery of processors & computer equipment.

Technical Scope: C++, XML, Galaxy Application

Hire Now