SUMMARY

• 15+ years of experience in database design, modeling, administration, programming, solution design as well as expertise in business interface and leading projects.
• Strong hands - on experience in Cognos, Microsoft BI Stack of SSIS, SSRS and SSAS as well as installation, administration and maintenance of databases on SQL Server 2016/2012/2008/2005 in standalone as well as MS clustered environments.
• Proficient in T-SQL, Informatica and SSIS for ETL of data into warehouses tasks and setting up secure data exchange between with external vendors, clients and subsidiaries of the organization.
• Led the effort of designing and setting up reporting environment and data structures by setting up snapshot, transactional replication of databases for high availability OLTP applications and OLAP systems.
• Designed and developed data models, databases, SSAS cubes and reports. Strong experience in T-SQL, developing SQL CLR assemblies, SQL XML/XPATH queries, stored procedures, functions, views etc.
• Collaborated with business counterparts in requirements, suggested and developed effective BI solutions. Acted as project owner and coordinated activities for BI delivery projects.
• Experience in installing and configuring Oracle 9i and MySQL databases on Windows and Linux environments. Creating databases and granting user access to databases. Setting up DTS tasks for data transfer to SQL Server
• Hands on experience on Windows 2003/2012 Server, Linux and UNIX system administration.
• Experience in installing, configuring and administering Microsoft Cluster Services on SAN/NAS.

TECHNICAL SKILLS

Languages: C#, SQL, VB, Powershell, Perl Scripts

Operating Systems: Windows NT/ 2008/2012/2016 Server, Ubuntu, and Linux AS/ES.

BI Technologies: SSRS/PowerBI, Cognos 8/10, Tableau

Database: Servers MS SQL Server 2005/2008/2012 , 2016/2017, Oracle 9i, and MySQL

Applications: Red gate SQL,TFS,Git,Visual Studio 2017/2019, Informatica 9.x, Cognos 8/10, Erwin, E/R Studio.

PROFESSIONAL EXPERIENCE

Sr Data Engineer/Data Architect

Confidential, NY

Responsibilities:

• Designed and modeled data ware-houses and data marts for Enterprise BI solutions. Hands-on experience in SSIS and building complex stored procs in T-SQL for and performance improvement.
• Lead the requirements gathering from business units and designed, developed BI solutions using Tabular and MDX cubes in SSAS and built reports in SSRS/Power BI.
• Worked as Scrum master for data team and implemented the Agile practices. Interfaced with business units and external vendors and developed solutions for integration of data feeds of flat files and web services
• Designed the implemented the OLAP environment with SQL Replication/SSIS for sourcing the OLTP environment databases into OLAP environment for Analysis and operational reporting.
• Strong knowledge of SQL schema, system tables, SQL server internals. Hands- on experience in trouble shooting and resolving deadlock issues. Proficient in SQL Profiler and SQL trace files
• Hands-on experience in CLR assemblies with C#, XML/XML path queries to consume XML feeds and web-services from Vendors and applications
• Working knowledge of moving the on-prem SQL databases to Azure SQL and building Pipelines and SSIS in Azure Data Factory
• Hands-on experience in building dashboards in Tableau and working knowledge of Python for ETL and Analytics using pandas and numpy packages.

Sr BI/Data Engineer

Confidential, PA

Responsibilities:

• Designed database environment and provided technical support in set up, administration and migration of SQL Server 2005/2008/2012 servers in standalone and clustered environments.
• Designed the database structures, table partitioning and indexes for optimum query performance. Hands- experience in setting up transactional replication, log shipping to ensure high availability.
• Acted as technical lead for designing, developing, testing and delivery of suitable BI solutions for Commercial lines marketing, underwriting, predictive modeling and risk control departments.
• Hands on experience in developing stored procedures for complex queries for good performance, views for controlled access to data and triggers for data access audit purposes. Setting key constraints for data integrity.
• Strong knowledge of data modeling, designed and developed data warehouses, data marts and Tabular, Multi dimensional SSAS OLAP cubes. Familiarity with SQL Server data mining algorithms and concepts and SAS.
• Designed and developed ETL procedures using Informatica, T-SQL Stored Procedures, and DTS/SSIS for integrating data feeds to upstream OLTP and OLAP environments for reporting purposes and highly available data structures to meet reporting SLAs.
• Set up secure data transfer between external vendors, clients and divisions within organizations using SQL Server Integration Services, Informatica, Web service calls and File transfers.
• Developed SQL Server reports in SSRS, Power BI,SSAS cubes, Power-pivot models, Cognos 8/10 and designed the reporting data structures using replication and CDC and strong working knowledge of data modeling.
• Developed SQL CLR assemblies in C# to consume web services and strong working knowledge of XML/XPATH.

Database Administrator

Confidential, NJ

Responsibilities:

• Duties include installing and configuring SQL server 2000 to support production mortgage application. Setting up the RAID 1, 5 levels for fault tolerant database partitions. Supported large production databases.
• Install and configure windows 2000 server OS and configure windows environment security for securing the SQL server database access. Upgrade to 2003 server and migrate the databases.
• Hands-on experience on setting up Exchange 2003 server. Create and set up mail box permission and policies.
• Designed the structure of databases and tables, partition the active and Inactive portions of data over tables for better for optimum performance. Setting up key constraints to ensure the database consistency.
• Developed stored procedures, views and user defined functions. Developed the DTS packages for loading data from different ODBC sources like Oracle and other SQL Server databases.
• Hands-on experience on setting up snapshot, transactional replication for large databases. Troubleshoot and fix replication issues. Setting up database maintenance plans for backup and disaster recovery of databases.
• Set up SQL jobs for repetitive DTS tasks, indexing tasks and bulk import of data into database. Knowledge of database locking mechanism as troubleshoot and minimize the deadlocks on the database
• Installed and configured SQL Analysis services. Created data warehouses and OLAP cubes. Developed reports for historical data and aggregated measures.

SQL Server DBA

Confidential, VA

Responsibilities:

• Responsibilities include administer and troubleshoot the Clustered Windows 2000/2003 servers and the Clustered SQL Server 2000 servers. Migrated databases from 2000 to Windows 2003 Server environment
• Administer and troubleshoot the clustered SQL servers. Critical data has been managed on an EMC2 Clarion SAN component. Patch testing, deployment to database Servers and test the application functionality.
• Developed VB/WMI Scripts to update TCP/IP settings and automate administration tasks.
• Installed and configured Microsoft Operations Manager 2005 to monitor all the servers including Active directory, Exchange and SQL servers. Developed custom rules and alerts to monitor effectively.
• Installed SQL server 2000 and created databases using T-SQL and Enterprise manager. Users and role administration to database access. Setting up database maintenance plans for backups and recovery of databases. Developed the disaster recovery plan and database restores
• Hands on experience in developing stored procedures, Views to control the database access. Created functions and triggers to ensure the database consistency. Indexing the databases for faster data retrieval.
• Installed and Configured SQL Server 2000 Clusters for the database backend for applications. Developed DTS packages for database imports from Oracle and Access databases and other ODBC sources.
• Installed and configured SQL server reporting services and Analysis Services. Created OLAP cubes and reports.

System/Database Administrator

Confidential

Responsibilities:

• Duties include installing, configuring and maintaining windows 2000/2003 server, upgrading 2000 to 2003 server. McAfee/NAI antivirus updates to servers and deploying security patches to database servers
• Building windows servers according to organization standards with Altiris, Smart start and fault tolerant mechanisms with RAID 5. Documenting the server builds according to SOPs.
• Installed and configured MOM 2000/2005 for operations management of the servers and developed necessary customized rules for effective management and failure alerting for critical services. Monitored SQL, IIS, and windows servers.
• Hands on experience in designing and setting up AD domains, Windows 2000 to 2003 server migration, configuring subnets, DNS, DHCP Services. Strong working knowledge of WMI/VB scripting.
• Migrated to Exchange 2003.Configuring exchange server settings, mailboxes and exchange backups.
• Installed and configured Redhat Linux 9.0. Developed Shell scripts and cron jobs to automate the tasks.
• Hands-on experience in installing SQL Server 2000, SQL server instances. Creating databases and users. Administering backups through maintenance plans and restores. Migrating databases 2003 server environment
• Created the indexes to improve the query performance and key constraints to ensure database integrity. Set up the SQL jobs for repetitive tasks and SQL alerts. Strong knowledge of locking mechanism and dead locks.
• Implemented the snapshot, transactional replication for high availability of databases. Troubleshoot replications issues and database access issues to application.
• Installed and configured the web applications on IIS5/IIS6 with ASP.NET. Developed ASP based web component to Maximo application server for web clients’ access to application and authentication against MS SQL Server 2000 database. Strong working knowledge of web application development on ASP.NET with C#.

System/Data Specialist

Confidential

Responsibilities:

• Installed and configured windows 2000 server upgraded NT to windows 2000 server. Performed ghosting and also unattended installations employing sysprep for NT/2000 professional workstations.
• Administered tape backups and restore on Veritas Backup exec8.6 and Microsoft back up onto disks tape maintenance and disaster recovery. Install, configure print servers, print queues and print devices
• Designed and configured the Active Directory Services on both Windows NT and 2000. Migrated AD from NT to 2000. Configured corresponding security policies and group policies for users and group accounts.
• Installed and configured SQL server 7.0/2000 on Windows 2000 environment. Optimizing the performance through RAID and file groups. Developed database maintenance plans and recovery of databases.
• Duties also include creating databases using T-SQL and Enterprise Manager. Develop stored procedures, views and triggers. Ensured data integrity by developing primary, foreign and check constraints.
• Provide database support for production applications. Develop DTS packages to migrate data from MS Access, flat file into SQL Server.
• Duties include Installation and administration of mysql databases on Redhat Linux 8/9 servers. Developed shell scripts for backup tasks. Developed cron jobs and administered server resources for CPU, Memory, disk I/O