Hi,
Here are the details of my available consultants.
Please revert back to me for resume in Word Format and Contact details
Please feel free to call/email me for further information.
Thanks,
Jay Chauhan
cyberThink Inc
jay.cyberth...@gmail.com
========================================================================
1) Senior Informatica/ETL Lead
Availability : Immediate
Present Location : MA
Location Preference : Nationwide
SUMMARY
• Over 10 years of IT experience in ETL Architecture, Analysis, design,
development, testing ,implementation, maintenance and supporting of
Enterprise level Business Intelligence (BI) solutions using Data Warehouse
(DW)/Data Mart (DM), ETL, OLAP, ROLAP Client/Server and Web applications
on Windows and Unix platforms
• Worked on projects for Insurance Clients such as The Hartford and
Healthcare/ life sciences Clients such as Pfizer Inc., Amgen Inc.,
AstraZeneca(With IMS data), and Retail Clients such as 7Eleven.
• Over 10 years of Relational Modeling and Dimensional Data Modeling
using Star & Snow Flake schema, De normalization, Normalization, and
Aggregations. Designed Data bases using Erwin 4.5
• Over 8 years experience in using Informatica Power Center
6.x/7.x/8.1.1/8.5.1/8.6.1Data Stencil, Designer, Repository Manager, Server
Manager, Workflow Manager, Workflow Monitor including Administration and
performance tuning of Informatica
transformations/mappings/sessions/workflow’s
• Over 3 Years of experience in generating various complex reports,Dash
Boards and score cards using Business Objects 6.X/XI/XIR2 Designer, Reports,
Info view, Supervisor, Web Intelligence(WEBI) including security
administration
• Over 10 Years of experience in using SQL, PL/SQL Dynamic SQL,Stored
procedures/functions, triggers and packages, complex joins, correlated
sub-queries, aggregate functions analytic functions, materialized views,
indexing, partitioning and performance tuning the same using explain plan
and TKPROF Analysis.
• Over 10 years of experience working in multi-terabytes data warehouse
using Databases like Oracle 10g/9i, MS Access 2000/2002, XML ,IBM UDB DB2
8.2, SQL Server 2000 ,MS Excel and Flat files
• Have Good understanding of ETL/Informatica standards and best practices
,Confirmed Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
• Experience in writing UNIX Korn shell scripting
• Experience in Data Quality Analysis,Data Profiling, Data cleansing and
metadata management
• Experience in testing coordination ,writing test cases and executing
test scripts ,And logged defects in Quality Center(QC)
• Maintaining and Supporting during Assembly/Integration Test ,QA,UAT,
and Production for Issues/Bug fixes
• Experience in all phases of System Development Life Cycle(SDLC)
• Excellent team player with very good communication skills and
leadership qualities.
• Experience with coordinating and leading onsite-offshore development
TECHNICAL SUMMARY
ETL Tools: Informatica Power Center 6.x/7.x/8.1.1/8.5.1/8.6.1
Scheduling Tool: Siebel Analytics DAC, Autosys, Control-M
BI Tools: Business Objects 6.5/XI/XIR2,Cognos 6.0
Data Cleansing Tool: Trillium
Data Modeling Tool: Erwin 4.5
RDBMS: Oracle 9i/10G, MS Access 2000/2002, IBM UDB DB2 8.0/7.0, MS SQL
Server 2002/2005
GUI Tools: FTPPro, Toad, SQL Navigator, MS Share point, Clear case (version
control), SQL * Loader
Languages:Java, C, C++, SQL, PLSQL, COBOL, XML, UNIX Korn Shell Scripting
Web Servers: Apache, Tomcat, WebLogic 2.0
Operating Systems: Windows NT, XP, UNIX (Sun-Solaris/AIX/HP), and Linux
Others: MS Office Products (Project,Excel, Power Point,word, Outlook, Visio
etc.)
========================================================================
2) Senior Business Objects Lead
Availability : Immediate
Present Location : NJ
Location Preference : Nationwide
SUMMARY OF QUALIFICATIONS:
* Around 10 years of professional experience as a software
developer in designing and development of Data warehouse, Reporting,
Business Objects Enterprise XI3.1/XIR2/Crystal Reports XI, Oracle, SAP
BW and SQL Server.
* Full Life cycle experience in analysis, design, development,
test and implementing Data Warehouse, Database Administration Business
Intelligence and Client Server applications.
* Business Intelligence: Business Intelligence experience using
Business Objects XI R3/R2/XI/6.5/6.1/6.0/5.1.
* Extensive experience in OLAP tools providing basic to complex
Business Intelligence solutions and in all phases of SDLC.
* Highly skilled in Business intelligence system study, design,
development and implementation of applications.
* Extensive experience in developing BI Solutions using various BI
Tools (Business Objects, Crystal Reports).
* Business Objects: 7+ years experience in Business Objects XI
R3/R2, 6.X, 5.X, Business Objects Designer, Business View Manager,
Crystal Reports, Crystal Reports Enterprise Reporter, Supervisor, Info
View Web-Intelligence 2.X, ZABO, BCA, CMC.
* Support and lead administration of BO environment and other BI
tools, designing Universe, creating reports, configure LDAP and other
security features for a BI environment.
* Experience with Installing and Administration of Application
servers like Tomcat, IIS 5, and Apache (Clustered and Standalone
environments).
* Experience in installation, administration and upgrading
versions of BO both desktop and server products on both Windows and UNIX
environments.
* Experience in upgrading from version 5.X to BO XI R2 and also
proficient with the features of Business Objects 6.5, XIR3.
* Created the complex WEBI reports such as Cross Tab and Master
Detail Reports using the Java Report Panel.
* Designed, implemented and migrated complex Universes and
Business Objects Reports, Created classes, subclasses, objects,
Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts
and Aliases for resolving Loops and checked the Integrity of the
Universes.
* Extensive Experience in migration of Business Objects 6.X to BO
XI Release 2 and Crystal Info or CE9 to BO XI R2.
* Having Good Experience in creation of Dashboard, Score card and
WEBI Reports.
* Created Dashboards to monitor business performance, insightful
analytics, role based dashboards.
* Experience in data retrieval methods using Universes, Personal
Data files, Stored Procedures, and free hand SQL.
* Experienced in Training & Supporting end-user reporting needs
using Business Objects.
* Worked on the Master, Kernel and Component approach during
the linking of universes.
* Worked extensively with new features of Business Objects XI and
6i including Index awareness, Derived tables and Central management
console.
* Implemented Security Features of Business Objects like row
level, object level and report level to make the data secure.
* Having good knowledge of Crystal Xcelsius.
* Possess Excellent Communication and Interpersonal skills.
Technically sound, Result-Oriented with strong Problem solving skills.
Innovative & efficient. Capable of working as a Team Member or
Individually with minimum supervision.
* Flexible and versatile to adapt to any new environment with a
strong desire to keep pace with latest technologies.
* Schema Modeling: Star Schema Modeling, OLTP, OLAP, MS SQL Server
2000, MS Access 2000/97, Erwin 4/3.x, Windows NT/2000, Windows
2000/98/95.
* Dash Board Manager: experience using Dashboard Manager, Report
Writer, BO Performance Management module & Dashboard Manager).
* Data Modeling: Well versed in Data Modeling experience using
Dimensional Data Modeling and Relational Data Modeling, Star Join
Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical
Data Modeling.
* Good Knowledge in extraction, transformation and loading (ETL)
process.
* Oracle: Extensive database experience using Oracle
10g/9i/8i/8.0/7.3, SQL, PL/SQL, SQL*Loader, Stored Procedures, TOAD,
Explain Plan, Ref Cursors, Constraints, Triggers, Views, Inline Views,
Materialized Views, Tuning, Database Links, Export/Import Utilities, MS
SQL Server 2000, MS Access.
Technical Overview:
Business Intelligence: Business Objects XI3.1/XI
R2/XI/6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business Objects
Reporting, CMC, Web-Intelligence 6.0/2.7/2.6/2.5, Broadcast Agent, BO
Publisher, Designer, Supervisor, Auditor, Performance Management &
Dashboard Manager, Report Writer),CMC, SDK, TOAD 8.5.
ETL Tools: Informatica Power Center 8.x/7.x, SSIS
Data Modeling: Dimensional Data Modeling, Data Modeling, Star
Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables,
Physical and Logical Data Modeling, ERWIN 4.0, Visio, Voyager.
Databases: Oracle 10g/9i/8i/8.0/7.x, MS SQL Server
2000, Teradata, MS Access, DB2, Sybase.
Programming: SQL, PL/SQL, SQL Plus, VB, C, C++, Java
Script, .Net.
Environment: MS-Windows 9.x/Me, Windows NT 4,
MS-Windows 2000/XP.
========================================================================
3) Senior UNIX (Solaris/AIX/Linux) Administrator
Availability : Immediate
Present Location : MA
Location Preference : Nationwide
SUMMARY OF QUALIFICATIONS:
Senior IT professional with over 12 years of IT experience more than 3
years of experience in capacity planning/designing/implementation and
more than 10 years of experience in Unix/Linux administration on
different applications/databases/tools/utilities & tuning of Solaris
servers (Sun ENT 10k/4500/450/250/280, Sun Fire
1280/880/890/480/490/440/240/210, Netra servers & Sun StorEdge Arrays
A5x00/A1000/D1000/S1/T3/3510/3120), SCO , AIX
Installation configuration and managing zones and containers
Working experience with other flavor's of UNIX like IBM AIX 4.3/5.x, SCO
7.x.x
Working experience with Windows Active directory
Installation configuration and administration experience of f5 load
balancer on GTM, and LTM platform
Good experience in TCP/IP networking (Implementation configuration and
troubleshooting)
Working experience with other networking O/S like Novel NetWare 3.x to
4.x
Working experience with networking hardware like CISCO routers ,
switches
Good experience is DNS, NFS, NIS, SAMBA , SENDMAIL, POSTFIX, Cyrus IMAP
& POP, Squid proxy, Ngios, LDAP, Request tracker, Apache, Tomcat Jboss
IBM eSeries p6xx, RS/6000 series Compaq (HP) server and other server
base hardwires Redhat Enterprise Linux 3, 4 systems administration and
Tru64
Experience working with Veritas Volume Manager (VxVM), Veritas File
System (VxFS), Veritas Cluster Server (VCS), sun Cluster (SC),
Disksuite, Solaris Volume Manager (SVM), ZFS ,NIS, NFS, DNS, LDAP & IP
Chain
Installation configuration and troubleshooting of clearcase
Solaris Service Management Facility (SMF) and Sun Resource Mgmt (SRM)
Perform as senior member of project team and junior member of management
staff
Implemented ITIL processes and procedures and JCAPS composite
application and SAS certification
Successful Implementation of Server consolidations and transition of IT
Infrastructure Projects and provide support structure for the Operations
Basic knowledge of SOLR
Planning and designing of SAN using EMC clarion, Netapp, SUN, Xiotech
and Dell SAN boxes
Build a service-oriented architectur uning Sonoc MQ
Enterprise Security Management to manage to enterprises security
SUN Identity management for Proven Performance and Scalability
Work with hardware vendors for evaluation and selection of appropriate
hardware
TECH SKILLS SUMMARY
Networking: Cisco Routers/ switches, Novel Netware, Unix Networking,
TCP/IP concepts, Network Port Management
Mail: Sendmail, Cyrus IMAP/ POP, iPlanet Messaging server, POSTFIX &
Ms Exchange (Administration).
Administration Tools: Admintool, vmstat, iostat, top, traceroute,
ping, sar, prstat.
Backup: Legato, Veritas Netbackup 5.1 and 6.5, TAR, Dump
(ufsdump), DD, Ufsrestore,
Virtualization Solaris 10 zones, VMware ESX Server, AIX LPAR,
DLAPR
Databases: Oracle 8i/9i, My SQL server, Posgres.
Scripting: Shell, PERL,
Language C, C++
Highly availability Sun Cluster, VERITAS cluster
Volume Manager SVM, VERITAS volume manager, LVM
Open source: DNS, NFS, NIS, SAMBA , SENDMAIL, POSTFIX, Cyrus IMAP &
POP, Squid proxy, Ngios, LDAP, Request tracker, SOLR,Apache, Tomcat
Jboss
Administration: SMF and SRM
Windows management WMI
Web servers: Apache, Tomcat, Jboss, Mod_JK,Weblogic ,
websphare
Firewalls: Checkpoint and IPtable, IPchain, cisco PIX
Load Balancer: BIG IP f5 Load Balancer
Middleware: Tuxedo , OC4J, IBM WebSphere MQ,
SAN EMC, SUN, DELL, xiotech
Security IBM TIVOLI Access Manager, Checkpoint
Firewall,Cisco PIX
ERP Basic administration of Oracle Apps
(11i) in Prod and Fin Modules
Monitoring tools Big brother, cacti, nagios, BMC petrol, NNM and
Remedy
========================================================================
4) Lead SAS BI Certified
Availability : Immediate
Present Location : TN
* Over 8+ years of professional experience with increasing
responsibilities and successful record of achievements in application
design/development, database management, warehousing and statistical
analysis & report generation.
* Experience in SAS Programming, Data Analysis using SAS v8.2,
9.1.3, 9.2 in Credit Cards, Financial and Pharmaceutical Industry.
* Proficient in various SAS Business Intelligence tools and
manipulating large-scale data sources to fulfill business needs.
* Advance SAS Certified.
* Base SAS Certified.
* OCA (IZ0-007) Certified.
* Experience working with SAS under platforms such as Windows
2000, XP, UNIX,MVS(OS/390).
* Expertise in SAS/BASE, SAS GRID Manager , SAS DDE,
SAS/ACCESS,SAS/GRAPH, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/REPORT,
SAS/CONNECT , SAS Web Portal, SAS Information map ,SAS Stored Process,
SAS Web Report Studio and SAS EG areas and proficient in data
manipulations, report/graph generations using the data steps with varies
SAS functions, procedures, macros and ODS facilities on PC SAS,
Mainframe and UNIX platform.
* Strong analytical and computational skills
* Able to work independently on multiple projects simultaneously
with minimal supervision with little to no formal specifications
* Work often leads directly to operational efficiencies and
effectiveness reducing expenses. Works closely and effectively with all
levels of internal business clients and senior management.
* Experience working with MS Office tools like Excel, PowerPoint
and ODS HTML formatted files to produce ad hoc reports to the Users and
Business Partners for Presentation and further Analysis.
* Experience in SAS with Oracle, MS SQL Server, DB2 using
SAS/Access interface connectivity
* Export / extract data from databases and perform migration of
data using Upload, Download.
* Strong exposure to Business and Data analysis, design and
training of users. Ability to work independently / in a team
environment and ability to absorb technical knowledge quickly.
* Extensive SAS Program development experience. Recent assignments
involved data analysis, design, development, enhancement and support of
various SAS data marts.
* Highly self-motivated and goal-oriented professional with
rational problem solving and sound decision making capabilities,
recognized by peers for providing complete, accurate, alternative and
timely solutions to complex problems.
* Outstanding skills in documenting and streamlining business
process and procedures and proven ability to translate business
requirements into Analytical solutions.
* Liaison between business unit and systems organization to
provide leadership in defining process improvement, cost saving and
revenue-generating opportunities.
* Seasoned professional with knowledge of Project Life Cycle
(SDLC) Management with extensive knowledge in coordinating complex
analytical projects for various levels of an organization.
* Ability to build productive relationships with colleagues across
all functional and technical disciplines, providing focused Business and
Project Management, handling multiple projects at the same time.
* Experienced in analyzing and assessing business and financial
processes, identifying risks and identify business.
* Development and management of detailed project plans to include,
resources, tasks, requirements, milestones, and review points.
* Flexible, self-motivated, detail oriented, fast learner and
eager to continually learn
* Works well under pressure and in complex, changing environments
* Believe in continual improvement of processes and change
management.
* Worked on Onsite Offshore modal for more than 6 years.
Technical Skills:
* Statistical Software: SAS (Base SAS, SAS/SQL, SAS/MACRO,
SAS/GRAPH, SAS/ACCESS , SAS/ODS,SAS/CONNECT,SAS/Grid Manager ,SAS DDE).
* SAS BI Tools: SAS EG, SAS Portal, SAS Information map, SAS Web
Report Studio, SAS Stored Process, SAS Web Studio
* Programming Languages: SAS (UNIX, Windows , Mainframe), PL/SQL,
Procedures, SQL, Sql*Loader, Shell Scripting ,VBA,JCL
* Office Tools: MS Office, MS PowerPoint, MS Visio.
* Database: Oracle (8.1.7, 8i, 9i), DB2,SQL Server
* Operating Systems: Windows 96/98/2000, XP, NT,VISTA,
UNIX,MVS(OS/390)
* Internet Technologies: HTML, XML
* Special Software: TOAD 8.0 (Tool for Oracle Application
Development),Dream Viewer, Documentum , Test
Director, Remedy 5.01.02, AIX 3
--
You received this message because you are subscribed to the Google Groups
"Associate Programs" group.
To post to this group, send email to associate_progr...@googlegroups.com.
To unsubscribe from this group, send email to
associate_programs+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/associate_programs?hl=.
