Informatics Developer / Data Analyst Resume Bethesda, MD - Hire IT People

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 provide IT Staff Augmentation Services!

Informatics Developer / Data Analyst Resume

Bethesda, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship