SUMMARY

• Two years of extensive experience in implementing, developing & maintaining various Business Intelligence application systems for Financial, Retirement, Investment, Insurance, Consumer Loans, Communications and Consulting sectors using wide range of BI tools.
• Experience developing powerful data visualizations using Microsoft Power BI, Qlik and Tableau.
• Good working experience on object - oriented programming like Java & Python.
• Knowledge of Hadoop Map Reduce and Big data concepts.
• Strong experience on end to end implementation of Oracle DRM and maintenance of metadata of various upstream and downstream systems.
• Hands on experience in both Relational and NoSQL database management using tools like Microsoft SQL server, Oracle SQL, MongoDB, and SQLite.
• Experience in interacting with various Data sources like Data warehouses, Exadata, OLAP sources, Packaged Applications (PeopleSoft, Oracle EBS, and SAP), Unstructured and Semi-structured data.
• Experience writing Linux shell scripts & Windows DOS scripts, which are used in Job automation process.
• Performed end to end installation of Oracle Hyperion EPM suite, OBIEE, Informatica, Power BI, Qlik Sense.
• Experience working with Extract, Transform & Load process using Microsoft SSIS, Informatica (E-T-L) and Oracle ODI (E-L-T).
• Extensive experience on SOAP & REST Web Service APIs for remotely interacting with Data Relationship Management server, Planning and Essbase instances.
• Knowledge of Hyperion EPM architecture and how it interacts with various downstream and upstream systems.
• Experience in Continuous Integration tools like Jenkins.
• Extensive experience using Microsoft Excel for building reports and performing calculations.
• Good Experience with Version Control Management tools like GitHub, IBM Clear Case.
• Experience in Agile software methodology with Version-One, JIRA & Rally.
• Highly curious about latest trends in Business Intelligence sector, technologies and thoroughly mastering them with a keen awareness of new industry developments and evolution of programming solutions.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft Access, SQL Server 2008 R2, and SQL Server 2012, 2014

Software/Databases: MS SQL Server 2008RS,2012 MS SQL Server Reporting Services 2008/2012 (SSRS), MS SQL Server Analysis Services 2008/2012 (SSAS), MS SQL Server Integration Services 2008/2012(SSIS), ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, PerformancePoint Server

Development Environments: Microsoft Visual Studio 2008/2, Microsoft Visual Studio Team System 2008/2010/2012 , Microsoft SQL Server Management Studio 2008/2012/2014 , Microsoft SQL Server 2008/2012/2014 , ORACLE, POWER BI, Tableau, Excel, Smart Sheet

Programming Languages: Experienced in Transact-SQL (T-SQL), XML, and C#.

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential

Responsibilities:

• Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company .
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.

Environment: s: Microsoft Power BI, Microsoft SQL Server Management Studio, Visual Studio 2019, HTML, CSS, Azure, AWS, MS Access, Java, Python, Scala, HDFS, Apache Pig, Apache Spark, Hive, Sqoop, SSIS, T-SQL, MySQL, Mongo DB.

Power BI Developer

Confidential

Responsibilities:

• Managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed and resolved by analyzing data.
• Worked with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources
• Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Expert in connecting multiple data sources in Power BI to implement working reports.
• Hands on experience in developing reports and dashboards visualization.
• Worked on Microsoft Visual Studio 2008/2012 project environment to create dynamic metadata driven SSIS packages for source data extracts and destination system updates.
• Created, maintained and analyzed wide variety of reports / Excel spreadsheets for senior management. Oversaw departmental software drive / files.
• Scheduled a job in SQL Server Agent that runs on daily basis and creates a log file and maintained the Errors in Error log file.
• Experienced in developing ETL processes from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks, and transformations provided by SSIS.
• Excellent skills in developing SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
• Involved in automating SSIS Packages using SQL Server Agent Jobs.
• Exported and imported data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.
• Created tabular, list, matrix reports and writing queries to perform drill down operations in SSRS.
• Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager.