SUMMARY:

• Proactive and self - motivated information management professional with 14 years of proven experience in helping clients solve complex business problems. Proficient in designing enterprise solutions centered around Salesforce enablement with expertise in Salesforce declarative development and gaining experience with Apex and VisualForce. Expert in architecting data warehouse and data modeling solutions using Informatica PowerCenter Designer and Developer tools. Experienced in integrating diverse Systems using REST APIs and Informatica Powercenter.

TECHNICAL SKILLS:

Salesforce.com: Visual Force, Lightning pages (Pages, Component & Controllers), Triggers, Custom Objects, Validation Rules, Workflow Rules, Dashboards, Reports, Process Builder, Flows, Approval Processes, Sandbox development and Testing, Dynamic Forms and Actions, Apex Classes, Gearset, Change Set, Ant Migration Tool

Data Warehouse and ETL: Informatica Powercenter 10.5/9.6.1/9.1.0, PowerExchange FOR LDAP CDC, Informatica Developer tool, Mulesoft

Databases: Oracle, SQL Server, PostgreSQL, My SQL

Query Languages: SQL, SOQL, SOSL

Query Tools: Toad, SQL Developer and SQL workbench.

Web Services: SOAP, WSDL, XML, JSON, RESTData Transfer Tools for RESTfull APICurl, Postman, App Exchange, Data Loader

Programming Languages: Python, Apex, PL/SQL

Data Analytics: Oracle Business Intelligence: OBIEE 12cCognos 8 BI v.8.3

Scripting: Unix Shall scripting, Python

PROFESSIONAL EXPERIENCE:

Senior Software Engineer and Technical Lead

Confidential

Responsibilities:

• Collaborate with Customer in gathering requirements and help in design and development of various Forms and Applications across various offices.
• Analyze organization processes, converting business workflows into exact Salesforce.com workflows and configuring solution to meet business requirements.
• Clearly identify the data, business process and workflows of the organization with respect to salesforce.com implementation.
• Develop Salesforce application utilizing Salesforce’s GUI, write Apex & Visualforce code.
• Monitor and manage the day-to-day operations of the Platform including system access, User provisioning of the Production Environment, User provisioning of various applications based on permission sets and groups, Sandbox creation, etc., in accordance with the policies, procedures, and standards established by the BAP Program Management.
• Create processes to dynamically update the User profile as per the custom object count.
• Create Custom Objects, Custom fields, Approval processes, Page layouts, Custom Tabs, and various other components as per the client and application requirements.
• Create Dynamic forms and Actions, including but not limited to Workflow Rules, Workflow Actions, Email Templates, Email Alerts, Field Updates and Outbound Messages to manage the Workflows & Approval Processes.
• Develop processes utilizing process builder and Flows. Create screen flows, record trigger flows and auto launched flows.
• Implement Record-Level security using Role Hierarchy, Sharing Rule and Manual Sharing settings.
• Create Data Validation Rules and Triggers to ensure data validation.
• Use Informatica Powercenter and Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Use it to read, extract, and load data from comma separated values (CSV) files.
• Create custom Report types, Reports and Dashboards based on customer’s reporting requirements and business needs.
• Manage the deployment process from development of sandbox to Integration, UAT and Production environment.
• Deployments: Deploy Salesforce code & metadata via Changesets & Gearset, a devOps tool.
• Using Informatica PowerCenter 9.6.1, developed and managed ETL processes to bulk load data from Agency’s diverse data sources into Salesforce Standard Objects - Users, Contact, Account.
• Using Ant Migration Tool command-line utility and Salesforce REST API, create ETL jobs to expose Salesforce metadata and load it back in custom object for Salesforce Metadata Reporting.
• Using Automation techniques, Unix and cronjob, automated the ETL jobs to run without human intervention.
• Experienced in leveraging Powercenter to integrating diverse government and commercial data sources with Salesforce Org using REST APIs and Informatica Powercenter, like GSA.gov form, SAM.gov vendors and Dun & Bradstreet data.
• Created ETL process to bulk provision multiple users for an application. Using ETL process multiple users were assigned permission set and public groups in one process.

Confidential

Service Action Request System (SARS) Engineer

Responsibilities:

• Built workflows required for Self-service hosting service for customers to request IT and Consulting services.
• Built Datamart for SARS, that included gathering requirements and Extraction, Transforming, and Loading of data (ETL) using Informatica PowerCenter 9.1.0.
• Used HTTP Transformation to invoke SOAP-based web service requests to integrate with newScale and vCenter platforms.
• Used Stored Procedure Transformation to send email notifications on the completion of tasks.
• Used SQL Transformation to generate dynamic content on-the-fly by passing ETL-built queries directly to the database.
• Used Java Transformation to deformalize data.
• Created the data mart for Train Track Dashboard.
• Using Informatica PowerCnter 9.1.0 did the ETL design, implemented slowly changing dimensions, type I and type II to load Dimensions and Fact tables.
• Created the RPD (Data Model) in OBIEE 12c
• Installed and Configured PowerCenter 10.5, 9.6.1, and 9.1.0 on UNIX platform, and Informatica PowerExchange CDC 9.1.0 and 9.0.1 for Oracle on UNIX platform
• Wrote UNIX shell scripts for automation, auto restart of INFA services
• Executed deployments, and created and assigned groups, roles and privileges for user groups
• Worked on SQL queries to query the Repository DB

Data Warehouse Specialist

Confidential

Responsibilities:

• Documented project requirements and translate them into functional and non- functional specifications.
• Created ETL processes to extract source data, transform and clean it by applying business rules and load into the data warehouse using Informatica Powercenter 8.6.
• Using Microsoft SQL Server Integration Service (SSIS), used Fuzzy Grouping, Fuzzy Look up Transformation and Statistical techniques from set theory, created a process that helped de-duplicate and consolidate AAMC IDs for the returning applicants and assigning new AAMC IDs.
• Using Cognos 8 BI v 8.3, created BI reports to ensure data consistency across data cycles.

Database Analyst

Confidential

Responsibilities:

• Analyzed and performed Quality Control Audits throughout the Data Warehouse and Data Mart build process
• Developed ETL processes using Informatica Powercenter 8.1.1, enabling data integration with Data Warehouse solutions
• Created and maintained documentation of the data factory/warehouse process and design
• Built internal reporting applications for various product deliverables and data analyses using Cognos 8 BI v.8.3