We provide IT Staff Augmentation Services!

Data Architect & Bi Resume

SUMMARY:

Highly self - motivated professional with great analytical and communication skills and 15+ years’ experience in database design, development and maintenance on SQL Server in high volume and high transactional OLTP environment including credit card payment application . Self-motivated and tech savvy team player with a passion for technology accompanied by special interest and expertise in RDBMS. A service oriented mentality with high sense of ownership of the problems and requests assigned, focusing on managing and resolving issues, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. A nalyzing business and technical requirements, and mapping them to implementation strategies and database designs and implementing information systems that led to organization being leader in industry.

TECHNOLOGY PROFILE:

Software: Microsoft Office, Excel, Access, Visio, Erwin, All OS, MS Project, SQL Server, SAN based storage systems and Virtual Server environments

Software development: Visual Studio.Net, BIDS, ASP, SQL Server, DTS, SSIS, SSRS, SSAS, C#, VB, VBA, T-SQL, VB Script

Technologies/Protocols: TCP/IP, Active Directory

WORKING EXPERIENCE:

Confidential

Data Architect & BI

Responsibilities:

  • Collaborating with business analysts, system architects, software architects, design analysts, and others to understand business or industry requirements, create and/or follow chosen technology roadmap
  • Gathering Business Requirements (goals, objectives, budget, timeline, compliance, legal) and creating SSD (System Specification Document) and DDD (Design Detailed Document)
  • Generating Technical Requirements(Data sources, Performance, Scalability, High Availability - Database Replications, Mirroring, Snapshot and Log Shipping; Disaster Recovery, Maintainability)
  • Data Warehouse/Mart processing (Master Data Management, File placement, Partitioning, Recovery model, planning ETL - Staging design, data cleansing, control flows, data querying and transformation using scripts, network transfer, Data Modeling - Visio, Erwin. Processing: multidimensional vs. tabular - disk vs. memory, queries execution)
  • Maintained high Data Warehouse performance by using suitable data types, defining needed data, indexing, partitioning, compression, optimizing Windows Server setting and hardware requirements; Implemented SCD - Slow Changing Diminutions to store data changes, SSIS Deployment model - Project vs. Package deployment
  • Reporting SSRS - client requests, rendering, caching, dashboards using Tableau
  • Managed and mentored group of 5 senior developers to become SQL efficient and set high standards for database implementation and modification

Senior Database Administrator

Confidential

Responsibilities:

  • Experienced in Installation, Configuration, Maintenance, Tuning, Upgrading and Administration of SQL Server, applying patches and service packs to keep the database at current patch level and managing security
  • Implemented DR and High Availability solutions based on RTO and RPO, Backup (compressed) locals and remote (Azure Clouds); SQL (and Windows) Clustering with SAN Replication, Snapshot databases for development environment, Log Shipping for reporting and non-production transactions
  • Reached high Scalability by using large tables partitioning, multi-core CPUs and Storage area networks (SANs)
  • Experienced with partitioned schemas, tables and indexes, File groups; implemented SQL Server Auditing (database objects), CDC - Change Data Capture (database and table levels)
  • Established policies and procedures related to data security and integrity
  • Automated SQL Server maintenance activities by using SQL Agent Jobs with written T-SQL code procedures
  • Wrote Distributed Queries between SQL Servers by creating linked servers, AD-HOC Query
  • Experienced with SQL Server Analysis Services, Microsoft Azure Services: SQL Server, Compute - VM, Storage, Backup for database development
  • Analyzed the organization's needs and developed a long-term strategy for data storage
  • Managed all phases of credit-card database development for e-comm project, including mapping, designing, configuring, implementing, testing, and post-launch support
  • Integrated client’s information systems using ETL (Extract, Transform, Load) - SSIS and Data Warehousing
  • Experienced with migrating database from Access and SQL servers to newer SQL Server versions, extracted business logic from VBA code, macros, queries and interlined tables, triggers and stored procedures

SQL Database developer

Confidential

Responsibilities:

  • Coordinated physical changes to databases; and codes, tested and implemented SQL databases modifications, established physical database parameters
  • Designed and implemented stored procedures, views and other application database code objects
  • Maintained SQL scripts, indexes and complex queries for analysis and extraction
  • Experienced in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard, Performance Monitor, Dynamic Management Views and functions, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks
  • Diagnosing and resolving database access and checking on performance issues using DBCC
  • Analyzed the needs of company and establishes priorities for feasibility studies, systems design and implementation to develop new and/or modify the company's custom made information processing systems
  • Mitigated risk factors through careful analysis of financial and statistical data
  • Full SDLC ( Software Development Life Cycle ) management experience, p repared project plans that outline expected tasks and activities
  • Consolidated all company processes into centralized software application including new processes to increase users efficiency
  • Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
  • Moved between Agile (XP, Crystal, Scrum, and FDD) and Waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

Confidential

Database Analysis

Responsibilities:

  • Identification of the data elements which are needed to support the data processing system
  • Usage of properties of and relationships between data elements
  • Preparing database specification and structure necessary to support business requirements

Confidential

Database Administrator

Responsibilities:

  • Installing and configuring SQL Server
  • Taking part in the preparation and execution of technical tests
  • Populating a database with new information and/or transfer existing data into it
  • Creating backup copies of data
  • Setting database security and also preventing data loss
  • Identifying and escalating immediately any risks to the database service
  • Designing physical database schema, data modeling

Confidential

Database Administrator

Responsibilities:

  • Coordinating physical changes to databases structure; and testing made changes
  • Calculating optimum values for SQL database parameters
  • Setting up user security access level for each segment of data items for all user action, such as insert, replace, retrieve, or delete data
  • Tested and corrected errors and refined changes to database

Hire Now