Sign in

Data Analyst

Coppell, Texas, United States
November 03, 2018

Contact this candidate


Lalitha Ranganathan


Professional Summary

Over 20 years of experience in various Information Technology areas involving Business Analysis, Data analysis, Data analytics, Architecting, designing, developing solutions around Data Warehousing and Business Intelligence applications.

Flair and innovation in problem-solving. Strong Data Analysis, Business Analysis, presentation and communication skills.

Extensively used SQL, Excel, PowerPoint, Word, Information Design Tool, Universe Design, Desktop Intelligence, Central Management console (CMC), Crystal xCelsius, Unix\Linux, Query as a web service, Amazon Wed Services (AWS), Snowflake Data Warehouse, Erwin,Tableau, Web Intelligence, Rich client, SAP Business Objects, Dashboards, Data Integrator (ETL), and Data Services Designer (ETL).

6 years in leadership role assessing new projects, design work and acting as SME for Enterprise Reporting and Business Intelligence agile team resources.

Primary point of contact for all technical challenges in Enterprise Reporting and Business Intelligence environment. Often sought out to recommend solutions for various implementations.

Exposure to various tools like Alteryx, Data Stage, Informatica, Designer Studio, Lumira, Power BI, MicroStrategy, SAS.

Used various databases like Oracle, Teradata, Vertica, SQL Server, Snowflake Data warehouse (AWS).

Good Domain knowledge in Telecom business, Banking and Mortgage business, Billing and Payment,hospital management etc

Proficient in software development methodologies and practices – Agile/Scrum, SDLC and Waterfall.

Experience writing technical stories in JIRA. Used industry standard notations.

Worked with all levels of management.

Detail oriented with strong time management and organizational skills.

Proven track record of taking ownership and delivering results within an Agile delivery model

Self-motivated, hardworking, possess strong analytical and problem solving skills and result oriented with the spirit of teamwork and effective communication and interpersonal skills.

Efficient work style with a strong sense of urgency.

Eager to learn, able to adapt quickly and very reliable.

Work Experience

Capital One - Plano, TX (May 2018 – Current)

Sr. Analyst:

Assisted in migrating data and metrics from legacy databases (Teradata, SQL Server etc) to Snowflake Data Warehouse in a flattened format on AWS S3 using agile development methodology in bi-weekly sprints and 8-week Program Increments (PI)

Performed end to end data migration that involved collection of rationalized data elements, development of flattened SQL scripts, source to target data mapping, metadata creation, lineage documentation, metrics optimization, data profiling, UAT and establishment of regression test scripts

Tuned SQL scripts to enhance performance of data processing

Collaborated with data risk management team to implement and document the business data Quality(BDQ) checks - Validity, Accuracy, Completeness, Consistency and Timeliness of the data being migrated

Extensive experience in collating, collaborating and deep history data validation/matching from different databases and data formats.

Expertise in working collaboratively across multiple cross functional teams

AT&T - Dallas, TX (Sep 2005 – Dec 2016) ; AT&T/Amdocs, TX (Dec 2016 – Feb 2018)

Sr. Data Analyst\Analytics:

Profiled and extracted data from data warehouse and cleansed for reporting with high quality.

Located high volume of data sets and prepared data or defined the specifications to prepare data from multiple sources (vertica, Teradata, Oracle etc)

Worked on MDM data interpretation in a large enterprise environment

Wrote scripts and queries for data extraction, transformation and loading to create new data source for reports.

Worked on multiple operating Systems, including macOS, Windows, iOS, etc.

Created dashboard for Marketing and Finance team and created reports which was delivered to IPhone Launch Command Center and to other executives every hour during the launch.

Ensure necessary metadata repositories are developed for all initiatives and ensure these meet current needs and provide flexibility for future growth.

Located data sets and prepared data or defined the specifications to prepare data from multiple sources: scripting, database management and queries.

Created tableau worksheets with hierarchies, groups, and datasets for each business data and exported to tableau server.

Developed various visualizations for the business data in Tableau.

Modeled new data models based on user requirements and updated existing data model.

Resolved issues independently while sharing best practices and knowledge with colleagues.

Sr. Business Analyst:

Participated in requirements gathering sessions with business unit and end-user; document end-user requirements for data capture, program functions, data quality, reports and analysis, and training.

Acted as functional expert on internal systems including intimately understanding the functionality in the system, how to translate business requirements into system changes, and the impact of changes to previously implemented releases.

Identified and documented system deficiencies and recommend solutions.

Worked with cross-functional teams to devise and drive out business approaches.

Managed multiple priorities and projects coupled with the flexibility to quickly adapt to ever changing business priorities and perform well under pressure.

Created process mapping and workflow creation.

Assisted in enforcement of project deadlines and schedules.

Assisted with User Acceptance Testing (UAT).

Drove support for current and new technologies to push application growth.

Sr. Architect\Developer:

Heavily worked in Full IT life cycle activities such as Requirements gathering, design, development and unit testing of Business Objects universes and reports.

Interacted with the business clients to gather reporting requirements.

Translated the business requirements in to design specifications and provided mockups where appropriate.

Created various universes and reports.

Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports to different environment within the organization.

Involved in design and development (ETL) of data warehouse environment


Provided time and cost estimate for all the ERBI Agile projects.

Provided input to upper management to make key decisions relating to product selections.

Responsible for researching any new options and functionality added to the product suite.

Continuously staying current with the new features.

Lead offshore teams and guiding them with data mappings requirements, user interface specifications, processing logic as per business requirements.

Assisting others in the team and being point of contact across the company for any technical issues.

Trained end users and created Quick Reference Guides on reports and various functionalities.

Provided the technical leadership, assisted, and mentored the team members.


Acted as first point of contact for all major technical issues.

Attended meetings with clients every Week to address any issues or concerns.

Resolved innumerous issues with a quick response time.

Team Collaboration:

Interacted with ETL Developers, DBA’s and Analysts in the environment to resolve multiple issues.

Maintained excellent working relationship with clients.

Adea Solutions - Analyst (July 2001 – Aug 2005) - Programmer Analyst (Aug 1999 – June 2001) High Tech Clinical Laboratories – Developer (May 1998 – May 1999) Indira Gandhi Center for Atomic Research - Analyst (Oct 1997 – Apr 1998)

Education, Training and Awards:

Consistently received Key Contributor Award from 2005

IT Unified Process Bronze Certification from AT&T

Agile Bronze Certification from AT&T

Cloud Bronze Certification from AT&T

Completed CLOUDU Cloud Certification from Rackspace.

Received IT Rewards Award, Work Smart Collaborator Award, Workforce 2020: Agile Program/Project Management - Agile PG/PM: Agile Development from AT&T

Attended Mobile App Development, Agile and Cloud Boot Camp and received Certification, AT&T

Regular attendee of ASUG and Teradata User group meetings, Texas

Completed Crystal reports and Micro Strategy training, Texas

Digital imaging and painting Certification (Adobe Photoshop 7.0), North Lake Community college, Texas

Web Animation Certification (macromedia flash MX), North Lake Community College, Texas

Completed Certification courses in Data Tech for Java, C++, Power builder etc., India

MS, Computer Science, 1998.

Contact this candidate