SUMMARY

• 14 years of total IT experience, 4+ years’ experience in the Confidential .com CRM Platform . And 12+ of experience in Database programming, Data Modeling, Data Integration, Data Migration, Data Conversion, Data Warehousing, ETL, Azure Data Factory, Azure Data lake, Azure SQL Databases and Business Intelligence.
• Hands on experience managing, analyzing, design and testing databases and Data Conversion projects.
• Strong in architecture, design and development of applications using MS SQL Server.
• Experience in implementing Agile Methodologies.
• Experienced in building Custom Applications that includes administration, configuration, implementing and support experience with Confidential .com platform
• Excellent understanding of Roles, Profiles, Users, object level security. field level security, record level security and sharing rules.
• Experienced working with Confidential .com sandbox and production environments, also with Eclipse IDE Force.com Plug - in environments
• Excellent understanding of Sales cloud and Service Cloud processes.
• Excelled in working with various Confidential .com standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, Campaigns, Reports and Dashboards.
• Experience with tools like Apex Data Loader, Eclipse IDE and Force.com IDE.
• Strong Implementation and Integration experience using Custom objects, Custom fields, Formula fields, Triggers, Apex classes, Visual Force Pages, Lightning Components, Page Layouts, Workflow rules, Approval processes. Record Types, Standard Controllers, Custom Controllers, Extension Controllers, SOQL and SOSL.
• Extensive experience using Sales Force Administration (SFA) tasks like Managing Users, Roles, Profiles, Permission sets.
• Implemented security and sharing rules at object, field, and record level for different users at different levels of organization. Also maintained various profiles and configured the permissions based on the organizational hierarchy.
• Experience on SOQL, SOSL, Visualforce, APEX, Force.com and Web services API.
• Experienced in scripting languages like HTML, XML and Java Script.
• Experience in Lightning Components development using Aura Framework.
• Knowledge on LWC (Lightning Web Components)
• Creates and modifies forms, business rules, UI Policies, Client Scripts, workflows and other business-related information in the ServiceNow platform
• Thorough knowledge of XML and working with XML in SQL Server
• Broad experience in database development, including effective use of database objects, SQL Trace, explain plan, various optimizers, hints, indexes, table partitions, sub-partitions, materialized views, and global temporary tables.
• Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture, SQL Profiler, Data Warehousing, ETL, Azure Data Factory, Azure Data lake, Azure SQL Databases
• Experience in requirement discussions, database design phases, and project management.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Superior communication skills and strong decision-making and organizational skills along with outstanding analytical and problem solving skills. Able to work well independently and also in a team by troubleshooting technology and business-related problems.
• Good exposure to verifying and validating health & benefit-related business rules like agent commissions and bonuses. Domain knowledge in US healthcare insurance and telecom.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Profiler, Database Engine Tuning Advisor, SQL Server Data Tools (SSDT), Data Warehousing, ETL, Azure Data Factory, Azure Data lake, Azure SQL Databases

ETL Tools: SQL Server Integration Service (SSIS), Azure Data Factory, Azure Data lake

Reporting Tools: SQL Server Reporting Services (2000/2005/2008 R2/2012), MS Access, MS Excel

Database: MS SQL Server 2014/2008 R2/2005/2000, MS Access, Confidential 9i/8i

Programming: T-SQL, PL-SQL, C, VB, XML Schemas

Web Technologies: HTML

Confidential Technologies: Apex Language, Apex Trigger, ApexClass, SOQL, SOSL, Visualforce Pages / Components, Lightning Components, Workflow & Approvals, Reports, Dashboards, Analytic Snapshots, Custom Objects

Confidential Tools and Integration Tools: Eclipse, Force.com Eclipse IDE Plug-in, Change sets, Workbench, Apex Data Loader, Force.com Platform (Sandbox, and Production).

Other Tools: MS Office Suite ( Confidential Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Crystal Reports 9.0, Visual Source Safe, TOAD, TFS

PROFESSIONAL EXPERIENCE

Confidential

CRM Developer

Responsibilities:

• Performed roles of Developer and Administrator in the organization for customization and configuration.
• Using Data Direct connected to SQL Server and pull the data into Confidential external objects
• Created a user interface for Billing, Usage and payment process using the Custom Objects, Lightning Tabs, Lightning Components, Page Layouts, and Customization options.
• Created Custom Fields, Custom Reports, Triggers, Custom Formulas and Field History Tracking.
• Used Master-Details, lookups, and many-to-many relationships with Junction Objects.
• Created advanced workflows rules with field updating actions and validations, and automated business processes.
• Created Visualforce email templates, lightning email templates and automated Email Process to send appropriate users.
• Worked on Profiles, sharing rules and levels, public groups and employed manual sharing, restricted access to sensitive organization’s data.
• Developed Lightning Components, Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Worked with SOQL, SOSL & relationship queries for query optimization and not to hit governor limitations.
• Web services have been developed to get/put the data from/to Web Application developed in .net
• Used Data Loader and Workbench for insert, update, and bulk import or export of data from Confidential .com objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Involved in the analysis of the user requirements and identifying the sources.
• Database Programming: Creating Procedures, triggers, functions, views etc .
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed and developed SSIS Packages
• Worked database/ETL performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Documentation of the new assignments, technical specifications and requirement documents
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Created SQL Server Agent Jobs, Alerts

Environment: Force.com Platform, Aura Framework, Lightning Components,Apex Classes, Controllers, Triggers, SOQL, Custom Reports, Dashboards, Apex Data Loader, Workbench, Force.com IDE, Developer Console, Workflows & Approval Process, Process Builder, GitHUB, ANT Tool, Jira, Data Direct, SQL Sever

Confidential, San Jose, CA

Database Developer & CRM

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Used Master-Details, lookups, and many-to-many relationships with Junction Objects.
• Created advanced workflows rules with field updating actions and validations, and automated business processes.
• Created Visualforce email templates, lightning email templates and automated Email Process to send appropriate users.
• Worked on Profiles, sharing rules and levels, public groups and employed manual sharing, restricted access to sensitive organization’s data.
• Developed Lightning Components, Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Worked with SOQL, SOSL & relationship queries for query optimization and not to hit governor limitations.
• Data modeling: Responsible for creating Logical and Physical data models new PeopleX system using CA Erwin data modeler R9.6
• Data migration: Responsible for migrating data from SAM system ( Confidential database) to new PeopleX (SQL server database on Azure).
• Database Programming: Creating Procedures, triggers, functions, views etc .
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Documentation of the new assignments, technical specifications and requirement documents
• Responsible design and develop methods for data security and data classifications.
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Used GITHUB for version controlling

Environment: SQL Server Azure, SSIS, SSDT

Confidential, Sacramento, CA

Sr. SQL Server ETL/BI Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Database Programming: Creating Procedures, triggers, functions, views etc .
• Responsible design and develop methods for data security and data classifications.
• Collect, validate, Consolidate and load audit universes by every month.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Load CMS audit universes created by business to compare with audit data created by our team.
• Designed and developed SSIS Packages for CMS Audit universes project.
• Created 100+ SSIS packages for getting different sources of data, such as flat files, Excel sheets
• Worked database/ETL performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Created Metric reports using Power BI
• Worked on data analysis and created views for KPIs and Metrics requested by business users
• Documentation of the new assignments, technical specifications and requirement documents
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Created SQL Server Agent Jobs, Alerts
• Scheduled SSIS Packages and Backup/Restore of a databases

Environment: SQL Server 2014, SSIS, SSRS, TFS, MS VISIO and Power BI

Sacramento, CA

Senior MS SQL/SSIS Developer & Data Warehouse Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Database Programming: Creating Procedures, triggers, functions, views etc
• Provide database coding to support business applications using SQL server T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Data Conversion: Created SSIS packages to load required data from legacy SIEBEL system ( Confidential ) consists of 5TB in to data warehouse system (SQL Server).
• Designed and developed data warehouse model for dashboard project.
• Created data warehouse model sourced from SIEBEL
• Created data warehouse model sourced from FILEMAKER
• Gather requirements and design of data warehouse and data mart entities
• Created Dimensions, facts tables and Views for KPIs, inputs to Tableau Dashboard
• Created Dashboard mockups and prototypes using Power BI
• Trained Developers on Data Warehouse Development and ETL Development best practices
• Designed and developed SSIS Packages for CCTC dashboard project.
• Created 30+ SSIS packages for getting different sources of data, such as flat files, Excel sheets, data from FILEMAKER database and data from SIEBEL database
• Data modeling: responsible for creating Logical and Physical data models existing CCTC enterprise data model and future data warehouse model for CCTC dashboard project using CA Erwin data modeler R9.6
• Created Logical and Physical model for existing database source systems such as SIEBEL and FILEMAKER
• Created custom built reports for metadata from data models
• Created custom built Erwin queries
• Worked database/ETL performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Documentation of the new assignments, technical specifications and requirement documents
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Created SQL Server Agent Jobs, Alerts
• Scheduled SSIS Packages and Backup/Restore of a databases
• Used TFS for file maintenance.

Environment: SQL Server 2014, SSIS, CA Erwin data modeler, TFS, MS VISIO, Power BI and Tableau

Confidential, Dallas, Texas

Lead SQL/SSIS Developer

Responsibilities:

• Responsible for designing and developing stored procedures, user-defined functions, views, triggers, and indices.
• Involved in analysis of requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Data modeling: Responsible for creating Logical and Physical data models
• Responsible design and develop methods for data security and data classifications.
• Worked on Data conversion project involving NT (National voice tables) in Confidential system with size greater than 3 TB to SQL server using SSIS (ETL) tool.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed, maintained and developed SSIS packages for PCAT and VQE (Product catalogue and Qualification) systems.
• Created several Dynamic Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View using SQL programming to implement the business logic and performance. Created XML schemas (XSD), Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Created complex SSIS packages using proper control and data flow elements.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Responsible for Database/ETL performance tuning
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Regular monitoring of a rapidly-changing 500 GB database
• Reduced total ETL package running time from 8 hours to 2 hours
• Scheduled the SSIS packages and Jobs.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
• Configure SQL Reporting Services (SSRS), including data-driven subscriptions
• Documentation of the new assignments, technical specifications and requirement documents
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Worked on preparing test cases for all work requests in each deployment
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed unit testing, integration testing and system testing as part of application development.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.
• Used TFS for file maintenance.
• Led the 4-member team and updated project manager on daily work progress
• Worked very closely with Business users, End users and resolved any business process related issues.

Environment: SQL Server 2008 R2 and 2014, SSIS, TFS and C#.NET

Confidential, Milwaukee, WI

Lead SQL Developer

Responsibilities:

• Responsible for designing and developing stored procedures, user defined functions, views, triggers, and indices.
• Involved in analysis of Requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created a modularized model of procedures for complete VUE compensation product database.
• Converted long and complex procedures in to different modules as a part ease of access and performance tuning.
• Developed complex procedures related to the calculation of commissions & bonuses for insurance agents.
• Worked on a complex commission calculation procedures which involve multiple iterations of complex calculations based on user defined Templates
• Designed, maintained and developed SSIS packages and SSRS reports
• Scheduled the SSIS packages and Jobs.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Worked on series of procedures to reduce total run time from 4 hours to 30 minutes
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Documentation of the new assignments, technical specifications and requirement documents
• Performed unit testing, integration testing and system testing
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used TFS for file maintenance.
• Led the 3-member team and provided daily updates to the project manager

Environment: SQL Server 2008, SSIS, SSRS, C#.NET and TFS

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Worked as onsite coordinator for the VUE Compensation Management System
• Responsible for gathering requirements from clients and sharing the requirements with the off-shore team
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created several Dynamic Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View using SQL programming to implement the business logic and performance. Created XML schemas (XSD), Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Optimized database queries and stored procedures
• Reduced considerable amount of execution time on compensation procedure.
• Designed SSIS packages to extract data into VUE from various carriers
• Designed and developed SSIS packages to load policy and premium data from source systems
• Actively participated to resolve the production tickets
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used Visual Source Safe for file maintenance.
• Documentation of the new assignments, technical specifications and requirement documents
• Performed unit testing, integration testing and system testing

Environment: SQL Server 2008, SSIS, SSRS, C#.NET and TFS

Confidential, Sunrise, FL

Software Engineer

Responsibilities:

• Job responsibilities include involvement in SDLC, requirement gathering and understanding, documentation, application development and providing support for technology and functionality related bugs reported by client.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Created stored procedures, user defined functions for calculating commissions and payments in PL/SQL
• Created batch processes and procedures for data export received in flat files
• Created SQL load batch process for loading flat files to destination system
• Coordinated with the team members to develop the application on time and in line with the quality requirements
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used Visual Source Safe for file maintenance.
• Documentation of the new assignments, technical specifications and requirement documents
• Designed and developed applications including UI layer, business layer, data layer, and common layer in VB Programming language
• Worked with Implementation team and closely moved with end users to implement/support production issues.

Environment: PL/SQL, Confidential , VB, C#.NET