Home

SRINIVAS - POWER BI CONSULTANT

[email protected]

Location: Dallas, Texas, USA

Relocation:

Visa: H1B

Employer : [email protected]; [email protected]; (609) 778-4215 ext 1000 Srinivas Professional Summary: Having Around 13+ years of IT experience on MICRO SOFT BI TOOLS like SSIS, SSRS, Power Bi, SSAS and SQLSERVER 2005, 2008, 2012, 2014.In this tenure, involved in design, analysis, development and implementation of various applications in Client/Server environment. Good experience in SSIS ETL tool, SSRS Reporting Tool and SSAS Analysis Tool and POWER BI Reporting Tool. Implemented Power BI reports & Dashboards using different visual charts like Tree map, Funnel and Bar chart, Map, and custom visual charts. Implemented dynamic RLS at data and reports level on Power BI security. Good working knowledge on creating calculated columns & measures using complex DAX expressions. Involved in publishing Power BI reports to service and configuring RLS. Worked on visual interactions using edit interactions to make few visual to effect data based on requirement. Extensively used buttons and bookmarks in Power BI report for dynamic report visualization. Having good experience in Power query, Power pivot and Power view for creating the effective reports and dashboards in Power BI. Experience on enabling various types of filters for reports and pinning visuals into Dashboards. Good working knowledge on Data modelling and Relationships in Power BI. Hands on experience in Power BI Administration tasks and Gateways. Hands on experience in deploying the developed SSIS packages into integration services catalog and file share location in different environments. Extensively worked on Optimizing the Performance of SSIS Packages and T-SQL stored procedures. Developed various weekly and monthly business Reports, Tabular, matrix, list and Drilldown, Drill through reports using SQL Server Reporting Services (SSRS). Good working Knowledge on Deploying the SSRS Reports into Share point portal, Report manager, Report server. Extensive working knowledge on using visual studio to develop c#.net code required in script task. Worked on Optimizing the Performance of SSRS Reports and scheduling reports using subscriptions. Good working knowledge on creation of cube in SSAS. Created Calculations, Aggregations, KPI S, Perspectives, and Partitions for CUBES. Good working knowledge on Creating SSAS tabular modeler work analysis purpose. Knowledge on data warehouse concepts like star schema, Snowflake schema, dimension, and fact tables. Having excellent analytical and Database and T-SQL skills. Extensive knowledge in writing SQL AND T-SQL Queries, Stored Procedures, Functions, Cursors, Indexes, Triggers, and views. Highly motivated and a conceptually strong individual with exceptional analytical and design skills. Excellent professional written and verbal communication and interpersonal skills. Proficient in technical writing and presentations. Technical Skills: Operating Systems Windows Server 2000/2003/2008/2010 Windows XP/Vista Languages T-SQL, C#.Net, XML Tools/Utilities SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2008/2012/2014, SQL * Plus Databases MS SQL Server 2008 R2/2012/2014 ETL tools SQL Server integration services (SSIS). Reporting Services SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI and Tableau. Functional Experience Banking, Finance, Sales & Retail Education: Bachelor of Technology (B. Tech) from JNTU, Hyderabad, India. Professional Experience: Client Name: NANOMETRICS Role: BI Developer \Reports Developer Oct 2017 Till Date Location: Milpitas, CA Nano metrics is a leading provider of advanced, high-performance process control metrology and inspection systems used primarily in the fabrication of semiconductors and other solid-state devices, such as data storage components and discretes including high-brightness LEDs and power management components. Responsibilities: Responsible for requirements gathering and analysis. Responsible for coordinate the offshore team and onshore team. Implemented Power BI reports & Dashboards using different visual charts and custom visual charts. Implemented dynamic RLS at data and reports level on power bi security. Involved in publishing Power BI reports to service and configuring RLS. Worked on visual interactions using edit interactions to make few visual to effect data based on requirement. Extensively used buttons and bookmarks in Power BI report for dynamic report visualization. Implemented calculated columns & measures using complex DAX expressions. Creating BI report using various types of filters and pinning visuals into dashboard. Responsible for developing the ETL s Using MSBI (SSIS) to load the data into Data warehouse and monitoring daily ETL jobs. Responsible for optimization of SQL queries and T-SQL and SSIS Packages. Extensively worked on migration of ETLS and Reports from old servers to new servers. Created various Service, Manufacturing reports as per the user requirement using SSRS. Created various stored procedures using Sql server, to provide the data set needed for SSRS Reports. Used script task to make web service calls to get the information from .net webservices as per requirement. Responsible for Issues Handling, raised by the User. Created Different kind of SSRS Reports like Tabular, Drill down, Drill through, Graph reports. Created Different kind of power Bi reports for Analytical purpose. Used Power BI to create various analytical dashboards that depicts critical KPI s. Power Query was used in data modelling and cleansing operations of data in Power BI Reporting tool. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Created Cached reports, Snapshot reports, linked reports using SSRS. Created different kind of weekly, monthly, quarterly SSRS Reports based on the business requirements. Responsible for doing unit testing. Involved in code reviews, Involved in UAT issue logs. Environment: Microsoft SQL Server 2012,2014, SSIS, SSRS,T-SQL, MS-Excel, Windows XP/7, VS Business Intelligence Tool , TFS, SharePoint, visual studio 2015,Sybase,Tableau, Power BI, Power Pivot. Client Name: Everest RE Insurance. Mar 2017 Sep 2017. Role: BI Developer\ Reporting Analyst Location: Liberty Corner, NJ. Everest Re provides reinsurance and insurance to an international set of customers. Types of insurance provided include property, worker's compensation, crop, professional liability, and accident insurance. Responsibilities: Involved in requirements gathering and analysis with Business team. Attending and hosting meeting with business team and internal teams. Created various stored procedures to pull the data as per the business requirement to create tabulator reports. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Used Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data Manipulation. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Created reports in Power BI desktop preview portal utilizing the SSAS Tabular via Analysis connector. Deployed data intensive Power BI dashboards to SharePoint team site as per business requirements. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Utilized Content Packs for deployment into various environments. Created different SSIS Packages to maintain ETL data loads. Responsible for optimization of SQL queries, T-SQL and SSIS Packages. Responsible for deploying the SSIS Packages into different environments like SIT, UAT, PROD. Responsible for Maintain the code in TFS server. Responsible to do unit and smoke tests. Environment: Microsoft SQL Server 2012,2014, SSIS, SSRS,T-SQL, MS-Excel, Windows XP/7, VS Business Intelligence Tool , TFS, SharePoint, visual studio 2015,Sybase,Tableau, Power BI, Power Pivot. Client Name: CIT Group Inc. Sep 2016 Mar 2017. Role : Sql server Developer\ Reporting Analyst Location: Livingston, New Jersey CIT Group Inc. is the one of the famous financial bank which has helped drive innovation as leader in middle-market lending, and financing the retail, energy, health care, and transportation and technology sectors. Loan Hub is the Data ware house Project which maintains the several loan systems data of CIT Group Inc. Responsibilities: Involved in requirements gathering and analysis with Business team. Attending and hosting meeting with business team and internal teams. Responsible for creating the SSIS Packages to implement the logic as per the business requirement. Created Different kind of SSRS Reports like Tabular, Drill down, Drill through, Graph reports. Created Cached reports, Snapshot reports, linked reports using SSRS. Created different kind of weekly, monthly, quarterly SSRS Reports based on the business requirements. Deployed these SSRS Reports the SharePoint portal as well Report server. Responsible for optimization of SQL queries, T-SQL and SSIS Packages. written DAX queries pull the data from SSAS tabular model. Created Different slices on the dashboard report using Power BI. Created charts, Maps, tabular, Interactive reports using Desktop power bi and deployed the same into power BI cloud server. Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives. Involved in interacting with business users and performed Gap Analysis according to client requirements. Scheduled the Dashboards refresh, published and maintained the data sources and reports in the Tableau Server. Experience with design and development of Tableau visualization Solutions. Loaded data into STAR Schema data warehousing fact and dimension tables. Used ado.net to get records information and updated in the destination table. Used script component to get the timestamp, as well as for Metadata validations, Data Validations. Responsible for doing unit testing. Involved in code reviews, Involved in UAT issue logs. Environment: Microsoft SQL Server 2012,2014,SSIS,SSRS,T-SQL, MS-Excel, Windows XP/7, VS Business Intelligence Tool , TFS, SharePoint, visual studio 2015,Sybase,PowerBI,Tableau. Client Name: NYC State DOE Role: SQL Server, Power BI Developer Feb 2016 Sep 2016 Location: New York City SESIS is the New York City Special education student information system maintains the referral, evaluation, and placement processes for school-age students suspected of having a disability and those who are already identified. The IDEIA(Individuals with Disabilities Education Improvement Act) requires the New York City Department of Education to identify, locate and evaluate all children with disabilities and those suspected of having a disability residing in New York City, including students who are homeless or Ward of the State, or not attending a New York City public school. The Child Find provision also applies to all children who may be in need of special education services and is an obligation that extends to all professional staff members. Responsibilities: Involved in requirements gathering and analysis. Attending and hosting meeting with customer and internal teams Performing RCA for database and application related issue. Performing Health Check for better performance of the database and application. Created Database Maintenance Planner for the Performance of T-SQL in SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing Code and Package Deployment. Configuring Backup for database and restoring database. Experience of database restore from one server to another database server. Performing Health Check for better performance of the database and application Performance tuning using various tools. Responsible for supporting the databases monitoring jobs and logs. Involved in software installation and troubleshooting of sql server 2012, 2014 and windows. Responsible for database backups restores and replication and security. Responsible for optimization of sql queries and T-SQL and SSIS Packages. Used script task to make web service calls to get the information from .net webservices as per requirement. Created Calculations, Aggregations, KPI S, Perspectives, and Partitions for CUBES. Extensive working Knowledge on MDX Queries. Hands on experience on Creating Named sets, Tuples, Aggregation functions using with members in MDX. Responsible for Issues Handling, raised by the User. Enhancing the SSIS packages, and CUBE as per the source on quarterly basis, yearly basis. Responsible for deploying the packages, cubes using. Created Different kind of SSRS Reports like Tabular, Drill down, Drill through, Graph reports. Created Cached reports , Snapshot reports, linked reports using SSRS. Created different kind of weekly,monthly,quarterly SSRS Reports based on the business requirements. Deployed these SSRS Reports the SharePoint portal as well Report server. Created SSAS tabular modeler work analysis purpose written DAX queries pull the data from SSAS tabular model Created Different slices on the dashboard report using Power BI Created charts, Maps, tabular, Interactive reports using Desktop power bi and deployed the same into power BI cloud server. Environment: Microsoft SQL Server 2012,2014, SSIS,SSRS,SSAS,T-SQL, MS-Excel, Windows XP/7, VS Business Intelligence Tool , TFS, SharePoint, visual studio, PowerBI. Client: GSK (Glaxo Smith Kline) Nov 2014 Dec 2015 Role: SQL Server BI Developer\MDS Developer Location: Hyderabad The NextGen ONE MDS is a key strategic project sponsored by the Global President and is delivering a step change in how GSK Consumer healthcare golden data with the surveillance of Data steward manages and monitors and execute on its business mission to outgrow the market and the competition . MDS: Master Data Management System Implementation In MDS the Data is sourced from the data Source and is loaded into an Integration Layer. The integration layer consists of tables for landing data from external systems. The data is then transformed and loaded using Sequel server Integration Services (SSIS) into the Master Data repository to handle business processes via MDS Staging tables which correspond to each of the MDS entities. MDS data is then exposed into an Interface and Subscription Layer ready for the target systems to either receive or pull the data. Data can be authored/mastered directly inside the Master Data repository. Data mastered in the repository will be included in the data flow and consumed by the downstream systems along with data provided by external systems. Workflow and triggering is automatically controlled by the Informatica Workflow, but can also be initiated manually using the Microsoft SQL toolset. The Downstream Subscription and Load processes are handled by existing Informatica ETL and workflow elements. Responsibilities: Managed and involved in requirements gathering and analysis. Responsible for supporting and enhancing the MDS Packages, Model and Creating Entities, Hierarchies, BusinesRules, Security. Developed ssis packages using LOOKUP,SCD,DERIVEDCOLUMN,DATACONVERSION Transformations Responsible for Building and deploying ssis packages in .ispac format into all Environments. Responsible for developing the T-SQL, ssis Packages to pull data from source to MDS Layer. Responsible for Raising Tickets for Issues and communicating with client regarding MDS Issues. Responsible for database backups, Restore, Replication and deploying MDS Packages in Prod, Dev, Test. Responsible for daily monitoring jobs and Loads using sql agent. Involved in supporting the databases and troubleshooting the database. Created Calculations, Aggregations, KPI S, Perspectives, and Partitions for CUBES. Created Named sets, Tuples, Aggregation functions using with members in MDX. Involved in UAT testing. Environment: MS SQL Server 2012, BIDS/Data tools (SSIS), T-SQL, Master Data Services 2012, C#, Linux, Share Point Portal Server, Notepad++, TFS, Oracle 11g, Toad for Oracle 9.7.2.5, IBM DB2 9.5.1, Teradara, Visual Studio 2012. Client: Microsoft Dec 2012 Sep 2014 Role: SQL Server BI Developer Location: Hyderabad Marketing Budget Planning (MBP) is the corporate application for planning and tracking marketing investment. MBP is a web-based marketing tool designed to assist users to plan, forecast, track, and analyze marketing spend. Mercury is a financial reporting application and data warehouse containing all allocated General Ledger data for Microsoft s internal and external reporting. In general, there are process and data issues that cause finance users to want to view both Mercury and MBP data within a single report view. The goal of this project is to build a single consolidated reporting tool that brings together MBP and Mercury data so the finance community can more efficiently analyze financial data across the two sources. Responsibilities: Involved in requirements gathering and analysis. Responsible for supporting the databases monitoring jobs and logs. Involved in software installation and troubleshooting of sql server 2012 and windows. Responsible for database backups restores and replication and security. Written various T-SQL Stored procedures functions and triggers. Responsible for Issues Handling, raised by the User. Enhancing the packages, and CUBE as per the source on quarterly basis, yearly basis. Created Calculations, Aggregations, KPI S, Perspectives, and Partitions for CUBES. Created Named sets, Tuples, Aggregation functions using with members in MDX. Responsible for deploying the packages, cubes using. Loaded data into STAR Schema data warehousing fact and dimension tables. Responsible for Creating and deploying reports onto Report Server. Responsible for doing unit testing. Involved in code reviews. Involved in UAT issue logs. Environment: Microsoft SQL Server 2008, SSIS, SSRS,SSAS,T-SQL, MSRA, MS-Excel, Windows XP/7, VS Business Intelligence Tool , TFS, SharePoint. Client: Time Warner Inc. Nov 2011-Nov 2012 Role: Sr SQL server BI Developer Location: Bangalore To provide reporting on data originating from various systems, the data needs to be consolidated from: Remedy Change Management Archer This data will enable tracking of application connected to projects, their hardware and software components, the application owners, and the work activity that is carried out in the Remedy and CR systems. Analysis of this data will enable senior management to identify system efficiency, resource loading, as well as budgeting for future software, hardware and resources. The resulting data will also be able to accurately list all application, platform and owner information in case of major upgrades/emergencies. Responsibilities: Responsible for requirement gathering and communicate with client. Involved in database support, backup, restore and replication. Created T-SQL Stored procedures and functions. Creation of datasets in SSRS to populate report data. Creation of Drill Down, drill through repots in SSRS. Implementing Groups in Reporting tables to display totals and sub totals. Creation of matrix report for dynamically expanding columns Repeating of matrix for each group using list. Responsible for deploying reports onto Report Server. Involved in code reviews for all the reports. Involved in UAT issue logs. Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS) Environment: MS SQL Server 2008, SSRS 2008, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Windows Sever 2000/2003/2008R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS). Client: Royal Bank of Canada July 2011-Oct 2011 Role: SQL Server BI Developer Location: Bangalore The requirement of this RBC-LIQUIDITY project is to automate the loading process of source files, validation of data and reporting the exceptions to the source systems. This automation process is developed in such a way that it could be extended to other applications also with appropriate modifications. This application has three parts, Pre-process, ULP (Universal Loading Program) and Post Load Process. Responsibilities: Involved in software installation and requirement gathering. Responsible for Troubleshooting and optimization of performance of databases. Creation of Br Expressions for validating data. Creation of T-sql statements using Br expressions. Involved in database support, backup, restore and replication. Responsible for supporting monitoring of jobs using BCP, SSIS Tool. Creation of stored procedures for inserting data into destination. Creating ssis package for calling stored procedures for different sources. Deploying and scheduling the ssis packages. Environment: MS SQL Server 2005,2008, Windows 2000/2003, Excel, TSQL, Microsoft Visual Studio 2005, SQL Reporting Services, SQL integration services. Client: Royal Bank of Canada Oct 2010- June 2011 Role: SQL Server, SSRS Developer Location: Bangalore RBC Spend Aggregator is an internal reporting website to show the expenses of the organization drilled down and aggregated to each employee and each department in the organizational structure. The database back-end resides on SQL Server 2005. Analyze the requirements from the business, understand the data model of the existing database and design the application to be built using .NET and SQL Server 2008 Reporting Services. Code the design into a .NET framework which shows the embedded SQL Server 2008 Reporting Services reports. Review at all stages of the SDLC is conducted and re-work handled. Defect management based on the below mentioned testing phases. Quality Assurance Testing and Integration Testing, User Acceptance Testing, Regression Testing. Responsibilities: Involved in software installation and requirement gathering. Responsible for Troubleshooting and optimization of performance of databases. Creation of datasets in SSRS to populate report data. Creation of Drill Down, drill through repots in SSRS Implementing Groups in Reporting tables to display totals and sub totals. Responsible for deploying reports onto Report Server. Generated cube for ad-hoc reporting. Involved in code reviews for all the reports. Involved in UAT issue logs. Environment: SQL Server 2005, 2008, MS-Office, MS-Excel, VSS. Client: LexisNexis May 2009- Sep 2010 Role: SQL Server, SSRS Developer Location: Hyderabad The LexisNexis Database is complete prospective details of 2lakhs US and NONUS companies and their contacts, products, blogs, financial information and research tool that provide interactive access to entire company information to track the changes of every annual, quarter, monthly and day to day updates. Responsibilities: Created Stored Procedures and Functions. Created Tables and Relationship between tables using constraints. Created ssis package for developing DWH. Deploying and scheduling ssis package. Created ssrs reports for annual, quarter, monthly updates. Responsible for code review Involved in UAT issue logs. Environment: SQL Server 2005, 2008, MS-Office, MS-Excel, VSS. Inforlinx Software Solutions India Client: KineToScopeMedia. July 2007- April 2009 Role: SQL Server Developer Location: Hyderabad At Orange Goat Project Will help make that vital connection between property owners that are looking to fill their vacancies and prospective renters that want to find the home. Renters can search the site to find detailed listings in their chosen area(s) with information about contact information, pricing, photos, floor plans, community features and amenities and virtual tours And Property owners could post their vacancies for view by thousands of interested prospective tenants providing detailed accounts of all the elements of their property. Responsibilities: Creation of Data Bases, Tables, and maintain table relationships as per Requirement. Created Stored Procedures, Views, Indexes, Roles and maintained database users. Development and implementation of backup and recovery strategies. Environment: SQL Server 2005, MS-Office, MS-Excel. Keywords: csharp business intelligence active directory information technology microsoft California New Jersey