We provide IT Staff Augmentation Services!

Informatics Developer / Data Analyst Resume

4.00 Rating

Bethesda, MD

TECHNICAL SKILLS

  • SDLC
  • RDBMS
  • Data Warehouse
  • Database Design
  • MS SQL Server 2008/2012
  • Transact - SQL and MSBI(SSIS
  • SSRS) on Windows and Unix/Linux OS large data sets coding query writing
  • ETL and reporting
  • MS Office Word
  • Excel
  • PowerPoint
  • Outlook
  • Agile methodology
  • Scrum Process
  • TFS and JIRA issue tracking system

PROFESSIONAL EXPERIENCE

Informatics Developer / Data Analyst

Confidential, Bethesda, MD

Responsibilities:

  • Developed, implemented and maintained data management, data transformation, data integration, data visualization application, and reporting tools for predictive analysis with respect to access methods, access time, device allocation, validation checks, organization, security, documentation and statistical methods
  • Established procedures to solve complex problems regarding system equipment capacity and limitations, operating time and output; and prepared detailed specifications from which programs were written/designed, coded, tested, debugged
  • Selected acceptable RDBMS system, installed hardware, software, work station and servers.
  • Diagramed logical information flow, showing source and distribution of all segments, processing elements, channels, and methods of entering corrections, and data retention requirements
  • Proposed and revised database dictionaries, created Physical and Logical Entity Relationship Database Model
  • Integrated data, databases, packaged solutions and infrastructure components
  • Develop and deploy data transfer packages using SSIS and maintain the jobs running
  • Wrote SQL query, test T-SQL code and stored procedures
  • Perform user accounts administration, file management duties on AWS GovCloud server

Sr. Programmer/Data Analyst

Confidential, Chevy Chase, MD

Responsibilities:

  • Worked with project lead, manager and business users to understand business processes, gather and document project requirements and translate them into functional specifications for Business Intelligence reports and applications
  • Created a unified framework proactively managing the environment to bring data together from multiple applications and report out through various report initiatives.
  • Worked in development, UAT and production environments
  • Created database objects like Tables, Views, Joins, Store Procedures, Triggers, Functions etc. using T-SQL to store data and to maintain database, data warehouse and EDW efficiently
  • Created SSIS packages to extract heavy data, transform data from variety of source into different destinations data on daily basis
  • Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS
  • Developed reports core metrics, performance scorecard and quality assurance dashboard
  • Proposed report formats, including graphical presentations to effectively communicate meaningful data trends and relations
  • Delivered reports for business users and management’s review for further analysis
  • Utilized calculations, sorts, filters, and created new parameters based on new business requirements to enhance data presentation in reports; and created many drill down/drill through, cascaded parameters, ad-hoc reports
  • Detected and solved root causes in successful delivery of reports through JIRA issue tracking system, and maintain version controls on Team Confidential Server
  • Developed many Tabular Reports, Metrics Reports, Drill down/Drill through Reports and Scorecards using SQL Server Reporting Services (SSRS); and created many multi valued parameters in the reports
  • Provided 24 x 7 Production support to the database and application issues

We'd love your feedback!