SUMMARY:

• Senior ETL Developer (Informatica Cloud, SSIS), Certified Salesforce Administrator and Experienced Database Administrator with a demonstrated history of working in the insurance industry. Skilled in business process, APIs integration, requirements analysis, performance tuning and data migration. Strong information technology professional with a Master of Science in Electrical and Computer Engineering.
• Proven ability in middleware integration components preferably in iPaaS ( Integration platform as a service ) platforms such as IICS (Informatica Intelligent Cloud Services).
• Proficiency in Salesforce real - time integration using APIs (REST/SOAP/Bulk ), Web services.
• Knowledge in developing Informatica Cloud Mappings, Mapplets, Integration Templates, Tasks, and Task flows for data loads.
• Expertise in Informatica cloud services like Data Synchronization and Data Replication for Salesforce and other applications.
• Adept at Salesforce CRM Configuration, Customization, and Testing of applications.
• Proficient in creating roles, profiles, email templates, page layouts, workflows, workflow actions and approval process.
• Strong knowledge in ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert and Bulk Copy Programming (BCP).
• Hands on experience in migration, installation, configuration, maintenance and upgrade of MS SQL Server 2014 and prior versions.
• Expert level skills in Data Modeling (Physical and Logical), Installation and Configuration, upgrading from previous versions of SQL servers.
• Project implementation using Agile or Scrum development methodologies.
• Strong Analytical and debugging skills. Quick turnaround time for any issues reported.
• Demonstrated ability to translate functional/high-level design in detailed technical design.
• Team player with good communication, interpersonal and business analysis skills.

KEY SKILLS:

• IICS
• SSIS, CozyRoc (SSIS+)
• APEX Data Loader
• Salesforce ID Connect
• Salesforce Classic/Lightning
• JIRA, QC, Erwin 4.0
• MS SQL Server
• APEX
• XML
• JSON
• XQuery
• SQL
• SOQL
• SSRS
• Microstrategy
• Prophix

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL (Informatica Cloud, SSIS) Developer, Salesforce Administrator

Responsibilities:

• Administer, support and monitor ICS, Salesforce and SQL Server Databases and Instances.
• Actively engage in building robust ETL solution using Informatica Cloud to harness the best practices.
• Maintain, enhance and troubleshoot integration mappings.
• Architect, design, development and implementation of Salesforce API integration with HR applications (Concur, UltiPro), AMS systems (Sagitta, BenefitPoint) and various other applications.
• Successfully architect, design, develop and implement Salesforce - AMS bi-directional, Employee onboarding process, automated file extraction process and other cloud-based integration projects.
• Development and administration of SSIS packages for BI Reporting (Microstrategy), Financial Reporting (Prophix) and other insurance-related applications.
• Development and administration of automated file extraction process of Concur (expense reimbursement application) using IICS for BI Reporting.
• Participate in development of BI Group. Including BI report development practices, standards, procedures and controls.
• Periodically backup Salesforce system data and attachments including all history tables using Informatica Cloud Replication process.
• Salesforce Administration, Custom Objects, Custom Tabs, Custom Fields, Role-based Page Layouts, Custom Reports, Report Folders, Report extractions to various formats, Design of Visual Force Pages, Dashboards and various other components as per the business requirements.
• Actively engage in creating Roles, Profiles, Email Templates, Page Layouts, Workflows, Workflow Actions and Approval Process.
• Provide 24x7 on-call support in a very dynamic environment with mission critical applications.
• Interact with Support teams, developers, etc. to perform troubleshooting, debugging, root cause analysis and resolve application issues.
• Proactively monitor database operations, capacity planning and performance tuning (SQL and database) for optimal performance of applications.
• Performance tuning, and optimization of stored procedures and queries.
• Plan, coordinate, communicate, test, implement, and install product upgrades and patches.
• Develop and maintain infrastructure, environment landscape and other Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
• Administered, supported and monitored multiple SQL*Server databases and Informatica Cloud Services.
• Installed and maintained SQL Server 2014 and 2008 R2 64-bit in production environment.
• Migrated SQL Server 2000 to SQL Server 2008 R2 and SQL Server 2008 R2 to SQL Server 2014.
• Converted DTS packages to SSIS (DTSX) packages to run in 64-bit environment.

Confidential, Canton, MA

I.T System Analyst - SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 R2 and SQL Server 2005 on Windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Extensively used of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.

Confidential, Orange, NJ

I.T System Analyst - Jr SQL Server DBA

Responsibilities:

• Configured Cisco Router, routing protocol and fine-tuned the static route and dynamic routing protocols.
• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service packs as required.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.