- Worked as a developer in various client facing projects involves technologies like SSIS, SSRS, SQL Server and Power BI.
- Developed SSIS packages to load data from various sources like flat files, xml files, excel files etc to sql server database.
- Developed ETL SSIS package to read delimited flat file and load to SQL server target database.
- Developed SSRS reporting dashboards reading data from sql server database.
- Created Power BI demo dashboards based on the various needs of specific domains like social network, health care etc.
- Developed SSIS package to process xml files and load to multiple target sql server database.
- Created a End to End SSIS package using control flow and data flow to load XML file as soon as we receive in the landing folder.
senior bi developer
- Create Reporting Solutions for various departments of the bank
- Build BI reports and dashboards using IBM Cognos
- Understand business requirements and translate them into technical solutions
- Wrote Code sourcing Oracle Database by Connecting Reporting Services (SSRS) through ODBC.
- Analyze data to create reports based on clients request.
- Conversion of existing reports in crystal format.
- Design and implement reports using crystal reports XI based on data pulled via SQL within encore clinical and Financial.
- Experienced in providing business solutions to various levels of decision making activities with up-to-date activities, quality, complete and accurate reports including drill down and roll up capabilities
bi developer, data & analytics
- Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems that comprise databases like XML, Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
- Develop scripts to automate the execution of ETL using shell scripts under Unix environment using Autosys.
- Expertise in SQL Server and T-SQL (DDL, DML and DCL) in constructing Tables, Joins,Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules
- Implemented Copy activity, Custom Azure Data Factory and Azure Data Flows Pipeline Activities for On-cloud ETL processing .
- Expert in creating, debugging, configuring, and deploying ETL packages designed MS SQL Server Integration Services (SSIS)
- Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
- Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease
- Worked on the Enhancements of Existing Reports and Fixed Bugs in the PROD Environment.
- Created New Reports with Minimal Requirements by Communicating with the Business Users.
- Used Drill down, Drill Through, Parameterized functionality in the report
- Deployed Reports to Report Center/ Reporting Services Portal.