Director of Data Management & Analytics

• Sep 2016 - Present

Sr. SQL Server BI Developer

• Dec 2015 - Sep 2016

 Create new and update reports as per Report Requirement Documentation (RRD) using Report Builder and Business Intelligence Development Studios of SQL Server 2012.  Creating new packages and update existing packages from BRD (business requirement documents).Create and update T SQL code for all requirements  Using RRD developed SQL queries and developed SSRS reports in BIDS.  Update existing report s from Report Builder as per RRD  Extensively worked with SQL Server queries and store procedure.  Developed and designed SSRS reports as per requirements.  Worked with Complex T-SQL queries to get the desired result from database tables  Manage data-mart and data warehouse  Troubleshoot existing reports and packages.  Worked on new and existing Stored Procedures, Functions, Views and Other objects  Worked extensively on SQL, SSRS, and SSIS  Used C# for code behind logic.  Creates SSIS packages using data flow: Excel, Flat File, OLE DB as data flow sources, Aggregate, Data Conversion, Derived column, Cache transform, Conditional split, Lookup, Merge join, Multicast, Row count, Sort, Union all, OLE DB Command as data flow transformation, Excel, Flat file, and OLE DB as data flow destinations. Show less

SQL Server BI Developer

• Dec 2013 - Dec 2015

 Created Project and Reports using SSRS. Developed yearly and quarterly company expense reports.  Scheduled ETL packages using SQL Agent  Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS  Developed parameterized reports which were used for making current and future business decisions.  Developed table, queries, views, store procedures and trigger. Design SQL Server relational database Show less

SQL Server Developer

• Aug 2012 - Dec 2013

 Worked on Microsoft Visio 2010 to create event diagrams, MS Excel and Access.  Developed an SSIS ETL package to upload data from Excel.  Develop SSRS report to track events in the year throughout various categories as well as revenue generated.  Worked with development team to optimize the department webpage with more information using HTML, CSS, and ASP.NET.  Created Views to reduce database complexities  Worked on Microsoft Visio 2010 to create event diagrams, MS Excel and Access.  Developed an SSIS ETL package to upload data from Excel.  Develop SSRS report to track events in the year throughout various categories as well as revenue generated.  Worked with development team to optimize the department webpage with more information using HTML, CSS, and ASP.NET.  Created Views to reduce database complexities

SQL Server BI SSRS Developer

• Jun 2010 - Aug 2012

 Generated various reports like Cascade type reports, Tabular reports, and Drill down reports  .Worked on analyzing and performance tuning queries by looking at the appropriate joins.  Install and design SQL Server for ETL and reporting  Designed, developed and deployed SSRS reports that include; parameterized reports, drill down reports, drill through reports, click-through reports and SubReports  Generated various reports like Cascade type reports, Tabular reports, and Drill down reports  .Worked on analyzing and performance tuning queries by looking at the appropriate joins.  Install and design SQL Server for ETL and reporting  Designed, developed and deployed SSRS reports that include; parameterized reports, drill down reports, drill through reports, click-through reports and SubReports

BI Developer

• Mar 2008 - May 2010

 Provide FCC / Flexcube Support by executing SQL queries in Oracle 9i.  Build and modify business reports on Business Objects and crystal reports to provide management with needed reports such as loans, checking accounts, savings accounts, audits, financial and accounting.  Wrote transformations to extract data from multiple sources (CSV, Excel) and build SSRS reports for operations department.  Manage MSSQL server database as well as schedule jobs to facilitate daily data  Provide FCC / Flexcube Support by executing SQL queries in Oracle 9i.  Build and modify business reports on Business Objects and crystal reports to provide management with needed reports such as loans, checking accounts, savings accounts, audits, financial and accounting.  Wrote transformations to extract data from multiple sources (CSV, Excel) and build SSRS reports for operations department.  Manage MSSQL server database as well as schedule jobs to facilitate daily data