Sign in

Data Analyst

Northborough, MA
December 21, 2019

Contact this candidate


Prathyusha N

Phone Number: 317-***-****


6+ years of Industry experience as a Data Migration/Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.

Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page

Layouts, Email Services, Approvals, Workflows, Reports, Dashboards, Tasks and actions.

Equal competence Integration Services, Reporting Services and Analysis Services.

Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

Hands on experience in SQL Server Reporting Service (SSRS).

Hands on experience in scheduling and deploying reports on report manger.

Hands of experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.

Extensive experience in data migration and integration using Data Loader.

Experience in interpretation and integration of conceptual models, logical models, view models (snowflake, star-schema), object models.

Experience with using master data, reference data and meta data concepts for reusability of designs

Experience in data migration from Excel, MS outlook and Legacy Systems using Data Loader, Import Wizard, Informatica Cloud, Cast Iron and Pervasive Data Integrator.

Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as SAP BODS and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements.

Knowledge in SAP Business Objects (Enterprise) 4.0 such as Web Intelligence, Semantic Layer (Universe Designer) and Data Integration (Data Services) 3.2, 4.0 and SAP Dashboards (Xcelsius 2008).

Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

Experience in building and managing Universes, creating Complex, Ad-hoc Reports and/ or Charts using Business Objects.

Expert in writing complex formulae at the summary level and group level to implement the business logic

Strong knowledge of Object Oriented Programming (OOPS) and Object Oriented Design (OOD) concepts.

Hands on Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks. Created complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO.

Successfully migrated data from legacy to SAP system.

Experience working with Analytics and Data Visualization tools (e.g. Cognos, Business Objects, Power BI)

In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping; and design using UML, Rational Rose, and Visio.

Hands on experience of testing Client-Server applications (Tronweb)

Experience in database development, administration, database design, and support of oracle in development and production environment.

Understanding of both waterfall and agile development methodologies.

Self-starter and well disciplined. Experience in teaching and research work Excellent written and oral communications skills as well as analytical skills.

Technical Skills:

Operating System: Windows NT

Languages: SQL Script, PL/SQL, T-SQL, C++, Java, Apex.

Web: PHP, HTML, CSS, Adobe Flex 3.0, and Dream viewer.

Databases: SAP HANA, MS SQL Server 7/2000/2005/2008/2016,

Oracle 8i/9i/10g

ETL Tools: Data Services 4.0 Information Steward, SQL Server

Integration Services (SSIS)

Data Modeling Tools: ERwin r7.1/7.2/7.3/8.0, Oracle Designer 12.0 and ER

Studio 8.5, JIRA

SFDC Technologies: Marketing Administration (Campaigns, Leads), Salesforce Automation (Accounts, Contacts, Opportunities), Customer Service and Support Automation (Cases, Solutions), Reports, Dashboards, Workflow & Approvals, and Custom Objects.

Reporting Tools: Business Objects 4.0, 3.1/3.0- (Information Design

Tool, Universe Designer, Crystal Reports 2013, Web Intelligence, Info View, CMC, WEBI), Xcelsius 2008, Dashboards 4.0, SAS Web Report Studio, Power Bi,

SQL Server Reporting Service (SSRS)

Experience/Project Work

Duration: Mar 2018 - Current

Industry: Cognition Financial (Student Loan Platform), Boston, MA

Project Description/Scope:

Cognition Financial (formerly The First Marblehead Corporation) was founded in 1991 with the goal of helping students reach their educational goals through access to funding. Cognition Financial then changed availability of and access to education loans for students and their families. Through the Monogram Loan platform, along with our lender partners, Cognition Financial changed the structure and flexibility of private student loans. Through the raise^ private student loan program which we designed in conjunction with, and which is offered through, our lending subsidiary, Cognition Lending, we are increasing the availability of funding.

Role: Sr. Data Analyst


Created new SQL databases, tables, views, functions, stored procedures and jobs.

Optimized existing database objects structure and indexes.

Created Stored Procedures to transfer data from XML to SQL server database.

Created stored procedures to assign unique loan keys to be able to analyze origination and servicer data properly.

Creation and automation of reports in SQL Server, Access, Excel.

Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.

Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.

Creating jobs for scheduling the SSIS packages.

Getting data from different data sources.

Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, Conditional Split, Multicast, Union-all and Merge.

Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.

Effective communicator among cross-functional business and IT units, management and data providers.

Diagnosed and addressed operational data requests

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Perform in-depth analysis and reporting on data used for financial accounting, trend analysis and forecasting.

Performed and conducted complex reporting analytics

Generate reports with parameters, sub reports, cross tabs, charts using Power BI .

Responsible for all reporting and data management needs for largest group within Finance including financial reporting, operational reporting and process improvement.


Duration: Feb 2015 – Sept 2016

Industry: Mercury Products (Manufacturing), Schaumburg, IL

Project Description/Scope:

Mercury Products Corp. is a diversified metal products company. Products include fuel tank straps, rain caps, engine core freeze plugs, heat shields, interior and exterior grab

handles, brackets and clamps, custom fabrications and producing high tolerance stainless tubing. Mercury is a tier 1 to the automotive and heavy truck industries and also the emissions and aftermarket industries. Customers include: Ford, GM, Peterbilt, Kenworth, Freightliner, Volvo, Mack, Caterpillar and Navistar.

Role: Data Analyst


Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for about 100 Business Users.

Extracted data from Oracle and SQL Server using SAP Data services to load it into a single data warehouse repository.

Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.

Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Developed logical data models and physical data models using ER-Studio.

Involved in defining the system and functional requirements of the reports.

Conducted master data analysis and mapping activities.

Responsible for creating business requirements and system documentation, as well as contributing to end-user and project management documentation.

Design, develop, test, implement, and maintain analytic solutions leveraging centrally managed reporting tools such as Webi, Dashboard and Crystal

Generate reports with parameters, sub reports, cross tabs, charts using Webi Reports

Served as a resource and/or participant in business process re-design activities. Assists the users in determining if and how system enhancements may improve.

SAP BI Administrator managed Users, Groups, Securities, Folders and Connections through CMC.

Identify, analyze issues in client requirements, application systems & architecture and design specifications.

Manages monthly inventory and close process for all locations.

Experience in designing of Business Objects Universe and Reports connecting to Relational Database like Oracle, Access, SQL server etc

Implementing the requirements as a modeling solution in BOBJ Universe (IDT)

Expertise in reporting/analytic role with a focus on visualization design and development.

Created Ad-Hoc reports on need basis using SAS Web Report Studio to show variation between WEBI and SAS.

Exposure to debugging/troubleshooting of SAP Business Objects Universe and reports using HP Quality Center (HPQC)

Exposure to Migration Process and methodology in a development and Production environment.

Aggregate, analyze, and report vast quantities of data in an organized and visual format by clearly communicating with the users.

Experience in supporting business queries on data analysis.

Duration: Sept 2013 – Dec 2014

Industry: Crawford & Co (Insurance), Lake Zurich, IL

Project Description/Scope:

Based in Atlanta, Georgia, Crawford & Company (www.crawfordandcompany) is the independent provider of claims management solutions to the risk management and insurance industry as well as self-insured entities, Based in Atlanta, Ga., Crawford & Company is the world's largest independent provider of claims management solutions to the risk management and insurance industry as well as self-insured entities, with an expansive global network serving clients in more than 70 countries.

Role: Salesforce Administrator


Worked in a team as administrator to perform detailed analysis of business and technical requirements and designed robust, secure and scalable the solution.

Analyzed the business requirements and mapped to Salesforce.

Experience in implementing Salesforce projects, supporting complex implementations for sales cloud, Miller Heiman Sales Methodology support including Sales Access Manager (Strategic Selling/Conceptual Selling and Large Account Management Process), and Informatica Cloud Integration platform.

Performed data migration from MS Outlook, Excel to Salesforce using Data Loader.

Provided analytical support for multiple, complex projects simultaneously while meeting the deadline established timelines, work plans.

Developed a process to manage request and approvals for leads and opportunities. Implemented a specialized management process with version capabilities to keep track of updates and milestones in project.

Created workflow rules and defined related tasks, validation rules, Auto-Response Rules, Approval process, email alerts and templates, and field updates.

Customized page layouts for Campaigns, Leads, Opportunity, Contacts and Accounts depending upon user roles, and groups.

Designed various HTML Email templates for Auto-Response to customers.

Developed Web-to-Lead functionality for customers directly to Salesforce CRM.

Used sandbox mode for testing and migrated the code to the production instance in installments.

Created custom report types like summary and matrix reports to track pipeline insight, program opportunities.

Seeing and documenting if the business process requirements was complied or according to the client requirements (provide reports on project deliverables whether it is open, closed, re-open, in-progress, or assigned to other team).

Duration: Aug 2011 - Aug 2013

Industry: Vesta (Oil & Gas Industry), Vernon Hills, IL

Project Description/Scope:

Vesta – EAM Maintenance Data and System Assessment

The Vesta system assessment is a site-based consultation which involves exploration of SAP implementation, maintenance, and business practices, all centered on the PM module and maintenance. Vesta will be providing strategy consulting, implementation analysis, and best practices suggestions pertaining to Enterprise Asset Management (EAM) processes while we will analyze a sample of equipment and material data.

Role: Data Analyst


Developed EAM Maintenance Data and System Assessment Business Rules provided by Vesta using complex validations in Data Services 4.0.

Worked on Plant Maintenance (PM)to load the IDOC's into ECC

Loaded IDOC's into ECC for Equipment data, Maintenance Order Management data, data and Functional Location data using flat file inputs

Built post load validation extract of PM in order to validate the data loaded into ECC using ABAP data flows.

Designed new Universes and modified the existing Universes based on the business requirements.

Created new events, folders, profiles, users and group in CMC.

Created User Objects including Dimensions, Details and Measures.

Created Dashboards for SAP Enterprise Asset Management (EAM) implementation specifically in the PM using various components of Xcelsius.

Developed several complex Xcelsius Dashboards with high visibility within Plant Maintenance processes(on Plant type, Notification type and Order type)

Developed Dashboards using (Query as Web Services) QAAWS on top of Universe Designer as well as developed Dashboards using the complex Excel Functions in Xcelsius 2008.

Performed Unit testing on the Dashboard by comparing with the Source tables, with the count of Valid and Invalid records.

Involved in creating new Templates for the Reports.

Dashboards identify the gaps and optimize the underlying Business processes to achieve more efficient results and will be the key for the assessment of the data for future recommendations.

Extensively used SAP HANA Studio for modeling purposes.

Created/Configured Attribute views, Analytic views, Calculation views, Analytic privileges, Ownership privileges, GRANT & REVOKE privileges, Global Authorizations, Decision Tables, Mapping tables, User defined Schemas, Packages and sub-packages in SAP HANA Studio.

Created complex reports by linking data from multiple data providers using merged dimensions. Also used functionalities such as combined queries.

Duration: Jan 2010- Jun 2011

Industry: Amgen (Healthcare), Thousand Oaks, CA

Project Description/Scope:

Amgen is a leading human therapeutics company in the biotechnology industry. For

more than 25 years, the company has tapped the power of scientific discovery and

innovation to advance the practice of medicine. Amgen pioneered the development

of novel products based on advances in recombinant DNA and molecular biology and

launched the biotechnology industry’s first blockbuster medicines. Today, as a Fortune

500 company serving millions of patients, Amgen continues to be an entrepreneurial,

science-driven enterprise dedicated to helping people fight serious illness.

Role: Data / Business Analyst


Tasks included multiple projects with deadlines, team cooperation to meet these deadlines, and being held accountable for code style, documentation, and project efficiency.

Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.

Utilized RUP to configure and develop process, standards, and procedures.

Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Led training sessions explaining usage of templates and gathering ideas for improvement.

Created and optimized executive summary, operating information, gross margin, and framework (Xcelsius) dashboards, including hierarchical selectors, flash variables (linking to dashboards.

Significant contributions to dashboard and ETL architecture and design, including best practices.

Built reports connected to BI services pointed at Web Intelligence blocks. Reports launched by and received prompts from Xcelsius dashboard.

Successfully migrated data from legacy to SAP system.

Experience in Usage and Development of AIO (All In One)/BPDM 3.0 and AIO 3.2 and 4.0 Methodologies.

Experience with the Central Management Console (CMC) to handle the Administrator Issues.

Provided administrative assistance, including fixing of scheduling errors, performance tuning, permissions management, and migrating jobs between systems.

Creation of new repositories and configuration of existing ones.

Acted as go-to for the team for technical concerns and idea development.

Created the data flows, workflows, transformations and SAP target data formats.

Analyzed source data and created data profiling reports.

Education & Certifications:

SAP Certified Application Associate - SAP HANA

SQL Certification - Querying Microsoft SQL Server 2012

Best Employee of Year (2010) – Mphasis HP Certified Administrator -SP14

Bachelor’s in information technology- Jawaharlal Nehru Technological University, India

Contact this candidate