SUMMARY:

• Experience on installation, troubleshooting, administration experience with Microsoft SQL Server 2012/2014/2016.
• Strong technical understanding of data modeling, design, architecture principles and techniques across master data and transaction data.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission - critical production systems to meet business needs, using SSIS, SSRS, SSMS and other Microsoft development tools.
• Knowledge of SQL Server Integration Services (SSIS) and strong understanding of DW processes and OLAP concepts.
• Develop a data modeling for Data warehouse database and maintain referential integrity.
• Experience on Development and maintenance of SSIS Data Transformation Services packages and SSRS matrix and dashboard reports.
• Analyze workflow charts and diagrams and translate operations requirements into technical designs to map and automate data load from source systems to data warehouses, downstream applications, and trading partners
• Monitored and created automated scheduled Jobs; Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking.
• Implemented backup and recovery strategies; performed Full and Transaction Log Backups and restored them whenever necessary; Regularly Monitored Resources availability, Database and log files size.
• Experience on script development and troubleshoot SQL Code and design (stored procedures, tables, views, triggers, indexes, constraints).
• Develops, maintains and monitors automation for continuous validation of data quality, alerting and triaging system for data quality failures.
• Administer, test, and implement databases, applying knowledge of database management systems
• Monitor database performance, implement changes and apply new patches and versions when required
• Ability to multi-task and context-switch effectively between different activities and teams.
• Strong oral and written communication skills and Strong documentation skills (scope, requirements, high-level design).

TECHNICAL SKILLS:

Language: T-SQL, PL/SQL, HTML, XML, XSLT, ESQL and R.

ETL/Reporting tools: SSIS, SSRS, SSAS, Query Analyzer, Export / Import (DTS), and Crystal Reports

Statistical tools: Excel (pivot table), SPSS, and SSAS.

Database: clustering, mirroring, log shipping, partitioning, replicating and always on available group

Hard disk storage area: SAN, NAS, RAID /Striping

Performance Tool: Tuning Advisor, Profiler, extended event, DTA, SSMS, SAC, SSCM, PerfMon and DMVs.

Operating Systems: Windows Server 2003/2008/2012 , VM Windows XP/7, Citrix Xen Server and Terminal Server.

RDBMS/DBMS: MS SQL Server 2005/2008/2012/2014 , Azure, 2000, DB2, oracle 10/11 and SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

BI Developer

Responsibilities:

• Provide database administrator functions for database setup, tuning and query optimization.
• Perform administration, maintenance, monitoring and security tasks ensuring our database infrastructure is running efficiently and smoothly.
• Provide expertise and guidance in logical and physical database design, development, operations, security and maintenance
• Partner with our network team to ensure proper server setup, security, backups and shared resources are being utilized efficiently.
• Create/modify SSIS packages.
• Create/modify reports in SSRS.
• Experience with database design and modeling as related to data warehousing and business intelligence.
• Designs, maintains and monitors the data warehouse, including persistence layer (operational data store, reporting warehouses, and metadata management).
• Oversees the configuration and optimization of hardware/software.
• Performs database optimization activities to improve query, integration and reporting layer performance.
• Develops, maintains and monitors automation for continuous validation of data quality, alerting and triaging system for data quality failures.
• Continually ensures completeness and compatibility of the technical infrastructure and data warehouse implementation to support system performance, availability and architecture requirements.
• Develops database objects and structures for retrieval and analytics, according to defined specifications.
• Participates in the resolution of any database-related issues that occur during or after normal business hours.
• Documents data integration processes, metadata and other related items.
• Determine business intelligence and data warehousing solutions to meet business needs.
• Database administration and development experience with SSIS and SSRS.

Confidential

ETL Developer

Responsibilities:

• Generate recurring and ad hoc reports and forecasting as needed
• Acquire data from multiple data sources and build dashboards for key business metrics
• Translate stakeholder’s requirements into reporting deliverables and proactively communicate on progress and findings
• Develop, modify, maintain and support custom reports (T-SQL) for both ad hoc and ongoing needs
• Maintain ongoing metrics, dashboards to drive key business decisions
• Identify ways to standardize and automate regular reports
• Identify and document service level risks and trends, performing root cause analysis when service levels are impacted
• Develops, tests, and promotes Microsoft SQL Server code and ETL jobs to support the BI.
• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary
• Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
• SQL Server Installation, Upgrades, Migrations and Configuration
• Install database software service packs and cumulative updates as necessary
• Maintain database documentation as required
• Maintain and administer database security access
• Perform database Ad-hoc backups and restores
• Troubleshoot and resolve database connectivity issues
• Follow Change Management processes to implement database configuration changes
• Follow Problem Management processes to troubleshoot and resolve recurring issues
• Proactively monitor and respond to MSSQL database Alerts.
• On-call requirements to ensure 24 x 7 support of database operations