Krishna K

Experience

• 

  Enterprise Solution Inc

  Jan 2007 - Jan 2008

  Test Analyst

  1.Responsible for project participation with the Testing function2.Efficiently designed Functional Test Cases using Black Box testing techniques3.Reviewed, updated and executed TOM/Test cases4.Performed White Box tests on Java web services using JMeter and Oxygen XML Editor5.Involved in Functional, System and Database testing using SQL query to check data integrity6.Validated Defects and Enhancement7.Interacted with client to gather requirement and progress updation.

• 

  UBS

  Dec 2009 - Dec 2010

  Analyst

  Efficiently managing ITGs related to some projects Instrumental in performing manual testing using Informatica (black-box)Make sure content and structure of all testing documents/artifacts is documented and maintainedPreparing and carrying out VBA coding for the test cases created in the Test PacksEffectively apply TOAD to access back end Data Base (FDD) for test results comparisonInvolve in developing CORE automation tool using VBA for generating expected resultsExecuting ad-hoc and Regression testing of system components under aggressive release scheduleEvaluating and analyzing Expected with Actual results in DBUtilizing JIRA and Quality Centre to report bugs and follow upActive participation in Client project related Discussions and defect Triage callsHandle UNIX to migrate the Input files to GGL stage Data baseResponsible for testing code, developed using Informatica and also to execute the runsSupervising versions of files & modification being made using SVNPreparing and maintaining FMEA document for the processImpart training to new Resources for the projectAllocating tasks to team members and ensure that their utilization levels are as per project expectationsCordinating and managing meetings including agenda preparations, status reporting, capturing meeting minutes etc. Arranging weekly/monthly productivity reports and Test summary reportsAttending meetings and walkthroughs with the management team to ensure steady progress Show less

• 

  Cognizant

  Mar 2010 - Apr 2014

  A detailed Analysis of Requirements and preparation of scenarios: Updating Project Tracker with the conflict that have been identified in the analysis. Coming up with queries at initial stage and updating the query tracker with resolutions after discussing with SA and Business which will be provided for team to refer while execution.Preparing Test cases as per scenarios identified.Mapping each Test case to Requirement and preparing Requirement Traceability Matrix.Providing overview of the project to Team Lead to confirm my understanding.Providing Overview to other team members to help them in better understanding the flow before execution.Providing everyday updates to Tech lead and Business at every stage of the project.Test execution confining to time deadlines. Helping peers as I have handled majority of Requirement Analysis and Test case designing.Logging defects, 99% of the defects logged are fixed without any rejections.Attends Defect Tracking and project meeting and provided updates on project execution status. Discuss Defect details with Development team for more details and tracks till the closer.Maintains Test data and Artifacts for future reference in common folder.Provided transition to new team members. Show less

  • Associate

    Mar 2012 - Apr 2014

  • Senior Process Executive

    Mar 2010 - Mar 2012
• 

  Cigniti Technologies

  Apr 2014 - Jun 2022

  Project Lead

  Successfully managed and directed a team of 10 resources, ensuring the smooth execution of various projects.Implemented Snowpipe for continuous data loading, optimizing data flow and enhancing project efficiency.Spearheaded the adoption of zero-copy cloning, facilitating the cloning of databases for streamlined development and QA environments.Utilized AWS S3 integration for data loading and external tables, enhancing data accessibility and management.Played a pivotal role in resolving data issues during ETL processes, employing COPY for efficient bulk data loading.Established and maintained resource monitors on warehouses, contributing to optimized data processing and resource allocation.Demonstrated proficiency in creating internal and external stages, transforming data during the load process.Leveraged time travel functionality, going back up to 21 days to recover missed data and ensuring data integrity.Led handshake calls with onsite teams and business analysts at every project stage, fostering effective communication and alignment.Prepared comprehensive project metrics, offering valuable insights and overviews to team members.Expertly managed UAT validation by sharing sample data with customers, enhancing project transparency and client satisfaction.Implemented temporary and transient tables on various datasets, contributing to efficient data management and analysis. Show less

• 

  Affinitiv

  Sept 2022 - Jan 2023

  Data Engineer Manager

  Data Integration Strategy:Expert in classifying methods for integrating data from diverse client systems to create comprehensive reports from multiple sources.Analytical Documentation:Lead the analytical interpretation of highly specialized technical information, creating detailed documentation and reports.Reporting Strategy:Translate reporting requirements into a strategic scope and delivery plan for the subject area.Dashboard Development:Initiate the development of efficient and interactive dashboards using diverse data visualizations such as Bar charts, Cross tab, Tree Maps, Heat Map, Bubble Chart, Line charts, and custom charts.BI Environment Support:Provide production support for the existing BI environment, including ETL processes, data warehouse, Tableau, Business Objects, and other analytic tools.Process Implementation:Implement processes like Daily standup calls, Dashboard creation, MSR (Monthly Status Report), WSR (Weekly Status Report), and DSR (Daily Status Report).Training Delivery:Impart training to cross-functional teams, ensuring proficiency in data-related processes and tools.Data Set Assembly:Assemble large, complex data sets that align with non-functional and functional business requirements.Process Improvements:Identify, design, and implement internal process improvements, including infrastructure redesign for scalability, optimized data delivery, and automation of manual processes.Analytical Tools Development:Develop analytical tools leveraging the data pipeline to provide actionable insights into key business performance metrics, including operational efficiency and customer acquisition.Stakeholder Collaboration:Collaborate with stakeholders, including Executive, Product, Data, and Design teams, to support their data infrastructure needs and address data-related issues.Performance Monitoring:Monitor and analyze information and data systems, evaluating their performance to discover opportunities for enhancement. Show less

• 

  NextGen Healthcare

  Apr 2023 - Sept 2023

  Staff Engineer

  • Executed data transformations using DBT and Snowflake, utilizing tools such as Fivetran, to optimize data workflows and enhance efficiency.• Extracted raw data from the source (NGE) through Fivetran, conducting necessary cleanups and transformations before loading it into Snowflake.• Engineered data marts, creating both facts and dimensions, typically structured in STAR schema or tailored to specific reporting needs.• Played a pivotal role in designing data models, identifying dimensions and facts, referencing bus matrix documents.• Implemented improvement measures to change the structure from Point-feature Development & Verification Team to Scenario-based Testing Team covering real-world use cases.• Created & updated SOPs and formulating new processes for code review, code coverage and unit testing.• Managed & improved utilization margins; executed projects & programs in line with recognized best practices methodology and managed operations governance, quality assurance, conflict resolution & reporting.• Maintained active communication with business teams, gathering project insights and functional requirements. Show less