Home

Geeta Sesha Chaitanya - Power BI with SQL Server, SSRS, SSIS, Microsoft Project Server, Microsoft Project with 15 + years of Exp

[email protected]

Location: Salt Lake City, Utah, USA

Relocation: Yes

Visa: H1B

Geeta Sesha Chaitanya : [email protected] : +1 646 764 9429 PROFESSIONAL SUMMARY Around 15+ Years of professional IT experience in Designing, Developing, Deploying and Managing BI and Cloud applications using Microsoft Project Online, Project Server 2007/2010, Project for Web, Azure, Power BI, SSRS, SSIS, SQL Server, Fluent Pro Books, T-SQL, SharePoint, Tableau and Microsoft Applications in domains like Manufacturing, Oil & Gas, Telecom, Banking, E-commerce, and Health Care, proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in the complex and challenging customer environment. Conversant with all phases of the Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance. Extensive experience in implementing Microsoft Project Online, Project for Web, Solutions along with MS Visio, Microsoft Project, Power Query, PowerPivot, SharePoint, and SharePoint Designer. Extensive experience in implementing Microsoft Bl/Azure BI solutions like Azure Data Factory, Power BI, SQL Server Integration Services, SQL Server Reporting Services, Data Modeling, Data Warehousing, Data Analytics, Client Collaboration Expert knowledge of architecting and developing Power BI solutions by configuring the data security, assigning the licenses, and sharing the reports and dashboards with the different user groups in the organization. Well versed in Data warehousing concepts, DW Architecture, DW/BI tools, MS Azure - Azure SQL, MS SQL, MSBI - SSIS, SSRS, SSAS, Power BI, QlikView, Excel VBA, VB and Excel Pivot, Experienced in client requirement Analysis, Physical, Logical Design, Development, Debugging, Testing, Deployment, Support, and Maintenance of business applications using SQL Server 2019/2016/2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016/2019. Experience developing Custom Reports, different types of Tabular Reports, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services (MS POWER BI, Tableau, SSRS) in the Business intelligence development studio (BIDS). Experienced in migrating Data from Project Online OData, Excel, Flat file, and Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring SSIS packages. Experience in creating and deploying MS POWER BI SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations. Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of packages, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption. Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2019/2016/2014/2012/2008/2005. Strong Data modelling experience using ER diagrams, Dimensional data modelling, Working knowledge of ODBC, OLEDB, T- SQL, SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and scripting languages. Responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advanced Data Analysis, Business Research and Quantitative Analysis Strong understanding of HR metrics and KPIs, including turnover rates, employee engagement, performance metrics, etc. Familiarity with data governance principles and best practices for maintaining data accuracy and integrity. Proven mentor and trainer, skilled at communicating with all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence. Eager to learn new Technical and industry skills and derive simplicity from complex problems. Problem-solving issues that arise in day to day running of automation processes and providing timely responses and solutions as required. CERTIFICATIONS 70-778 Analyzing and Visualizing Data with Microsoft Power BI PL-300 Microsoft Power BI Data Analyst AZ-900 Microsoft Azure Fundamentals MS-900 Microsoft Office 365 Fundamentals AZ-104 Microsoft Azure Administrator 70-533 Implementing Microsoft Azure Infrastructure Solutions 70-532 Developing Microsoft Azure Solutions TECHNICAL SKILLS Cloud Microsoft Project Online, SharePoint Online, Project Service, Power Apps, Azure Workflows Microsoft Power Automate, SharePoint Designer Workflows, MS Flows Azure Technologies GitHub, TFS Repos, Azure Functions, Azure Data factory RDBMS SQL Server 2019,2016, 2014, 2012, 2008 ,10 and 2016, SSIS Process Tool MS Visio 2019/2016/2010/2007 Migration Tools Fluent Pro Migrator, EPM Pulse Reporting Tools Microsoft Power BI, SSRS, Tableau, Microsoft Fabric Reporting Tools SQL Server Reporting Services 2008/12/14/19, Azure Synapse Analytics Distributed Technologies Web Services, Web API, Cloud, AWS, Azure Version Controls SourceTree, Git, TFS Open Source Python(novice) Software Engineering Agile, waterfall PROFESSIONAL EXPERIENCE Client: Halliburton, Salt Lake, UT Jan 20 Present Role: Technical Consultant (Power BI) Responsibilities: As an Application Lead responsible for Designing and Development of EPM applications and reporting solutions using Power BI by integrating with SQL Server, Excel and SAP. Developed interactive and visually compelling reports and dashboards using Power BI, transforming raw data into actionable insights to support decision-making processes. Designed and implemented data models in Power BI, incorporating multiple data sources and complex relationships to create comprehensive analytical solutions. Created custom visuals and calculated measures in Power BI to address specific business requirements and enhance data visualization capabilities. Designed and implemented a comprehensive HR dashboard in Power BI, providing real-time visibility into key HR metrics and enabling proactive decision-making. Integrated external data sources into Power BI reports to enrich HR analytics, such as market salary data, employee survey results, and performance reviews. Developed predictive analytics models using Power BI to forecast employee turnover and identify retention strategies. Developed and maintained Power BI dashboards and reports to analyze HR data, including headcount analysis, employee demographics, turnover trends, and performance metrics. Collaborated with HR stakeholders to understand business requirements and translate them into actionable insights using Power BI. Automated data extraction and transformation processes to streamline reporting and ensure data consistency and accuracy. Conducted data validation and reconciliation to ensure the accuracy and reliability of HR analytics reports. Provided training and support to HR teams on using Power BI to access and interpret HR data effectively. Automated data extraction, transformation, and loading (ETL) processes using Power Query in Power BI, reducing manual effort and improving data accuracy and consistency. Utilized DAX (Data Analysis Expressions) language in Power BI to create calculated columns and measures, perform complex calculations, and generate advanced analytics. Integrated Power BI with other Microsoft Office applications, such as Excel and SharePoint, to streamline data exchange and enhance collaboration among team members. Implemented row-level security and data-level security in Power BI to restrict access to sensitive data and ensure compliance with security policies and regulations. Conducted user training and workshops on using Power BI, educating end-users on report navigation, data exploration, and self-service analytics capabilities. Collaborated with business stakeholders to gather requirements and define KPIs (Key Performance Indicators) for Power BI reports and dashboards, ensuring alignment with business goals. Provided ongoing support and maintenance for Power BI solutions, troubleshooting issues, and implementing enhancements to optimize performance and usability. Coordinated with business managers on optimizing the query executions in power bi reports by streamlining sql queries/views/stored procedures. Assisted business managers by automating the report functionalities with Power BI tools Created Excel reports, KPI, and dashboards based on business requirements Application is used technology group for checking respective managing their Project, Resources, generate time reports, Project/Resource scheduling etc Automated data extraction, transformation, and loading workflows, reducing manual intervention and improving data processing times by 30%. Created and optimized complex SSIS packages for data migration, cleansing, and validation, ensuring data quality and integrity. Implemented data mapping and transformation logic to standardize data from diverse sources, resulting in more accurate and consistent reporting. Monitored ETL processes to identify and resolve issues proactively, ensuring high availability and reliability of data pipelines. Sharing weekly and monthly report with offshore/Onshore higher management Coordinate with different teams during service pack upgrades, SQL Patch installations and vulnerability remediation's on servers. Conducted performance tuning and optimization of SQL queries, indexes, and database configurations, resulting in a 40% improvement in query response times. Designed and implemented disaster recovery plans, including setting up and maintaining database replication and mirroring. Monitored and resolved database incidents and alerts using SQL Server Management Studio (SSMS) and third-party monitoring tools. Responsible for monitoring capacity issues, developing effective capacity plans, and ensuring that customer service meets the established Service Level Agreements and quality standards. Analyze user requirements and product architecture/design to derive testing performance, scalability, and durability testing. Worked extensively in user and production support. Resolving production issues, creating stories for larger changes, and helping users and businesses with the support they need, including giving access to applications and extracting reports and stats related to the application for business. Environment: Power Bl, Power BI Gateway, MS SQL Server 2019/2016/2014/2012/2008 R2, MS Excel, Team Foundation, SSIS, SSRS, SharePoint Online, Microsoft Project Online, Microsoft Project, Power Apps, ADO, SAP. Client: Capital One, Chennai, India Jan 14 Dec 19 Role: Power BI Technical Consultant Responsibilities: Designed and implemented robust data models for data marts, ensuring optimal organization and structure of data to support efficient querying and reporting. Working with Azure Blob and Data Lake storage and loading the data into Azure Synapse (DW) Migration of Data from on premises SQL to Azure SQL and Azure Synapse Analytics (DW) Working on creating Data pipelines to transfer data, schedule triggers using Azure Data factory Extracted, transformed, and loaded (ETL) data from multiple sources using SQL to ensure data accuracy and consistency. Created and optimized SQL queries to retrieve relevant data for analysis, ensuring efficient performance and minimal latency. Utilized Power BI to design interactive and visually appealing dashboards that included key performance indicators (KPIs), charts, and graphs. Conducted in-depth analysis to identify sales trends, customer behaviors, and market opportunities, providing actionable insights. Implemented automated data refresh schedules in Power BI to ensure up-to-date information availability. Utilized Power BI Performance Analyzer to identify and resolve performance bottlenecks in reports and dashboards. Developed the Canvas application in PowerApps to automate the manual data entry application Developed PowerApps app using SharePoint and SQL as data sources Dataverse/Dynamics 365 as Data source for PowerApps, Power BI Design, develop and manage paginated reports with Report Builder Analyzing using Apache Spark in Azure synapse Requirement gathering for Business insight and analysis and Functional Specifications Document high level functional and technical design specifications Testing Functional, Regression Install, Upgrade and maintenance Power BI Gateways (on Premise) across Organizational Level Adding different data sources to the Gateways and assigning the permissions to Business partners Environment: Azure Synapse, Azure SQL, SQL Server, Azure Data Bricks, Power BI Desktop, Power BI Cloud, PowerApps, DAX expressions. Azure Data Factory Client: BSNL, Hyderabad, India May 12 Nov 13 Role: Project Analyst Responsibilities: Lead meetings with key business leaders to gather and coordinate end-user requirements to determine the best portal solution for business needs. Analyze user needs, determine portal governance requirements, make recommendations for best product solutions, collaborate agreement on product and developed infrastructure requirements, guide users on SharePoint best practices, and develop user interface forms and business logic. Taken care of Installing SharePoint and Project Server 2010, SQL Server 2012, and configured Power BI Service and Gateway. Managed Power BI implementation projects for clients, from initial requirements gathering to deployment and post-implementation support. Coordinated with internal teams and external vendors to ensure successful project delivery within agreed timelines and budgets. Communicated project progress, risks, and dependencies to clients in a clear and transparent manner, fostering trust and confidence. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the decision-makers for strategic planning. Delivered training sessions and workshops to empower clients with the knowledge and skills needed to effectively use Power BI. Created training materials and documentation tailored to the specific needs and skill levels of client users. Offered ongoing support and guidance to clients, helping them leverage Power BI capabilities to drive business insights and decision-making. Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads. 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 report data could be used to send information to different Primary Vendors, Clients, and managers. Used Business Intelligence Mark-up Language (BIML) to rapidly create SSIS packages and solutions and automate SSIS Design Patterns. Developed various solution-driven views and dashboards by developing different chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots in Power BI. Developed SSIS packages and Deployed SSIS projects using the Project Deployment model data, including packages and project parameters. Environment: Microsoft Project Server 2010, Microsoft Project, Microsoft SharePoint 2010,Oracle SQL Server 2008/2012 Ms Power BI SSIS, Microsoft Power BI SSRS, Oracle SQL Server 2012/2008, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007, Crystal Reports, Service Now. Client: ADCO, Hyderabad, India July 11 - April 12 Role: Project Analyst Responsibilities Designed, installed and configured enterprise-class SharePoint 2007/2010 environments per TxDOT client requirements. Installed and configured the following server applications: Windows Server 2008 R2, SharePoint 2010 Enterprise, SQL 2010, MS Project Server 2007, and Windows Azure Workflow Server incl. Service Bus, and Office / Project Web Apps. Configured SharePoint services, including SQL Analysis and Reporting Services to enable business intelligence / Performance Point, Excel Services, etc. Power Pivot and Power View, Access Services 2010, Enterprise Search, User Profile Services for the new social experience, BCS, Visio Graphics, and Word Automation. Responsible for monitoring SharePoint timer, search services, IIS, Disk Space and CPU usage using Systems Center 2010. Architected business process automation solutions in SharePoint for onboarding, sales contract management, order processing, sales process support, creative brief management, and automated document management using SharePoint workflows, InfoPath and 3rd party solutions. Supported vendor team with their efforts surrounding Nintex integration, Configured and maintained term store, and helped with search features. Provided technical expertise in identifying, evaluating, and developing effective solutions in SharePoint that met line of business requirements. Planned and led migration efforts for three production SharePoint farms from 2007 to 2010. Produced pre-migration assessment and UAT plans. Installation included the gathering of all system requirements, analysis of all current development and production tiers in the farm, configuration of SQL and Analysis services, complete installation of the Project Server binaries into an existing SharePoint deployment, applied all cumulative updates as needed, creation of the Project Server service application, setup Project Server web application, create separate Project Server Web App site collection, create Confidential instance, configure Project Server for SharePoint permissions mode, install and configure Workflow Manager, setup cube building service, build OLAP cubes, create and setup appropriate access groups to Project Server BI, setup and configure. Performance Point service application, setup and configure secure store, setup and configure Excel service application, setup and configure SSRS in SharePoint integrated mode, system test, troubleshoot all issues, write and deliver all installation documentation. Managed the content migration process by gathering departmental requirements and developed a plan for gradual content migration. Assisted in developing migration plan as well as implementation and post-implementation support. Responsible for providing subject matter expertise, mentorship, and training to clients and junior professionals on best practices in technical design. Environment: Microsoft Project Server 2010, SharePoint Server 2010, WSS 3.0, Office 365, Microsoft Office SharePoint Designer 2007/2010 SQL Server 2008 R2, Windows Server 2008 R2, IIS 7.0, ASP.NET, Quest, Idera, AvePoint, and Nintex, JIRA Client: Sterlite, Hyderabad, India Oct 10 Jun 11 Role: SharePoint Project Co-Ordinator Responsibilities Served as a member of the Core Team assisting the business in refining remaining requirements and, in doing so, protected the project from what had been habitual and substantial scope creep and mentored 12 Developer direct reports. Provided the functional areas of the business with a single point of contact for the project's IT assets. Made a very positive impact on each developer's ability to stay focused on completion of goals and the forward momentum of the project in general. Worked in the R&D team, which involved identifying the best practices for Project Server and JIRA integration, tested various projects like CEPTAH and wrote customer API in data integration. Managed/administered SharePoint SQL databases, implemented SQL SSIS packages and assisted business groups with tasks related to their database needs. Configured JIRA for Agile methodology process for users to manage projects. Created custom SQL Server Reporting Services (SSRS) Reports to be displayed in a Microsoft SharePoint 2010 web application. Designed and developed SharePoint 2010 workflows, custom sites, and branding. Designed and developed custom SharePoint 2010 applications using SharePoint Designer. Continued progress in revising and updating existing documentation regarding enhancement and upgrades to applications and hardware improvements. Directly supported the Confidential team in improving server manageability and application performance and reducing production downtime. Developed customized client-specific monthly fund reports using SSRS (SQL server reporting service) Used SSIS (SQL Server Integration Services) to load data from MS Excel or tab-delimited text files in applications. Supported Project Professional in the Office with daily issues such as check-in, check-out, Time Sheet entry and Access Management to the PWA site along with JIRA. Collaborate across enterprises to develop detailed resource maps and gather requirements for reports. Administrate Project Server, maintaining enterprise resources, users, and schedule templates, archiving completed projects, calendars, timesheet approvers, and customized look-up tables and views. Involved in SharePoint and Project Server migration, Report generation using built-in tools, and JIRA administration. Environment: Project Server 2010, SharePoint 2010, SharePoint Designer 2010, InfoPath 2010, C#.NET, Nintex workflow, Visual Studio, SQL Server 2008 R2, Windows Server 2008 r2. Client: Hindustan Zinc, Hyderabad, India Nov 09 Sep 10 Role: SharePoint Project Co-Ordinator Responsibilities Design & development of intranet, extranet and internet portals using the out-of-the-box features & custom applications of SharePoint 2007. Created Infopath forms, deployed them on the SharePoint site and configured the workflow using Visio and SharePoint Designer 2007. Ensured project documentation in multiple repositories is updated regularly. Coordinated project team deliverables through SharePoint, Jira and MS Project Server. Ensured data consistency and alignment to the project lifecycle. Showcased project dashboard using functions like V-lookup, Pivot Table and Graphs from source data using MS Excel. Conducted requirement gathering from business stakeholders, prioritization and fulfilment. Managed project communication with multiple business stakeholders in a Confidential matrix environment. Used MS PowerPoint to present weekly project status reports showing progress, graphs, risk status and budget variances. Oversaw all status reporting processes to the leadership and the reviews and required approvals. Coordinated logistics for all. Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008 Database by using multiple transformations provided by SSIS Such as Data Conversion, Conditional Split, Merge, and Union all scheduled and maintained nightly and Weekly load of data by creating the corresponding job tasks. Worked extensively on web forms and data binding controls like Grid View, Data List and drop-down boxes and Mapping page fields to the database fields. Build a DR environment from scratch and set up weekly farm and daily site collection backups. Changed all the SharePoint servers to use SQL alias instead of DNS entry. Environment: Microsoft SharePoint 2007, Windows Server 2008 R2, Microsoft SQL 2008r2, InfoPath 2010, SP Foundation 2010, SP 2010 server, MS Office 2010, SP Design 2010, Visual Studio 2010, Microsoft .Net framework 3.5. Client: Vedanta, Hyderabad, India Oct 08 - Oct 09 Role: SharePoint Administrator Responsibilities Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder. Used ETL tools like DTS, SSIS, and SSAS, Created SSIS package, Deploying the package in different sources and importing/exporting, BCP (Bulk Copy) to import & export data from flat files, and Excel to MS SQL Server databases. Data from/to Oracle, MySQL, and Access Database, including flat files like text, Excel, and CSV files to SQL Server 2005/2008r2. Monitor and resolve deadlock for client issues. Troubleshooting connectivity issues, Permissions, etc. Monitoring SQL server performance using Activity Monitor, profiler to find performance. System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability. Provided database design, development, and support services to the Microsoft SQL Server to transact SQL, Microsoft Visual Basic, and Oracle Software. Assisted in the design, implementation, and maintenance of data warehouses. Also implements MS SQL Server Data Transformation Services. Handled errors extensively using exception handling for easy debugging and displaying the error messages in the application. Created different Search Scopes based on file types and added properties in advance search to search data in specific columns. Set up Permission levels for individual users and SP Active Directory groups in sites, libraries and lists as per requirement. Scheduled regular Backups by setting Timer Jobs from Central Administration and using PowerShell CMDLETS regularly. Actively participated in team and client meetings to develop the application. Participated in bug-fixing and release planning meetings. Environment: SharePoint Server 2007, InfoPath 2007, Office 2007, SharePoint Portal Server EDUCATION Bachelor of Business Management from Acharya Nagarjuna University, IN (2007) Keywords: csharp business intelligence active directory rlang information technology microsoft procedural language Arizona Colorado Utah