SUMMARY

• 8 years Extensive experience in Information Technology & Client/Server applications, covering all phases of Software Development Life Cycle, Including Source gathering, Analysis, Design, Development & Implementation in large application development Projects.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, and Update Strategy transformations.
• Designed Error Handling and Event Handling mechanism and used Configuration files, Log providers, and checkpoints whenever required in SSIS.
• Good Exposure to Microsoft Azure Data Factory.
• Worked Extensively on Designing the Data warehouse.
• Proficient in creating reports in SSRS, Power BI, and publishing to Power BI service.
• Creating audits/logging for SSISpackages on task and package levels.
• Experience in report writing using various types of Ad Hoc Reports like Table, Matrix, Drill Down, Drill Through, Parameterized, and Cascaded reports in SSRS.
• Extensively worked on optimizing the performance to speed up the process in the SSIS packages and SQL server queries.
• Proficient in building SSISpackages using transformations like Conditional split, Lookup, Fuzzy, Merge, Execute SQL tasks, and FTP.
• Extensively worked on designing the Book marks, Drill - down, and Drill through reports in Power BI and created the roles for implementing the row-level security for the words.
• Hands-on experience migrating the on-premise SQL Server databases to Azure SQL server using the DMA and bacpac methods.
• Good exposure to Azure data factory.
• Good understanding of creating the pipelines and configuring the Integration runtime in ADF.

TECHNICAL SKILLS

Languages: ASP.NET, C#.

Web Development Tools: ASP.NET, HTML, HTML5, JavaScript, JQuery, CSS, CSS3, Bootstrap, MVC4, MVC5, SOAP, XML.

Development IDE: Visual Studio 2008/2010/2012/2013/2015/2017

Databases: Microsoft SQL Server 2016/2014/2012/2008/2005 , Oracle 10g, 11g, PL/SQL

Operating Systems: Windows Server 2008, Windows XP, Windows 7, Windows 8

Web servers: ISS 5.0,6.0,7.5

ETL & Reporting TOOLS: Data Transformation Services, Visual Studio (SSIS, SSAS, SSRS, POWER BI, PowerApps, Power Automat)

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SSDT, Report Builder, snowflake

PROFESSIONAL EXPERIENCE

Confidential, MN

Power BI/PowerApps/ADF Developer

Responsibilities:

• Created the DTS Package through ETL Process to vendors in which records were extracted from Flat file and Excel sources and loaded daily at the server.
• Designed new reports into Power BI based on Business requirements utilizing the latest components.
• Wrote complex DAX for calculated measures and columns, utilized iterators, Parent-child Hierarchies, and Cardinalities. Implemented Row-Level security for effective retrieval.
• Used Business Intelligence Mark-up Language (Biml) to rapidly create SSIS packages and solutions and automate SSIS Design Patterns.
• Developed SSIS packages and Deployed SSIS projects using the Project Deployment model dat includes packages and project parameters.
• Worked with Dataverse/ Dynamics 365 . Created tables, and relationships and used within in PowerApps, PowerBI
• Worked on Authentication in Power BI with Custom Data connectors.
• Scheduled time for refresh reports in Power BI.
• Developed forecasting App using PowerApps and employed Power Automate to send emails to users.
• Implemented KPIs in the Main dashboard page for High-Level Business Analysis
• Developed Power BI visualizations, dashboards, and workbooks using Power BI Desktop.
• Designed and documented the data flow from different sources to validate the business rules and error conditions using Visio.
• Using Power BI, migrated Crystal reports to SSRS reports into Power BI.
• Built Views for dashboards (Power BI, SSRS).
• Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data sources.
• Performance tuned long-running lengthy SSRS reports and optimized rendering time by ten times the actual time.
• Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data to Azure Data Lake.
• Created SSIS packages for regular files from various clients for shipping.
• Automated a couple of workflows using PowerShell. Involved in writing background jobs using PowerShell and Deployed the applications using Octopus deployment.

Environment: Visual Studio 2017, Python 3.7, SQL, Bitbucket, JIRA, Entity Framework, Snowflake, SSRS, SSIS, Power BI, PowerApps, PowerAutomat.

Confidential, St Louis, MO

Power BI/PowerApps/ADF Developer

Responsibilities:

• Created the automated build and deployment process for application, re-engineering setup for better user experience, and leading up to building a continuous integration system.
• Intensively worked on T-SQL Stored Procedures for performance tuning.
• Build the applications through Team City and deploy them in all environments with Octopus Deployment.
• Created flows with PowerAutomat.
• Dataverse/ Dynamics 365 as Data source for PowerApps, PowerBI
• Used variousSSIStasks such asConditional Split, Derived Column, script taskusingvisual basicwhich were used forData Scrubbing, data validation checksduringStaging, before loading the data into the Databases
• Created the SSIS packages using the SQL Server Integration Service platform.
• Designed the Dimensions and Measures to Develop the SSAS Cube.
• Designed the Partitions, Hierarchies, and Aggregations in the Cube.
• Involved in Scheduling the SSIS Packages using the SQL Server Agent.
• Worked in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file, to MS SQL Server using SSIS.
• Implemented Data compression and encoding as per requirement Power BI reports.
• Responsible for creating SQL datasets for Power BI Reports.
• Utilized Power BI for Office 365 to amplify data visualization with collaboration and management.
• Implemented different filters like Row-level for effective retrieval of reports.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Created complex DAX measures.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Created DFD (Data Functional Design) artifacts dat incorporated the process flow Visio, S-T Mapping document, and all the specifications for proper ETL implementation.
• Implemented Hierarchies in the Power BI Reports, Aggregations, Data categories, and Relationships.
• Developed the Canvas application in Power Apps to automate the manual data entry application.
• Developed PowerApps app using Sharepoint and SQL as data sources.
• Define virtual warehouse sizing for Snowflake for different types of workloads.
• Created Grouping, sorting columns, and writing expressions according to business requirements.
• Worked in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file, to MS SQL Server using SSIS.
• Developed SSIS packages for all the inbound data flat files and JSON files.
• Used Tidal scheduling tool to schedule SSIS packages and SSRS reports.
• ETL Package Jobs Scheduled to run daily during Night Hours in the data warehouse

Environment: Visual Studio 2017, ASP, Power BI, PowerApps, Snowflake, SourceTree, SQL, SSIS, SSRS, Visio, Bitbucket, JIRA.

Confidential, St louis, MO

Sr. SQL/Power BI/PowerApps/ADF Developer

Responsibilities:

• Designed and implemented facts, dimensions, measures, and OLAP cubes using dimensional data modeling standards in SQL Server 2008 dat maintained data.
• Used LDAP for securing the user roles.
• Deployed application into Azure Server by creating Azure SQL server by setting up Continuous Integration (CI)/Continuous Deployment (CD) from Team Foundation Server (TFS).
• Consumed flat files JSON files and developed SSIS packages.
• Used DAX (Data Analysis Expressions) functions to create calculations and measures in the Tabular Models.
• Automated the flows with Power Automat.
• Used DataVerse/Dynamics 365 as Data source.
• Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages developed to update the database daily/Weekly/monthly.
• Generated Power BI Dashboard with quick/context/global filters, parameters, and calculated fields on Power BI reports
• Created Power BI Dashboards with interactive views, trends and drill-downs, and user-level security.
• Involved in creating the notebooks for moving data from raw to stage and then to curated zones using Azure data bricks.
• Developed SSRS reports dat could be used to send information to different Primary Vendors, Clients, and managers.
• Implemented the Row Level filters.
• Worked with various tasks such as Control Flow (Execute Sqltask, for each loop container, Data Flow task, File System, etc.) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, a conditional split, derived column, etc.
• Involved in Designing the Multi-Dimensional cube.
• Written expressions for calculations and aggregations in the SSAS cube.
• Identified the dimension and fact tables and designed the data warehouse using star schema.
• Used JIRA Confluence for tracking the log Decisions. TFS as Central Repository
• Designed and built ETL process for integration with external systems using SSIS.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Using the logic for screening each client record in the system, develop windows batch script and PowerShell scripting.

Environment: Visual Studio 2017, C#, ASP, SQL, TFS, Power BI, PowerApps, Snowflake, Visio, SSIS, SSRS.

Confidential, Destin Florida

Sr. SQL/PowerBI Developer

Responsibilities:

• Extensively worked with T-SQL queries.
• Followed Agile and Scrum methodology for continuous integration & continuous delivery with regular minor releases.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
• Imported data from flat files to SQL Server database using SSIS. me also used Azure for Scaling and checking the reliability of the applications which were developed during the project
• Utilized Power BI to create various analytical dashboards dat depict critical KPIs along with slicers and dicers, enabling end-user to make filters.
• Created calculated columns and measures in Power BI and Excel depending on the DAX queries requirement.
• Automated the Flows with PowerAutomat.
• Used Power BI Power Pivot to develop a data analysis prototype for advanced visualization reports.
• Designed and developed Power BI Dashboards and reports and published them to Power BI Services.
• Implemented the Parent-Child Relationships in Power BI alongside Iterators and row-level filters. Visibility of Levels.
• Build the Logical and Physical data model for Snowflake as per the changes required
• Define virtual warehouse sizing for Snowflake for different types of workloads.
• Used JIRA Confluence for tracking the log Decisions JIRA Crucible for Code Check-in.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Utilized different SSIS information stream changes, for example, Data Conversion, Conditional Split, Derived Column, and Lookup, which were utilized for Data Scrubbing and Validation Checks amid arranging before stacking the information into Data Warehouses for all ETL packages.
• Responsible for Developing, Monitoring, and Deploying SSIS packages.
• Used SQL Server Mail Agent to send automatic emails when packages or queries failed.
• Upgraded and configured SQL Server 2014/2012/2008 R2 for several applications with the latest service packs.
• Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates. Involved in scheduling, creating snapshots, and subscriptions for the reports
• Developed store procedures, triggers, functions, and database tables in SQL database.

Environment: Visual Studio 2017, Dapper, SQL, C#, Power BI, PowerApps, Snowflake, SSIS, SSRS, AWS.

Confidential, Jacksonville, FL

SQL, POWER BI Developer

Responsibilities:

• Creating SSRS reports supporting reporting, data analysis, and business planning.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Used several visualization types like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush, Waterfall, Gauges, etc.) in Power BI according to the requirements.
• Designed complex data-intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Configured and created SSIS solutions for ETL and business intelligence process for data integration and migration services
• Created several cubes in SSAS and built alot of MDX queries to query cubes and access cube's data
• Worked with Row level and page level filters as per client requirement.
• Incorporated Error Redirection during ETL Load in SSIS Packages. Performed Unit testing and System Testing of the ETL Process.
• Generated various Drill-through Reports, Parameterized Reports, Matrix, and Tabular Reports.
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS) and report builder.
• Responsible for creating, executing, and delivering tabular, matrix, and charts reports and debugging and deploying reports in SSRS.
• Design star, snowflake schema in Analysis Services.
• Converted DTS Package to SSIS package for synchronizing existing process (DTS migrations).
• Used JIRA Confluence for tracking the log Decisions JIRA Crucible for Code Check-in.
• Extensively worked on User Interface pages (aspx) using C#.
• Evaluate Snowflake Design considerations for any change in the application
• Designed the Wireframes for the Project Design using Balsamiq Mock-ups.
• Worked on the Click-Once deployment for publishing the application.
• UsedSQLextensively in command objects of SSRS and Crystal reports
• Used SSIS to build high-performance data integration solutions, including Extraction, Transformation, and Load (ETL) packages, and scheduled the SSIS packages and jobs.
• Developed stores procedures, triggers, functions, and database tables in SQL database

Environment: Visual Studio 2015, SQL Server 2015, .Net 4.5, C#, PowerApps, Power BI, SSRS, SVN.

Confidential, VA

SQL, Power BI Developer

Responsibilities:

• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files, etc.) and then loaded the data into destination tables by performing different transformations using SSIS.
• Worked with Visual VB .NET, Entity Framework LINQ, WCF, SQL database, Web API, jQuery, and Software life cycle using Class diagram activities for the application portal.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI for strategic planning decision-makers.
• Worked with Team-City for Continuous Integration (CI). Wrote PowerShell scripts for command line step in Team City.
• Validating the data from SQL Server to Snowflake to ensure it has Apple to Apple match.
• Define virtual warehouse sizing for Snowflake for different types of workloads.
• Worked on the Click-Once deployment applications
• UsedSQLextensively in command objects of Crystal reports.
• Extensively worked on the Design and development of SSIS (ETL) packages to extract, transform and load data from various sources like Excel files and flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Creating Packages on SSIS using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, and Aggregation.
• Created SSIS packages to perform incremental loads using timestamps.
• Setting up the Server Connections, File paths, Parameter mapping, and Expression mapping in SSIS.
• Involved in the SQL migration, worked on Replication and High Availability to ensure the database was up all the time.
• Generated reports utilizing SSRS and Excel with power pivots; deployed reports within SharePoint integrated mode.
• Developed store procedures, triggers, functions, and database tables in SQL database.

Environment: Visual Studio 2015/2012, SQL Server 2015, .Net 4.5/4.0, Entity Framework, LINQ, SQL, SSRS, TFS, GIT, SVN, Team-City, Octopus Deploy

Confidential

SQL DEVELOPER

Responsibilities:

• Involved in the project’s complete lifecycle (SDLC), me.e., Design, Development, Implementation, and Unit testing.
• Wrote complex SQL queries and Stored Procedures using SQL Server 2005 for extracting and manipulating the data.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors, and appropriate User-defined functions to implement the business logic.

Environment: HTML, CSS, jQuery, SVN, VB.NET, VBSCRIPT, JAVASCRIPT and SQL 2005/08.