SUMMARY:

• Ov e r 12 + y e ar s o f I T e xp e ri e n ce (7 years of Clarity PPM) strong bu s in e s s an d t e chn ical v is ion with ef f e cti v e pe op le skill s t o a llow clo s e wo rk with se n ior m an agem e n t.
• Ab ility t o man age m u ltip l e co m p le x p ro jec t s for in tern al an d extern al cu s tom e rs . In n o va ti ve an d creat iv e p rob le m s ol ve r, results orie n ted, h as an ap titud e for le arn in g while p oss e s s in g a s en s e o f u rge n cy .
• Clarity Version experience 7.5, 8.1.3, 12.1.0 and 13.2.0
• Clarity infrastructure design, clarity installations, upgrades and NSA configurations
• Clarity development with Clarity Studio 12.1.0 and v13.2.0. I m p le me n ta tio n o f cu s to m ob jec t s u s in g Clar ity Stud io f or the different components of reference architecture. Creating portlets, attributes, Lookups, notifications and processes.
• Good Experience on GEL, NSQL, Store procedure, Function and Trigger
• Datamart extraction and time slicing monitor. Resource create and OBS permission setup for security
• Clarity Remedy support and clarity Performance monitoring by BMC - TMART tool
• Clarity CAPA Testing and publishing for end users; CAPA tool installation, upgrade, backup and restore
• Clarity Database Performance monitoring by oracle OEM(Oracle Enterprise Manager)
• Oracle 11g database backup, restore by using data pump export and import command; Creating the clarity database table space, resizing the database table space, creating users and granting the database access permission
• Business Object Report Server install and upgrade up to r3.2
• SharePoint-2010 creating contents, library, manage security permission and upload the files
• Windows server 2008 enterprise build for Clarity V13.1.0
• SQL Server 2005/2008 installations and configurations with Clarity Application Database. Database export and import
• Cl arity v 1 2.1 and v13.1.0 b oot camp f o r techn ical an d fun ction al.
• E xp e rtis e in O racle D B o n W ind ow s an d L inu x.
• E xp e rie n c e d i n C l ar i ty t e c hn ical/System Admin an d d eve lop me n t.
• Micro s of t C e rtifi e d Sy s te m Ad m in i s tra to r (MC SA) Windows 2003 track .
• Ora cle 11g O CA(Oracle Certified Associate)
• Very good experience on Oracle Data Guard (Primary and Standby database setup)
• Ability to work on multiple projects/tasks simultaneously to meet deadlines. A very good team player and self-starter. Ability to coordinate with business, technical and other support teams for technical support in the organization
• Currently holding Green Card(Legal Permanent Resident), no work visa sponsorship required

TECHNICAL SKILLS:

• Clarity Project management tools-In s ta ll, con f igur e an d up grad e v 7.5.3, v8.1.3, v12.1.1 to v 1 3.2.0
• Op e ratin g Sy s t e m -Win -N T- 4. 0, Win -200 0 Pro f es s ion al, W in - XP, W in - 2003, Win-2008 and L in u x/Unix
• Pro gram m in gLan gu age - V B.NE T, Visual Basic, De ve lope r6i.
• Reporting tools- Actuate, Info view and Tableau
• Web Pro gra mm in g - HT ML, DH T ML, Fron tPage, A SP, . NE T, Jav a Scr ip t, PH P
• DBM S/RD BMS -MS - Acc e s s2000, SQL Ser v e r 2005, O racl e 8i/9i, 1 0gan d11g
• PL/SQL cr e at in g t ab le, v iew, Ind e x, Stor e P ro ce du re, Trigger and d at e Fun ction s
• App licat ion P ack age - MS- Wo rd, MS - E xce l, MS - Po we rP oin t, an d Ad o b e Ph oto s h op
• N e twork - LAN, WAN and Load Balancer T5. Different type of Switch and router setup
• Intranet Content Management Tool SharePoint-2010
• Project Schedule Tools - Open Work Bench (OWB) and Microsoft Project(MSP)
• Agile Project Management
• Application Monitoring tools - BMC-TMAR
• Email Client- Outlook Setup with Microsoft Exchange Server 2010
• Web hosting and support, FTP create and SSL certificate installations
• PC America POS system installation and configurations with merchant account for credit and debit card process

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Clarity PPM Solutions Architect

• Clarity and SAP integration- (non -labor) financial data transactions from SAP to Clarity
• Clarity and Active Directory integration with Siteminder
• Clarity and TROUX application Configurations to manage enterprise application software standard across the company
• Working on Clarity Financial Configurations with team
• Clarity application servers/infrastructure de s ign an d I m p le me n ta tio n for V13.3.0 with necessary ports and admin security rights
• Clarity application server upgrade v13.1.0 to v.13.3.0 with prerequisite all steps before proceed the upgrade
• Clarity performance monitor by custom portlets
• Responsible for creates cu s to m Ob jec t s, Sub-objects, Attributes, Portlets, Menu, Tab, NSQL u s in g Clar ity Stud io f or im p le m e n ta tio n o f th e d iff e re n t compon e n t s o f re f e re n c e arch itec tu re

Confidential, Chicago

Clarity Technical Lead and Business Analyst

• Clarity application servers/infrastructure de s ign an d I m p le me n ta tio n for V13.2.0 with necessary ports and admin rights
• Clarity application server upgrade v12.1.1 to v.13.1.0 with prerequisite all steps before proceed the upgrade
• Worked with DBA team to upgrade clarity database 10g to 11g with proper character set, default table spaces, block size andproper users permissions
• Worked With DBA team to setup Data guard (Primary database and Secondary database) and UAT for database failure
• Responsible for database performance monitor by OEM(Oracle Enterprise Manager) daily basis. Long time running Process kill by SQL ID and CPU performance capacity
• Clarity application cluster setup with NSA page and setup load balancer(T5) with application ports
• Business Object report server installations and configurations with clarity. Report server database backup and restore. Info view report creates and run for executives.
• Responsible for creates cu s to m Ob jec t s, Sub-objects, Attributes, Potlets, Menu, Tab, NSQL u s in g Clar ity Stud io f or im p le m e n ta tio n o f th e d iff e re n t compon e n t s o f re f e re n c e arch itec tu re
• Cre at e P L/SQL St or e d P ro ce du re s an d t rigg e rs, DB link and functions in O racl e by using database client Toad for oracle 9.6
• Perf or m Clar ity P PM con f i gu ration, cu s to m iza tion, d ashb oard impleme n ta tio n, OBS creation an d u se r s e cu rity main tenan ce with global and instance rights
• Using XOG(XML Open Gateway) to upload resources, objects, OBS, Portlets, Projects data and expenses
• Clarity Report and jobs scheduled, run, close and cancel. Due to the performance issue i did the Clarity jobs on pause for sometimes
• I was responsible for data migration from development box to production box
• Wo rking with P ro jec t management, R es ou r ce management an d Dem an d Man age me n t m odu le s
• I was responsible for support to open time period, timesheet unlock, Project flag approved, users unlock and Lock. Also helping functional team members to update user id and calendar holiday update countrywide
• CAPA testing for different groups within Nokia corporate. CA P A training tool Installations, Configuration and Up grad e. Helped the functional team to create project modules under CAPA and publishing on the clarity application servers. Also I was responsible for CAPA database Export and Import
• Cl arity application P e r f orman c e mon it or b y BMC - TM A RT. I was responsible for create script for application ports, timesheet, different projects and country. Also generating the weekly clarity performance reports for executives and uploading on SharePoint
• Remedy support and distributions for specific team member in daily basis. 60% of remedy ticket I did solve everyday
• Op e n W ork B e n ch install and configurations. Also supp orting the project schedule and calendar issue to users
• QIL(Quality In Line), I did the QIL data upload almost 4000 to 6000 records per week in the clarity system by using XOG and for data validation purpose we have Visual basic script to validate the data for wrong format
• Every month of first week I had used the Clarity Monthly Maintenance window along with DBA team. During the maintenance time user will able to see the maintenance page for specific time slat
• I was responsible for install clarity and oracle software in all development boxes. Clarity back and restore, NSA page setup and configurations.
• I was responsible to use Oracle RMAN (Recovery Manager) tools for database physical backup and restore, also able to take specific table space backup.

Confidential, SanRamon, CA

Clarity Technical Consultant

Respon si b ili t i es

• I was responsible to configure Cl ar ity application server with Clarity v7.5.3, 8.1.3 and v 1 2.0.0 for different clients. Xinify had 26 Windows 2003 servers and four Linux servers hosted on server beach
• Clarity application server upgrade v8.1.3 to v.12.0.0 with prerequisite all steps before proceed the upgrade
• Business Object report server installations, configurations, backup and restore by using Business object tools
• I was responsible for creates cu s to m Ob jec t s, Sub-objects, Attributes, Potlets, Lookups, Menu, Tab, NSQL u s in g Clar ity Stud io f or im p le m e n ta tio n o f th e d iff e re n t compon e n t s o f re f e re n c e arch itec tu re
• By using XOG(XML Open Gateway) to upload resources, objects, OBS, Portlet, Project data and expenses
• Report and jobs scheduled, run, close and cancel. Due to performance issues, i do the jobs on pause for sometimes
• I was responsible for data migration from development box to production box
• Wo rked with P ro jec t management, R es ou r ce Management an d Dem an d Man age me n t m odu le s
• I was responsible to support to open time period, timesheet unlock, Project flag approved, users unlock and Lock. Also helping functional team members to update user id.
• Responsible for install clarity and oracle software in all development boxes. Clarity back and restore, NSA page setup and configurations
• I was responsible to open a case with CA for critical issue and implement the solutions as per CA’s concerns
• Using Oracle RMAN (Recovery Manager) for database physical backup and restore, also able to take specific tablespace backup.
• Using data pump to take logical database Export and import for full backup of specific schema from database
• I was also responsible to manage Xinify’s office network and support

IT Manager (Oracle)

Respon sibiliti es

• Installation, configuration and upgrading of Oracle 9i server software and related products
• Trouble shooting and customer support on various database issues
• Creation of PL/SQL Block, Store Procedures, Functions & Triggers
• Tuning of Database and applications whenever required
• Using Oracle RMAN (Recovery Manager) for database physical backup and restore, also able to take specific tablespace and control files backup.
• Create users and table spaces, add control files. Grant permission to users
• UAT for 15 users and production support of 24x7
• Network LAN setup with 35 computers

Confidential

Respon sibiliti es

• Oracle Database design and implementations with Visual Basic 6
• Oracle database administrations, installations, upgrade & migration, backup and recovery.
• Database performance tuning and health check, database security, development, capacity planning of database and production support of 24x7