We provide IT Staff Augmentation Services!

Lead Software Engineer Resume

SUMMARY:

  • Confidential is working as Lead Software Engineer for Confidential and Having 16 Years of Experience in Designing and developing database applications using Confidential technologies Azure SQL Server, SQL Server integration services, SQL server Reporting services, and also having testing various database application developed using Informatica and Confidential technologies.
  • Proven Strong debugging skills in developing and testing any complex ETL’s and reports.
  • Excellent knowledge on Data analysis, validation in Transact - SQL, Data Conversion, ETL, Data Warehouse and ETL jobs. Worked on Validating SSRS Reports and SSAS Cubes, for Confidential finance it applications.
  • Worked with Windows PowerShell to develop the Deployment tool to deploy the SSIS packages.
  • Worked Estimations of testing effort by analyzing the requirements of project. Worked on creating the test plans for various ETL projects.
  • Worked on identifying various dependencies and assessing various risks involved in ETL projects.Having Certified Scrum Master (CSM).
  • Having good experience in agile scrum process. Extensively worked on Insurance, Banking, Manufacturing and Storage domains.
  • Extensively worked on Load, Stress and Performance testing using VSTS and Analyzing the Performance parameters.
  • Worked on automating the Stored Procedure automation using VSTS Database Testing.Worked on Automating the Test cases using C# and XML

KNOWLEDGE:

Programming: C#, T-SQL

Databases: SQL Server 2005/2008/2012/2016 , Teradata

OLAP: Cognos, SSAS, Confidential Power BI

Process Tool: Confidential AzDO,JIRA, MTM, Quality Center(ALM),TFS, XStudio

ETL Tools: ADF, SSIS and Informatica

Reporting: Cognos Reporting, SQL Server Analysis Services, Reporting Services, Power BI, Pivot, Share point

Automation: VSTS Performance, NUnit, Database Automation using C#

Functional Expertise: Data Analysis, ETL Validation, Reports Validiation, Automation testing, Manual testing of desktop and windows and mobile applications

Industry Expertise: Banking, Insurance, Manufacturing, Storage Domain

Cloud: Azure and VMWare

PROFESSIONAL EXPERIENCE:

Confidential

Lead Software Engineer

Responsibilities:

  • Analyze and understand business requirement and report the requirement issues to BA and correcting requirements before development phase
  • Work closely with Product Owner in prioritizing list of requirements to create Product Backlog
  • Develop Source and Target mappings including data transformations
  • Design and implement Data model for upstream systems
  • Develop Azure data pipelines using Azure Data Lake and Azure Data Factory
  • Transform business validation rules and Load valid data into the destination systems using SSIS Package and C# Script
  • Create schemas, stored procedures, functions and common table expressions to perform database activities using Azure SQL
  • Develop ETL process which pulls data from flat files and loads to Cloud SQL Azure database
  • Analyze the Production Data and create data simulation in upstream and downstream systems
  • Follow Change Request Plan and create or update SSIS Packages
  • Identify the root cause of the issue and decided whether it’s an issue from developed requirement or a new requirement
  • Reusable queries are created for complex ETL transformations
  • Complete data comparison done between Database and Salesforce application using data loader
  • Understand the facility bank share, Roll-ups and balance related requirements
  • Simulate production data in upstream and downstream systems
  • Coordinate and prioritizing the issue logs and work towards closure
  • Followed Scaling Agile Spotify model with Tribes, Squads, Chapters and Guilds

Technologies: Confidential Azure Cloud, SQL Server Integration Services (SSIS), Azure SQL, PowerShell, MS Azure DevOps (TFS/VSTF)

Confidential, Richardson, TX

Lead Software Engineer

Responsibilities:

  • Analyze the business requirements and develop the mapping document based the business requirements as per target data system
  • Create the data model and build relation between tables.
  • Design and develop the ETL using Confidential Azure Data Factory pipelines and unit test the ETLS
  • Develop the ETLs using the business required transformation rules and move ghee code to higher environment
  • Created SQL queries based on mapping document and used them to validate the target data
  • Involved in various business requirement discussions and raised questions against poorly defined requirements, raised too many issues during the requirement gathering phase which reduced the project execution cost.
  • Effort Estimations based on the complexity of the requirements. Analysis of sprint tasks.
  • Participate in triage meeting to understand the defects.
  • Responsible for Fixing the defects and implementing the changes in requirements.

Technologies: Confidential Azures Server, Azure Data Lake, Azure BLOB, AzureDevOps tool to track the project Epics, Deliverables, Tasks, User Stories.

Confidential, Allen, TX

Sr Software Engineer

Responsibilities:

  • Validation of mapping rules from mapper tool which maps from MISMO to Confidential
  • Integration testing multiple tasks related to single document
  • Daily communication with BA lead to get the clarification on requirements
  • Bridge between Confidential vendor team and customer to resolve the requirement issues
  • Responsible for analyzing and raising the requirement issues to BA’s and correcting requirements before going to development
  • Static Requirement Analysis of sprint tasks
  • Worked on Automating the Functional test cases for Experience project using Coded UI with C#

Technologies: C# and XML, Coded UI

Confidential, Redmond, WA

Test Lead, BI Consolidation

Responsibilities:

  • Worked as scrum master
  • Preparing based Test Cases on Requirement Specification.
  • Preparing the Test Scripts as per Test Cases.
  • Preparation of the Master Test Plan.
  • Validated the records after successful completion of jobs.
  • Coordinating Defect Calls with the development team.
  • Understand the requirements for ETL process
  • Involved in Performing Regression Testing and System Integration Testing (End-End Testing).
  • Involved in Peer-Reviews on Test Cases prepared.
  • Data Comparison using SSDT Tools
  • Involved in maintaining standards (naming convention) and Quality.
  • Worked on Estimations for the testing the new feature/changes/bug fixes
  • Worked on analysis of customer facing issues and identify the root cause and suggest an approach to fix the issues
  • Follow the scrum process for project execution
  • Participated in Daily standup meetings to discuss the day to day work

Technologies/Tools: SQL Server 2012, MTM, VSTS, SSIS, SSAS

Confidential, NJ

Test Lead, Data Protection

Responsibilities:

  • Worked on Preparation of Test Plan
  • Worked on Functional testing of application for multiple releases and analysis of issues during sustenance phase
  • Worked on Estimations for the testing the new feature/changes/bug fixes
  • Prepared test cases and uploaded to XStudio test management tool
  • Setup the meetings to discuss the requirements of applications with client
  • Setting up the test environments for the applications and installation of the product onto multiple platforms like windows/Linux/HPUX/AIX and test execution on all platforms
  • Worked on analysis of customer facing issues and identify the root cause and suggest an approach to fix the issues
  • Follow the scrum process for project execution
  • Participated in Daily standup meetings to discuss the day to day work

Technologies/Tools: VMWare, JAVA, XQUAL Studio, JIRA

Confidential, AL

Test Lead, Data Protection

Responsibilities:

  • Preparation of the EDW Master Test strategy.
  • Designing Test Cases for Sprint tasks.
  • Review of test cases prepared by offshore team.
  • Preparing the Test Scripts as per Test Cases.
  • Performing the static Requirements Analyzer on story cards prepared by Business analysts and validating the requirements in terms of clarity, consistency and completeness
  • Smoke testing of ETL workflows and Reports after every build deployment
  • Running the ETL Workflows and Validated of data from source to target system after
  • Successful completion of jobs.
  • Preparation of test data required for ETL process.
  • Preparation of test required for various reports
  • Validation of reports data based on defined business rules
  • Involved in Performing Regression Testing and System Integration Testing (End-End Testing).
  • Worked on Estimations for the testing the new feature/changes/bug fixes
  • Worked on analysis of customer facing issues and identify the root cause and suggest an approach to fix the issues
  • Generating QA Dashboards for management. Reports pertaining to Bugs and test cases
  • Follow the scrum process for project execution.
  • Participated in Daily standup meetings to discuss the day to day work

Technologies/Tools: Informatica, Teradata, Cognos, ALM, Guidewire, SQL Server, UFT

Confidential, WA

Test Lead

Responsibilities:

  • Acquiring knowledge from client and Explain the team on requirements in detail
  • Preparation of UAT scenarios and Test data preparation for integration testing
  • Performance testing using VSTS. And publish the test results to the business for each scorecard.
  • Stored Procedure Automation using VSTS Database Testing
  • Participate in the technical and design meetings to understand design of application.
  • Effort Estimation and Test Strategy preparation
  • Setting up the dev/test environments for the applications
  • Review of test cases written by the team to ensure the test coverage as 100%.
  • Testing of aggregate values and calculated values for different sources.
  • Involved in testing appropriate security privileges on subject areas and dashboards according to business requirements
  • Setting up the triage meetings to discuss the bugs and Assigning Priority to the bugs.
  • Identify critical test path, execute and ensure quality of product, for all situations involving change of scope.
  • Preparation of traceability matrix to ensure the test coverage
  • Installation of builds when the dev drops comes to SIT
  • Identifying the root cause for the issues encountered during SIT/UAT
  • Cross team collaboration to work on end to end testing during system integration.
  • Responsible for delivery of all testing related artifacts and signing-off on the GO decision of project, from test team.
  • Supporting UAT team in doing data management and tying out the data
  • Validate Migrated from of existing system to new system.
  • Migration testing using C#,net and XML Parsing
  • Responsible Testing Reports and validating the reports against source database.
  • PerformedAPI testing using NUnit framework
  • Worked on Database testing thru API’s
  • Development of few screens
  • Worked on bug fixes for the issues
  • Describe responsibilities and s.
  • Describe responsibilities and s.
  • Describe responsibilities and s.

Technologies: SQL Server 2005, 2008,2012, C#, VSTS, SSIs, SSAS, SSRS, Coded UI, VSTS Perfomance Testing, VSTS Database Testing, NUnit Automation using C#

Hire Now