SUMMARY

• Seasoned independent data science consultant with MBA in MIS (Management Information Systems) and 12+ Years of business and IT consulting experience in Project Management, Database Design, Development and Business Intelligence.
• Proven ability to create and deliver solutions tied to business growth, organizational development and data management optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.
• Extensive domain knowledge in Banking, Telecommunication, Government, Healthcare, Utility, Manufacture, and e - commerce etc...
• Worked on all activities related to the development, implementation, administration and support of ETL process for large-scale Data Warehouses using SSIS 2008-2014.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Mapping, Stored Procedure, Constraint, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reporting using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience utilizing Analysis Services in SharePoint integrated mode (PowerPivot for SharePoint), and Power BI.
• Professional DBA experience of SQL Server installation, login and user creation, role and permission configuration, tuning, Log shipping, query optimization and server migration.
• Migration/Conversion experience from SAS, Access, C# to SQL Server.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle). Utilizing Visual Studio 2005-2013 for program development.

TECHNICAL SKILLS

• SQL Server
• T-SQL
• SSIS
• SSRS
• SSAS
• MS SharePoint
• Power BI
• Data Warehouse
• BCP utilities
• Crystal Report
• Power View
• Access
• Visio
• Project
• CA Erwin
• TFS
• SAS
• C#
• VBA
• HTML
• CSS
• Oracle
• CRM
• WordPress
• SEO
• Windows
• TCP/IP
• XML/XLT
• Teradata

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Program Manager

Responsibilities:

• Automated existing manual sampling process to increase productivity and accuracy.
• Apply and develop highly advanced data access routines to extract data from source systems for monitoring operations compliance to banking Laws, Rules and Regulations.
• Act independently to uncover and resolve issues associated with finding data that can be used by Compliance Testers to monitor operational compliance.
• Serve as a consultant to Test Designers to ensure appropriate data filters are applied based on business/product needs.

Continental

SQL BI Database Developer/Architect

Responsibilities:

• Utilizing SSIS to migrate data from vendor system to in-house system. Write and schedule to run ETL packages and SSRS reports to produce daily reports for internal and external users. Prepare conversion mapping documents. Write T-SQL based on business requirements to perform data cleansing.
• Using T-SQL, SSIS and SSRS to convert SAS processes to SQL Server applications based on existing processes and new design and requirements to streamline the legacy processes.
• Utilizing T-SQL BULK INSERT, BCP utility, T-SQL and SSIS to create automated processes to load data from internal and external sources (data files) to SQL Server databases.
• Migrated C# applications to SQL Server applications.
• Used Team Foundation Server as source code control and change management tool.
• Maintained high availability SQL environments using log shipping.
• Supported daily production systems. Performed DBA routines.

Confidential

Database Developer/Architect

Responsibilities:

• Gathered and documented requirements and business needs.
• Translated requirements into technical and functional design for back-end solutions.
• Developed, tested, implemented, and supported all aspects of data integration utilizing SSIS, Stored Procedures, C#, and VBA.
• Created tables, views, functions, stored procedures, and SSIS packages for validation and loading processes.
• Created and documented unit testing.
• Deployed from Development to Test and from Test to Production.
• Evaluated, analyzed and monitored databases to resolve performance issues.
• Participated in end-user training, support and documentation.
• Created and maintained documentation of processes, databases, applications and procedures.
• Utilized TFS (Team Foundation Server) source control and Rally for Version Control, Agile Planning & Collaboration and Reporting.

Confidential

Senior BI Database Developer

Responsibilities:

• Integrated Analysis Services and Reporting Services with SharePoint to use Power Pivot, Power View, and Reporting Services for SharePoint for Accounting Department.
• Developed variety of Integrated Services Jobs and Reporting Services reports for different service functions.
• Supported production systems including identifying and resolving systems integration issues, such as activities associated database performance, reporting, and .NET applications.
• Reviewed and revised, as required, design of logical and physical data models and file structures.
• Developed and implemented strategies for gathering data from operational databases as well as third-party vendors for inclusion.