SUMMARY:

• I have extensive experience in the Information Technology Industry. I have worked as Business Intelligence Developer
• Data Warehouse Designer, Data Quality Governor, ETL designer/developer, Data Modeler, BI Architect, Client Server/Web Developer, Analyst and Lead.

PROFESSIONAL EXPERIENCE:

Confidential

Sr BI Develoepr/Architect

Responsibilities:

• Dimensional data modeling - modeled enterprise data warehouse. Implemented EDW on Sql Server and Snowflake. \• Created tables, indexes, views, stored procedures, user defined functions, common table expressions analytical functions to facilitate efficient data manipulation and data consistency using T-SQL.
• Designed and developed ETL SSIS packages and scripts.• Wrote data governance SSIS packages queries.• Guided and coordinated with team members

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Dimensional data modeling - modeled data warehouse. Designed and developed SQL Server Integration (SSIS) packages, C# code to extract and transform and load (ETL) from various sources such SQL Server, Flat files, Oracle, Sybase, XML, as well as various data quality check matrixes related to financial data.
• Created tables, indexes, views, stored procedures, user defined functions, cursors, common table expressions (CTEs), analytical functions to facilitate efficient data manipulation and data consistency using T-SQL, PL/SQl Enhanced SSAS cubes and wrote MDX quires. Rewrote existing queries to improve performance substantially. Migrated from Sql server and 2016. Managed database releases, coordinated with team members to collect and organize deployment packages. Deployed SSIS, Database objects with Azure cloud DevOps services. Guided and coordinated with team members.

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Dimensional data modeling - modeled data warehouse. Designed and developed ETL SQL Server Integration (SSIS) packages, C# code to extract and transform and load (ETL) from various sources such Teradata, SQL Server, Flat files related to financial tax, billing, revenue and audit data. Created Tidal jobs and monitored
• Tidal job portal for job progress, errors. Created tables, indexes, views, stored procedures, user defined functions, common table expressions (CTEs), analytical functions to facilitate efficient data manipulation and data consistency using T-SQL. Designed and developed table partitioning for better performance and maintenance for high volume data with billions of rows. Analysis for migration from Sql Server . Prototyped SSAS cubes and wrote MDX quires. Rewrote existing queries to improve performance substantially. Managed releases, coordinated with team members.

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Modeled data warehouse. Tuned the database for performance. Designed and implemented indexing and partitioning strategy to improve query performance and database maintenance. Designed and developed SQL Server Integration (SSIS) package, C# code to extract and transform and load (ETL) from various sources such
• SQL Server, Flat files, Oracle, SAP as well as various data quality check matrixes. Created tables, indexes, views, indexed views, stored procedures, user defined functions, cursors, common table expressions (CTEs), analytical functions to facilitate efficient data manipulation and data consistency using T -
• SQL. Rewrote existing queries to improve performance substantially. Migrated from Sql server . Managed database releases, coordinated with team members to collect and organize deployment packages. Wrote database development standards. Guided and coordinated with team members.

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Remodeled data warehouse. Tuned the database for performance. Designed and implemented indexing and partitioning strategy to improve query performance. Designed and developed SQL Server Integration (SSIS), packages to extract and transform and load (ETL) from various sources such SQL Server,
• Veritca, Denodo, Hadoop, Flat files, Sybase, xml, Oracle etc as well as various data quality check matrixes. Created tables, indexes, views, indexed views, stored procedures, user defined functions, cursors, common table expressions (CTEs), analytical functions to facilitate efficient data manipulation and data consistency using T - SQL, C#. Rewrote existing queries to improve performance substantially. Migrated from Sql server .

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Gathered requirements about data warehousing needs for financial data related to trading and investment activities and risk analysis. Design and developed Multidimensional data models Developed and maintained SSAS OLAP cubes, wrote MDX queries and Excel /SSRS reports against it. Converted reports to SSRS from in house reporting tool in Share Point integrated mode.
• Developed ETL stored procedures and SSIS packages to pull data from various sources to SQL Server Wrote JIL scripts to create Autosys jobs and monitored Autosys job portal for job progress, errors. Wrote stored procedures and C#, vb.net modules. Tuned the databases for performance. Managed releases.

Confidential

Sr BI SQL Developer / Architect

Responsibilities:

• Gathered requirements about data warehousing needs for financial data related to Fixed income - CMBS and RMBS, Risk Design and developed Multidimensional data models. Developed and maintained SSAS OLAP cubes, wrote MDX queries and Excel /SSRS reports against it. Developed ETL stored procedures and SSIS, C# packages to pull data from various sources to SQL Server, Oracle, Netezza Wrote JIL scripts to create Autosys jobs and monitored Autosys job portal for job progress, errors. Developed SQL server objects such as Tables, Views, Triggers, Indexes, Stored Procedures, Functions,.
• Scripts Tuned the databases for performance. Managed releases. Guided team members. Worked out hardware capacity requirements and coordinated with System Administrators / DBA for migration of applications to new Windows 2008, 64bit servers from Windows bit servers and from SQL Server 2005 to
• SQL server 2008 R2. Converted databases/SSIS packages/ SSAS cubed/ SSRS reports from SQL server 2005 to SQL server 2008 R2 Interfaced between Share point Admin and SAs and DBA for moving share point to new servers and setting up SSRS in share point integrated mode.. SQL server 2012 components (SSAS, SSRS, SSIS) conversion from SQL server 2008R2. Developed Power view/ Power Pivot application. Analyzed what all changes are needed for moving databases to Netezza from SQL server.

Confidential

Sr BI Developer/Architect

Responsibilities:

• Gathered requirements about data warehousing needs for securities (Hedge Funds/ Equities/ Fixed Income/ Options). Designed relational and dimensional data model using ER - Studio. Designed and developed SQL Server Integration (SSIS) ETL packages for Risk data. Created Control-M jobs and monitored Tidal job portal for job progress, errors. Created tables, indexes, Views, index views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency using 2008/2005 T-SQL.
• Wrote SQL queries. Tuned the database for performance. Coordinated with Micros strategy reporting team and prototyped SSRS reports /SSAS cubes. Managed monthly releases

Confidential

Sr BI SQL Developer/Architect

Responsibilities:

• Owned reporting module. Gathered requirements for securities (Hedge Fund / Equities/ Fixed Income/ Options) Designed relational and dimensional data model. Designed and developed SQL Server Integration (SSIS), C# ETL packages. Created Control - M jobs and monitored Tidal job portal for job progress, errors.

  Designed and developed OLAP solutions and (Sql Server Analysis Services - SSAS) cubes. Designed and developed SQL Services Reporting Services (SSRS 2008) Reports against SSAS Cubes and Data Warehouse with charts. Wrote T-SQL and MDX queries. Developed Tableau 8 Data Visualization dashboards. Comparison analysis and tests between Power BI and Tableau. Developed stored procedures and SSIS package to pull market data. Created tables, indexes, Views, index views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and

  Triggers to facilitate efficient data manipulation and data consistency using T-SQL.PL/SQL, C#. Tuned the database for performance. Designed and developed .net classes, controls and web pages for displaying reports. Guided and coordinated with team members. Confidential, New York From Sr BI SQL

  Developer/Architect See section above for Confidential .