Ritu Sharma
Data Analyst
Austin,TX
Summary
Experienced business professional with a strong background in data warehousing and business intelligence. Demonstrated success in data analysis and process improvement, resulting in streamlined operations and cost reduction. Skilled at identifying trends through data analysis and implementing strategies to enhance efficiency.
Overview
13
13
years of professional experience
2009
2009
years of post-secondary education
Work History
Team Lead
Accenture
2016.03 - 2021.02
- Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively.
- Identified and documented all data mappings and rules for data conversion for customer data
- Provided solution using ETL datastage tool to extract and generate files (EBCDIC, ASCII) to send to TSYS and other bank applications.
- Led cross-functional teams for successful project execution while maintaining strong collaboration among team members.
- Established clear performance metrics for the team which helped in tracking progress towards set targets effectively.
- Coordinated project activities and work assignments with offshore team.
- Created high level and low level design documents and presented to project review board to get approval
- Gathered and analyzed client requirements to support all changes required for customer data migration from mainframe legacy application to total systems (TSYS)
- Created datastage jobs and sequences to load files from upstream application into DB2 database and create files for downstream applications
- Designed and implemented error handling and data grief checking mechanism to check data quality and communicating users about the data issues.
- Loaded files in vertica using reusable osh script utility and apply reconciliation technique using control file
- Queried DB2 and Vertica database using sql to support user queries and testing
- Created detailed implementation task schedule for tracking all activities during production implementation period
- Created Runbooks for all production processes/jobs and get approval from production operations and support teams.
- Migrated code in production and provided post implementation warranty support.
- Created and Updated Project Status Report, Issue/Risk Tracker and Bug Tracker
- Delivered high-quality software solutions on time and within budget by effectively managing project resources and priorities.
- Developed scalable and maintainable software architecture, ensuring long-term sustainability and adaptability to evolving business needs.
- Achieved faster delivery times by automating repetitive tasks using custom scripts and tools developed inhouse.
- Evaluated the performance of team members regularly, providing constructive feedback for continuous growth and improvement.
- Implemented robust security measures, safeguarding sensitive data from potential breaches and ensuring compliance with industry regulations.
- Facilitated effective communication between stakeholders, translating business requirements into actionable tasks for the development team.
Software Product Development Lead
Accenture
2012.02 - 2016.02
- Established strong relationships with key stakeholders, fostering collaboration and effective communication throughout the organization.
- Perform performance monitoring and tuning of ETL processes during application testing and production operations.
- Develop, maintain and support ETL processes using DataStage.
- Streamlined product development processes by implementing agile methodologies and efficient team collaboration.
- Document benchmarks and procedures needed to optimize performance.
- Implemented rigorous testing protocols for quality assurance, resulting in fewer defects and higher customer satisfaction rates.
- Establish and implement best practices to ensure data quality and ETL performance.
- Optimized product lifecycle management, resulting in reduced time-to-market and increased profitability.
- Collaborate with DBAs, architects, and developers in the implementation of BI solution.
Senior Software Engineer
Accenture
2010.01 - 2012.02
- Analyzing data flows and functionality and provide solutions in data modelling for card database.
- Create High Level Design document and get approval from project review board.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
- Enhanced software functionality by identifying and resolving complex technical issues.
- Developed scalable applications using agile methodologies for timely project delivery.
- Provide technical solution for data movement from 250 Oracle tables to DB2 tables using reusable datstage osh script utility.
- Create mapping document for source to target tables and views.
- Create SQLs for pulling data from source tables using required conditions and filters. Create configuration files for each module providing necessary parameters which is used as input in the osh script.
- Create reusable shell script purge utility to purge data from tables in order to comply data retention guidelines.
- Create maestro jobs for scheduling and executing batch jobs as per execution flow.
- Fixing and analyzing defects during SIT testing.
- Provide solutions to business queries during user testing.
- Propose reusable solution for comparing data from source to target using ksh shell script.
- Create Implementation tasks tracker and get approval from project team.
- Deploy code in production during implementation and provide technical support in case of any issue.
Software Engineer
Accenture
2008.06 - 2010.01
- Analyzing reporting requirements to provide necessary data related to customer method of verification.
- Identify all source systems and provide solution to build interface in order to get required data.
- Create source to target data mappings with rules and transformations.
- Create and present high level and low level design document and get signoffs from project team.
- Build datastage jobs and sequences to pull data from source and create files in required format to send to downstream application.
- Implement reconciliation technique (ex records counts, hash total validation) for data verification and validation.
- Presenting and getting approval of project design from Client Project review Board.
- Delivery of change requests within proposed Timelines.
- Perform system integration testing and provide solution to user queries during user testing.
- Create maestro jobs for scheduling and executing batch jobs as per execution flow.
- Deploy Code in production and provide technical support in case of any issue.
Education
B.TECH - ECE
INDRAPRASTHA COLLEGE OF ENGINEERING
India2008-05
Skills
Software Product Management
Design Process Innovation
Extract Transform & Load (ETL) Tools
IBM WebSphere DataStage
Functional Test Planning
Configuration & Release Management
Application Architectures
Design & Build Enablement
Build Management
Data Warehouse Tools
Data Conversion & Migration
Oracle Database
IBM DB2
Shell Scripting
Training
- DW and BI Concepts
- Informatica - Beginner
- Informatica -Intermediate
- DW Concept-Intermediate Level,
- Teradata Basics
- Business Objects
- TERADATA
- PL/SQL
- INFORMATICA BI TOOLS
Timeline
Team Lead
Accenture
2016.03 - 2021.02
Software Product Development Lead
Accenture
2012.02 - 2016.02
Senior Software Engineer
Accenture
2010.01 - 2012.02
Software Engineer
Accenture
2008.06 - 2010.01
B.TECH - ECE
INDRAPRASTHA COLLEGE OF ENGINEERING