SUMMARY:

• 13 years of diverse IT Experience with all phases of software development life cycle (SDLC), involved in designing, developing, integrating and implementing, software applications based on SQL, ASP.Net and building multi - tiered architectures.
• Hands on experience in creating in SSIS packages.
• Intermediate level experience in developing Tableau Dashboards.
• Basic understanding with Hive.
• Ability to code and implement complex business rules in SQL Stored Procedures.
• Experience in Performance tuning of Queries and Indexing, and partitioning the tables to improve performance.
• Performed Database deployments, Backup and restores.
• Timely managed the scheduling of jobs.
• Handled patch management.
• Effectively managed onsite and offshore teams on global projects to meet project timelines and SLAs.
• Strong Leadership skills with expertise in mentoring developers and providing solutions to technical groups on ETL best practices.
• Handled team from project start up until project closure with adherence to client standards.
• Worked in projects that have huge out stream and in streams connections.
• Good in anticipating the implications and consequences of situations and take appropriate action to be prepared for possible contingencies.
• Posses’ good working experience and business knowledge in Sales, Supply Chain, Manufacturing and Health Domains.
• Adopted and implemented agile and delivered successfully.
• Well versed in applying design patterns as part of coding standards.
• Performed code reviews.
• Ability to lead and motivate team members and encourage teamwork.
• Good communication skills coupled with strong team playing and facilitation skills
• Excellent Verbal and Written Communication Skills and Strong in Documentation.

TECHNICAL SKILLS:

Reporting Tools: Reporting Service (SSRS), Crystal Reports,Tableau.

BI Tools: SQL Server Integration Services (SSIS), SSRS

Programming Languages: VB.Net, C#.Net, ASP.Net.

Defect Tracking tools: JIRA, TFS, Service now

Databases: SQL Server 2005, 2010, 2012, 2014.

Scripting Languages: JavaScript, VB Script HTML, JQUERY and XML

Version Controller: TFS, VSS, PVCS, Star team.

Process Methodologies: Agile, Waterfall, Iterative.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Role and Responsibilities

• Work on the Work Requests raised by the team by creating tables, views and stored procedures.
• Created SSIS packages, to generate reports in CSV, Excel format by reading data from SQL server.
• Created automation framework including file monitoring locations specified by users and uploading the data from the files placed by users to database.
• Developed stored procedures to break huge data into small datasets and generate excel files.
• Created simple dashboards using Tableau for data representations for monthly and weekly reports.
• Created SSRS reports for applications to generate reports based on user requirement.
• Normalized the database by implementing the appropriate norm
• Worked on database health monitoring tool and automated job scheduler.
• Work on the tuning the objects to optimize the performance.
• Identify and work on the automation tasks that eliminated the manual intervention of performing data refresh and data validations.
• Used the tools JIRA as Issue tracking tool and for code checking.
• Generate the deployment scripts for deployment in different environments using Visual studio 2013.
• Deployments in UAT and Production.
• Schedule jobs in different environments.

Confidential

Sr Consultant

Role and Responsibilities

• Creating stored procedures, views, T- SQL queries.
• Designing the database to accommodate the new design and make changes to the current table design to meet the business criteria.
• Worked on improving the performance of the over all database by writing good T-SQL code.
• Loading the data from multiple sources like csv, Excel, Txt files into SQL Server through SSIS.
• Generated reports in SSRS.
• Assisting Business Analysis team to do Data analysis.
• Collected the slow running queries and improved the performance of the queries.
• Maintaining Development and Test Databases.
• Involved in Database deployment includes Backup and restores.
• Assigning and tracking the production incidents.
• Responsible for providing the instructions for the Build and DB deployment team.
• Sync up with the QA team high level testing and fixing the build breaks up.
• Addressing the concerns raised by the deployment team during build activity.
• As part of handling production incidents identify the user stories and proceed for bringing it to closure.
• Involved in designing the new tables and performed normalization.
• Monitor and maintain the Development Database.
• Played role of leading database development activities
• Created SSIS packages for data migration activity.
• Perform Code reviews for MVC and database articrafts.
• Coordinate with onsite coordinator on getting clarifications for PBI allocated for team.
• Responsible for database delivery activities.
• Tracking and providing metrics for PBI’s and Bugs.
• Played the role of an individual contributor and lead.
• Work with business and QA to fix the scope of the defects.
• Analyze, debug and fix the defects.
• Code reviews and responsible for deployment activities.
• Used TFS to maintain the version control history during development.
• Played major role in Acord development.
• Involved in data fixes project for accord related defects.

Confidential

Sr Consultant

Role and Responsibilities

• Work with Architects, Dev Managers and Business Analysts to clearly define and understand business requirements, development estimation and work plans for multiple internal enterprise projects.
• Design and developed SSIS packages.
• Work with Lead architects to conceptualize and prototype the appropriate solution, present to the development team and document the design of the business component and database objects required to implement the solution.
• Mentoring the team through various phases of the project to build capabilities.
• Reviewing the tasks of resources in the team.
• Recommend technological solutions/options when required on projects and teams to achieve business objectives.
• Coordinate with other SME and cross functional team members, both onshore and offshore for solutions and development tasks on projects.
• Secondary responsibilities as a Lead consultant include people management.

Confidential

SQL/ETL Developer

Role and Responsibilities

• Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008,Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created complex Stored Procedures, Views, and Triggers according to the business needs and Also done optimization to some objects so that they run efficiently.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Implemented Disaster Recovery Plan by maintaining Backups and performing the Restoring of the system and user databases.
• Experienced in writing complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non clustered indexes.