SUMMARY

• Around 12 years of experience in IT industry and gained expertise as ETL Developer, SQL/BI Developer, Automating Software Configuration Management (SCM), Deploying Applications through Continuous Integration (CI) and Continuous Deployment (CD) and Managing Cloud Services.
• Work closely with the Marketing team to enhance existing tools and data architecture supporting reporting.
• Worked on Power BI and prepared dashboards to make it more attractive.
• Managed and automated collaborative project work using Project Management Software Smartsheet
• Expert in calculating measures and dimension members using Multi - dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
• Experience in building Office 365 solutions including Power Automate (Flow), Power Apps, Power BI
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Experienced on Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App)
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub Reports, Global map reports in both Power BI Desktop and Power BI Cloud service.
• Robust MS Access and excel skills with Power pivot, PivotTable, PivotChart, Power view, VLOOKUP functions and formulas.
• Work with the project teams on implementing the defined Policies within Access & Identity Management (AIM) solution
• Updated existing and created new reports using Microsoft SQL Server Reporting Services.
• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic Sql, Merge statements. Built and monitored indexes to bring down processing times from minutes to seconds
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients and Power BI for executives and managers
• Utilized T-SQL to pull data from various databases and created various dashboards, scorecards and reports to support loan business decision making. Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and business using SSRS and Power BI
• Created scripts to analyze data, modify data, import / export scripts, and execute stored procedures. Created complex queries for use in Power BI.
• Developed custom calculated measures using DAX in power BI to satisfy business needs.
• Updated and tested current OLAP data cubes including Servicing cube using SSAS and MDX
• Experience on databases like MySQL, SQL server, PostgreSQL, Mongo DB, Cassandra, Big Query
• Experience on the Scripting Languages like Python, Bash & PowerShell
• Experience on Web Technologies like HTML, XML and Application life cycle Management (ALM) experience supporting or designing complex ETL production environments
• Experienced in supporting 24/7 production computing environments, on-call, and weekend support.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux/CentOS 5.x/6.x/7, Sun Solaris 11/10, Ubuntu/Debian, Windows Server 2008/2012

Source Code Management Tools: Gitlab, GitHub, SVN, CVS, Bitbucket

Continuous Integration Tool: Jenkins, GitlabCI

Build Tools: Maven, NPM

Containerization Tool: Docker

Languages/Scripting: Java, Shell, Python, PowerShell

Databases: MySQL, SQL Server, Mongo DB, Casandra, Snowflake, PostgreSQL

Reporting: SSIS, SSAS, SSRS, MDX, DAX, Power BI, Tableau

App/Web Servers: Apache, Tomcat, Nginx

Bug Tracking Tools: JIRA, Clear Quest, HPE AGM

Web Technologies: HTML, CSS, Java Script, XML, JSON

Cloud Platform: Amazon Web Services, Azure, GCP

Monitoring Tools: AWS CloudWatch

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Power BI | SQL Developer

Responsibilities:

• Analyzed and designed software and database solutions.
• Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
• Experience in building Office 365 solutions including Power Automate (Flow), Power Apps, Power BI
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Managed and automated collaborative project work using Project Management Software Smartsheet
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked in Agile methodology to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.
• Designed various cube objects such as KPIs, drill through actions, aggregations, and translations. Implemented key performance indicators, actions, hierarchies, and attribute relationships with added functionalities.
• Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on Server to achieve the efficiency of SQL Server Analysis (SSAS)
• Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.
• Understand the business needs and convert into the Data Models using Erwin tools for Data modelling, Table design, DB Objects.
• Work closely with the Marketing team to enhance existing tools and data architecture supporting reporting.
• Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts. Worked with Excel Power Pivot Tables.
• Used recently introduced Power BI to create self - service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS)

Environment: MS SQL Server, Azure, SQL Server Reporting Services, T-SQL., POWER BI, SQL, SSIS, SSAS, SmartsheetMDX, DAX, Tableau

Confidential, Chicago, IL

Power BI | SQL Developer

Responsibilities:

• Developed ETL framework for processing and monitoring import of flat files in SSIS for key client
• Maintained SQL scripts and complex queries for analysis and extraction, Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS
• Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT
• Developed and created the new database objects including tables, views, index, stored procedures and functions and advanced queries, developed complex TSQL stored procedures and SSIS ETL processes utilizing XSLT and XML queries to consume and translate the vendor XML and Excel data files into the supporting database
• Worked extensively on almost all the transformations such as Aggregator, joiner, Cached and Uncached Lookups, Connected and Unconnected Lookups, SQL, Java, XML, Transaction Control, Normalizer, and Sequence Generator
• Provided production Level 1 and Level 2 on-call support for ETL processing, requiring time-critical resolutions to issues
• Managed and automated collaborative project work using Project Management Software Smartsheet
• Translate business needs to technical specifications
• Design, build and deploy BI solutions using Power BI
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Created scripts to automate in-house metadata explorer project using Shell Script and SQL
• Created and loaded multiple Metadata resources from the data warehouse
• Worked with various scripting languages like Shell and Python, Wrote Python scripts for pushing data from Mongo DB to SQL Database
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Very good knowledge of DAX and MDX queries
• Created SSRS inventory management reports
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages
• Store procedures, User defined functions, Views, TSQL scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting, and joining tables
• Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes

Environment: SQL, TSQL, SSAS, SSIS, SSRS, Power BI, SSMS, SSDT, Smartsheet, GIT, MDX, DAX, Shell, python scripting, windows, Linux

Confidential

ETL| SQL Developer

Responsibilities:

• Demonstrated ability to adapt to company's evolving environment by learning quickly & taking on expanded roles by implementing new procedures and improving existing ones
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application
• Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT
• Scheduled and maintain packages by daily, weekly, and monthly using SQL Server Agent in SSMS
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files
• Responsible for optimizing SQL queries, stored procedures to improve the performance time
• Conducted data migrations from third party databases to create consolidated database system
• Performed data analysis on product datasets and led the modeling and development of the initial Enterprises data loading ETL/ELT solution in SQL 2008 R2
• Created the weekly meeting BI SSRS reports on data acquisition and integrity progress for Director of Information Systems, Director of Digital Operations, and Vice President of Business Development
• Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data
• Connecting to data sources, importing data, and transforming data for Business Intelligence.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Able to implement row level security on data and application security layer models in Power BI.
• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
• Created batch job processing, scheduling, and production support
• Created a SQL script to create the tables, implement business rules, and populate the tables, developed queries and reports to illustrate features of the application
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, SQL Server automatic email notification and backup strategy
• Extensive use of T-SQL programming and stored procedures to interactive with the database, and ASP to perform the calculation of the risk assessment modeling
• Using ASP and SQL server programming to produce a final assessment report which are rich with dynamic graphics and charts

Environment: s: SSAS, SSIS, SSRS, SSMS, SSDT, Power BI, MS SQL, Bash Scripting, Jira, GIT, SVN, Windows Server 2008