We provide IT Staff Augmentation Services!

Data Analysis Resume Profile

Skill Set Summary

  • SQL Server DB Admin: Installation, configuration, programming and administration of SQL Server 2000 - 2012, design, dev. and implementation of logical physical DB architecture, data warehouse development OLAP - De-normalized and OLTP normalized. Hands on development from the tabular level to procedural level, including index mgt. Programmatic solutions incorporating business rules for server db metrics and engine tuning. Assignment and/revocation of user logins, roles and database privileges including database security. Perform Sql Server optimization and tuning. Adjustment and configuration db internals, jobs and logs monitoring, paging allocation, memory and library management, SQL scripting of stored procedures, triggers and complex queries, log shipping, backups restores plus disaster recovery. Development, Administration and scheduling of DB maintenance plans. Legacy conversions of SQL Server 2000-2012. Lock Block control and error recovery, Local, linked remote server management, Manage distributed transactions and meta data services, Data replication - snapshot, transactional and merge, push or pull . Setup, configuration and synchronization of replication to include, as applicable, publishers, distributors, subscribers articles. Capacity planning, Business systems planning, SDLC, End-user and developer support.
  • Oracle Development: Oracle 9i, 10g 11.0 PL/SQL dev. of stored procedures, complex queries, triggers, for the aggregation of Oracle data in support and development of reporting solutions and API's.
  • BI Development: T-SQL programming, development and execution of DTS and SSIS packages, in the development of Marketing, CRM, ERP solutions. Data and control flow, constraints, extractions, transformations, data cleansing and data copies. DTS SSIS container and custom scripts development. DTS to SSIS conversion, BO Development in Business Intelligence Design Studio BIDS,SSRS Reporting.
  • SAP/Business Objects XI.R2/3:- BO Designer, BO Desktop Intelligence, and CMS. Develop BO universes global reporting solutions -
  • Objects, Classes, Parameters, Filters, T-SQL or PL-SQL programming, as applicable Reports development from parsed and aggregated OLTP OLAP data. Multi-data source universe solutions. Executive Operational reporting.
  • Crystal Reports 7.0-11-R2/3/2008:.Installation, configuration administration. Hands on report development, publication distribution.
  • CMS/CMC admin. Executive Operational Reporting. Excelsior Dashboard Development .
  • MS Access Development, Admin Programming Versions 2.0 - 2010: Upgrades, configuration, installation and administration. Development of macros, queries, forms reports, event procedures and VBA module coding. Data conversions to SQL Server, Multi-user and stand-alone API's. SQL Server/Oracle back-ends
  • Data Analysis Architecture: requirements gathering, qualitative quantitative data analysis, data modeling, data mapping, process and dataflow diagramming. Analytic trending and predictive data aggregation. Develop Statistical models, data driven analysis and relational, informational and operational models. Gather business intelligence regarding data acquisitions and conversions. ETL and reporting. UAT and case testing JAMMA .
  • Query review and testing, Data categorization/aggregation for API support and reports development, Tools Erwin, Visio- Salesforce Solomon - Microsoft Dynamics
  • Work Demographic: Massachusetts, Connecticut, Rhode Island

Hire Now