Birendra Kumar Yadav Email & Phone Number

Pune Area, India

Pune Area, India

As SSIS/SQL Developer works for Technology Business Management Office, By using BI tools provides cost transparency, annual budgeting, forecasting, and variance tracking processes for CIOs. As an input to BI tools Data modeling of financial feed are developed in SQL Database. Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data martsSSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL task, Pivot/Unpivot .Writing T-SQL to create complex functions, stored procedures, and triggers to facilitate business rules and to automate system events using scheduled tasks and SQL Server jobsFollows change management process to resolve application defects or to implement development enhancementsDevelopment, Unit Testing, SIT Testing, Integration and Regression, Production Release, Production Support, BAU Complete life cycle. Merging of code while doing the Parallel development Streams.Facility with development methodologies including Agile Methodology.

Pune Area, India

Working as a SQL developer for the project called Liquidity reporting, Liquidity management reporting is mandatory for the banks to ensure the regulatory bodies, like FSA(Financial Services Authority UK). Project solution is based upon MS SQL database to load, integration services to extract & transform and reporting services to represent the data.• T-SQL, Functions, Stored Procedure, SSIS and SSRS Development , test-driven development and unit testing• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, derived tables, common table expressions (CTEs).• Closely looking the performance issue and Suggesting the best approach to resolve the performance issue.• Closely working with testing and business team changing the business requirement keep on track all these changes and for improvement of Quality delivery by using the Quality Centre, it’s HP Product.• In current project we are migrating from waterfall model to agile methodology.Being part of scrum Team (Daily stand up call ,sprint planning ,retrospectives etc ).

Mumbai

Leading Cable Television (Direct to Home) player in India: Responsibilities include understanding the business requirements and building an Analytical Data Mart to assist daily insight generation, building of predictive models, daily campaigning on the data and everyday data refresh.• Created a platform to generating Daily, Weekly and monthly reports using SQL queries , SQL Server Reporting Services (SSRS), Excel and other proprietary platform.• Developed complex queries and T-SQL coding (stored procedures, functions, and views) to support data analysis, operational process, data migration /ETL (SSIS) and streamline various business functions.• Created a SQL schema to execute campaign on daily basis, Created automated system to track the response of daily campaigns.

Mca, Computer Science

Bca, Computer Application