SUMMARY:

• Over 15 years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse.
• Strong understanding of Data Modelling in data warehouse environment such as star schema and snow flake schema.
• Hands - on experience leading all phases of software development efforts, including requirements, definition, design, development, testing and implementation.
• Extensive experience in Extracting, Transforming and Loading (ETL) using SSIS, bulk insert, BCP, DTS packages into the Data warehouse from heterogeneous databases.
• Highly proficient in using T-SQL for developing complex stored procedures, tables, views, SQL joins and T-SQL scripting
• Highly experienced in Logical and Physical database design & development, normalization and data modeling SQL Server Enterprise Manager
• Highly experienced in turning complex business logic and business rules into database design through the use of stored procedures, triggers and function
• Experienced at database tuning utilizing analyzing clustered/non-clustered indexes, execution plans and query design to improve performance
• Demonstrated capacity to implement innovative, dynamic software solutions that meet all functionality requirements as identified during the requirements phase of the development process.
• Adept at developing effective, dynamic solutions that meets the current budget and technical limitations; but designed in such a way that provides the means of easy transition to other technologies.
• Experienced working with offshore vendors and establishing offshore teams and processes.

TECHNICAL SKILLS:

RDBMS/DBMS: MS SQL Server, MS Access, Oracle

Database Technologies/Tools: SQL Server Enterprise Manager, T-SQL, Query Analyzer, SQL Profiler, SSIS, SSRS, BCP, DBCC, Power BI

Programming Languages: VB.Net, C#, SQL, XML, HTML, VBA

Operating Systems: Windows 8, Windows 7, Windows XP

Software: SQL Server (7.0 - 2014), Visual Studio .Net (2003 - 2016), Crystal Reports (7.5 - XI), MS Office (2.0 - 2016)

Web Tools: Internet Information Server (IIS), FTP

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Senior SQL Developer

• Created 50+ customized drill-through and parameterized reports according to the business requirements in SSRS.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle and flat files.
• Involved in all phases of software development life cycle, to include requirements, design, development and testing.
• Designed and developed efficient, complex stored procedures using multiple joins, CTE’s, and subqueries.
• Responsible for conducting code reviews of junior programmers.

Confidential, Jacksonville, FL

Senior SQL Developer

• Design, develop, implement and maintain stored procedures, SSIS packages and reports for multiple contact center clients and divisions.
• Contribute to platform architecture decisions by providing expertise from the database perspective.
• Define and maintain documented software development policies and procedures, best practices and coding standards.
• Proactively identify and implement opportunities to improve data collection, interface design and database performance.
• Participate in technical and business strategic planning discussions.
• Review and validate task estimates assisting in the creation of project timelines.

Confidential, West Palm Beach, FL

Senior ETL Developer/Technical Lead

• Created and updated Business Requirement and Functional Requirement documentation.
• Created test cases from analyzing business, functional, system requirements and diagrams during the design phase of projects that achieved 100% accuracy of the goals required by several business units.
• Assisted in the design documentation for process to merge SAP and JDE customer, vehicle and sales transaction data into a Teradata centralized data repository.
• Assisted Lead Architect in system design and specification documentation.
• Created more than 25 ETL packages to merge, cleanse and transform data into centralized Teradata repository.
• Designed and developed multiple packages for consuming 3rd party web services into integration plan, including WHI, Carfax and Polk.
• Integration of Crystal Reports reporting capabilities into all custom application development; Development of robust, dynamic reports to meet the ever changing customer needs.
• Responsible for identifying test scenarios, conditioning test data and executing test plans.
• Organized and facilitated project planning, daily stand-up meetings, reviews, sprint, release planning, demos and other Scrum-related meetings.

Confidential, Richmond, VA

Senior SSIS/SSRS Developer

• Designed and developed many SSIS packages for the management/processing of daily data load files utilizing Control Flow, Data Flow and Script task to cleanse, transform and load millions of rows of data from various sources
• Facilitated the Requirements Phase for multiple, simultaneous projects.
• Developed complex Stored Procedures to generate various drill-through reports, parameterized reports, Matrix reports and linked reports using SSRS.
• Created 35 customized reports for clients and legal representation.
• Integration of Crystal Reports reporting capabilities into all custom application development; Development of robust, dynamic reports to meet the ever changing customer needs.

Confidential, PA

Senior Database Developer/DBA

• Technical Lead for constructing new data warehouse for data integration between financial and operational databases.
• Tuned 100+ existing stored procedures, ETL packages and DTS packages that increased performance by 45%.
• Responsible for identifying process improvements and gathering requirement documents to help manage the development expectations.
• Designed new ETL processing for Marketing Department that increased accuracy of daily export files, used by Blue Hornet, by 35%.
• Created 25 new ETL packages for marketing campaigns from specifications provided.
• Utilized SSIS for data migration from multiple data sources, to include SQL Server, MS Access, XML, flat files and automated data feeds to SQL Server utilizing SSIS, bulk insert, BCP and DTS packages.
• Monitored and improved performance of SQL Server 2005/2008R2 databases using SQL query redesign, analyzing of indexes, keys and execution plans
• Mentored and trained 3 junior level database developers on performance tuning and efficient SQL syntax through code reviews and weekly training sessions.
• Refactored existing MS Access and Excel reporting applications to SSRS reporting services. Decreased time required for daily, weekly and monthly reporting by 50%.
• Provided on-call support for production system issues.
• Provided ad-hoc reports to various departments and Senior Management.

Confidential, Exton, PA

Senior Programmer Analyst

• Performed functional review of legacy system and created new specification documentation to be used during the design and implementation phase.
• Designed and developed custom Contact / Claim management system to include a client-server application, new SQL Server 2008R2 backend database and all corresponding stored procedures, SSIS/DTS packages and reporting capabilities with SSRS and Crystal Reports.
• Designed and developed several ETL packages for daily data integration with new environment.
• Provided on-call support for production system issues.