NIKITHA A

Email : [email protected]
Phone: 732-791-2764

Professional Summary:

● Highly professional and well-versed Data Analyst/BI Developer with over all 8+ year’s practical hand-on experience in designing
and developing with strong background in Data warehousing and ETL experience.
● Strong IT experience in the field of Data analysis, ETL Development and Data Modeling.
● Experience in Business and Data Analysis, Data Profiling, Data Migration, Data conversion, Data Quality, Data Integration and
Metadata Management Services and Configuration Management.
● Expert in data modeling with creating Star Snow Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data.
● Strong experience in interacting with stakeholders/customers, gathering requirements through workshops and existing system
documentation or procedures.
● Experience in various phases of SDLC analysis, requirements gathering, designing with expertise in documenting various
requirement specifications, test plans, Source to target mappings, SQL joins.
● Expert in coding SQL using procedures, Triggers and Packages.
● MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise
in MS SQL Server 2005/2008R2/2012/2014/2016and over 6+ years of experience in Microsoft’s Business intelligence stack products
like SSIS and SSRS and 2+ years of experience in Power BI Service, Tableau Server and Microstrategy Intelligence Server,
Thoughtspot.
● 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 performance in data analysis and data profiling using complex SQL queries on various source systems like Teradata and
Oracle.
● Expert in Data Migration, Data Integration, Data import and export through the use of multiple ETL tools.
● Excellent knowledge in gathering business requirements and preparing required project documentation and tracking and reporting
regularly on the status of projects to all project stakeholders.
● Strong Knowledge on Normalization /DE normalization database design methodology.
● Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
● Expertize in Microstrategy product namely Microstrategy desktop, Microstrategy Intelligence server, Microstrategy report services
and Microstrategy dashboard.
● Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server
performance.
● 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).
● 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

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, Microstrategy intelligence server, Tableau, Power BI, Thoughtspot.
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.

Professional Experience:

Client: THE VANGUARD GROUP, Malvern, PA July 2022 – Feb

2024
Jan 2019 – Nov 2021
Data Analyst

● 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.
● Gathering business requirements, working closely with business users, leaders and developers.
● Analyzing business requirements and designing conceptual and logical data models.
● Working on various dimensional models using star and snowflake schemas.
● Performing data analysis and data profiling using complex SQL queries on various source systems.
● 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.
● Involving in gathering requirements from business and translating them into reports for the Microstrategy platform.
● Using Microstrategy desktop 9.2.1 to build schema objects.
● Designing and developing dashboards using Microstrategy report service documents for various products and services.
● As per business requirement, designed developed and maintained Microstrategy based reports.
● 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.
● Strong Experience with Thoughtspot in building the charts, dashboards, pin boards, views and workflow to support business
decision process.
● Experience in building pin boards and creating worksheets to improvise tableau applications in Thoughtspot.
● Creating SQL scripts to load data into Thoughtspot for BI Analytics.
● Experience in Data integration, Slack integration, Embedded analytics and configuring SAML authentication in Thoughtspot.
● 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 as a result 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, Microstrategy Intelligence server, Thoughtspot, Star
and Snowflake schema, Data integration, AWD, AWS, Cognos, VBA, JIRA.

Client: PNC Financial Services, Pittsburgh, PA May 2017 – Dec 2018

Data Analyst
● 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

BI Developer (MSBI)/Power BI

● 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
SQL/BI Developer
● 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 in order 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.

Education:
● Masters in Computer and Information Science from Southern New Hampshire University, Manchester, NH, USA
● Bachelors in Information Technology from JNTU, Hyderabad, INDIA