SUMMARY:

• Highly accomplished, deeply driven, Technology professional with 10+ years of progressive experience in Database Management and Information Technology field, with comprehensive hands - on expertise in Financial, data warehouse architecture, Team Leadership and application development management and support. Repeatedly demonstrates the ability to apply technical skills for the of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams.

TECHNICAL SKILLS:

Database/Big Data/Analytics Platforms Experience: .Big Data / Data Science / Hadoop / Microsoft Business Intelligence / BI / Business Intelligence / SSRS / SSAS / SSIS / SQL / T-SQL / MDX / Azure / Cloud / AWS / Data Warehouse / ETL / Power BI / Architect / Big Data / Hadoop / Scala / Python / Apache / Hive / Spark / MS Azure / Amazon Web Services / AWS / EMR / RDS/ Redshift / S3 / EC2 / Lambda / Glue / Data Pipeline / Kafka / Power BI / Data Lake / Data Lake Analytics / Azure IoT Hubs / BLOB Storage / HDInsight / Data Factory / Machine Learning / SQL Data Warehouse / Steam Analytics / Ruby / DynamoDB / Kinesis / Data Engineering

PROFESSIONAL EXPERIENCE:

Confidential

Avp, Data Engineering

Responsibilities:

• Responsible for leading a high performing data engineering team that support the Perdictive modeling and Data Science teams.
• Build out data Platform infrastructure of Sql server 2017 and PostgreSQL 9.6 to support multiple large 250 million record datasets.
• Design and deliver applications to automate analytic models written in R and Python utilizing NLP and Machine learning.
• Develop interfaces in .Net and Python/Flask that allows an endused to use analytic model and machine learning solution.
• Architect various big data solutions to enable the analysis of large set in Hadoop/Spark/Hive environment.
• Liason with internal IT team to build out Data Lake infrastructure and resolve issues.
• Build and support various Big data pipelines to support the digitalization/analytics and modeling functions.

Confidential

Data Solutions Architect

Responsibilities:

• Provide leadership on data architecture for a SaaS Financial Recognition and rewards systems running on azure cloud platform.
• Responsible for leading the design/development efforts of ETL solutions to sync data between on premises legacy systems and Azure cloud Platform.
• Designing, implementing and supporting complex Master Data Management solutions used to migrate legacy ecommerce platform to azure Cloud platform.
• Responsible for management of enterprise Data Models for various systems.
• Architect various data enhancements to the system such as interface with SalesForce.com.
• Big Data Architect of Hadoop/Hive solution used to analyze sales and traffic log for ecommerce site.

Confidential

EDI Database Systems Lead/Technical Project Manager

Responsibilities:

• Database Performance including stored procedure tuning, optimization, execution plan analysis, code deployment, index management of Large MultiTerabyte SQL Server Instances in a BizTalk 2009 environment. Utilize performance analysis tools such as SQL Profiler, PSS-Diag and SQL Sentry to capture data streams and identify potential performance and scalability issues.
• Architect, Setup and Deployment of Amazon RDS instance Multi-AZ sql server.
• Setup Cloud-watch to monitor to monitor health of AWS RDS instances.
• Design amazon virtual private Cloud, security groups, EC2, S3 and cloud front to support database tier systems.
• Create Data migrations packages using ssis and third party tools to Replicate, load data and perform bidirectional sync of data between AWS cloud to on-Premise.
• Develop and review of T-SQL and database changes to solve various business issues and automate database administration tasks which include backup and recovery, partitioning, CDC, triggers, cursors, indexing change, SQL Agent jobs and SQL Mail. Utilize SSIS and Data stage tools for all ETL tasks. Design BI multi-dimensional data models using SSAS.
• Develop various UNIX shell scripting using (ksh, bash) and Oracle PL/SQL to automate various database tasks

Confidential

Enterprise Database Administrator/Developer

Responsibilities:

• Support and Project management of Enterprise wide farm of Sql Server 2000/2005/2008/2012, Netezza and Oracle database Systems used to support a data/analytic intensive Global Company.
• Perform Data migration of CRM System from SalesForce.com to Microsoft Dynamics CRM 2011.
• Lead Global CRM migration
• Design and Architecture of high availability /Clustered Database and Load balanced Applications Systems and server to support a 24x7 Global CRM System and Financial Analytics Data Warehouse.
• Management and integrate legacy systems/data into new Global CRM system, Plan and Migrate Salesforce.com and in-house custom CRM to Microsoft Dynamics CRM 2011.
• Perform enterprise wide upgrade of Database Clusters from 2000/2005 to SQL Server 2008 R2/SQL 2012.
• Manage Oracle 10g System apply Software Patches, daily database administration and user accounts.
• Implement, Administer and integrate Linux/Netezza Twin Fin appliance into Company s Database Infrastructure.
• System Manager Role involving operating and supporting Enterprise application Netezza as an EDW (i.e. deploying DDL, backup, replication, re-indexing, Change Management etc.).
• Developed shell scripts Design and Execute solution to Load data 100+ Million Row tables in the Netezza warehouse used for deep Analysis of financial Data used to support the Business Intelligence initiative for Global Banking, Securities and Trading Customers.
• Database Tuning and proper indexing of Large Analytic Financial Data sets and High volume transactional systems reducing query /System run times.
• Troubleshoot ETL, IIS, and San Storage, SAP Business Objects, Database replication issues and Web applications interaction with enterprise database systems.

Confidential

SQL SERVER DBA/Developer Financial Systems

Responsibilities:

• Perform day-to-day DBA activities in a high transactional and multi server environment including, but not limited to: backup, restore, Database Tuning (high transaction 24x7 environment),
• Develop ETL solutions using Sql 2005 SSIS/DTS used to load data in 2005 database and automate back office Financial and clinical Processes.
• DBA Team Lead for Supporting Production Sql 2000/2005 database servers and applications.
• Supervise and coach 3 junior team members.
• Perform SQL-DBA functions handling production support DBA/Applications issues.
• Experience with the full development lifecycle (SDLC) with WPF, Silverlight, Win/Web forms on the front end and SQL Server and Oracle backend.
• Lead architect and developer for the design and implementation of financial reporting and data warehouse for the integration of Medical Management systems McKesson CCMS and Trizetto Claims System.
• Disaster recovery Team Lead for SQL Server database, 60 Financial and Clinical Systems.
• Database Tuning (high volume), Database Management (clustering, replication and data migration) and Database Security

Confidential

Contractor/Consultant

Responsibilities:

• Drive development of business intelligence/data warehousing solutions for assigned projects.
• For marketing strategies in a multi database platform MS/SQL and DB2/Unix environment.
• Lead development resources through prototype, design, and development of business Intelligence. Manage project risks and scope with internal and external clients.
• Effectively communicate project status and progress to all stakeholders.
• Develop several web based OLAP projects using Microsoft Analysis Services, MS- Reporting Services.
• Develop T-SQL stored procedures to fix/cleanup data quality issues in a large enterprise datawarehouse.
• Develop exports from transaction system to OLAP system.
• Integration new Merger and Acquisition companies data and databases into UHC Galaxy Data warehouse.

Confidential

Technical Team Lead/DBA

Responsibilities:

• Hands on DBA and Technical Lead for the implementation of Enterprise Healthcare ERP for /HMO/TPA.
• Develop eligibility data warehouse, Clinical/claims OLAP cubes used for reporting and tracking of key healthcare business indicators.
• Develop web based applications front end and integration tools used across the enterprise, reusing existing business rules and leverage SOA/Web Services and database-stored procedures.
• Built various components used in reporting application that deliver reports over the web and on schedule, Develop the applications using ASP.NET/ASP, C#, Visual Basic COM objects, Crystal Reports and DBI third party controls.
• Function as Database Administrator for SQL Server 2000 and Sybase Adaptive Enterprise Server 12.5 used by various client server and Web applications across the enterprise.
• Perform DBMS upgrade, tuning, dumping and load services for Sybase DB Servers across the enterprise.
• Application and Database Architect of client server application used to manage Healthcare Providers network Database in a SQL Server environment, Design database, code user interface and manage/set project deliverable, deliver project within budget and time constraints.
• Enterprise Application Management responsible for software upgrade, Disaster Recovery and business continuity processes for both Databases and Applications.
• Manage applications system build, change request control and configuration of HBOC Pathways, Amisys C/S, QNXT and McKesson s CCMS applications.
• Coordinate, QA testing efforts, System security changes, business user signoff and daily enterprise support of production issues.
• Architecture and Design of Application solutions used to implement new business for major Health plan customer such as GHI, AETNA, Oxford Health Plan, Confidential, and Health Net
• Responsible for creating and processing inbound and outbound EDI Transactions to process Healthcare and Financial EDI X12 Transaction set (834,270,276,278).
• Develop and customize various maps using tools like Mercator, EDIDEV, EC Map to process, import and convert HCFA 1500, UB92 medical claims and HIPPA standard transactions.

Confidential

Project Manager/Technical Lead

Responsibilities:

• Work as part of a team developing a web bases reservation system running over the Internet.
• Developed interface systems using Oracle 8I, PL/SQL, Unix Shell programming, ASP, XML, HTML, Visual Basic 6.0 and JavaScript.
• Develop a web based reporting framework for the application using Crystal Reports 7
• Lead software developer for point of sale application for a retail environment.
• Design databases, develop interface screens in Visual Basic 6.0 /ASP to handle sales transaction, inventory management module, accounting systems module allowing pos to interface with most off the shelf Accounting systems.

Confidential

Information Systems Manager

Responsibilities:

• Function as Hands on manager and Technical Lead for all aspects of software development, Network administration for a national Vitamin manufacturing and retail organization.
• Management and maintenance of corporate databases and Supply Chain ERP application used for order processing, inventory management, fulfillment and Electronic Funds Transfer and processing.
• Implementation of Point of Sale system incorporating real time credit and debit card processing using icverify and JIT inventory management-reporting system used in corporate retail stores nationally.
• Development and deploy several application using Visual Basic, SQL server 6.5 and Visual FoxPro in an effort to create tools to automate various business processes, provide historic sales trends and providing management with accurate Financial, Marketing and Sales Data Analysis essential for growth.
• Deploy Internet based solutions providing the communication infrastructure necessary for conducting Business on the World Wide Web (WWW.LEF.ORG) and effectively communicate with other international divisions and customers around the world using internet/intranet bases solution using ISDN, T1, Internet Routers and TCP/IP.

Confidential

Senior Analyst /DP Manager

Responsibilities:

• Successful migration and retooling of corporate information infrastructure.
• Network Analysis, Installation, and Troubleshooting of Novell 3.12 network, setup of user accounts, installation of software and hardware utilizing Hubs, Bridges and Routers.
• Systems Manager for a Digital Equipment VAX minicomputer responsible for solving software/hardware and network connectivity problems across the enterprise.
• Successful integration of Novell, OS2, Windows 95, Windows 3.1, CITRIX Winview and VAX/VMS achieving a reliable and state of the art network infrastructure.
• Responsible for maintaining Client Server database applications used for underwriting, claims processing and accounting.
• Develop several applications using FoxPro/Visual FoxPro, C, C++, SQL, Progress and other 4GL tools.
• Develop two Commercial software packages AAA Quick Quote TM and Advantage Member Care TM used by credit unions nationally to analyze and select Extended Warranty Insurance Coverage.
• Responsible for maintaining and setup of Predictive Dialer utilizing real-time database access.
• Develop and maintain user interface and management tools use for sales processing, payroll, forecasting, and Direct Mail marketing and lead acquisition.
• Database maintenance and integration, performance tuning, disaster prevention.

Confidential

User Consultant

Responsibilities:

• Troubleshoot PC hardware and software problems in 2000 user DECNET LAN/WAN environment.
• Create user accounts, network monitoring and daily backup of Novell file server.
• End-user support for PC and Macintosh hardware and software.
• Assist students in debugging of programs in a Variety of programming languages and applications software.