PROFESSIONAL SUMMARY

• Sr. Programmer Analyst having 12 Years+ of strong professional experience with proven leadership qualities. Highly adept to adapting work pace to evolving clients deadlines and experience in designing and implementing multitierhigh - performance application designs in Healthcare, Finance, Sales and Travel industries
• Strong in studying user requirements, analyzing, designing, coding, implementation, debugging, testing, deployment and implementation of strategic solutions across diverse industries
• Strong knowledge of automating systems under SDLCusing Agile & Waterfall methodologies
• Strong knowledge of documentations like Use-case and Process flow diagrams, Technical and Functional specification documents and Impact analysis documents
• Problem identification, proposing solutions & make process improvements saves business time & money
• Strong clients support skills and experience with client handling with onsite and off shore model
• Build and maintains applications versioning control using TFS and VSS tools
• Strong in Creating and Maintaining large SQL databases using normalization best practices in SQL Server
• Designing database objects like Tables, Synonyms, Views, Stored Procedures, UDF, Triggers and Indexes
• Knowledge & experience in SQL Replication, CDC, Log Shipping and database mirroring processes
• Knowledge of Server General Administration including Roles Assignments and security strategies
• Excellent knowledge in Performance Tuning and Process Optimizations using SQL profiler, index tuning wizard and SP debugging by following best practices and troubleshooting of data issues
• Creates jobs, setup SQL e-mail, design alerts and schedules database maintenance activities
• Automated backend processes through Jobs, Optimized batch processes and Perl and Scripting
• Maintain, Troubleshoot and Setup Backup & Restore processes and do space monitoring activities
• Troubleshooting daily issues, creating release plans and schedule releases for multiple servers.
• Experience in Data Migration process using BCP and other custom tools and processes
• Custom ETL design process and running BCP / ETL utilities on demand and SSIS packages
• Excellent ability to develop and implement data and Report solutions using tools like (SSRS, Crystal Reports, and Microsoft Excel and word etc)
• Generate AdHoc queries and high end Dashboard Reports on-demand for management using BI tools (SSRS and Crystal Reports)
• Added New features to existing data analysis reports and daily maintenance activity jobs
• Work with clients and design solutions to integrate third party data sharing with existing database
• Independently worked on designing teh Integration modules responsible for exchanging data between Applications like Northstar Complaint management and JDE (JD Edwards) Shipping systems
• Knowledge in designing applications and coding using Object Oriented Programming concepts in (ASP.Net, VB.Net, HTML, C#.Net)
• Quality Assurance (QA) experience with developing Test Plans and Test Scripts
• Experience in doing Unit testing, System and Functionality testing.
• Assisting teams to Perform Black Box testing, Performance testing, Front-End and Back-End Testing
• Facilitated UAT with teh stakeholders and business users along with UAT and SIT planning

TECHNICAL SKILLS

• Microsoft SQL Server (2014, 2012, 2008, 2005 and 2000)
• T-SQL, PL-SQL, Oracle 8i, 9i
• SQL Profiler, Query Analyzer, Export & Import (DTS), SSIS, BCP
• Visual Studio 2012/ 2008/2005,
• ASP.Net, C#.Net & VB.Net, VB 6.0, Java Script and VB Script, Ajax, HTML, XML
• SQL Server Reporting Services (SSRS), Crystal Reports 8.0 & 11.0
• Scheduler, JCL's and Application structure (Mainframe)
• Connect Direct (NDM), Web Logic, Queues, Channels, Perl Scripts
• Windows 2000, 2003 & 2008 R2, Windows XP

PROFESSIONAL EXPERIENCE

Sr. Programmer Analyst

Confidential, PA

Responsibilities

• Responsible for Requirement and database code Analysis for new Interface design
• Defined Scope and transformed existing process logics based on new application architecture
• Worked with Data Migration team for planning and mapping of data columns and transformation jobs and testing data migration activities
• Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
• Designed data transfer modules (using CDC and custom jobs and codes) dat uses single dynamic script for transferring data (performing Extract, Transform and Load) for creating feeds for downstream applications
• Dynamic scripts dat needs less /no maintenance and smart handle data exchange and sends email in case of failures or process breaks
• Created AdHoc Dashboard summary and SSRS Reports which includes tabular and Crosstab formats also contains custom filters, Interactive sorting features and parameterize inputs for presenting data
• Configured SQL e-mail system dat sends automatic emails incase of any error happens in SQL server level or Application (real time transactions) level
• Involved in Code Debugging & Performance Tuning of teh procedures using teh SQL recommendations
• Managing Code and Reports under Version Control system by using TFS
• Part of Solution Review team to analyze, review and optimize teh solutions provided by other team members of Application design
• Created Technical Specification, Impact analyses and deployment documents
• Handle enhancements and Production-support activities
• Provided solutions on process optimizations, Stored Procedure design & other database related concerns
• Designed teh database Integration modules responsible for exchanging data between Applications like Northstar Complaint management and JDE (JD Edwards) Shipping systems

Tools: Microsoft SQL Server 2012 & 2000, CDC, SQL Profiler, Query Analyzer Visual Studio 2012, SSRS (BI Tool)

Technical Analyst

Confidential

Responsibilities

• Setup new clients from base on VM Ware environment
• Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
• Design database maintenance tasks for executing DBCC commands to check physical and logical consistency of teh databases
• Create scripts to Rebuild indexes automatically on scheduled maintenance down times
• Designed SQL Server Replication architecture (Implemented Transactional Replication, Snapshot replications) dat can handles multiple banks simultaneously for pushing data over secured network using NDM’s and secured networks
• Created database Mirroring for clients
• Worked with DBA team for planning of Disaster recovery policies
• Created Scripts using Perl and SQL scripts to automate Releases over Client Implementations and for runtime Replication object Installations changes
• Created Maintenance Jobs for running and monitors database backups and space availability on servers. Send email alerts for issues reported for Replication Status, performance issues
• Configured SQL Mail Agent for sending automatic email incase of issues
• Created deployment documents to deploy in all test and production environments for various clients.
• Worked on Requirement Analysis and provided time bound solutions for process enhancements.
• Worked in Conducted workshops with SMEs and understood Client IT needs tan work with Client and Offshore Teams for coordinating Project Scope, and closing teh requirements for every releases
• Handle enhancements requests and Production-support activities and prioritizing them. Provide solutions by Debug teh problems reported and provide time bound solutions to clients requests

Sr. Software Developer

Confidential

Responsibilities

• Worked on Code Analyses, column mapping and Data Transformation processes for migrating master data
• Worked with Data migration team for migrating data from Oracle to SQL 2005 and SQL Server 2008 R2 and defining migration steps, providing source and destination table mappings and creating scripts for Bulk Data load
• Worked on Application development, designing UI using ASP.NET and C#.NET
• Understanding PL SQL code in Oracle (using Toad for Oracle) and convert logic as SP’s at SQL end
• Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
• Created Maintenance Jobs for Maintaining SQL Servers availability and monitors Backup Statuses and manage space availability on servers
• Designed complex T-SQL code for Customer Imports and other interfaces Configured SQL Mail Agent for sending automatic emails
• Enhanced teh business logic using SP’s and UDF’s to retrieve information on teh services like Billing, Customer, generating vouchers, Critical Business/Finance data for Reports (PL, BL etc)
• Designed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using Crystal Reports for Accounts, Tariff, Operations Management System and Finance modules
• Handle enhancements and Production-support for project by Debug teh problem and provide time bound solutions to client
• Analyzed and evaluated teh performance of teh application from various dimensions
• Check physical and logical consistency of teh databases and Rebuild indexes
• Conducted User Acceptance Test (UAT) for successful implementation by meeting all requirements
• Responsible for trouble shooting and provide support to development teams on issues and worked on database tuning and performance monitoring activities
• Worked on updating Integration packages for additional requirements in SSIS
• Managing Code and Reports under Software Configuration Management and Version Control by using VSS

Team Lead

Confidential

Responsibilities

• Worked on Application development and designing UI interface using ASP.NET and VB.NET.
• Created database objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and defining users and Roles in SQL Server
• Created Stored Procedures to retrieve information on teh services like Billing, Purchases, generating vouchers, Critical Business and Finance data for Reports and maintaining inventories
• Designed Reports using Crystal Reports and Microsoft tools like (Word, Excel and Power point)
• Designed custom interface jobs dat updates and synchronizes data on all multiple subscribed servers automatically based on options selected what needs to be synched
• Designed job dat acts as Real time Replication service to synch data under all departments and acknowledgements sends to Head of dept as soon as any projects or grants initiated
• Involved in Business flow Management activities such as Process design, Process Execution, Process Monitoring
• Designed MIS system for delivering teh documents online and sending teh approval via Mail system to teh concern departments. It TEMPhas been developed with built-in Intelligence to operate in a user-friendly environment.
• Responsible for Requirement Analysis and scoping teh requirements and provide time bound solutions for enhancements and issues and release processes.
• Supporting Team on troubleshooting issues and guiding development teams by providing required information and support they needed
• Analyzed performance issues in application and helped team by guiding and provide necessary support for fixing teh issues
• Conducted User Acceptance Test (UAT) for successful project implementation and making sure to close all requirements