Data Architect at Clearlink

About us

  Clearlink, a SYKES company, partners with the world’s leading brands to extend their reach, drive valuable transactions and deepen consumer insight. Clearlink has delivered millions of customers to its brand partners, including AT&T, CenturyLink, Travelers, Safeco and DISH, among others, through customized marketing, sales and technology services. Headquartered in Salt Lake City and established in 2003, Clearlink employs more than 1,500 sales, marketing and technology professionals in Utah and in Scottsdale, Arizona. The teams at Clearlink are some of the best and brightest in the industry and are consistently honored for culture, performance, and financial growth. 

Clearlink has been recognized nationally and locally for strong leadership, business growth, innovative employee initiatives, and corporate social responsibility. For the ninth consecutive year, Clearlink ranked highly in Utah Business Magazine's "Fast50,"​ eight consecutive years on MountainWest Capital Network’s "Utah 100"​ and the Inc500/5000 list. For two years running, the Salt Lake Tribune and Deseret News named Clearlink one of the "Top Workplaces in Utah."​ And finally Clearlink’s 360 Fit Health and Wellness program was awarded the Worksite Wellness "Diamond Award"​ and "Innovation Award.”

As a company fueled by its people, Clearlink is always looking for passionate and creative professionals who excel at disrupting the status quo. To learn more or to apply for open positions visit clearlink.com.


      CLEARLINK
  

- Implemented SSIS Business Intelligence Life cycle i.e. design, development,configuration, deployment and scheduling packages in Development, Test and Production environments.- Created dimension and fact tables based on business requirements to create SSAS OLAP cubes.- Created multiple reports, scorecards and visualizations using Tableau.- Experience in developing parameterized charts, graphs, dashboards and Reports on SSAS Cubes and using SSRS to develop drill-down ,drill-through And cascading reports.- Created complex stored procedures to populate data marts for reporting purposes.- Experience in writing T-SQL, working with SQL Server Data Tools for data cleansing, datascrubbing and data migration.- Formulated and documented the physical ETL process design based on business requirements andsystem specifications including source to target mappings,transformations, lookups, aggregations and expressions.- Created packages in SSIS with error handling as well as created complex SSIS packages usingvarious data transformations like conditional split, Cache, for each loop, multi cast, Derived column,Data conversions, Merge, OLEDB Command, script task components.- Hands on experience in writing SSIS script/script component task using C#,VB script forcustomized data manipulation of complex SSIS packages.- Used Processing options like Process update, Process full, Process data in while creating SSISpackage using Analysis services execute task.- Created slowly changing dimensions ( SCD ).
    
        …
      
        see more
      
    




      University of Utah School of Medicine
  

Varian Medical SystemsVarian Medical Systems (VAR) of Palo Alto, California, USA, is a leading radiation oncology treatments and software maker. They produce linear accelerators and software for treating cancer and other medical conditions with radiotherapy, proton therapy and brachytherapy. The company also supplies tubes and digital detectors for X-ray imaging in medical diagnostics, dentistry, security, industrial inspection and cargo screening.Roles and Responsibilities:- Supported/augmented the executive team with implementing the Sales and Operations Planning (S&OP) process by building forecasting models using R and forecast accuracy measurement dashboards.-  Designed, developed and supported various QlikView and Tableau dashboards for various departments within the company.- Designed and implemented data warehouse architecture for corporate circulation datawarehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions.- Built dashboards for measures with forecast, trend line and reference lines.- Integrated data from various sources such as SAP, Salesforce, Service Now, SQL Server 2014, MS Excel with QlikView, and designed and developed data models and data stages for storing and presenting data.-  Experience in extraction, transformation and loading (ETL) of data flows using SSIS withcomplex integration of SQL Server tables, flat files, excel files and comma separated files (.CSV)- Expertise in creating Indexes( clustered, Non-clustered Views, indexed views, complex storedprocedures, User defined functions, Common Table Expressions (CTE’s) and appropriate triggers tofacilitate efficient data manipulation to maintain data consistency.- Involved in QlikView server migration and configuration for the new company which spun off in January of 2017.- Worked on setting up fresh connections to the available data sources for the new company’s Qlikview QA server.
    
        …
      
        see more
      
    



Varian Medical Systems’ vision is a world without fear of cancer. To meet this challenge, we equip the world with new tools for fighting cancer.

For more than 70 years, we have developed, built and delivered innovative cancer care technologies and solutions for our clinical partners around the globe to help them treat millions of patients each year. With an Intelligent Cancer Care approach, we are harnessing advanced technologies like artificial intelligence, machine learning and data analytics to enhance cancer treatment and expand access to care. Our 10,000 employees across 70 locations keep the patient and our clinical partners at the center of our thinking as we power new victories in cancer care. Because, for cancer patients everywhere, their fight is our fight. For more information, visit http://www.varian.com

Varian reserves the right to remove any comment for any reason and ban any user from its page at its sole discretion. Varian does not endorse user comments on its page and cannot confirm their accuracy. User comments do not necessarily represent the ideas, thoughts, beliefs, opinions or views of Varian, or any of its affiliates.


      Varian Medical Systems
  

Mphasis is an IT services company based in Bangalore, India that provides infrastructure technology and applications outsourcing services, as well as architecture guidance, application development and integration, and application management services.Roles and Responsibilities:- Led and managed a team of 4 Software Engineers.- Designed, developed and deployed multiple performance dashboards using Tableau for monitoring and measuring different KPIs.- Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.- Created and maintained medium to complex level ETL packages using SQL Server Integration Services (SSIS).- Experience developing SSAS Cubes, Aggregations, KPIs, Measures, Partitions, Data Mining Models, and deploying and Processing SSAS objects.- Experience in creating, populating and maintaining data marts for reporting purposes.- Experienced in Installation, Configurations, Deployments, Tuning, and Troubleshooting of IBM WebSphere Application Servers.- Developed UNIX SHELL SCRIPTS to automate file deployments and server reboots.- Supervised website related changes all the way from configuration and design through to release. - Configured Websphere resources such as JDBC Provider, Data Sources and Connection Pooling in order to connect to Oracle databases.- Used IBM support assistant tools to analyze logs for memory leaks and created PMRs to work with IBM for unresolved issues- Performed WAS and Web server (IBM HTTP) patching (fix pack).- Configured Queues, Queue Connection Factories, Queue destinations and message listener services.
    
        …
      
        see more
      
    



About us

  Mphasis enables customers to reimagine their digital future by applying a unique formula of integrated cloud and cognitive technology. Mphasis X2C2 TM formula for success, (shift anything to cloud and power everything with cognitive), drives five dimensions of business value with an integrated consumer-centric Front to Back Digital Transformation, enabling Business Operations and Technology Transformation. Mphasis applies advancements in cognitive and cloud to traditional application and infrastructure services to bring much needed efficiency and cost effectiveness. Mphasis’ core reference architectures and tools, combined with domain expertise and hyper specialization are the foundation for building strong relationships with marquee customers.

Mphasis

About the Client:General Motors, General Motors Corp. (NYSE: GM) the world's largest vehicle manufacturer employs 340,000 people globally in its core automotive business and subsidiaries.Founded in 1908, GM has been the global automotive sales leader since 1931. GM today has manufacturing operations in 32 countries and its vehicles are sold in more than 190 countries. In 2002 GM sold more than 8.6 million cars and trucks nearly 15 percent of the global vehicle market.ITSRC, an SRO application developed by and for GM is used by a wide range of GM employees to cater their IT needs. ITSM is a tool used to handle incidents from ITSRC. ITSRC previously known as IT Service Center helps facilitate users to raise a request and get those requests submitted and approved by GM approvers for various services and products. We strive to produce first class support and solutions to our GM clients all over the world.Roles and Responsibilities:- Handled incidents in IT Service Manager and provided support and solutions to clients using ITSRC.- Acted as definitive point of contact for On-Shore clients.- Performed small enhancements using SQL Server 2008 R2 based on client requirements.- Experience in Database Backup, Recovery and Disaster Recovery procedures.- Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.- Experience in implementing high availability process like log shipping, Mirroring, and Clustering.- Worked on data fixes based on business needs.- Tested applications during a firewall configuration or server interruptions.- Had great exposure and good relationship with Clients and Stakeholders.- Dealt with providing support to incidents with deadlines.- Met closure of incidents based on client satisfaction and within the SLA period.
    
        …
      
        see more
      
    



- Performed monitoring activities for multiple source system applications and handled and resolved production issues on time to ensure data quality and consistency.- Troubleshooting failures of Info packages and documenting the root causes.- Participated in the new transition project called ITSC, which involved adding new functionalities and merging of the RTP applications, so that all the business needs can be performed at one go.- Monitoring the loads and analyzing the reasons for frequent failures of Info packages and finding and documenting the root causes.- Performed Health checks and tested application availability during server Interruptions. - Monitored several jobs and stayed on top of any failures by rectifying any bad files or records.- Was part of EBM Data Maintenance Team where I worked on break fix/maintenance tickets with varying priorities and resolved within the SLA time line using Microsoft Sever Management Studio .- Dealt with goal completion and stringent SLAs.- Was also a part of sFTP Team where I,                 - Performed Enhancements for the existing jobs as per the requirement.                 - Identify the root cause of any critical job failures and document it.                 - If any critical job failed First priority will be moving the files to destination manually,   so  that the critical agreement and invoice files will be available to clients on time.- Created documents as per the project needs and presented the same to the team.- Acted as a primary contact for all Severity issues.- Involved in the new transition project called ITSC, which involved adding new functionalities and merging of the RTP applications, so that all the business needs can be performed at one go.- Understood Requirements and Specifications of the module.- Finding, logging and updating any issues to improve the quality of product.  - Creating Daily, Weekly Status Reports.
    
        …
      
        see more
      
    



- Trained in JAVA, MySql and a variety of other soft skills.- Gained experience in working with tools such as Eclipse, Netbeans and MySQL Workbench.


- Coursework: Data Mining, Data Warehousing, Advanced Data Mining, Business Intelligence and Data Analytics, Cloud Computing, Advanced Data Management- Capstone Project: Creation and Design of Open Source Tableau For Data Visualization and Analysis- Data Warehousing Project: Enterprise Data Warehouse Design and Implementation for a Professional Soccer Organization


At the David Eccles School of Business, we pride ourselves on providing our community on the University of Utah campus and beyond with all the tools needed to blaze any path into the business world they choose. Our students enjoy hands-on work experiences with both established companies and aspiring startups. Our top-tier faculty provides pioneering research as relevant in the classroom as it is in the boardroom. And our alumni engage with prospective and current students as guest speakers and hosts for networking events with professionals across a range of business-related fields.

Data Architect at CLEARLINK

CLEARLINK

Data Architect

University of Utah School of Medicine

Business Intelligence Developer / Data Warehouse Analyst

Varian Medical Systems

Business Intelligence Developer Intern

Mphasis

Senior Software Engineer/ Team Lead - RouteOne Middleware Operations

Mphasis

Software Engineer, General Motors – IT Service Request Operations

Mphasis

Associate Software Engineer, General Motors – Request To Pay (RTP)

Mphasis

Trainee Software Engineer

University of Utah - David Eccles School of Business

Information Systems

Master’s Degree

Jeppiaar Engineering College, Anna University Chennai, India

Information Technology

Bachelor’s Degree