Sulamitha Shalvy Cheruvathur

+1-704-***-****

adwbgi@r.postjobfree.com

**** ****** ***** **, *** 13-302,

Charlotte, NC-28210

Visa Type: H4 EAD

EXPERIENCE SUMMARY

9+ years of professional experience in software systems analysis, design, and development

Hands-on expertise in MS SQL Server, T-SQL, and MSBI (SSIS/ SSRS), Tableau, Power BI, Data – Migration, Analysis and Validation, Data Warehousing, ETL, Banking and Telecom Domain experience.

Have valid H4 EAD.

3+ years of Extensive experience in building Tableau dashboards and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level-of-Detail (LOD) expressions in Tableau

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis

Design and develop various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

Designed and developed entire ETL and Reporting (Power BI)part for one of the Major US Bank- Counterparty Credit Risk project.

Good exposure to each of the phases of Software Development Life Cycle (SDLC), developing projects from stage of concept to full implementation

Around 6 months of onsite experience working at client location, Manchester, UK for TalkTalk Technologies, wherein involved in transition activities and single point of contact for offshore to resolve any project related issues

Knowledge of Powershell scripting

Basic knowledge of MS Azure.

A keen Analyst and Team Player with thorough understanding of all aspects of the SDLC from understanding client requirements through direct client interaction, translating them into technical specifications and driving their execution

Energetic, proactive, enthusiastic, hardworking, and result oriented team player inclined towards achieving career goals and enterprise objectives

EDUCATIONAL QUALIFICATIONS

Bachelor of Technology(Electronics and Communication Engineering) CUIET,Duration:2004-2008

TECHNICAL SKILLS

Operating Systems

MS Windows XP/ 2007/ 2008

Tools

MS Office, SQL Server Management Studio 2008, SQL Server Business Intelligence Development Studio (BIDS), Clarify, SSDT, MS Office Suite 2007, MS Visio 2007, JIRA, Autosys,Power BI, Tableau

Software

MS SQL

Databases

MS SQL Server 2008 R2/ 2012/2017/2019

PROJECT EXPERIENCE

Evolent Health International Private Limited 3Oct’18 to Jan’20

1. Project: Aldera Oct’18 to Jan’20

Description: Evolent is a health care company purpose-built for creating clinical value, boldly leading the transformation to value-based care delivery.. This involves designing the system from scratch, designing datamodel, ETL, Frontend Portal,Reports and backend services.

Responsibilities:

Working in health care domain project.

Design and develop complex T-SQL stored procedure for supporting front end application.

Analyze data inserted by various applications and fix any data issues identified.

Prepare high level and low level design document for new development and enhancement.

Optimize the performance of T-SQL queries and stored procs.

Analyze and fix the defect in the existing code base and monitor it till closure in Jira.

Perform unit testing and prepare quality documents.

Prepare adhoc T-SQL scripts as per the business requirement.

Created partitioning on SQL server 2019.

Analyze the business requirement and liaise with clients in bridging any gap in requisite.

Develop tabular reports and dashboard using Tableau and integrate it with front end application.

Maintain confluence portal and keep updated with all changes in the existing functionality and new requirements.

Prepare ETL module in loading data to Data warehouse system using SSIS.

Created Bar charts, Trend Lines and tableau reports as per the business Requirements.

Gained strong stored procedure, view, and trigger experience including developing these objects as per client requirements

Extensively used Date Functions, LOD’s, parameters and Calculations in reports.

Deployed Tableau reports onto the server for different teams and set security level for different LOBs

Created Custom Hierarchies and groups to meet the Business requirements

Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Defined relationships, created actions, filters, parameters, calculated fields, sorting, groupings, live connections, in-memory.

Environment: SSIS, Tableau 2018.3, MS SQL 2016

Synechron Technologies Pvt. Ltd., Pune Sep’15 to Sep’18

1.Project:NxGenReporting

Mar’17 to Sep’18

Description: NxGen is a migration project in which counterparty credit risk system is developed in-house for a major US Financial Institution. This involves designing the system from scratch, designing datamodel, ETL, Frontend Portal and backend services. The new system will be a replacement for a third party tool. The system is used to calculate counter party credit risk for all the transactions performed involving various financial products.

Responsibilities:

Involved in the entire life cycle of the project - requirement gathering, estimation, development, deployment and defect fixing.

Converted business requirement to technical story for developing various Tableau reports.

Conducted grooming session with client and module leads to finalize and sign-off the requirements.

Developed regulatory and management reports using Tableau.

Created SSRS reports that included drill down, drill through, sub, and linked reports using MS SSRS 2008/ 2012

Created various quality dashboards as per the business requirement.

Worked closely with Data Model team in designing the data warehouse for reporting project.

Prepared detailed technical design document for all reports created, capturing the required transformation on transactional data before loading to data warehouse as well all aspects of report.

Developed T-SQL stored procedures for data source in the Tableau reports.

Ensured all reports are rendered with in SLA by enhancing the performance of Tableau reports and fine tuning underling queries.

Gather and document scope definition, requirements, deliverables, acceptance criteria, roles and responsibilities, assumptions, constraints and dependencies.

Developed data driven subscription for automated report delivery.

Worked on the deployment of reports to MS Azure Cloud.

Assisted portal team in hosting the report in the front end application.

Designed and developed PowerShell scripts for automating configurations and deployment.

Designed and developed data loading module for reporting database using SSIS.

Performed defect fixes in the existing code and monitored till closure using Jira.

Performed unit testing as a part of development and defect fixing as well prepared unit test cases and test logs.

Reviewed deliverables of all offshore team members and provided suggestion/comments in technical and functional front.

Acted as first point of contact for all queries from client and business users as well prepared T-SQL scripts for analyzing underlying data.

Designed and developed outbound feeds to deliver data to downstream systems using SSIS and T-SQL.

Responsible for creating, updating and managing all project related documents including – technical design documents, ER Diagrams, ETL mapping sheets, sample reports, functional design document, project standards document and know error document.

Environment: SSIS, Tableau 2018.3, MS SQL 2014

2. Project: Asurion Europe

Mar’16 to Mar’17

Description: Asurion provides insurance and support to Mobile phones. Its major clients include Virgin Mobile, 3UK, Tesco, and BT

Responsibilities:

Developed code within the sprint followed by unit testing. Produced good quality code with no bugs

Created SSIS package as per requirement for automation purpose

Worked on T-SQL programming (SQL Server 2012) and SSDT

Created complex dashboards and reports using Power BI

Created automation scripts

Performed analysis of business requirements and created Spike documents for the same

Presented TAG documents to business

Completed the analysis of more than 15 user stories independently

Supported Production release more than 5 times and completed development of more than 15 user stories from Development, QA artifact creation and QA support, Production artifact creation and final RFC approval

Proactively analyzed and did troubleshooting of issues

Environment: MS SQL Server 2012, T-SQL, Power BI

3. Project: Quovant

Sep’15 to Mar’16

Description: Quovant is a legal spend and matter management technology and services provider. They offer intuitive/ configurable solutions that provide focus, transparency, and flexibility to corporate legal departments, risk managers, and third party administrators.

Responsibilities:

Fixed errors in production database using SQL scripts and ad hoc queries, and generated reports as per client requests

Created and amended SSRS reports as per business requirement

Worked on T-SQL programming (SQL Server 2012) and SSDT

Created automation scripts

Performed data analysis

Environment: MS SQL Server 2012, T-SQL

Cognizant Technology Solutions Sep’14 to Sep’15

1. Project: Octon US5G

Sep’14 to Sep’15

Description: Generated SSRS report as well developing SSIS packages and worked on the development of maintenance screens creating SPs, which are consumed by front-end.

Responsibilities:

T-SQL Programming–

Worked on T-SQL programming (SQL Server 2008 R2)

Worked on the development of maintenance screens/ backend database

Developed stored procedures for each maintenance screens depending on client requirement

Prepared HLD as well LLD documents as per client’s business requirements

Prepared database design diagram for TDF database using Visio

Interacted with team members for mutual benefits in the project, and interacted with the customers/ clients on their projects for providing technical advises/ feedbacks

SSIS–

Developed SSIS package for loading files to staging database

Worked on ETL staging database data to TDF database

SSRS–

Created drill down, drill through, sub, and linked reports using MS SSRS 2008/ 2012

Environment: Visual Studio 2010, MS SQL Server 2012

Tech Mahindra Ltd. Nov’10 to Sep’14

1. Project: Tiscali - OSS Database Rationalization

Nov’11 to Sep’14

Description: Fixed migration errors as well created SSIS package for replication of database.

Responsibilities:

T-SQL Programming–

Fixed errors in migration of SQL Server Management Studio 2008 R2/ 2012

Worked on T-SQL programming (SQL Server 2008 R2/2012)

Gained strong stored procedure, view, and trigger experience including developing these objects as per client requirements

Developed scripts for fixing errors, amending scripts, and analyzing the error with the help of queries

Primarily responsible for client's requirement analysis/ design, which includes logical, coding, testing, peer code review, and effort estimations

Interacted with the team members for the mutual benefits in the project, while interacting with the customers/ clients on their projects for providing technical advises and feedbacks

Replication Database (SSIS)–

Developed SSIS packages to replicate data from Tier 1 to Tier 2 database

Worked on data that has been replicated for the purpose of backup and performing reporting/ analytical activities on Tier 2 so that there will not be any performance issues on production environment

Developed portal as a front-end, which picks data from Tier 2 database and provides updates for order tracking, number management or for other purposes; it mostly helps team to perform BAU activities

Involved in ETL development using SSIS

Data Fixing–

Tacked the intricate database structure within short span of time

Involved in data fixing within very short span of time thus facilitating smooth migration

Fixed the errors, which came up on data migration from one database to another

Analyzed/ understood error scenarios, and created scrips to fix them in bulk in minimal time span

Wrote queries for error fixing involving the complex database structure for various products

Raised permits for executing SQL scripts for data fixing

Prepared presentations to colleagues and customers on the migration plan

Developed the scripts for data fixing as well developing rollback scripts in case of any failure

Received customer appreciation within a very short span for the speedy and efficient work performed

SSRS–

Excellent knowledge in SSIS as well SSRS

Engaged in report development using SSRS for the various products involved and their sales

Used SSRS creating tabular, interactive, and parameterized reports for the various products involved via SQL Server Business Intelligence Development Studio (SSBIDS)

Created drill down, drill through, sub, and linked reports using MS SSRS 2008/ 2012 as well as managed the subscription of the reports

Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly

Data Analysis–

Engaged in data analysis using SQL queries

Performed third party analysis or root cause or if there were any issued in the system, and proactively performed analysis and suggested actions

Provided cost benefit from particular activity to third party; if they agreed proceeded accordingly

Defined cost saving for different products such as MPF, SMPF, IPS, OBC, WLR, and IDA/CPS

Discussed directly with the client on the requirement gathering and future enhancements

Created cubes/ scripts for ease of use in analysis and different types of reports for presentation purpose to the end users and as per their requirement

Gathered and evaluated information to reach sound decisions, and provided complete/ accurate solutions, presentations or reports

Understood current and future business requirements

Performed data analysis that helps in obtaining system and domain knowledge

Environment: Visual Studio 2008, MS SQL Server 2008 R2

2. Project: CRM Business Pro Services

Nov’10 to Nov ‘11

Description: Profile and user setups for various BT and BTLB applications namely Oneview, Apollo, Adder, SCARS, Converged Viewer, OBI, Mobius, and Siebel Analytics

Responsibilities:

Analyzed massive and highly complex data sets, and performed ad-hoc analysis and data manipulation

Gained sound knowledge of BT systems involved

Gained knowledge of front-end as well as backend of systems for BTLB and IPS

Performed Data Extraction, Transformation, and Loading (ETL) between systems using SQL tools such as SSIS

Worked closely with E2E Designer in gathering functional requirements for the application (GoUser)

Assisted in the production of detailed system requirements and functional and non-functional

Specified business requirements while developing applications such as Ecensus/ FixMe as well Agent Desktop

Tested new applications such as GoUser and IPS portals

Functioned as contact point and as interface between business users and the development team

Displayed strong customer focus with excellent communication skills

Involved in profile and user setups for various BT and BTLB applications namely Oneview, Apollo, Adder, SCARS, Converged Viewer, OBI, Mobius, and Siebel Analytics

Mainly engaged in providing support and solutions to the issues/queries of British Telecom Local Business (BTLBs) from system access perspective to support over 1000 odd users

Updated and handled databases for the BT and BTLB employees

Handled calls from end users and clients, which were related to BT and BTLB specific applications mainly CRM applications

Worked closely with clients and part of conference calls for issues, SR, analysis, post implementation issues, and handling escalations

Prioritized the work concerns related to user profiles and all applications

Analyzed, understood, raised faults, and service requests via Bridge (Clarify) on client and end user request

Analyzed and understood customer issues, and resolved them in minimal time taking SLA into consideration

Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly

Created tabular customer data reports using SSRS

Provided solution for the issues by interacting with the different dealer groups and clients

Prepared weekly report of users and BORG report for client and different application groups

Handled whole BTLB users issues, concerns, and changes along with IPS users issues

Received customer appreciation within a very short span for the speedy and efficient work performed

Environment: MS Visual Studio 2008, MS SQL Server 2008 R2

Contact this candidate