Business Intelligence(SQL) Developer

• Aug 2020 - Present

Business Intelligence Developer

• Oct 2018 - Aug 2020

Gathered, analyzed and documented the business requirements and business rules by directly working with end users. Created and maintained documents such as Documentation Road-map, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan. Developed different Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Created appropriate Triggers to assist efficient data manipulation and data consistency. Developed also database objects like tables, stored procedures, triggers, user defined data types and functions. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance. Implemented Error handling through TRY-CATCH method and used CTEs. Responsibilities included fine-tuning the SQL Server to achieve best performance. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications. Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database. Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports. Created and scheduled lot of SQL Jobs, using SQL Server Agent to perform various Administrative tasks. Created SSRS and Power BI reports from Multidimensional OLAP and Tabular model cubes with Multidimensional Expressions (MDX) and Data Analysis Expressions DAX. Developed and Maintained Custom and Crystal Reports. Implemented row level security RLS in Power BI reports to limit the data access by user roles. Show less

SQL BI Developer

• Jul 2017 - Sep 2018

Gather business requirements to develop BI solutions with team. Work together with Financial Planning and Analysis Manager and other stakeholders to find better solutions for the goals. Manage and maintain daily operations, including database backups and restores, maintenance jobs, and developers’ requests. Created database objects including Tables, Views, Stored Procedures, Function, Indexes, Statistics, Constraints, Partition Function and Schema and optimize the query performance. Created T-SQL scripts (generated tables and relationships), based on the customer’s request. Identified source, destination and staging area of data per ETL strategy and performed data cleansing and data profiling. Created new database objects like procedures, functions, indexes and views utilized T-SQL. Used System as well as User-Defined functions to increase the functionality of my T-SQL query. Creating SSIS packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures. Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling. Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a directory to load inbound files coming daily. Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure and errors. Pulled data into MS SQL Server Database from different DBMS databases sources like Oracle and Teradata with ETL packages. Created SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX. Developed and Maintained Complex Reports. Created and scheduled many SQL Jobs, using SQL Server Agent to perform various Administrative tasks. Designed, developed and maintained Tabular models based on Enterprise Data Warehouse. Show less

Database Engineer

• Aug 2011 - Jul 2015

Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies. Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships. Configuring tuning and optimizing T- SQL. Responsible for performing basic developer task like creating, altering and updating tables. Developed simple stored procedures, queries, views, joins and indexes by using T-SQL. Normalized the tables and maintained Integrity by using Primary and Foreign Keys. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse. Created, maintained and updated ETL packages loading both OLTP and OLAP database tables. Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS. Acquired data from primary or secondary data sources and maintain databases/data systems Identified, analyzed, and interpreted trends or patterns in complex data sets. Filtered and cleansed data, and reviewed computer reports, printouts and performance indicators to locate and correct code problems. Worked closely with management to prioritize business and information needs. Located and define new process improvement opportunities. Performed debugging and troubleshooting the technical issues while implementing the applications. Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Show less