SUMMARY

• 12+ Years of business and IT consulting experience in Project Management, Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test and Production environment with experience in MS BI stack (SSIS/SSRS/SSAS).
• 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.
• Worked on all activities related to the development, implementation, administration and support of ETL process for large - scale Data Warehouses using SSIS .
• 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.
• Experience in Performance Tuning and Query Optimization.
• Professional experience of SQL Server installation, login and user creation, role and permission configuration.
• Migration experience fromlower version of SQL Server to higher version.
• Migration/Conversion experience from SAS, Access, C# to SQL Server.
• Experience in implementing high availability using Log shipping in SQL Server 2014.
• Utilizing Visual Studio for program development.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with fullSDLC(Software Development Life Cycle).
• Self-motivated and possess ability for critical thinking, analysis and strong ability to identify suitable solutions using existing resources and new tools.

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
• LAN/WAN
• CRM
• WordPress
• SEO
• Windows
• TCP/IP
• XML/XLT

PROFESSIONAL EXPERIENCE

Continental, DE

Independent Consultant - SQL BI Database Developer

Responsibilities:

• Credit Protection Program: 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.
• SAS Migration: 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. Constructs BI STACK (SSAS,SSRS,SSIS) .
• Data integration: 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.
• Migrate C# applications to SQL Server applications.
• Use Team Foundation Server as source code control and change management tool.
• Maintain high availabilitySQLenvironments using log shipping.
• Support daily production systems.
• Maintain referential integrity, domain integrity and column integrity by using constrains etc.
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Assist to ensure performance, security, and availability of databases.
• Tune SQL queries usingexecution plansfor better performance.
• Manage indexing, debugging, optimization and performance tuning usingSQL ProfileandSQL Server Agent.
• Developdatabase triggersand stored procedures using T-SQL cursors.
• Configure and use database mail.

Confidential

Independent Consultant - Database Developer

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, Vineland NJ

Senior BI Database Developer

Responsibilities:

• Designed and developed Data warehouse tables, ETL packages and data warehouse models utilizing T-SQL, SSIS, SSRS and SSAS.
• Created and managed MS SQL files, databases, tables, indexes.
• Wrote complex stored procedures using T-SQL and schedule to run based on business needs on the back end to support front end reporting portal for BSA/AML, accounting, marketing/sales scorecard etc.
• Integrated Analysis Services and Reporting Services with SharePoint to use Power Pivot, Power View, and Reporting Services for SharePoint.
• Developed and tuned stored procedures, Integrated Services Jobs, and Reporting Services reports.
• Reviewed and revised, as required, design of logical and physical data models and file structures.
• Identified and resolved systems integration issues including activities associated database performance, reporting, and .NET applications.
• Provided technical assistance to the Enterprise Database backup group when requested.
• Developed and implemented strategies for gathering data from operational databases as well as third-party vendors for inclusion.
• Managed large database and application projects including requirement gathering, project planning and problem resolution.

Confidential, Lancaster, PA

Application Developer

Responsibilities:

• Analyzed SQL data, writing stored procedures and queries.
• Made changes to existing workflows based on client's requirements.
• Took client data and moved it through a service oriented architecture (SOA).
• Built a series of processes from the input stage to the output stage using XML and SLT.
• Utilized Agile Project Management in program developing.

Confidential, DE

Senior Analyst

Responsibilities:

• Created and deployed ETL processes using SSIS packages developed in SQL Server Business Intelligence Development Studio (BIDS).
• Developed projects using SQL Server SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using DMX.
• Generated variety of business reports using SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010.
• Successfully loaded the data from MUNIS (ERP software) and vendor report web to SQL Server database and analyzed and explained the results using SSRS, Crystal Report and Access as tools.
• Performed account analysis on the various revenue accounts and prepared various reports and conduct analysis.
• Recommend changes to improve accuracy and timeliness of existing processes.
• Established a daily report to help senior management in leading the day to day operations.
• Conducted analysis for ticketing and booting enforcement and collection processes and recommended suggestions to enhance the reporting and verifying procedures.
• Conducted Cost-Benefit analysis for various projects including Digital Parking Permit.
• Streamlined the revenue reconciliation processes for over $200 million revenue.

Confidential, Philadelphia, PA

IT Auditor

Responsibilities:

• Applied IT general controls concepts and auditing theories, procedures, and techniques to various applications, platforms, databases or operating system environments to ensure Sarbanes-Oxley compliance.
• Extracted and compile data for audit testing using standard software such as SQL Server 2008 (SSIS, SSAS, and SSRS), Microsoft Access, Excel, and ACL audit software.
• Provided consulting services to the organization on risk and control concerns.
• Supported management initiate ongoing process improvement initiatives.
• Utilized expertise in flowcharting, process and control mapping, and root cause analysis to assist the projects.