SUMMARY

• Around 14 plus years of IT experience with expertise in Software Development Life cycle by using MS SQL Server 2005/2008/2012 suite of products like SSIS, SSAS, SSRS and SQL Server Data tools, Db2,Netezza, C# .Net, ASP.Net, ADO.Net, MVC,XML and Java web based application and Scheduler engine using Austosys jobs.
• 4 years project management experience
• 5 years change management and release management experience
• Working within the Change Management process to raise and approve changes
• Develop objectives, phasing and content of the release management strategy for Software programs
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
• Experience managing Big Data platform deployed in Azure Cloud
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On - cloud ETL processing
• Experience in Monitoring and Tuning SQL Server Performance
• Leads the creation of change communication plans and the setting of project-level communication messaging and drives the execution of change communication and stakeholder engagement activities.
• Leads the impact assessment/analysis of intended changes to a division or business unit's operating model and provides input into people, process, and organizational alignment plans as necessary
• Works with the Change Process owner for the overall implementation, performance and continuous improvement of the firmwide Change Management Process, interfacing with GTI and Line of Business process, operations, performance, and business individuals and analysts
• Works directly with the process owner and change operations managers to ensure the process complies with regulatory requirements, CSA’s, and privacy regulations

TECHNICAL SKILLS

• Databases: SQL Server 2005/2008/2010/2012/2016, Confidential 9i,DB2,Netezza
• Languages: C, C++, T - SQL, PL/SQL, ASP.NET, Visual Basic 6.0, VB.Net,Java
• Scripting Languages: HTML, VBScript
• Operating Systems: Windows Server 2010/03, Windows XP.
• Tools: Visual studio 2016/2012/2010/2008, Erwin 4.0/3.5, IIS, Informatica,Abinitio
• Reporting: SSRS (MS SQL Reporting Service), Crystal Reports XI,Tableau, Excel

PROFESSIONAL EXPERIENCE

Confidential, Tampa,FL

Project Manager/Sr Application Expert

Responsibilities:

• Responsible for End to End release management in creating change tickets,getting Jiras work completed with Data analyst for Anlaysis and making sure development completed for the release and successfully completed in prod for every month.
• Worked successfully to implement Fidelity client to collaborate with Confidential .
• Provided senior-level oversight to the delivery of strategic programs and complex, large-scale projects.
• Ownership of planning/management of enterprise-level programs and strategic initiatives.
• Responsible for the sizing, selection, placement, and direction for resources to accomplish IT initiatives.
• Worked on security strategies and policies are balanced with business goals and risk management and Provide day to day administration of various systems to ensure employee/ corporate systems are operating securely & effectively
• Participate in security incident planning and response activities
• Ability to research and maintain proficiency in software, tools, techniques, countermeasures, and trends in information security, network vulnerabilities and encryption
• Improved response time 50% by developing / consolidating customer complaint / review process
• Designed, built and rolled out web-based budget and forecast collection tool, managed data transition to DB2 database and presentation in end-user analytics and reporting tools

Confidential, Lakeland, FL

Project Application Expert

Responsibilities:

• Create key metrics and identify opportunities to make tactical improvements to the release management process.
• Responsible for driving the development & deployment stores with a team located globally.
• Organized sessions and built plans and ensure successful delivery working with Product Vendors, Third-party vendors, etc.
• Established and streamlined a rollout process which enabled the store's rollouts per day to increase from to peak.
• Responsible for developing and Framework scheduling and implementation for each of the project areas.
• Manage the weekly change control board and Quarterly change release process
• Actively direct and manage the project life cycle from project kickoff through development, deployment, User Acceptance Testing support and launch
• Responsible for controlling and monitoring performance across the project management team for all aspects of an assigned project

Confidential, Tampa, FL

Application Release Expert/ Database developer Lead

Responsibilities:

• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Interacts through project updates and reviews with all functions requirements and different levels of management ensuring effective ongoing communications across dev teams/QA team and stakeholders
• Responsible for the sizing, selection of team, and direction for resources to accomplish IT s.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data.
• Developed Talend jobs to populate the claims data to data warehouse - star schema.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
• Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
• Experienced in using debug mode of talend to debug a job to fix errors.
• Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited, etc.

Confidential

SQL/ETL Developer

Responsibilities:

• Developed on SSIS migration packages for loading orcs(checks data) and claims daily and monthly data into the database by using various transformations
• Involved in loading bulk data from CDW tables and files data into the ocrs bill line history fact tables by using store procedures
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more).
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Created Implicit, local and global Context variables in the job. Worked on Talend Administration Console (TAC) for scheduling jobs and adding users.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
• Created linkage process by linking the claims data to the premium tables for pulling the data for
• Various columns like service from date, servicecerteffectivedate, genederid,Premiumdueageid, planbenmodskey .
• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Wrote complex T-SQL queries, stored procedures, and Views.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Confidential, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.