Sahithi

• Developed SSIS Packages for full loading and incremental loading of data in data warehouse using ETL mapping document.
• Performed debugging and unit testing of packages and tasks in a package.
• Developed dynamic packages with connection managers at project level, package level and parameters for facilitating dynamic packages.
• Implemented packages using tasks like execute SQL task, data flow task, script task,etc.
• Used data flow task for ETL and transformation tasks like Lookup, merge, merge join, row count, union all, OLE DB, SCD commands.
• Implemented logging in packages using SSIS logging.
• Implemented Transformations like derived column, conditional split using expressions in transformations of Data flow task.
• Integrated Data from different sources SQL Server, Oracle, DB2, Flat files like Excel,CSV.
• Implemented event handling on required events like Error, Post Execute, Pre-Execute.
• Implemented Performance Tuning with Parallel Execution Buffer Size increase from default and source side sorting and data type conversion.
• Trouble shooting SSIS Packages for memory handling issues.
• GIT integration for SSIS projects and version control.
• Implemented fact and dimensional modelling of tables in Data warehouse and created a package for each fact and dimensional tables that are to be loaded into Data warehouse.
• Implemented slowly changing dimension for required columns in type 0 type 1 type 2.
• Loaded the fact table with OLTP tables and surrogate key from dimensions.
• Created reports using SSRS with shared data sources and datasets.
• Used different visualizations Table, matrix, list, line.
• Deployed reports to report server and access to business users.
• Created multiple page reports with sub reports and drill through options with parameter passing through the drill down pages.
• Used cascading parameters for user filter options and user based selection.
• Connected to SQL Sever database and SQL Server Analysis Services multidimensional cubes from SSRS for data analysis and visualization.

Environment: SQL Server, SQL Sever Reporting Services(SSRS), SQL Server Integration Services( SSIS), SQL Server Analysis Services( SSAS), Oracle, Excel, CSV,GIT.

• Responsible for optimizing or modifying SQL queries, stored procedures to generate the reports according to the requirements from Business users.
• Created Database program in SQL Server to manipulate data; Responsible for writing complex SQL Queries and Stored Procedures
• Worked on improving the performance of queries with modifications in T-SQL queries, by generating execution plan of the long running queries with performance issues, by using indexes, using the select syntax efficiently, creating joins, using where, having clauses efficiently and by eliminated redundant and inconsistent data etc.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in developing triggers at the database level.
• Created sub-reports to present more detailed information about the summary.
• Performed Backup and restore of databases.
• Expertise in Power BI, Tableau, Excel, SSRS and other reporting tools.
• Connecting to data sources (Oracle, SQL, excel etc..), importing data and transforming data for Business Intelligence.
• Designed and Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating dashboards.
• Created effective reports using custom visualizations such as Gantt Chart, Skyline Chart, Timeline Chart, Gauge, Pie Chart in Power BI.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Worked with peer team members which includes requirement gathering, designing data flows, and generating reports according to their business requirements.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Developed and maintained a combined data store for reporting purposes.
• Created Views, Tables to pull data into Power Bi required for generating reports and dashboards.
• Created and developed calculated fields and DAX queries on respective reports in Power BI.
• Weekly presentation to the business users about the reports and their changes as required.
• Participated in project planning sessions with project managers, business analysts, to analyze business requirements and outline the proposed solution.

Environment: SQL Server, Power BI, Tableau, Microsoft Excel, SQL Server Reporting Services (SSRS), Oracle database, Power BI Service.

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power BI
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc..
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Creating data blending in case of merging two different datasets using Tableau
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel Power View, Power Query and Power Pivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Reports using Charts, Gauges, Tables, matrix.
• Created Parameterized Report, Dashboard Report, linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler