SUMMARY

• Highly qualified and well developed Senior SQL Developer/Business Analyst with extensive project lead experience that excels at leading cross - functional teams and coordinating multiple projects simultaneously using Agile and SCRUM Methodology.
• Solutions-oriented with notable success directing a broad range of IT initiatives while participating in planning and implementation of systems solutions in direct support of targeted business objectives.
• Exceptional problem solving, communication, organizational and time management skills.
• Full lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise-scale business applications and business intelligence software.
• In-depth knowledge of many web applications, database platforms, and enterprise environment systems.
• Unique competency in translating business issues into technical solutions including technical leadership and coordination, and ensuring customer needs are met.
• Outstanding leadership abilities; able to coordinate and direct all phases of project-based efforts while initiating efficient customer support initiatives.
• Exceptional multi-tasking skills with a wide-range of technical abilities and proficiency in several applications and database platforms.

• Systems/Business Analysis
• SQL Database Design
• Process Improvement
• Complex Problem Solving
• Database Administration
• Technical Staff Training
• Team Leadership
• Solutions Engineering
• Application Deployment
• Server Management
• Financial Services Industry
• Project Coordination
• Data/System Migration
• Troubleshooting/Testing
• Custom Enhancements

TECHNICAL SKILLS

Platforms: Windows Operating Systems

Software: Microsoft Office Suite, SQL Server, Server 2005, SQL Server 2008 Enterprise Manager, Visio, LogiXML, SSRS, SSIS, Cognos 8.3 (basic knowledge), Tera Data, SSAS(cubes/dimensions limited experience), Investran (back-end).

Languages: SQL, T-SQL, VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Senior SQL Developer/Data Engineer

Responsibilities:

• Understanding source systems, data issues and business rules.
• Designing dimensions and facts in a star schema environment.
• Reviewing and maintaining existing data warehouse tables.
• Writing ETL processes to bring in additional data from SQL, HIVE, etc.
• Pulling HIVE data into our data warehouse environment and created SSRS reports.
• Understanding data structures in HIVE and writing efficient queries in SSIS to pull incremental data.
• Using HUE to writing queries in HIVE DBs.
• Using Active Batch to schedule SSIS packages and Stored procedures.
• Maintaining SSAS tables.
• Going on pager duty and maintaining production processes.
• Learning Tableau and its features.
• Working in an Agile methodology driven environment with 2 week sprint and daily stand ups.

Confidential, Jersey City, NJ

Senior SQL Developer/Business Analyst/ETL Developer

Responsibilities:

• Partnered in building a script check in/check out tool in SSIS/VB that allows developers to make changes to scripts and check them into our production database.
• Designed documented and created a new production database environment that allows checked in scripts to run in our daily process to create population and sample files.
• Subject Matter Expert for the production environment, performed peer reviews, oversaw version control of production scripts, and gatekeeper of quality data entering the production database.
• Worked on new intakes to develop new population and samples for the Confidential testing team.

Confidential, Manhattan, NY

Assistant Vice President

Responsibilities:

• Supported production processes and reporting issues in a busy private equity firm while supporting Investran, a fund accounting system used to enter and maintain all funds the company created.
• Complied with Agile methodology for all projects from requirement documents and SCRUMS to execution and implementation.
• Developed SSRS reports and SSIS packages to automate data loads, as well as dynamic SQL and BULK data queries to read data from Excel and other files.

Confidential, Manhattan, NY NYC

Team Lead/Sr. Business Data Analyst

Responsibilities:

• Served as Equities Oracle BI/SQL Developer, working in a high-pressure trading floor environment on equities trade data and proposing solutions to the Equities Team on enhancements.
• Created, maintained and delivered dashboards and reports using Oracle BI (OBIEE) 10g. Also acted as Admin for all other users and provided appropriate access based on their roles.
• Organized and maintained business expectations by holding meetings with IPM to keep track of statuses and timelines.

Confidential, Manhattan, NY

Data Quality Analyst/Database Developer

Responsibilities:

• Consulted with business stakeholders, application developers, and business intelligence team to identify potential data anomalies and at-risk processes.
• Created recommendations for correction of data and developed business and technical processes to ensure data integrity at all times.
• Created SSIS packages calling stored procedures, querying Views from SQL Server 2008 for reporting and extracting data for clients.
• Created a file extract package for Toyota, GM (OEM) that provides data extracts in a delimited file for their internal imports.

Confidential, Red Bank, NJ

ETL/Database Developer/Data Analyst

Responsibilities:

• Played a key role in a conversion project that involved converting, mapping and moving data from legacy systems to the new Guidewire Claim Center, which is a well-known claims management application.
• Performed Test Cases and other QA standardized tests for every conversion piece in SQL Server 2008 and using Claim Center.
• Created aggregate claim codes for legacy Insurance system based on the business/treaty rules.