SUMMARY:

• A result oriented professional with 10 years of IT experience in Software Development.
• Over 5 years of strong experience in design and development of Identity and Access Management Solutions for large scale implementations.
• Domain experience in Banking, Insurance, Healthcare and Retail Sectors.
• Having Good working experience in creation of Custom Forms, Rules, and Applications.
• Design and Development of custom Reports using java and jasper Reports in SailPoint IdentityIQ.
• Experienced in designing and implementing customized solutions using SailPoint IdentityIQ.
• Experience in Identity and Access Management products like SailPoint IIQ 5.5, 6.0, 6.1, 6.4 and 7.0.
• Extensive knowledge in Role Based Access Provisioning.
• Knowledge on Identity Federation, Single Sign On, OAuth etc.
• Experience in Identity/Compliance Management Solutions and Role Management.
• Excellent knowledge of IDM user provisioning and IDM User Recertification.
• Experience in integrating & managing various resource adapters such as AD, LDAP, SAP, UNIX, Database, CSV resources etc.
• Thorough understanding of SQL and RDBMS, Experienced in Web Services, XML.
• Worked on Databases such as Oracle, SQL Server, MySQL and DB2.
• Solid experience in building web enabled applications using JSF, JUnit, Log4J, commons logging.
• Experience in working in an Onsite/Offshore delivery model.
• Exceptional analytical, oral, written, interpersonal, and trouble shooting skills.

TECHNICAL SKILLS:

Identity and Access Management: Oracle Identity Manager 10g/11g, SailPoint IIQ 5.5/6.0/6.1/6.3/6.4/7.0

Web Technologies: Apache web server, J2EE, JSF, JavaScript, Tomcat, and Jboss

IT Security Services: Access Control & Single Sign On, Identity management, User Provisioning

Directory Servers/Tools: Identity Management, DAP Browser/Editor, Microsoft Exchange Server, Microsoft, Sun One Directory Server, Windows Active Directory Server.

Programming Languages: HTML, Java, XML, Python, Shell Scripting

Databases: MySQL, Oracle, MSSQL Server, Teradata, Cassandra, MangoDB, CouchDB

BI Tools/ OLAP/Reporting Tools: Business Intelligence Development Studio (BIDS)/ Data Tools, DTS Import/Export, SSIS, SSRS, SSAS, MDX, Power BI, SQL Profiler, SQL Query Analyzer, Index Analyzer.

PROFESSIONAL EXPERIENCE:

Confidential, MD

SailPoint Developer

Responsibilities:

• Design of identity federation connectors from SailPoint to target systems, along with subsequent access control by SecureAuth.
• Ensure requirements gathered, processes defined, and use cases documented follow out of the box configuration vs. customization as much as possible
• Manage client requirements and configure SailPoint IIQ connectors for 34+ applications
• Design SailPoint deployment and solution architectures
• Participate in all SailPoint deployment activities - connector configuration, custom rule development, workflow configuration and development, third party system integration.
• Design, Implemented a solution which manage the Identity lifecycle of almost all applications with the enterprise, without directly controlling the identity store within the application.
• Involved in creating custom reports, certifications in order to cater various data feeds.
• Achieved SOX and PCI compliance by building a flexible and scalable framework to provide authentication and authorization services while supporting rules/roles/languages requirements for various International countries.
• Design and Implement data import of various types of data files from internal and external target sources for validating access levels.
• Created a Registry for important information on all applications.
• Participate in and/or User Acceptance Testing and bug-related reengineering efforts
• Perform Installation and configuration of SailPoint IdentityIQ
• Develop custom SailPoint BuildMap Rules and Workflows as per the business needs.
• Setup applications Active Directory, LDAP, Oracle and Flat Files.
• Providing solutions for the changing business requirements.
• Implement REST classes using SailPoint Rest Application.
• Using IIQConsole for operations such as checkout, import, connector Debug etc.,
• Used IQService as part Identity IQ for Active Directory (AD) provisioning.
• Setup direct connectors for AD, LDAP, MySQL, Oracle, EPIC
• Configuration of Roles, Policies and Certifications for governance compliance
• Build and Configure SailPoint in-built tasks like aggregation, ID refresh, schedule tasks, correlation, etc.
• Configuration and development of SailPoint Life Cycle Events (LCM)
• Customizing and branding of SailPoint solution.
• Provide knowledge transfer and post production support activities, as necessary.

Environment: Java SE, JSP, Tomcat 8, PowerShell Script XML, HTML, CSS, SailPoint Identity IQ 6.4.

SailPoint Developer

Responsibilities:

• Design & Implementation of SailPoint IIQ
• SailPoint IIQ Installation and Configuration as required by the design solution
• Implementation of Self Service feature, Password features (PTA, Forgot password, Change Password), provisioning feature, configuring various roles and policies in SailPoint
• Set up SailPoint IIQ policy server on 4 environments (Dev, QA, UAT & Production)
• Developed build map rule, creation rule and customization rule to create Employee and Contractor user accounts into SailPoint from their current application’s exported feed file.
• Developed a custom form in the SailPoint UI so that various admins can create Employee/Contractor user accounts manually through UI and provision users
• Created and ran the aggregation task to bulk load authoritative source data from Active Directory, Exchange and LDAP.
• Developed a creation rule to run update, terminate and rehire transactions on specified Employee and Contractor user accounts based on the feed file data.
• Developed a scheduler using Java that will periodically run to terminate contractors on their specified contract end date.
• Developed a code that will send expiration notification to Contractors.
• Developed a scheduler that would periodically check for Name change requests in the feed file data and will change the name of respective Employee account.
• Developed a java code that will consolidate role details of user accounts into a CSV file and send to HR or Application Admin. The admin can then act upon the access of users accordingly.
• Built Joiner, Mover and Leaver workflows to maintain user accounts
• Developed custom workflows with approvals and also modified OOTB workflows as per client requirement
• Created and Implemented static/dynamic roles. Configured entitlements and policies.
• Did Access re-certification, automatic/manual remediation for applications managed by SailPoint for Employees and Contractors
• Analysis of the specifications provided by the client and help Project Manager to estimate the effort required
• Requirement analysis and preparing Requirement Documents and Design Documents

Environment: Java SE, JSP, Tomcat 8, PowerShell Script XML, HTML, CSS, SailPoint Identity IQ 6.1.

SailPoint Developer

Responsibilities:

• Involved in designing the application for SailPoint Security Forms, SailPoint IIQ 7.0 Installation and Configuration.
• Onboard in-scope authoritative and target applications into SailPoint IIQ by deploying read/write and read-only connectors as declared in the scope.
• Aggregate and correlate in-scope authoritative and non-authoritative data and build global data warehouse and respective user accounts in SailPoint IIQ.
• Upgraded SailPoint from 7.0 to 7.0p2.
• Develop and implement in-scope application connectors.
• Define and configure workflows and associated email templates in SailPoint IIQ per the defined scope.
• Build and schedule/execute in-scope Certifications for in-scope applications.
• Establish out-of-the-box reporting per in-scope requirements.
• Loading and Correlating the Authoritative Applications to load the Identity Cubes.
• Involved in designing and implementing Custom AD connectivity in order to pull data from AD.
• Developed custom workflows using LCM in order to provision to AD.
• Integrated SailPoint IIQ with their existing provisioning system in order to cater existing requirements.
• Developed Build Map Rule, Composite Rule, Logical App, Correlation Rule and Delegation rule.
• Established an identity management framework that lays the foundation for identity governance.
• Involved in role definition, role management and certification.
• Invoke custom workflow through Java by building Provisioning Plan, launch.
• Configuring required entitlements and various certifications in SailPoint
• Design and implement new custom workflows for provisioning.
• Creating the IdentityIQ objects like Quicklinks, Forms, Rules, Custom Objects and Form Models to design the workflows.
• Coding, Unit Testing, Bug Fixing and Peer reviews of the code.
• Creating different type of applications by using Delimited, JDBC connectors.
• Using IIQ Console for operations such as checkout, import, connector Debug and Test Connection etc.
• Used IQ Service as part of IdentityIQ for Active Directory (AD) provisioning.

Environment: Java SE, JSP, Tomcat 8, PowerShell Script XML, HTML, CSS, SailPoint Identity IQ 7.0.

OIM Developer

Responsibilities:

• Coordinating with business analysts on collecting requirements
• Involved in Architecture, design, build, test and deployment stages of the project
• Integrated Oracle Identity Manager with Oracle Identity Analytics for Role Based Provisioning
• Developed Configuration, Integration and migration documentation for the client developing connectors and API(s) for automated provisioning
• Performed User provisioning and reconciliation from Flat file, DB and AD.
• Performed issue resolution with respect to these target systems.
• Acted as configuration manager for the project performing review of the OIM metadata exports.
• Version management of code and OIM components, import of OIM components.
• Sanity check on OIM environment.
• Configured entitlements, Provisioning and de-provisioning entitlements to users
• Applied Bundled Patch sets and OIM Merge Patch on OIM using O-patch utility
• Participated in Customer meetings and maintained On-call telephone for support, out of Business hours
• Registered the plugins, imported and exported XMLs into MDS.
• Configured Remote design console for Data Governance team
• Designed and implemented High Availability and failover
• Design workshops with all stakeholders involved in the project
• Built Identity Warehouse and Role mining
• Populated the Identity Warehouse (Imported Users, Applications and Glossary Definitions).
• Conduct Role Mining and validation.
• Designing and implementing custom solution for Recertification Managers and Admins for User Access
• Recertification and Data Owner Recertification
• Developed and implemented SIT and UAT test cases
• Trained Clients on managing infrastructure

Environment: Java SE, JSP, Tomcat 8, Power Shell Script XML, HTML, CSS, Oracle Identity Manager 10g/11g.

SQL Server Developer

Responsibilities:

• Solution development, ETL frameworks and implementing in SSIS to load daily from disparate source systems divided into feeds for international markets from sources oracle and Sybase databases; flat files; excel books.
• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data.
• Interacted with Business Analysts to understand and document the Requirements and translated these to Technical Specifications for Designing reports.
• Wrote SQL stored procedures to implement business logic. Designed the logical and physical databases of SQL Server.
• Report design and development and working with multi dimensional OLAP cube.
• Developing reporting solutions using T-SQL, MDX and bug fixing, enhancements for implementing complex business logic.
• Leveraging the SharePoint integration for publishing and managing reports and using Performance Point, Excel, Power-Pivot services for implementing BI solutions
• Designed and developed interfaces which were used for connecting to SQL Server database.
• Created DTS packages to get data from different sources, consolidate and merge into one single source, Imported and exported database, to schedule jobs for Batch Processing.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Used DBCC commands to check physical and logical consistency of the databases.
• Optimized database performance using SQL Profiler, SQL queries using Query Analyzer.
• Deployment of Jobs and Pre-Processing Scripts as per established release processes.
• Participating in team meetings, stand-ups and follow ups, reporting on the outcome.
• Handled ad-hoc requests like bug fixing, testing, supporting and maintenance.
• Unit/SIT/System/Performance testing and validating the work done.
• Performed database testing & maintaining the data by using the procedures.
• Designed a report on the monitoring of server performance using Task manager and Performance Monitor.

Environment: SQL Server 2008/R2, MS Access, MS Excel, C#

SQL Server Developer

Responsibilities:

• Involved in the development of the system.
• Involved in ER diagrams and mapping the data into database objects.
• Design of the database, Tables, Indexes, Views, Stored Procedures, and Triggers.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Wrote procedures to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to insert/update and delete data in MS SQL database tables.
• Working closely with Admin team in rolling out, installing and configuring SQL Server 2005/2008 as part of the upgrade policy.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Monitored the database and performed fine tuning, query optimization for improved performance.

Environment: SQL Server 2005/2008, Enterprise Manager, SQL Profiler, T-SQL.

BI Consultant

Responsibilities:

• Involved in gathering the design specifications of proposed system, Design and development of: OLAP Cubes, ETL process, Reporting solutions, Databases. And provide ongoing maintenance and support.
• Worked on data analysis, conduct root cause analysis and resolve production problems and data issues.
• Designed and developed data integration and migration solutions involving complex data conversion scenarios and business rules supporting multi-version data warehousing to define imports of the data, scheduling packages, to define integration flow, log error and to define Database Maintenance Plans and send emails.
• Develop cubes, dimensions and business critical KPIs representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Creating MDX queries according to business requirements, supporting enhancements for separate domains.
• Developed several detailed and summary reports functionalities like cascading, multi value parameters, Ad-Hoc Reports on Weekly and Monthly basis as per the Client Requirements
• Testing the routines developed with respect to flow and performance issues.
• Package migration, production support across the application.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, Oracle, DB2