Home

Nikitha - BI Developer or Data Analyst

[email protected]

Location: Philadelphia, Pennsylvania, USA

Relocation: EST

Visa: H1B

Professional Summary: Highly professional and well-versed MS SQL BI Developer with over all 8+ years practical hand-on experience in designing and developing with strong background in Data warehousing and ETL experience. Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MS SQL Server 2005/2008R2/2012/2014/2016. Over 6+ years of experience in Microsoft s Business intelligence stack products like SSIS and SSRS. 2+ years of experience in Power BI Service and Tableau Server. Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins. Expert in T SQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Script. Strong experience on developing ER diagrams like logical and physical data models using Erwin tool, Visio and Power Builder. Strong Knowledge on Normalization /Denormalization database design methodology. Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL Purposes across the different servers. Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail and scheduled SSIS Packages based on Business or Application needs. Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008 R2 using OLE DB connection providers by creating various SSIS packages. Highly Proficient in creating SQL Server Reports, handling sub-reports, and writing queries to perform roll-up and drill down operations in SSRS. Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. Used 2012, 2014, 2016 version of SSAS to develop tabular models and experience in performing tuning of tabular cubes. Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS 2005/2008/2012/2014. Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance. Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS. Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema and Operational Data Store (ODS). Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). Expert in creating the MDX cubes (Multidimensional Expression) and dimensions. (SSAS) Managed indexes, statistics, and tuned queries by using execution plan for optimizing the performance of the databases. Experience in configuring security, organizational content packs, data Gateways, refresh schedules for PowerBI service. Expertise in developing, enhancing, and tuning of Oracle database objects and advanced PL/SQL programs. Experience in working in agile scrum development methodology. Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments. Flexible and versatile to adapt to new- environment and technologies. Technical Skills: RDBM/Databases MSSQL Server 2016/2014/2012/2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azure Programing Languages T-SQL, PL/SQL, C, MDX, HTML, Java, Python, C Education: Masters in Computer science and Information - Southern New Hampshire University - Manchester, NH Bachelors in Information Technology - Jawaharlal Nehru Technological University Hyderabad, India. Professional Experience: Client: THE VANGUARD GROUP - Malvern, PA July 2022 - Till date Jan 2019 Nov 2021 Role: BI Reporting/Data Analyst Responsibilities: Obtaining and analyzing data using advanced statistical tools and sharing findings that lead to greater client insight, optimized performance, enhanced engagement, improved retention, increased revenue and/or decreased cost. Demonstrating independence and proactive thinking while pursuing and promoting discussion and debate on their analysis. Working with Team Leader to onboard new analysts and proactively share knowledge with other analysts across client teams. Communicating results, interpretations, conclusions, and suggestions in a manner that maximizes business partner s understanding of the impact to their operations. Clarify client needs to ensure that their needs are properly understood. Producing robust business, process, and crew reports/performance tools which support business goals and objectives. Leverage peers and other resources in identifying the most efficient techniques to maximize benefit to business partners. Seek to maximize automation of reporting. Ensuring a deep awareness and understanding of all data sources so that client needs can be met in an effective and thorough manner. When appropriate use knowledge depth/experience to troubleshoot any/all issues associated with data collection and availability. Working with tools like Microsoft Excel, Microsoft Access, IBM Cognos, and Tableau to perform everyday responsibilities. Working on Daily/Weekly/Monthly reports by gathering data from primary or secondary sources within the organization's data system, run dashboards and publish workbooks on Tableau. Working with Client Insight, IT, or any other relevant group to ensure the data collection and analysis infrastructure enables you to meet the needs of clients. Identify, implement, and support thorough testing and quality controls to ensure only the highest quality outputs are delivered to our clients. Support supervisor in ensuring the quality of less tenured analysts meet the expectations of our clients and expectations of their position. Deep understanding of businesses supported to ensure that proper context is used to shape deliverables. Managing a portfolio of work to ensure work stays on track and clients are informed of progress. Work with business partners, supervisor, and relationship manager to ensure appropriate prioritization of work. Data Modeling FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional, and multidimensional modeling and De-Normalization Techniques. BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, Tableau, Power BI. Tools/Database Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS). Application Packages MS Office, Microsoft SharePoint Server (MOSS) Operating Systems Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers. Participating in software elevation discussions to advocate for data interests of business partners and integrate new technologies into workflows. Providing business partners with insight into impact to key performance indicators that may result because of significant changes to business processes. Building strong relationships with business partners through functional expertise and cross-functional client team awareness to create a bond of trust and ensure a free flow of communication. Analyzing data and identifying opportunities to support reporting improvements, participating in special projects, and performing other duties as assigned. Environment: Microsoft Excel, Microsoft Access Database, Tableau, Power BI, AWD, AWS, Cognos, VBA, JIRA. Client: PNC Financial Services - Pittsburgh, PA May 2017 Dec 2018 Role: SQL/MSBI Developer Responsibilities: Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors, and indexes using T-SQL. Demonstrable knowledgeable experience with Informatica, Oracle SQL, PL/SQL development. Experience working in deployment of cubes, OLAP & XMLA. Developed tools using python, shell scripting, XML to automate tasks. Well experienced in data modeling & data migration from Oracle to SQL. Experience working in Power BI. Have experience in support and maintenance of BizTalk & AX Microsoft Dynamics with implementation and involved in working with self-direct assignments using tableau. Involved in projects with Power BI environment and tableau. Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions). Worked on SSIS Packages Documentation, source, archive, Stage path mapping. Develop Exception handling process and audit process for each ETL package. Developing SQL code such as writing complex queries, stored procedures, user defined function etc. Monitor and SQL profiler and tuned queries and procedures to boost database performance. Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, SCD to load data into Database. Involved in creating proxy accounts and Scheduling Jobs to execute SSIS packages. Responsible for creating database objects like table, Views, Store Procedure, Functions using T-SQL to provide structure to store data and to maintain database efficiently. Created and managed Interactivity Financials SSRS reports (Parameterized, Linked, Drilldown, Drill through reports) Environment: Informatica, PL/SQL, SQLServer 2016/2014/2012/2008/2005 R2,2012, SSAS, SSIS, SSRS, Windows Server 2008 R2, Visual Studio 2010, C#.Net, Oracle 9i, 11g, Teradata, TFS, Crystal Reports, AngularJS, Micro strategy, MS Dynamics AX, UNIX, LINUX, Azure, Mango DB. Client: Premier Inc - Charlotte, NC Sep 2016 April 2017 Role: BI Developer (MSBI)/Power BI Responsibilities: Designed and monitored the construction of the SQL Server Business Intelligence enterprise data warehouse. Generated Tabular Model in SSAS, partitioned, used different storage techniques, created DAX, MDX queries to retrieve and manipulate data off them. Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers. Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012/2014 and in adding calculations using MDX. Involved in writing MDX Queries for Analytical and Reporting purposes. Created various KPIs, actions, aggregations for proper analysis of data in the cubes. Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently. Processed OLAP cubes with various processing options depending on the requirement. Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses. Developed automation scripts which used REST APIs to extract data from blob storage of Azure Cloud Services. Created and Maintained SQL Server Agent Jobs for SSIS Packages. Customized sites on SharePoint Portal and hosted the SSRS and Power Pivot reports on to SharePoint. Created Power view reports using the Tabular SSAS models in Excel. Scheduled Reports using subscriptions in SharePoint. Provided 24/7 production support for Business users. Environment: Microsoft BI (SSAS, SSRS, SSIS -2012/14), MDX/DAX, Power BI, SharePoint 2007/2010, SQL Server 2012/2014, Business Intelligence Consumer Services. Client: Consolidated Edison - New York City, NY June 2015 June 2016 Role: SQL/BI Developer Responsibilities: Worked closely with business and involved in gathering the user requirements. Created database links and accessed the data through SQL statements. Responsible for writing and modifying store procedures, functions, packages for data conversions to create database objects dynamically. Created indexes, tables, and sequences as per the business requirement and views to maintain data privacy. Used SQL profiler to identify slow running queries. Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud. Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse. Analyzed the requirements and framed the business logic for the ETL process. Extensively used SSIS Import/Export Wizard, for performing the ETL operations. Performed data migration from Excel, Sybase, Oracle to MS SQL Server using SSIS. Normalized and denormalized data for Data Warehouse. Created package to transfer data between OLTP and OLAP databases. Designed Cubes with star schema using SSAS. Developed complex SSAS cubes with fact measures and multiple dimension hierarchies using partitions, KPIs, Perspectives and created various users, roles and assigned necessary permissions. Created hierarchies and partitions for improving SSAS cube performance. Created various complex reports and manage them using SQL Server Reporting Services (SSRS). Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications. Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard. Created various kinds of reports using power BI based on the client s needs. Used Collections, Bulk Collections for handling large amount of data in PL/SQL. Involved in creating visualizations and multiple dashboards in Power BI. Calculated columns, conditional column, custom columns, created measures in PowerBI. Responsible for creating SQL datasets for power BI and Ad-hoc reports. Design, Develop and Deploy Microsoft Power BI reports. Generated Daily, Monthly, Quarterly and Yearly reports in Power BI. Created Action filters, Parameters, and calculated fields for preparing dashboards and worksheets in power BI. Responsible for scheduled job maintenance and troubleshooting. Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters. Used Agile Development Methodology Point of contact for all the production issues. Environment: T-SQL, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Sharepoint Server, Azure, .Net, Power BI. Keywords: cprogramm csharp business intelligence database active directory information technology microsoft procedural language Delaware New Hampshire New York North Carolina Pennsylvania